Function: QM_List()

The QM_List function provides access to QuoteMedia's comprehensive API methods, allowing you to retrieve detailed market data in a tabular format directly in Excel.

QM_List Function Tutorial

Function Structure

=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 data from QuoteMedia's API for any of their methods. The functions generally return the data in a tabular (list-like) form.

Getting Intraday History

To get all 5-minute intervals from March 18th, 2020:

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

To get 5-min intervals from March 18th, 2020 to present:

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

To get 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")

Date Format

The date format must always be "YYYY-MM-DD". The symbol can be a stock or an option symbol. For options, the symbol needs to be a "yet to expire" option.

Getting EOD History

To get history for the last month:

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

To get history from a specific start date:

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

To get history between specific dates:

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

Data Package Availability

QM_List methods are available depending on the data package you have purchased from QuoteMedia. For example, if you have purchased an Options data package, you will be able to access options-related methods only.

Filtering Option Contracts

QM_List function can filter option contracts. Many times a stock will have thousands of option contracts. Pulling all contracts is cumbersome, so you can filter them:

Get all options for AAL expiring between July 19th and September 18th, 2020:

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

Filter by strike price (minimum 12):

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

Filter by strike price range (12-14):

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

Exclude expired and zero volume contracts:

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

Filter for puts only:

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

Get full history of an options contract:

=QM_List("getHistory", "symbol", "@AAL200717P00018000", "start", "2020-01-21")

List of Methods

Below is a list of available methods. The links take you to the documentation on QuoteMedia's support portal.

Registration Required

To view the documentation, you need to register and create a new account in QuoteMedia's support portal. Your QuoteMedia data account credentials will not work here. When you click on any link below, you will be prompted to register or log in to create a free account.

getEnhancedQuotes
getQuotesMini
getChartData
getIndicatorsBySymbol
getHistory
getFullHistory
getExchangeHistory
getOptions
getOptionChain
getOptionQuotes
...and 70+ more methods (see QuoteMedia documentation)

← Previous: Streaming Functions Next: mxls_db_query Function →