Simple, straightforward pricing.

All US & Canadian stocks (including OTC stocks) are covered by default. Approximately 13,500 stocks.

All US & Canadian ETFS are covered by default. Approximately 3,119 ETFs.

All US stocks and Indices Stocks. Premium usable and tradeable data. The data includes all greeks.

All US Mutual funds (Approximately 35,000). Canadian Mutual funds are available on demand.

Live updates on all Major and Minor currency pairs.

US Indices, ^SPX, ^NDX, ^VIX etc.

We cover COMEX, NYMEX, CBOT & CME exchanges.

More than 1200 Cryptos. Almost all alt coins, 17 Exchanges indlcuding Binance, GDAX, Bitmex, almost 9600 symbol pairs, and advanced analysis on cryptos like returns, drawdowns, risk metrics etc.

Hundreds of economic indicators like Treasury rates, Unemployement rates, Housing statitics etc.

End of the day pricing updates are available for European and Asian stocks.

Create starter spreadsheets with a web-based spreadsheet builder. Select your stocks and select the metrics and click a button to download a fully functional spreadsheet.

Get pre-built, open, and customizable portfolio tracking, trade journaling, portfolio management, and optimization templates.

Get pre-built, open, and customizable portfolio tracking, trade journaling, portfolio management, and optimization templates.

Track your positions over their lifetime by leveraging Excel to snapshot complex multi-leg trades and optimize and review your trading strategies.

Track your positions over their lifetime by leveraging Excel to snapshot complex multi-leg trades and optimize and review your trading strategies.

Get the flexibility to pull any financial metric and fundamental historical data point on stocks to create your financial models and analysis. For example, =hf_revenue(symbol, 2019,2) will get you the revenue in 2019, quarter 2. =hf_assets(symbol, LQ) will get you last quarter assets, =hf_assets(symbol, LQ-1) will get you the previous quarter and so on. More than 200 functions to get the historical fundamentals from any financial statements. Complete coverage of all financial statements.

Key ratios and statistics of stocks available on a timely basis with easy to use functions for example =EearningsPerShare(stock), EearningsDate(stock) and hundreds more. Check out the full list of functions at https://marketxls.com/functions

Download quarterly and annual financial statements with a single click.

Screen stocks with hundreds on fundamental and key statistics with MarketXLS web based screener and download saved screened stocks in your Excel with ease.

Improve the odds of your stock picks with MarketXLS stock ranks based on Value, Quality, and Technical factors.

Find stocks that Gurus (Graham, Cathie Wood, Fisher Philip and more) approve. 35 Guru Screen stocks updated on a daily basis.

Get earnings dates, stock splits, dividend dates and more event related data in your Excel sheets.

Get EPS estimates from analysts.

Full dividend history on stocks at click of a button.

Perform advanced custom analytics on our databases to get insights with easy to use functions. For example. =mxls_db_query(Symbol, closePrice, Highest, 18) Gets you the highest price of a stock in last 18 days. Many calculations and variables are included by default.

Track option contracts and your positions in Excel.

Track option contracts REAL TIME and your positions in Excel with real-time streaming (auto-updating) functions.

Get real-time streaming greeks for all option contracts.

Filter option contracts that meet your criteria. For example, find option contracts that expire between two specified dates, between specified strikes, only the PUTS.

Scan thousands of options contracts between multiple underlying stocks or indices to find the contracts you like to trade quickly. Then, save those criteria, so you do not spend any time filtering new contracts again.

Blackscholes model calculations on option contracts.

Historical end of the day and intraday historical data on live and yet to expired contracts.

A measure of implied volatility vs its past 1 month values, but it looks only at the highest and lowest values. Formula is (Current IV - 1 month Low IV) / (1 month Max - 1 month Min)

Historical end of the day historical data on expired contracts going back 5 years via easy to use Excel functions.

Historical EOD data going back atleast 15 years

Intra-day historical data going back one year with upto a minute granularity.

Get returns, drawdowns, the highest price in x number of days, x number of weeks, beta, volatility, the correlation between assets, and more.

Share your watchlists with your team/group using MarketXLS secured workspace especially configured for your team (Requires custom confiurations).

Share your screens with your team/group using MarketXLS secured workspace especially configured for your team (Requires custom confiurations).

Use our MarketXLS XLSolve AI save time and get instant answers to your MarketXLS and Excel questions. Trained on a vast customer experience database, it saves you time and effort!

With more than one thousand MarketXLS function, use our AI driven intelligent search to quick find what function you are looking for with example implementations to directly copy and paste in your Excel sheets.

Get realtime answers on your real-time data with ChatGPT Integration

Create starter spreadsheets with a web-based spreadsheet builder. Select your stocks and select the metrics and click a button to download a fully functional spreadsheet.

Save time by using Excel functions to create trade tickets that can be entered in your trading platforms. ThinkOrSwim, Tradier and Orion are the trading platforms we currently support.

Various trading platforms use different format for option symbols. Use MarketXLS to convert options symbology from one platform to another.

Hundreds of pre-built MarketXLS templates that are open and unprotected for you to customize and use covering topics like Valuations, Option Strategies, Stock comparisons and more.

Keep your data tables upto date with smart features that automatically fill in the missing historical data at click of a button.

Pre complied stock lists like SP500, Stocks Below $5 and many more.

Stay on the top of the markets with daily updated stock lists with stocks and their performances.

Share your research (and success) with your followers on Twitter and StockTwits.

Get one click ready-made charts that are zoomable and highly customizable, right from your Excel sheets.

2 Hours of consulting included a value of $300

Consulting available at the rate of $150 per hour