Here is a free spreadsheet that will get you started in the process of building your own technical analysis indicators in Excel. There are 3 parts to this tutorial that will show you how to create Simple Moving Average, Exponential Moving Average and Bollinger Bands. It’s a pretty simple sheet but gives you a start at TA for Excel.
AnalyzerXL is a package plugin for Excel with pre-built indicators for technical analysis. The add-in isn’t free, however, the fee is a one-time only fee. They have many other plugins including downloading historical data and retrieving real time price feeds.
Option Trading Tips
These guys provide a free spreadsheet for pricing call and put options. The model inside uses the Black Scholes Model so is suitable for options that are exercised at the expiration date. The formulas that drive the calculations are written in VBA. however, the source code for the VBA is not protected and can be viewed and edited.
Similar to the above, Hoadley provides an option pricing calculator in Excel. The Hoadley model is not free and comes with a small one-time price tag. This spreadsheet also uses Black and Scholes but also provides pricing for American options using the Binomial Model.
Trading Journal Spreadsheet
A very comprehensive Excel sheet for keeping track of your trades and trading ideas. Not a free spreadsheet but comes with a one-time fee. You can use this to record trades on stocks, options, futures, FOREX, CFDs and even spread bets.
MarketXLS is the ultimate set of tools for trading using Excel. It provides technical analysis, historical data, portfolios, charts, live stock/FOREX quotes and a stock screener! It, however, is not free and carries a per year price tag.
Here is a free spreadsheet that downloads historical stock data for calculating a stock’s historical volatility. It is used by option traders to determine the volatility level needed to use inside an option pricing model. While the sheet is free the VBA code that drives it is not unlocked (at the time of writing), which is strange because the other pricing spreadsheet above does provide an unlocked VBA code base.
Please feel free to suggest new spreadsheets to add here by sending me an email.