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...