Excel Formula Reference: Yahoo Finance

All Yahoo Finance Excel formulas start with EPF.Yahoo so they can be easily referenced.

The Excel Price Feed Add-in provides formulas for much of the data available on the Yahoo Finance website. These Excel formulas are simple to use in your existing spreadsheets, for example here are the formulas for current price and beta:

Yahoo Finance Excel Formulas

Yahoo Finance provides data from many different exchanges, some are real-time (such as the NYSE and NASDAQ) whilst others are delayed. For full details of coverage refer to Exchanges and data providers on Yahoo Finance on the Yahoo Finance website.

Basic Usage

The Excel Price Feed Add-in works by providing a library of new Excel formulas, most of which just require an instrument symbol or ticker.

For example to display the current price of Apple stock in a cell simply enter this formula:


How to find instrument symbols/tickers

All of the Excel Price Feed Add-in formulas require at least an instrument symbol/ticker. Most are standard, such as AAPL for Apple Stock. If you are unsure what the symbol/ticker is then you can use the Search function on the Configuration Pane.

For example, here I am searching for the Toyota stock ticker, I highlight the entry for the Japanese stock exchange (JPX) and see the ticker is 7203.T

Yahoo Finance Excel search for Toyota stock ticker

There are a bunch of shortcut buttons for quickly adding formulas to your spreadsheet, for example the "Price" button will add the price formula for Toyota stock to the currently selected cell in your spreadsheet.

Common Formulas

Although many of the formulas provided by the Add-in are specific to a particular instrument type/market, several are common to all instrument types.

The table below describes the most common:

Formula Description
EPF.Yahoo.Price Current mid price.
EPF.Yahoo.DayChange Change in price today.
EPF.Yahoo.DayChangePercent Percentage change in price today.
EPF.Yahoo.MarketState Current state for the market eg. "REGULAR", "PRE" etc.
EPF.Yahoo.PrevClose Previous market close price.
EPF.Yahoo.MarketOpen Market open price.
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 (%).

Instrument/Market Specific Formulas

Click on a category below to view the instrument/market specific formulas: