Utilities Tab in MarketXLS

Useful Lists

Market Movers

Earnings By Date

Function being revised

Symbol Lookup

Function being revised

Dividend History

Select any one stock and click on the dividend history option to get the dividend history.

Get Option Chains

Gets all available option contracts for stock, including the expired ones.
=QM_GetOptionChain("Stock Symbol")
Gets all available 'at the money' option contracts
=QM_GetOptionChainAtTheMoney("Stock Symbol")
Gets all available 'in the money' option contracts
=QM_GetOptionChainInTheMoney("Stock Symbol")
Gets all available monthly options
=QM_GetOptionChainMonthlies("Stock Symbol")
Gets all available weekly options
=QM_GetOptionChainWeekly("Stock Symbol")
Gets all available expiring most near term
=QM_GetOptionNearTerm("Stock Symbol")
Gets all available calls to the left and puts to the right, with Expiry in the middle
=QM_GetOptionStructures("Stock Symbol")
Gets all available options that expire at the maximum "OnDate"

=QM_GetOptionChainExpireMaximum ("Stock Symbol", OnDate -"YYYY-MM-DD")

Gets all available options that expire at the minimum "OnDate"

=QM_GetOptionChainExpireMinimum ("Stock Symbol", OnDate -"YYYY-MM-DD")

Option Scanner

Benzinga News

MarketXLS added news feed functionalities provided by Benzinga’s in-house analysis and data team. You’re able to access the news from relevant periods corresponding to market events.image.png

MarketXLS Update Table

Social Media

Copy link
On this page
Useful Lists
Market Movers
Earnings By Date
Symbol Lookup
Dividend History
Get Option Chains
Option Scanner
Benzinga News
MarketXLS Update Table
Social Media