Build Trading and Investing Models in Excel
Learn to design, code, construct and test Excel models that make money!
I get this question all the time. "I use Trading Software X and it has all the bells and whistles. Does your Excel software do what Software X does? I just want to make money." [signed, Trader Losing Money] You know my answer? "It's not the software." I've used the...read more
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