Excel Trading and Investing Models | ExcelTradingModels.com
  • FREE STUFF
    • Free Trading Model
    • Free Getting Started Guide
    • 5 Free Technical Indicators in Excel
    • Free Spread Trading Contract Calculator
    • Free Yahoo Finance Stock Split Adjuster
  • Trading Models
    • Four Trading Models in Excel
    • Trend Trading Model in Excel
    • Breakout Trading Model in Excel
  • Courses
    • Build an Automated Trading System in Excel Course
    • Build a Fund Investing System in Excel Course
  • Analysis & Data
    • Excel Technical Indicators Library
  • Articles
    • Excel Models
    • Data
    • Backtesting
    • Portfolio Analysis
    • VBA Code
    • FAQs
      • Stock Model FAQs
      • Fund Model FAQs
  • Shop
Select Page

FAQ: The VBA code Sheets(ticker).Select is highlighted. What do I do?

Data, FAQs, Stock Model FAQs, VBA Code

The code isn’t broken. The error you’re getting can mean one of 4 things: 1/ you did not save the .csv files you downloaded with TICKER.csv in ALLCAPS (replace TICKER with your desired symbols) 2/ your list of ticker symbols in the Controls worksheet are not in...

FAQ: When I Try to Insert a Command Button for ‘Run Model’ I Get a ‘Cannot insert object’ prompt’

FAQs, VBA Code

Save your model file as macro-enabled workbook (.xlsm) if you didn’t do that.   If your file is saved as an .xlsm then this issue is caused by an MS Office Update. Here is the best (simplest) fix: 1. Close all your Office programs and files. 2. Open Windows Explorer...

FAQ: DownloaderXL Not Populating Data for One Stock

Data, FAQs, Stock Model FAQs

Question: DownloaderXL populates all of the tabs in the DATAv3.xlsm file except for the very first one, designated as AAPL. I cannot figure out why this is happening, especially when all of the other tabs are working fine. Answer: Regarding the AAPL price data issue,...

FAQ: Ticker Symbol Excel VBA Mismatch Error

FAQs, Stock Model FAQs, VBA Code

Question: When I attempt to run the model with AAPL and several other stocks, I get a type mismatch error from Excel, and then in attempting to debug the model code, this is what is displayed (see below.) I realize that it is not recognizing the indicator variables,...

20 Lessons to Make Money Trading (and not lose your shirt)

Articles, FAQs

We were recently asked the following question by one of our customers.  It’s situation that all new traders face, but few actually ask the question before really diving in.  Our answer comes from years of experience developing and trading (successfully and...

FAQ: Can I backtest more or less than 10 funds at a time?

FAQs, Fund Model FAQs

You cannot use more than 10 funds at a time in the backtest model. The backtest model only has sufficient room in columns B through K of the Calculations sheet for 10 funds. You CAN backtest fewer than 10 funds. You will need to make sure the weekly closing price data...
« Older Entries

.

Free Trading Model 10 Steps to Create a Profitable Trading System in Excel - Free Getting Started Guide 5 Free Technical Indicators in Excel FREE Yahoo Finance Stock Split Adjuster in Excel FREE Spread Trading Contract Calculator in Excel
  • Home
  • Refund Policy
  • CFTC Rule 4.41
  • Facebook
  • Twitter
Copyright © 2024 ExcelTradingModels.com and FunnelProfit, LLC