https://marketxls.com/_next/static/chunks/25870-965c9f6050d6ef45.js

1"use strict";(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[25870],{72298:function(t,e,i){var o,a;i.d(e,{b:function(){return o}}),(a=o||(o={})).optionChainsVideo="/videos/option_chains_video.mp4",a.realTimeOptionsTracking="/videos/real-time-options-tracking.mp4",a.utilities="/videos/utilities.mp4",a.charts="/videos/charts.mp4",a.stockStreaming="/videos/stock_streaming.mp4",a.optionsStreaming="/videos/options_streaming.mp4",a.optionsFiltering="/videos/options_filtering.mp4",a.portfolioOptimization="/videos/portfolio_optimization.mp4",a.technicalIndicators="/videos/technical_indicators.mp4",a.historicalData="/videos/historical_data.mp4",a.cryptoDataInExcel="/videos/cryptos.mp4",a.stockScreener="/videos/stock_screener.mp4",a.addons="/videos/addons.mp4",a.aisearch="/videos/aisearch.mp4",a.cardStockStreaming="/videos/cards/stock_streaming.mp4",a.cardOptionsStreaming="/videos/cards/options_streaming.mp4",a.cardOptionsFiltering="/videos/cards/options_filtering.mp4",a.cardTechnicalIndicators="/videos/cards/technical_indicators.mp4",a.cardCryptos="/videos/cards/cryptos.mp4",a.cardAddons="/videos/cards/addons.mp4",a.xlsolveai="/images/xlsolveai.gif",a.effecientFrontier="/images/blog/invest-smarter-use-an-efficient-frontier-calculator.jpg",a.dividendCalendar="/images/marketxls_templates.png",a.introVideo="https://www.youtube.com/embed/y_TfCHS-nCA",a.useCasesVideo="https://www.youtube.com/embed/7Hzc1EzsXuU",a.optionProfitCalculatorVideo="https://www.youtube.com/embed/OF3CnlW4mWA",a.marketxlsDemoVideo="https://www.youtube.com/embed/mykAnK8yLu4",a.indiaLaunch="https://www.youtube.com/embed/BA_j-gyDXhQ",a.optionFunctionsAdvanced="https://www.youtube.com/embed/MAd5xn001aw",a.historicalDataFunctions="https://www.youtube.com/embed/y0iRSVr6dic",a.tradingIntegrations="https://www.youtube.com/embed/w8DgbRdhkxQ",a.portfolioAnalytics="https://www.youtube.com/embed/ePwI3tANxdc",a.rti_functions="https://www.youtube.com/embed/NX-7UXklIaQ",a.optionStrategyTemplates="https://www.youtube.com/embed/W6eNVfadN8U",a.returnFunctions="https://www.youtube.com/embed/m3Q6ZWZ4tDQ",a.optionsProfitCalculator="https://www.youtube.com/embed/OF3CnlW4mWA",a.sectorAnalysisReport="https://www.youtube.com/embed/WxarGceu4wY",a.optionsDemo="https://www.youtube.com/embed/Icr79Zhlxis",a.ind_explainerVideo="https://www.youtube.com/embed/XMhkM0z0PGY",a.ind_installingMarketXLS="https://www.youtube.com/embed/3E4O3LcYMsM",a.ind_applyingLicenseMarketXLS="https://www.youtube.com/embed/EHdHPBUAZ4k",a.ind_zerodhaConnectionMarketXLS="https://www.youtube.com/embed/kFwKOiynZRM",a.ind_angelOneStreamingConnection="https://www.youtube.com/embed/BhgATn-ATvc",a.ind_symbolLookupIndia="https://www.youtube.com/embed/XFzM2SZ6f5g",a.ind_applyingFunctions="https://www.youtube.com/embed/bJYlK8Hhenw",a.ind_historicalDataMarketXLS="https://www.youtube.com/embed/iwmHY62g6JQ",a.ind_optionSymbolMarketXLS="https://www.youtube.com/embed/C2-0qiBTTSw",a.ind_expirationNextFunctions="https://www.youtube.com/embed/v78imfa0lQc",a.ind_historicalFundamentals="https://www.youtube.com/embed/gOzEztebPl0",a.ind_historicalFundamentalsPeriodCodes="https://www.youtube.com/embed/Ek4Vq2-rjdc",a.ind_historicalFundamentalPERatio="https://www.youtube.com/embed/0zpXrcYuQO0",a.ind_historicalFundamentalNiftyPharma="https://www.youtube.com/embed/0BlaBYvigdg",a.ind_historicalFundamentalTemplates="https://www.youtube.com/embed/rPP1hHWowwQ",a.ind_dividendHistoryMarketXLS="https://www.youtube.com/embed/p_BYFr8gLFk",a.ind_watchlistInExcel="https://www.youtube.com/embed/QqBiUt2n6UM"},25870:function(t,e,i){i.d(e,{W:function(){return s}});var o=i(65808),a=i(72298);let s=[{sectionHeader:"DEFAULT DATA",headerTooltip:"\n          Data included by default in your plan: \n          <ul>\n            <li> 13,574 Stocks & their Options </li>\n            <li> 26,802 Mutual Funds, </li>\n            <li> 9,601 Crypto Currencies combinations </li>\n            <li> 3119 ETFs </li>\n          </ul>\n        ",isDefaultData:!0,blocks:[{title:"Stocks",checkList:[o.d.delayed15Minutes,o.d.realTimeStreaming,o.d.realTimeStreaming],tooltipText:"All US & Canadian stocks (including OTC stocks) are covered by default. Approximately 13,500 stocks."},{title:"ETFs",checkList:[o.d.delayed15Minutes,o.d.realTimeStreaming,o.d.realTimeStreaming],tooltipText:"All US & Canadian ETFS are covered by default. Approximately 3,119 ETFs."},{title:"Options",checkList:[o.d.endOfDay,o.d.realTimeStreaming,o.d.realTimeStreaming],tooltipText:"All US stocks and Indices Stocks. Premium usable and tradeable data. The data includes all greeks."},{title:"Mutual Funds",checkList:[o.d.endOfDay,o.d.endOfDay,o.d.endOfDay],tooltipText:"All US Mutual funds (Approximately 35,000). Canadian Mutual funds are available on demand. "},{title:"Forex",checkList:[o.d.delayed15Minutes,o.d.delayed15Minutes,o.d.realTimeStreaming],tooltipText:"Live updates on all Major and Minor currency pairs."},{title:"Indices",checkList:[o.d.AvailableOnDemand,o.d.endOfDay,o.d.realTimeStreaming],tooltipText:"US Indices, ^SPX, ^NDX, ^VIX etc."},{title:"Futures",checkList:[o.d.AvailableOnDemand,o.d.AvailableOnDemand,o.d.AvailableOnDemand],tooltipText:"We cover COMEX, NYMEX, CBOT & CME exchanges."},{title:"Cryptos",checkList:[o.d.delayed15Minutes,o.d.AvailableOnDemand,o.d.AvailableOnDemand],tooltipText:"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. "},{title:"Economic Indicators",checkList:[o.d.endOfDay,o.d.endOfDay,o.d.endOfDay],tooltipText:"Hundreds of economic indicators like Treasury rates, Unemployement rates, Housing statitics etc."},{title:"International Stocks",checkList:[o.d.AvailableOnDemand,o.d.AvailableOnDemand,o.d.AvailableOnDemand],tooltipText:"End of the day pricing updates are available for European and Asian stocks."}]},{sectionHeader:"MANAGE, MONITOR, TRACK, ANALYZE AND REPORT ON YOUR PORTFOLIOS IN EXCEL",blocks:[{title:"Spreadsheet Builder",checkList:[!0,!0,!0],tooltipText:"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."},{title:"Starter Spreadsheets",checkList:[!0,!0,!0],tooltipText:"Get pre-built, open, and customizable portfolio tracking, trade journaling, portfolio management, and optimization templates."},{title:"Portfolio Analytics Functions",checkList:[!0,!0,!0],videoLink:a.b.portfolioAnalytics},{title:"Portfolio Templates",checkList:[!0,!0,!0],tooltipText:"Get pre-built, open, and customizable portfolio tracking, trade journaling, portfolio management, and optimization templates."},{title:"Real time positions tracking",checkList:[!1,!0,!0],tooltipText:"Track your positions over their lifetime by leveraging Excel to snapshot complex multi-leg trades and optimize and review your trading strategies. "},{title:"Real time analytics functions",checkList:[!1,!1,!0],videoLink:a.b.rti_functions},{title:"End of day positions tracking",checkList:[!0,!0,!0],tooltipText:"Track your positions over their lifetime by leveraging Excel to snapshot complex multi-leg trades and optimize and review your trading strategies. "}]},{sectionHeader:"VALUE STOCKS, CREATE YOUR OWN STOCKS RANKS, CREATE YOUR OWN VALUATION/RISK MODELS",blocks:[{title:"Historical Fundamental data (10 years)",checkList:[!0,!0,!0],tooltipText:"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 fund

1amentals from any financial statements. Complete coverage of all financial statements. "},{title:"Key Statistics/Ratios",checkList:[!0,!0,!0],tooltipText:"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"},{title:"Financial Statements",checkList:[!0,!0,!0],tooltipText:"Download quarterly and annual financial statements with a single click. "}]},{sectionHeader:"PICK THE RIGHT STOCKS",blocks:[{title:"Web-based Stock Screener",checkList:[!0,!0,!0],tooltipText:"Screen stocks with hundreds on fundamental and key statistics with MarketXLS web based screener and download saved screened stocks in your Excel with ease. "},{title:"MarketXLS Stock Ranks",checkList:[!0,!0,!0],tooltipText:"Improve the odds of your stock picks with MarketXLS stock ranks based on Value, Quality, and Technical factors."},{title:"Guru Screens",checkList:[!0,!0,!0],tooltipText:"Find stocks that Gurus (Graham, Cathie Wood, Fisher Philip and more) approve. 35 Guru Screen stocks updated on a daily basis."},{title:"Stocks Events data",checkList:[!0,!0,!0],tooltipText:"Get earnings dates, stock splits, dividend dates and more event related data in your Excel sheets."},{title:"Analyst Estimates",checkList:[!0,!0,!0],tooltipText:"Get EPS estimates from analysts."},{title:"Dividend History",checkList:[!0,!0,!0],tooltipText:"Full dividend history on stocks at click of a button."},{title:"Query our database for Insights",checkList:[!0,!0,!0],tooltipText:"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."}]},{sectionHeader:"MAKE BETTER OPTIONS TRADES",blocks:[{title:"Options Tracking",checkList:[!0,!0,!0],tooltipText:"Track option contracts and your positions in Excel."},{title:"Real time Option Tracking",checkList:[!1,!0,!0],tooltipText:"Track option contracts REAL TIME and your positions in Excel with real-time streaming (auto-updating) functions.",videoLink:a.b.realTimeOptionsTracking},{title:"Real Time Greeks",checkList:[!1,!0,!0],tooltipText:"Get real-time streaming greeks for all option contracts."},{title:"Option Filtering",checkList:[!1,!0,!0],tooltipText:"Filter option contracts that meet your criteria. For example, find option contracts that expire between two specified dates, between specified strikes, only the PUTS."},{title:"Options Scanner",checkList:[!1,!0,!0],tooltipText:"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."},{title:"Options Profit Calculator",checkList:[!1,!0,!0],videoLink:a.b.optionsProfitCalculator},{title:"Options Strategy Templates",checkList:[!0,!0,!0],videoLink:a.b.optionStrategyTemplates},{title:"Option Valuation Functions",checkList:[!0,!0,!0],tooltipText:"Blackscholes model calculations on option contracts."},{title:"Options Historical Data",checkList:[!1,!0,!0],tooltipText:"Historical end of the day and intraday historical data on live and yet to expired contracts."},{title:"IV Ranks",checkList:[!0,!0,!0],tooltipText:"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)"},{title:"Options Historical Data (Expired Contracts)",checkList:[!1,!1,!0],tooltipText:"Historical end of the day historical data on expired contracts going back 5 years via easy to use Excel functions."},{title:"Advanced Options Summary Functions",checkList:[!1,!1,!0],videoLink:a.b.optionFunctionsAdvanced}]},{sectionHeader:"GET INSIGHTS FROM THE PAST",blocks:[{title:"EOD Historical",checkList:[!0,!0,!0],tooltipText:"Historical EOD data going back atleast 15 years"},{title:"Intraday Historical",checkList:[!1,!0,!0],tooltipText:"Intra-day historical data going back one year with upto a minute granularity."},{title:"Historical Data Functions",checkList:[!0,!0,!0],videoLink:a.b.historicalDataFunctions},{title:"Time Series Calculations",checkList:[!0,!0,!0],tooltipText:"Get returns, drawdowns, the highest price in x number of days, x number of weeks, beta, volatility, the correlation between assets, and more."},{title:"Stork Return Functions",checkList:[!0,!0,!0],videoLink:a.b.returnFunctions}]},{sectionHeader:"COLLABORATE WITH YOUR TEAM (MARKETXLS SECURED TEAM WORKSPACE)",blocks:[{title:"Share & Access Watchlists",checkList:[!0,!0,!0],tooltipText:"Share your watchlists with your team/group using MarketXLS secured workspace especially configured for your team (Requires custom confiurations)."},{title:"Share & Access Screens",checkList:[!0,!0,!0],tooltipText:"Share your screens 

1with your team/group using MarketXLS secured workspace especially configured for your team (Requires custom confiurations)."}]},{sectionHeader:"WORKFLOW UTILITIES",blocks:[{title:"MCP Server - AI Assistant Integration",isNew:!0,checkList:[!0,!0,!0],tooltipText:"Connect Claude, ChatGPT, Cursor and other AI tools directly to 500+ MarketXLS financial data functions via Model Context Protocol (MCP). Get real-time prices, fundamentals, options analytics, and technical indicators through natural language."},{title:"AI Driven function search",checkList:[!0,!0,!0],tooltipText:"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."},{title:"Spreadsheet Builder",checkList:[!0,!0,!0],tooltipText:"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."},{title:"Trading Functions",checkList:[!0,!0,!0],videoLink:a.b.tradingIntegrations,tooltipText:"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."},{title:"Options symbology converter",checkList:[!0,!0,!0],tooltipText:"Various trading platforms use different format for option symbols. Use MarketXLS to convert options symbology from one platform to another."},{title:"Pre-build templates",checkList:[!0,!0,!0],tooltipText:"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."},{title:"Dynamic Tables",checkList:[!0,!0,!0],tooltipText:"Keep your data tables upto date with smart features that automatically fill in the missing historical data at click of a button."},{title:"Ready made stock lists",checkList:[!0,!0,!0],tooltipText:"Pre complied stock lists like SP500, Stocks Below $5 and many more."},{title:"Daily Market Trackers",checkList:[!0,!0,!0],tooltipText:"Stay on the top of the markets with daily updated stock lists with stocks and their performances.",videoLink:a.b.sectorAnalysisReport},{title:"Stock-Twits/Twitter Integration",checkList:[!0,!0,!0],tooltipText:"Share your research (and success) with your followers on Twitter and StockTwits."},{title:"Ready Made Charts",checkList:[!0,!0,!0],tooltipText:"Get one click ready-made charts that are zoomable and highly customizable, right from your Excel sheets."}]},{sectionHeader:"GET RIGHT SUPPORT TO HELP YOUR WORKFLOW",blocks:[{title:"Fanatical Personal Service",checkList:[!0,!0,!0]},{title:"Optimize your sheets",checkList:[!1,!1,!0],tooltipText:"2 Hours of consulting included a value of $300"},{title:"Consulting",checkList:[!1,!1,!1],tooltipText:"Consulting available at the rate of $150 per hour"},{title:"Online Knowledge-base",checkList:[!0,!0,!0]}]},{sectionHeader:"MORE DATA? FUTURES, INDICES, INTERNATIONAL PRICES, EUROPEAN DATA AVAILABLE ON DEMAND",blocks:[{title:"Additional data avalable for purchase",checkList:[!0,!0,!0]}]}]}}]);