Excel Formula Reference: Yahoo Finance

Excel Price Feed Yahoo Finance Formulas Example Spreadsheet Download
Click the Excel icon to download a sample spreadsheet with all Excel Price Feed Yahoo Finance stock formulas.

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.

If you discover an issue with Yahoo Finance data or simply want to provide some feedback to Yahoo, then please use the Yahoo Finance User Forum. We are not responsible for the quality or coverage of Yahoo Finance data.

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:

=EPF.Yahoo.Price("AAPL")

Where AAPL is the ticker for Apple stock. This value can be a specific ticker or reference another cell in your sheet, basically these formulas work exactly the same way as the built-in standard Excel formulas.

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.Currency The 3 letter ISO currency code of the instrument
eg USD, EUR, JPY etc.
EPF.Yahoo.FinancialsCurrency The 3 letter ISO currency code that the company's
financials are reported in
eg USD, EUR, JPY etc.
EPF.Yahoo.Exchange The exchange eg: NMS (for Nasdaq), NYQ (for NYSE) etc.
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: