Use the built-in Technical Analysis Toolkit to calculate indicators directly on historical price data in your spreadsheet. Formulas live under =EPF.TA and are also available from the Excel Price Feed ribbon.
=EPF.TA.* formula
All Technical Analysis Toolkit formulas from the example spreadsheet and user guide:
=EPF.TA.SMA(prices, dates, lookbackWindow)=EPF.TA.EMA(prices, dates, lookbackWindow)=EPF.TA.VWAP(closePrices, highPrices, lowPrices, volumes, datesTimes)=EPF.TA.BollingerBands(inputPrices, inputDates, lookbackPeriods, standardDeviations)=EPF.TA.ATR(closePrices, highPrices, lowPrices, datesTimes, lookbackPeriods)=EPF.TA.RSI(prices, dates, lookbackWindow)=EPF.TA.MACD(prices, dates, fastPeriods, slowPeriods, signalPeriods)=EPF.TA.Aroon(closePrices, highPrices, lowPrices, datesTimes, lookbackPeriods)
Download a ready-to-use workbook demonstrating the technical analysis formulas.
Browse every technical indicator formula with parameters and examples.
Yes. Excel Price Feed includes a Technical Analysis Toolkit of standard Excel formulas such as =EPF.TA.SMA, =EPF.TA.RSI and =EPF.TA.MACD. No VBA macros are required. See the Technical Analysis overview.
SMA, EMA, VWAP, ATR, MACD, Bollinger Bands, RSI and Aroon. Browse each indicator under the user guide.
Yes. The indicators are native Excel formulas, so when your historical price ranges update the SMA, RSI, MACD and other indicators recalculate automatically.
Download the Technical Analysis Toolkit Formulas example spreadsheet. It demonstrates how to use the EPF.TA formulas in Excel.
See the Technical Analysis overview, individual indicator pages such as SMA, RSI and MACD, and the toolkit template.