Getting Started
- Introduction
- Download
- Installation & Activation
- Troubleshooting
- Data Refresh/Updates
- Software Updates
- Manage Your Subscription
- Example Spreadsheets
General Formulas
Technical Analysis Toolkit
- Introduction
- Simple Moving Average (SMA)
- Exponential Moving Average (EMA)
- Volume Weighted Average Price (VWAP)
- Average True Range (ATR)
- Bollinger Bands
- Aroon
Federal Reserve Economic Data
(FRED)
Yahoo Finance
IG Index / IG Markets
- Account Setup
- Formula Reference
- VBA Functions Reference
- Historical Price Data Download To Excel
- Historical Price Data Download To File
- Historical Client Sentiment Data Download
- Watchlists
- Live Positions, Transactions & Activity History
EODHistoricalData.com
Nasdaq Data Link
Technical Indicators / Technical Analysis in Excel
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.
=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:
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 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: