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: Mutual Funds

Excel Price Feed provides current market data for a large range of Mutual Funds 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 a ticker, for example: =EPF.Yahoo.Price("VFIAX")

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.YTDReturn	YTD Return.
EPF.Yahoo.FundExpenseRatio	Expense Ratio.
EPF.Yahoo.FundCategory	Fund category and focus. For example "Large Blend": A large fund with a blend of investments.
EPF.Yahoo.MorningstarOverallRating	Morningstar overall rating.
EPF.Yahoo.MorningstarRiskRating	Morningstar risk rating.
EPF.Yahoo.FundTotalAssets	Total Assets.
EPF.Yahoo.MutualFundYield	Mutual Fund Yield.
EPF.Yahoo.FundInception	Inception Date.

Fund Overview

All of these formulas require just a 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.FundTotalAssets	Total Assets.
EPF.Yahoo.YTDReturn	YTD Daily Total Return.
EPF.Yahoo.MutualFundYield	Yield.
EPF.Yahoo.MorningstarOverallRating	Morningstar rating.
EPF.Yahoo.FundInception	Inception Date.

Overall Portfolio Composition

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

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("VFIAX")

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 (%).

Trailing Returns

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

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("VFIAX", 2018)

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

Quarterly Total Return History

This formula requires a ticker, a year and a quarter, for example: =EPF.Yahoo.FundQuarterlyTotalReturn("VFIAX", 2018, 1)

Formula	Description
EPF.Yahoo.FundQuarterlyTotalReturn	Quarterly Total Return for specified year and quarter.

Risk Statistics

All these formulas require a ticker and period (3, 5 or 10 year), for example: =EPF.Yahoo.FundSharpeRatio("CCSAX",3)

Formula	Description
EPF.Yahoo.FundAlpha	Alpha: the risk-adjusted returns of the fund.
EPF.Yahoo.FundBeta	Beta: indicates the sensitivity of the fund to market movements.
EPF.Yahoo.FundMeanAnnualReturn	Mean annual return: average annual performance over the specified period.
EPF.Yahoo.FundRSquared	R-squared: the relationship between the fund and its benchmark index, expressed as a percentage.
EPF.Yahoo.FundSharpeRatio	Sharpe Ratio: the return delivered by the fund per unit of risk taken.
EPF.Yahoo.FundStdDev	Standard Deviation: how much the return of the fund is deviating from expected returns based on its historical performance.
EPF.Yahoo.FundTreynorRatio	Treynor Ratio: a measure of returns earned in excess of the risk-free return