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

The Basics of Excel Trading VBA

Articles, Excel Models, VBA Code

Top quality trading VBA must be written in a highly module-based manner. Applying Microsoft’s native VBA capabilities, you can create a selection of custom functions which will then be called within your VBA and with user controls such as checkboxes. The more...

Basics of Trading Model Rules Development

Articles, Excel Models, VBA Code

Trading model rules are based on IF-THEN statements, Variables, Loops, and Arrays.  If-Then StatementsAn IF-THEN statement is a way of conditionally evaluating inputs against pre-set criteria or rules. It is based on sequential linear logic, which is the way...

FAQ: I am having difficulty getting a section of the Excel VBA code to work. Some of the code is highlighted in blue and some is in yellow.

FAQs, Fund Model FAQs, VBA Code

Here is the code that was highlighted in blue: ’open data .csv file and copy column B data to \Data/ sheet Also, this phrase was highlighted in yellow: Sub Load_Data( ) This problem is typically caused by a missing or mis-named .csv data file, ticker symbol, or data...