Excel Price Feed provides full access to the options data that is available on Yahoo Finance. The formulas below are for a single option, the Add-in also provides access to options chain data.
You can use the standard Excel Price Feed formulas such as
EPF.Yahoo.DayChange etc. with option tickers. Please see the Yahoo Finance Excel Formulas page for more details.
In addition, there are some formulas which are specific to options. All of these formulas require just an options contract name, for example:
||Current ask price.|
||Current bid price.|
||The expiry date of the option.|
||The strike price of the option.|
||Total open interest for the option.|
||The underlying ticker of the option contract.|
Excel Price Feed also provides a very useful formula for constructing option tickers / symbols.
An option ticker is made up of four parts:
And these four parts are the parameters fot the
The input parameters required are:
|Ticker||The ticker for the instrument, eg "APPL" or "SPY".|
|Option Type||Put or Call. Can be "Put" or "P" or "Call" or "C".|
|Expiry Date||The expiry date of the option.|
|Strike Price||The strike price of the option.|
For example, say we are interested in an Apple 17 Jun 2022 Put at 155 strike. We can use this formula to construct the ticker/symbol:
=EPF.OptionTicker("AAPL","Put","17 Jun 2022",155)
Here was can see the formula in action in Excel: