Become An Idiot-Proof Trader: Excel Versus Trading Software
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...
Determining the “Trendiness” of a Market Using Excel
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...
Trading the Trend for Big Profits With Excel
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...
Your First Trading Model in Excel
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...
FAQ: The VBA code Sheets(ticker).Select is highlighted. What do I do?
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...