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 
Options Screener
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 

Options Pricing - Previous

Options Greeks

Next - Options Pricing

Option Pricing with Quotemedia

Last modified 11mo ago

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