Getoptionchainmonthlies - Options

Live

Category:Options

Description

Returns the table of all monthly options of an underlying ticker

Syntax

QM_GetOptionChainMonthlies(Symbol)

Examples

=qm_getoptionchainmonthlies()

Historical Data Available: No

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

MarketXLS Excel Add-in Tutorial - How to Use Getoptionchainmonthlies and Other Financial Formulas

▶

How does MarketXLS work?

Similar Functions

qm_getoptionchainmonthlies
=QM_GetOptionChainMonthlies("AAPL")
Technical Indicator
=TechnicalIndicator("MSFT","MACD") - Default setting -is12^26^9^3 , where 12 is the fast period, 26 is the slow period and 9 is the signal period.