Getting Started
- Introduction
- Download
- Installation & Activation
- Troubleshooting
- Data Refresh/Updates
- Software Updates
- Manage Your Subscription
- Example Spreadsheets
General Formulas
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)
Yahoo Finance
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
Nasdaq Data Link
VBA Functions Reference: Yahoo Finance
Excel Price Feed includes several functions which are specially designed to be used from VBA. They are all non-asynchronous functions which means that code execution is halted whilst awaiting the result of the function (unlike the regular Excel formulas which cannot be used with VBA).
| Formula | Description |
|---|---|
EPF.Yahoo.VBA.Price |
Current mid price. |
EPF.Yahoo.VBA.DayChange |
Change in price today. |
EPF.Yahoo.VBA.DayChangePercent |
Percentage change in price today. |
EPF.Yahoo.VBA.DayLow |
Day low. |
EPF.Yahoo.VBA.DayHigh |
Day high. |
EPF.Yahoo.VBA.DayVolume |
Volume of shares traded today. |
EPF.Yahoo.VBA.PrevClose |
Previous market close price. |
EPF.Yahoo.VBA.MarketOpen |
Market open price. |
EPF.Yahoo.VBA.MarketCap |
Current market capitalisation. |
EPF.Yahoo.VBA.52WeekLow |
52 week low. |
EPF.Yahoo.VBA.52WeekHigh |
52 week high. |
EPF.Yahoo.VBA.PERatio |
PE Ratio TTM (Trailing Twelve Months). |
EPF.Yahoo.VBA.EPS |
EPS TTM (Trailing Twelve Months). |
EPF.Yahoo.VBA.TrailingAnnualDividendRate |
Trailing annual dividend rate. |
EPF.Yahoo.VBA.TrailingAnnualDividendYield |
Trailing annual dividend yield. |
EPF.Yahoo.VBA.Currency |
The 3 letter ISO currency code of the instrument eg USD, EUR, JPY etc. |
EPF.Yahoo.VBA.Name |
Company name. |
EPF.Yahoo.VBA.QuoteType |
Quote type, for example "EQUITY" or "MUTUALFUND". |
Examples
1. Return the live bid price of Apple stock:
Dim stockPrice As Variant
stockPrice = Application.Run("EPF.Yahoo.VBA.Price", "AAPL")
Options Chain VBA Functions
Excel Price Feed includes 3 Excel VBA Functions for retrieving Options Chain data:
EPF.Yahoo.VBA.OptionsChain.List
This function returns options chain list data for the specified ticker and optional expiry date:
EPF.Yahoo.VBA.OptionsChain.List(ticker, expiryDate [OPTIONAL])
The input parameters required are:
| Parameter | Description |
|---|---|
| Ticker | The ticker for the instrument, eg "APPL" or "SPY". |
| Expiry Date | If no expiry date is specified options for the next expiry date are downloaded. |
EPF.Yahoo.VBA.OptionsChain.Straddle
This function returns options chain straddle data for the specified ticker and optional expiry date:
EPF.Yahoo.VBA.OptionsChain.Straddle(ticker, expiryDate [OPTIONAL])
The input parameters required are:
| Parameter | Description |
|---|---|
| Ticker | The ticker for the instrument, eg "APPL" or "SPY". |
| Expiry Date | If no expiry date is specified options for the next expiry date are downloaded. |
EPF.Yahoo.VBA.OptionsChain.ExpiryDates
This function returns a list of all possible option expiry dates for the specified ticker:
EPF.Yahoo.VBA.OptionsChain.ExpiryDates(ticker)
The input parameter required is:
| Parameter | Description |
|---|---|
| Ticker | The ticker for the instrument, eg "APPL" or "SPY". |