OptionLive

 

Syntax: OPTIONLIVE(Ticker, Fields, RefreshRate)

 

Equivalent Function Names: OL

 

Purpose: The function displays the live market data for a Yahoo! Options ticker, e.g. MSFT140103C00026000

 

Parameters: 
 

1.Ticker is the Reuters/Yahoo ticker.
 

2.Field may be optional for a given operation. They are equivalent to the fields supported by the Option function.

If no field is specified, the LAST_TRADE_PRICE is assumed.
 

3.RefreshRate = the number of seconds before the field is refreshed. Default value = 15 secs.

 

NOTE: The output of this function is not autoformatted! Therefore, if you require more than one cell as an output, you have to enter it as a range formula!

 

Examples:

1. Display the current option price, updated live

=OL("MSFT140103C00026000")  displays the current price of the given Microsoft option updated live.

 

 

2. Display the live price and open interest

=OL("MSFT140118C00026000","p,oi") shows the live open interest of a given option.

 

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017