Technical Indicators / Technical Analysis in Excel

Excel Price Feed Quandl Example Spreadsheet Download
Click the Excel icon to download a sample spreadsheet that demonstrates how to use the Technical Analysis Toolkit Excel formulas.

Excel Price Feed provides several technical indicators which you use to perform technical analysis on financial market data.

Unlike other Excel Add-ins, Excel Price Feed provides standard Excel formulas for technical analysis. This means that when your price data changes the technical indicator formula is automatically recalculated. You can easily combine these formulas with the Add-in's historical array formulas to build powerful financial models in your Excel spreadsheet.

All of the technical analysis/indicator formulas are in the format:
=EPF.TA
(ExcelPriceFeed.TechnicalAnalysis)

For example, the formula to calculate the simple moving average is:

=EPF.TA.SMA(prices, dates, lookbackWindow)

All of the technical analysis Excel formulas are also easily available via the ExcelPriceFeed tab in Excel:

Excel Technical Analysis Toolkit

Once your spreadsheet is setup with a technical indicator formula you can easily plot the results on an Excel chart like below. This shows the close price of the S&P500 with the Simple Moving Average (SMA):

Excel Technical Analysis Indicators

Excel Price Feed provides formulas for several technical indicators and we will adding more with each release.

Click on a link below to learn more about the indicator and how to use it in your spreadsheet: