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

Yahoo Finance Excel Formulas ETF (Exchange Traded Fund) 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

Yahoo Finance Excel Formulas ETF (Exchange Traded Fund) 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

Yahoo Finance Excel Formulas ETF (Exchange Traded Fund) 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

Yahoo Finance Excel Formulas ETF (Exchange Traded Fund) Fund Overview

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

Yahoo Finance Excel Formulas ETF (Exchange Traded Fund) 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

Yahoo Finance Excel Formulas ETF (Exchange Traded Fund) 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

Yahoo Finance Excel Formulas ETF (Exchange Traded Fund) 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

Yahoo Finance Excel Formulas ETF (Exchange Traded Fund) 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

Yahoo Finance Excel Formulas ETF (Exchange Traded Fund) 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

Yahoo Finance Excel Formulas ETF (Exchange Traded Fund) 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.