Real-Time Stock Option Pricing in Excel
Stream real-time or delayed live pricing data for stock options directly into your Excel spreadsheets.
Requirements
You will need any version of MarketXLS along with a data subscription for Options Pricing to use these streaming functions.
Options Streaming in Action
Option Streaming - Live price updates
Common Options Pricing Functions
This article describes various commonly used Options Pricing functions with Quotemedia's options data and historical option pricing in Excel.
Get Full Options Chain
=QM_List("getOptionChain","Symbol","MSFT")=qm_getOptionChain("MSFT")Get In-the-Money Options Only
To get all In-the-Money option contracts:
=QM_List("getOptionChain","Symbol","FDX","money","In")
Option pricing in Excel with full chain data
Creating Option Symbols
=OptionSymbol("MSFT","2020-08-21","Call",200)
Option symbol generation
Streaming Real-Time Option Prices
MarketXLS supports multiple option symbol formats for real-time streaming:
=QM_Last("@MSFT 180629P00090000")or
=QM_Last("MSFT180629P00090000")or
=QM_Stream_last("Option Symbol")Additional Streaming Functions
You can also use
qm_stream_ask, qm_stream_bid, and many more real-time functions to stream live option prices.