Constructing a trading model in Excel from commercially available add-in toolkits has distinct advantages, particularly for models based on standard technical indicators such as moving averages, stochastics, CCI, Bollinger Bands, etc. An add-in toolkit makes analysis...
Building a trading model from scratch using a combination of Excel formulas and VBA can be a lot of work, but has the advantage of full control over the model and what it needs to do. Individual spreadsheets are used for data capture, trade rule logic, and calculating...
Building a trading model in Excel involves developing the trading rules or logic that drive the buy/sell signals, capital allocation, and risk management. There are several types of trading models, each requiring a different approach to the trading rules: Fully...
< Back to Part 4 The final option is significantly more “techie” than the previous ones. SQL calls from Excel to a database involve either embedding SQL code into Excel’s VBA, or purchasing an add-in that gives you a graphical interface to do the...
< Back to Part 3 Using Excel’s native Web Query capability to extract data from Internet pages, you can automatically import market data from free sites such as Yahoo! Finance, Google, MSN, AOL, etc. This works fine for delayed and end of day data. The...