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)
• Bollinger Bands
• 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

Excel Formula Reference: Exchange Traded Funds (ETFs)

Excel Price Feed provides current market data for a large range of Exchange Traded Funds (ETFs) across many different providers and countries.

The sections below correspond to the sections on the Yahoo Finance website so you can quickly find the relevant Excel formula.

Live Price

All of these formulas require just an ETF ticker, for example: =EPF.Yahoo.Price("VOO")

Formula	Description
EPF.Yahoo.Price	Current mid price.
EPF.Yahoo.DayChange	Change in price today.
EPF.Yahoo.DayChangePercent	Percentage change in price today.

Summary

All of these formulas require just an ETF ticker, for example: =EPF.Yahoo.PrevClose("VOO")

Formula	Description
EPF.Yahoo.PrevClose	Previous market close price.
EPF.Yahoo.MarketOpen	Market open price.
EPF.Yahoo.Bid	Current bid price.
EPF.Yahoo.BidSize	Current bid size.
EPF.Yahoo.Ask	Current ask price.
EPF.Yahoo.AskSize	Current ask size.
EPF.Yahoo.DayLow	Day low.
EPF.Yahoo.DayHigh	Day high.
EPF.Yahoo.52WeekLow	52 week low.
EPF.Yahoo.52WeekHigh	52 week high.
EPF.Yahoo.52WeekChange	52 Week Change in price (%).
EPF.Yahoo.DayVolume	Volume of shares traded today.
EPF.Yahoo.AverageDailyVolume10Day	Average daily volume over past 10 trading days.
EPF.Yahoo.AverageDailyVolume3Month	Average daily volume over past 3 months.
EPF.Yahoo.FundTotalAssets	Total Assets.
EPF.Yahoo.FundNAV	Fund Net Asset Value (NAV).
EPF.Yahoo.Yield	Yield.
EPF.Yahoo.FundYTDReturn	YTD Daily Total Return.
EPF.Yahoo.FundExpenseRatio	Expense Ratio.
EPF.Yahoo.FundInception	Inception Date.

Fund Overview

All of these formulas require just an ETF ticker, for example: =EPF.Yahoo.FundCategory("VOO")

Formula	Description
EPF.Yahoo.FundCategory	Fund category and focus. For example "Large Blend": A large fund with a blend of investments.
EPF.Yahoo.FundFamily	Fund Family. For example "Vanguard"
EPF.Yahoo.FundTotalAssets	Total Assets.
EPF.Yahoo.FundYTDReturn	YTD Daily Total Return.
EPF.Yahoo.Yield	Yield.
EPF.Yahoo.QuoteType	Legal/Quote Type. For example "ETF"

Fund Operations

All of these formulas require just an ETF ticker, for example: =EPF.Yahoo.FundExpenseRatio("VOO")

Formula	Description
EPF.Yahoo.FundExpenseRatio	Expense Ratio.
EPF.Yahoo.FundHoldingsTurnover	Holdings Turnover.
EPF.Yahoo.FundTotalNetAssets	Total Net Assets.

Overall Portfolio Composition

All these formulas require just a ticker, for example: =EPF.Yahoo.Holdings.Cash("VOO")

Formula	Description
EPF.Yahoo.Holdings.Cash	Cash (%).
EPF.Yahoo.Holdings.Stock	Stock (%).
EPF.Yahoo.Holdings.Bond	Bonds (%).
EPF.Yahoo.Holdings.Other	Other (%).
EPF.Yahoo.Holdings.Preferred	Preferreds (%).
EPF.Yahoo.Holdings.Convertible	Convertibles (%).

Sector Weightings

All these formulas require just a ticker, for example: =EPF.Yahoo.SectorWeightings.BasicMaterials("VOO")

Formula	Description
EPF.Yahoo.SectorWeightings.BasicMaterials	Basic Materials (%).
EPF.Yahoo.SectorWeightings.CommunicationServices	Communication Services (%).
EPF.Yahoo.SectorWeightings.ConsumerCyclical	Consumer Cyclical (%).
EPF.Yahoo.SectorWeightings.ConsumerDefensive	Consumer Defensive (%).
EPF.Yahoo.SectorWeightings.Energy	Energy (%).
EPF.Yahoo.SectorWeightings.FinancialServices	Financial Services (%).
EPF.Yahoo.SectorWeightings.Healthcare	Healthcare (%).
EPF.Yahoo.SectorWeightings.Industrials	Industrials (%).
EPF.Yahoo.SectorWeightings.RealEstate	Real Estate (%).
EPF.Yahoo.SectorWeightings.Technology	Technology (%).
EPF.Yahoo.SectorWeightings.Utilities	Utilities (%).

Top 10 Holdings

All these formulas require a ticker and a position, for example: =EPF.Yahoo.Holdings.Top10.Name("VOO", 1) will return the company name with the largest holding in the VOO fund.

Formula	Description
EPF.Yahoo.Holdings.Top10.Name	Stock Name of Top 10 Holding.
EPF.Yahoo.Holdings.Top10.Symbol	Stock Symbol of Top 10 Holding.
EPF.Yahoo.Holdings.Top10.Percent	Percentage of Top 10 Holding (%).

Performance Overview

All these formulas require just a ticker, for example: =EPF.Yahoo.FundYTDReturn("VOO")

Formula	Description
EPF.Yahoo.FundYTDReturn	YTD Daily Total Return.
EPF.Yahoo.Fund1YReturn	1 Year Daily Total Return.
EPF.Yahoo.Fund3YReturn	3 Year Daily Total Return.

Trailing Returns

All these formulas require just a ticker, for example: =EPF.Yahoo.FundYTDReturn("VOO")

Formula	Description
EPF.Yahoo.FundTrailingTotalReturnYTD	Trailing Total Return YTD.
EPF.Yahoo.FundTrailingTotalReturn1M	Trailing Total Return 1 Month.
EPF.Yahoo.FundTrailingTotalReturn3M	Trailing Total Return 3 Month.
EPF.Yahoo.FundTrailingTotalReturn1Y	Trailing Total Return 1 Year.
EPF.Yahoo.FundTrailingTotalReturn3Y	Trailing Total Return 3 Year.
EPF.Yahoo.FundTrailingTotalReturn5Y	Trailing Total Return 5 Year.
EPF.Yahoo.FundTrailingTotalReturn10Y	Trailing Total Return 10 Year.

Annual Total Return History

This formula requires both a ticker and a year, for example: =EPF.Yahoo.FundAnnualTotalReturn("VOO", 2018)

Formula	Description
EPF.Yahoo.FundAnnualTotalReturn	Annual Total Return for specified year.