Build Trading and Investing Models in Excel
Learn to design, code, construct and test Excel models that make money!
If you are a trend trader your best profits will come by trading markets and securities that have a tendency to move in strong price trends. A key goal then is determining the "expected trend strength" or "trendiness" of a security. You must usually wait until a...read more
The foundation of a great trading system is the ability to identify and capture large price moves. A system that consistently generates large winning trades can easily offset smaller losing trades and produce significant profits. This is the main feature of trend...read more
I get this question a lot: "If you were going to design your first trading model in Excel, what system would you start with?" The answer has a lot to do with what you trade and what you consider "trading". Are you a stock trader or a foreign currency trader? Do you...read more
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...read more
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...read more