Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Function: QM_List()


MarketXLS Video
Play video


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:

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

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

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 :

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

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

NOTE: 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 from Quotemedia, you will be able to access options-related methods only.

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.

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.

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.

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.

If you need only puts.

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


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.


  1. getEnhancedQuotes
  2. getQuotesMini
  3. getChartData
  4. getIndicatorsBySymbol
  5. getHistory
  6. getFullHistory
  7. getExchangeHistory
  8. getHeadlines
  9. getHeadlinesticker
  10. getHeadlinesStory
  11. getInsiderSummaryBySymbol
  12. getEarningsEventsBySymbol
  13. getEarningsEstimates
  14. getEarningsEstimatesByCountry
  15. getEarningsEstimatesBySymbol
  16. getEarningsPreannouncementsByCountry
  17. getEarningsSurprisesByCountry
  18. getEarningsSurprisesBySymbol
  19. getMarketStats
  20. getIntervals
  21. getIntraday
  22. getIntradayHistory
  23. getRecentTradesBySymbol
  24. getHistoricTradesBySymbol
  25. getBasicFundData
  26. getOptions
  27. getOptionChain
  28. getOptionQuotes
  29. getOptionChainSymbols
  30. getRecentOptionStats
  31. getCompanybysymbol
  32. getCompanyLogos
  33. getProfiles
  34. getAnalyst
  35. getBrokerratingsByCountry
  36. getDividendsByExchange
  37. getDividendsByCountry
  38. getDividendsBySymbol
  39. getListingChangesByCountry
  40. getLookupSymbols
  41. getMarketActivityStats
  42. getMarketOpenStatus