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



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!



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