EPF.Yahooso 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 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.
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:
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
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.
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:
||Current mid price.|
||Change in price today.|
||Percentage change in price today.|
||Current state for the market eg. "REGULAR", "PRE" etc.|
||Previous market close price.|
||Market open price.|
||52 week low.|
||52 week high.|
||52 Week Change in price (%).|
Click on a category below to view the instrument/market specific formulas: