Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
← Back to Templates

How to use QM_List function to get OptionChain and Interval Data

Description

How to use QM_List function to get OptionChain and Interval Data thumbnail

The QM_List functions provide a robust method for extracting data from the Quotemedia’s API. They offer a wide array of applications, typically returning the results in a structured, table-like form.

For instance, should you wish to retrieve intraday history data for a certain symbol, you could utilize a QM_List function in the manner shown below:

=QM_List("getIntervals", "symbol","MSFT", "interval","5")

In the event you required data from a specific interval, the following applications would become relevant:

=QM_List("getIntervals", "symbol","MSFT", "interval","5","start","2020-03-18") This function will obtain all data from March 18th, 2020.

=QM_List("getIntervals", "symbol","MSFT", "interval","5","start","2020-03-18","end","2020-04-15") This function will fetch all data between March 18th, 2020 and April 15th, 2020.

Please adhere to the “YYYY-MM-DD” format for dating. Additionally, the symbol can also be an option symbol, provided it is yet to expire.

Thus, the structuring of a QM_List function may appear as:

=QM_List("Method Name", "Parameter1", "Parameter Value 1", "Parameter2", "Parameter Value 2",......,"Parameter N", "Parameter Value N")

Please refer to the examples listed below for a swift means of accessing the EOD History:

To fetch a month's history, apply this function: =QM_List("getHistory","symbol","AAL")

To extract history from a specific starting date, make use of this function: =QM_List("getHistory","symbol","AAL","start","2019-02-15")

To obtain historical data from a certain starting date till an end date, apply this function: =QM_List("getHistory","symbol","AAL","start","2019-02-15", "end","2020-05-25")

Note: The availability of QM_List methods is contingent upon the data package you have procured from Quotemedia. For instance, only those with the Options data package will have access to options-related methods.

The QM_List function, and its counterpart qm_listDynamic function, can be used to sieve through options contracts. This is particularly useful given that a single stock option could potentially have thousands of contracts. These functions can be used to filter out specific options:

Here is how to retrieve all options for AAL expiring between July 19th, 2020 and September 18th, 2020: =QM_List("getOptionchain","symbol","AAL","expireMin","2020-07-19","expireMax","2020-09-18")

If you want the options with a minimum strike price of 12: =QM_List("getOptionchain","symbol","AAL","expireMin","2020-07-19","expireMax","2020-09-18","strikeMin",12)

If you wish to set a range for the strike price, say, between 12 and 14: =QM_List("getOptionchain","symbol","AAL","expireMin","2020-07-19","expireMax","2020-09-18","strikeMin",12,"strikeMax",14)

If you want to exclude zero volume contracts and only get options yet to expire: =QM_List("getOptionchain","symbol","AAL","expireMin","2020-07-19","expireMax","2020-09-18","strikeMin",12,"strikeMax",14,"inclExpired","false","inclZeroVol","false")

If you only need put options: =QM_List("getOptionchain","symbol","AAL","expireMin","2020-07-19","expireMax","2020-09-18","strikeMin",12,"strikeMax",14,"inclExpired","false","inclZeroVol","false","callput","put")

To retrieve the entire history of an options contract: =QM_List(“getHistory”,”symbol”,”@AAL 200717P00018000″,”start”,”2001-01-01″)

Template Screenshots

How to use QM_List function to get OptionChain and Interval Data screenshot 1

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

Get started today
How does MarketXLS work?
How does MarketXLS work? Watch Demo

Similar Templates

Related Formulas