MarketXLS Tutorials

Search…

Getting Started

Functions: How to Use

Core concepts

Options Pricing

Historical Pricing

Create Charts using MarketXLS

Function: QM_List()

`=QM_List("What data set you need - the name of the method", "Parameter1", "Parameter Value 1", "Parameter2", "Parameter Value 2",......,"Parameter N", "Parameter Value N")`

The QM_List functions allow you to get the data from Quotemedia’s API for any of these methods. The functions generally return the data in a tabular (list-like) form. For example

For example, to get intraday history for a stock symbol, use the function as shown below:

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

This will get all 5-minute intervals from March 18th, 2020

`=QM_List("getIntervals", "symbol","MSFT", "interval","5","start","2020-03-18")`

This will get all 5-min intervals from March 18th, 2020 to April 15th, 2020

`=QM_List("getIntervals", "symbol","MSFT", "interval","5","start","2020-03-18","end","2020-04-15")`

The date format always need to be “**YYYY-MM-DD**”

The symbol can be an option symbol as well. The option symbol needs to be a “**yet to expire**” option.

Check out the following examples to get the EOD History.

To get history for a month use this function :

`=QM_List("getHistory","symbol","AAL")`

To quick get history from a specific start date use this function:

`=QM_List("getHistory","symbol","AAL","start","2019-02-15")`

To quick get history from a specific start date to a specific end date use this function:

`=QM_List("getHistory","symbol","AAL","start","2019-02-15", "end","2020-05-25")`

QM_List function and qm_listDynamic function can also be used to filter out the right options contracts. Many a time the option of a stock will have thousands of contracts. Pulling all the option contracts is cumbersome. So, you can use the qm_list functions to filter out the options like shown below.

To get all options for AAL which are expiring between July 19th, 2020 and September 18th, 2020 use like below.

`=QM_List("getOptionchain","symbol","AAL","expireMin","2020-07-19","expireMax","2020-09-18")`

To get all options for AAL which are expiring between July 19th, 2020 and September 18th, 2020 use the function below where the minimum strike price is 12.

`=QM_List("getOptionchain","symbol","AAL","expireMin","2020-07-19","expireMax","2020-09-18","strikeMin",12)`

To get all options for AAL which are expiring between July 19th, 2020 and September 18th, 2020 use like below where the minimum strike price is 12 and the maximum is 14.

`=QM_List("getOptionchain","symbol","AAL","expireMin","2020-07-19","expireMax","2020-09-18","strikeMin",12,"strikeMax",14)`

To get all options for AAL which are expiring between July 19th, 2020 and September 18th, 2020 use like below where the minimum strike price is 12 and the maximum is 14. And also there should be no zero volume contracts and only yet to expire options.

`=QM_List("getOptionchain","symbol","AAL","expireMin","2020-07-19","expireMax","2020-09-18","strikeMin",12,"strikeMax",14,"inclExpired","false","inclZeroVol","false")`

If you need only puts.

`=QM_List("getOptionchain","symbol","AAL","expireMin","2020-07-19","expireMax","2020-09-18","strikeMin",12,"strikeMax",14,"inclExpired","false","inclZeroVol","false","callput","put")`

To get the full history of an options contract, try the function:

`=QM_List(“getHistory”,”symbol”,”@AAL200717P00018000″,”start”,”2020-01-21″) `

List of Methods

Below is a list of all the methods available. The links take you to the documentation of each function on Quotemedia’s support portal.

- 2.
- 3.
- 5.
- 6.
- 8.
- 10.
- 13.
- 19.
- 20.
- 21.
- 22.
- 25.
- 26.
- 27.
- 28.
- 30.
- 31.
- 32.
- 33.
- 34.
- 38.
- 40.
- 42.

Copy link