Getting Started

• Introduction
• Download
• Installation & Activation
• Troubleshooting
• Data Refresh/Updates
• Software Updates
• Manage Your Subscription
• Example Spreadsheets

General Formulas

• Black-Scholes Option Pricing
• Instrument Identifier Conversions
• Miscellaneous

Technical Analysis Toolkit

• Introduction
• Simple Moving Average (SMA)
• Exponential Moving Average (EMA)
• Volume Weighted Average Price (VWAP)
• Average True Range (ATR)
• Moving Average Convergence/Divergence (MACD)
• Bollinger Bands
• Relative Strength Index (RSI)
• Aroon

Federal Reserve Economic Data
(FRED)

• Overview
• Formula Reference

Yahoo Finance

• Formula Reference
• • All Formulas
  • Stocks
  • Stocks: Income Statement
  • Stocks: Balance Sheet
  • Stocks: Cash Flow
  • Stocks: Analysis
  • Stocks: ESG Risk Ratings
  • Options Chain
  • Stock Options
  • Mutual Funds
  • ETFs
  • FX Rates
  • Cryptocurrencies
  • Commodities
  • Historical Market Data
  • News
• Historical Array Formulas
• Historical Data Download
• VBA Functions Reference

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

• Overview & Setup
• Historical Price Data
• Stocks Fundamental Data
• Stocks Financial Analysis

Nasdaq Data Link

• Overview & Setup
• Formula Reference

Technical Indicators: Heikin Ashi

Heiken Ashi (meaning "average bar" in Japanese) is a type of charting technique or indicator used in technical analysis to smooth out price action and identify trends more clearly.

Historical Price Requirements

Excel Formula Details

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

The input parameters required are:

Parameter	Description
Prices	An Excel range of the prices.
Dates	An Excel range of the dates.
Lookback Window	The number of periods in the lookback window.

The range of prices and dates must correspond and be of the same length, for example the first date in the date range must correspond to the first price in the price range.

The output columns are:

Output Column	Description
Date	The date that the simple moving average corresponds to.
SMA	The simple moving average.

Example Excel Formula

"Calculate the SMA with a 5 day lookback window"

In this example you can see the price/date data in columns A and B respectively. The SMA formula is in cell D2 and references the price (A2:A100) and date (B2:B100) ranges as well as the 5 period lookback:

=EPF.TA.SMA(A2:A100,B2:B100,5)

The formula calculates the SMA and returns the SMA and corresponding dates to columns D and E respectively: