https://marketxls.com/_next/static/chunks/58810-6e1486cc7cde6178.js

1(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[58810],{46377:function(e,t,a){"use strict";var o=a(85893),s=a(87224),n=a.n(s),i=a(81986),r=a(26548),l=a(84091),u=a(67294),c=a(92814),d=a(32666),h=a(69030);t.Z=e=>{let{questionAnswerList:t}=e,[a,s]=(0,u.useState)(-1),p=e=>{s(e===a?-1:e)},m=(e,t)=>{("Enter"===e.key||" "===e.key)&&(e.preventDefault(),p(t))};return(0,o.jsxs)("div",{className:n().frequentlyAskedQuestions,children:[(0,o.jsx)("h2",{className:n().title,children:"Frequently asked questions"}),function(e){let t=arguments.length>1&&void 0!==arguments[1]?arguments[1]:0;return e?(0,o.jsx)("div",{children:(0,o.jsx)(i.Z,{children:(0,o.jsx)(r.Z,{className:n().sectionContent,children:e.map((e,s)=>{let i=a===(s+=t);return(0,o.jsxs)(l.Z,{sm:12,md:6,className:"".concat(n().blockWrapper," ").concat(i?n().active:""),onClick:()=>p(s),onKeyDown:e=>m(e,s),tabIndex:0,role:"button","aria-expanded":i,"aria-controls":"faq-answer-".concat(s),children:[(0,o.jsx)(c.G,{icon:i?d.Kl:h.faPlus,className:"colorPrimary ".concat(n().icon),"aria-hidden":"true"}),(0,o.jsxs)("div",{children:[(0,o.jsx)("span",{className:n().question,children:e.question}),i&&(0,o.jsx)("p",{className:n().answer,id:"faq-answer-".concat(s),children:e.answer})]})]},s)})})})}):(0,o.jsx)("div",{})}(t)]})}},26350:function(e,t,a){"use strict";a.d(t,{n:function(){return o}});let o={pricingPage:[{question:"Where does the data come from?",answer:"Quotes data comes Quotemedia is 15 minutes delayed. Historical data, fundamental data come from multiple sources. The data is aggregated, transformed, cleaned and maintained on our secured servers and delivered through MarketXLS API. Real time live data is also available via Quotemedia's or Barchart's subscription"},{question:"Does the data change automatically?",answer:'It depends on the functions you use and the data subscriptions you have. You can stream real time data and also get data on a "refresh on demand" basis.'},{question:"Bloggers and Educators Discount?",answer:"If you are a full time blogger or an educator, you may get a discount on your purchase of MarketXLS. Contact us to submit your request."},{question:"Can I cancel anytime?",answer:"Yes, of course. You will have a link to manage your subscription and cancel anytime."},{question:"For what Countries and Exchanges this work?",answer:"MarketXLS works for US, Canadian, UK, and German & Australian* markets. * Australian Exchange ASX - requires additional barchart subscription for live data."},{question:"How do I contact you?",answer:"Email us at support @ marketxls.com. Or call us at US toll-free 1-877-778-8358."},{question:"I am a Forex trader can MarketXLS benefit me?",answer:"Yes, of course. You should be able to stream real time forex pricing in Excel and create your own indicators."},{question:"Can I use my own data?",answer:"Of course you can. The functionality described above can be used with any Time series data. "},{question:"Can I use VBA with MarketXLS functions?",answer:"Yes, of course."},{question:"Can I use this on multiple PCs?",answer:"Yes, the license is floating so can be used on any machine as long as its not used on multiple machines simultaneously with one license."},{question:"Does this work with Mac?",answer:"Yes! MarketXLS works natively on Mac through our Office 365 add-in. Simply install it from within Excel for Mac via File > Get Add-ins, or from the Microsoft AppSource marketplace. We also offer a Google Sheets add-on that works on any platform."},{question:"I trade US stocks and Options, which plan should I choose?",answer:"Even with the Basic version of MarketXLS and additional options data bundle you should be able to stream real time options data and get delayed live pricing for stocks and ETFs. All plans of MarketXLS give you the ability to buy additional data bundles."},{question:"How do I learn the software?",answer:"If you know how to use Excel then you already know how to use MarketXLS. There may however be some functions which you may need to be aware of. You learn those refer to our Knowledgebase."},{question:"What happens before renewal?",answer:"We will send an email to notify you that your subscription is about to renew with a link to cancel it if you need to do that."},{question:"Is there a Money-back Guarantee?",answer:"We offer a 30 day money back guarantee on MarketXLS platform's annual pricing. The additional data is purchased on a monthly subscription basis. The money back guarantee is not available for additional data purchases.  Please refer to our refund policy here."}],historicalOptionPricesPage:[{question:"Where can I find Historical Options Prices?",answer:"In MarketXLS menu, you can use the Historical button to get a list of some of the most commonly used Historical features."},{question:"How to backtest historical prices?",answer:'You can use our Historical functions to get options prices on a 

1specified date for Backtesting. [=Close_Historical("Symbol",\xe2€œdate\xe2€\x9d)].'}],realTimeStockOptionPricingExcelPage:[{question:"How to track Real-time Options prices?",answer:'To stream real-time price information, use any of the QM Stream functions such as =QM_stream_Last("symbol").'},{question:"How to Track Greeks in Real-time?",answer:'You can monitor any of the Greeks in Real-time with =QM_Stream_Delta/Gamma/Rho/Theta/Vega("Symbol").'},{question:"Symbol limit for options tracking?",answer:"Tracking options are limited to 300 symbols."},{question:"How to get Implied Volatility of options?",answer:"By entering =ImpliedVolatility into the worksheet, you will be able to use all of MarketXLS IV functions."},{question:"Can I calculate options profit?",answer:"Our brand-new Options profit calculator allows you to visualize your custom strategies in advance with estimated profits until expiration."}],historicalStockDataInExcelPage:[{question:"How to add real time stock quotes in excel ?",answer:"To validate your Real-Time data, type in one of the streaming functions:\n=qm_stream_last(symbol) \nOnce you input the function, data should start streaming. "},{question:"How do you automatically update stock prices in Excel?",answer:"You can either use streaming functions to stream real time prices inside excel automatically, or you can use =qm_last(symbol) functions and press refresh button at the top left corner of marketxls to update the stock price in excel."},{question:"What is the formula of live stock quotes in excel?",answer:"To validate your Real-Time data, type in one of the streaming functions:\n=qm_stream_last(symbol) \nOnce you input the function, data should start streaming. "},{question:"Can you get historical stock data in Excel?",answer:"MarketXLS allows you to get historical stock data directly in your excel sheet within seconds. You can get the data for a particular date in the past or even choose a time range to get the historical values for that period."},{question:"How do I extract stock data in Excel?",answer:'You can use simple functions like =open("MSFT") to get the open price of the stock symbol. We have similar functions for all the important stock parameters like open,high,low,close,bid,ask,volume,change, etc. MarketXLS also offers real-time stock data in excel.'},{question:"Does MarketXLS provide an Excel function that returns historical adjusted close prices for stocks and ETFs, and is a Barchart data subscription required to use those functions?",answer:'Yes, MarketXLS provides the historical adjusted close prices. You have to use the "Custom Dates" button on the menu bar. It allows you to filter through different dates, ascending/descending order, and different time frames like daily, weekly, or monthly. This does not require a Barchart subscription unless you need stock data from CME, COMEX, CBOT, ICE Canada, etc. The "Custom Dates" function and other historical data functions should work with all MarketXLS subscriptions. The only historical data that you do not get in the Pro plan is "Intraday historical data".'}],optionsTradingExcelPage:[{question:"How do you get Options prices in Excel?",answer:"You can either stream real-time data from the market into excel by using streaming functions, or you can use qm_last(symbol) to retrieve last price and refresh manually when needed."},{question:"How do you get Option chain in Excel?",answer:'You can query the option chain of any stock ticker by using =QM_GetOptionChain("Symbol")'},{question:"Can you get Implied Volatility Percentile & Ranks?",answer:"By entering =ImpliedVolatility into the worksheet, you will be able to use all of the MarketXLS percentile and ranking functions."},{question:"How to create an Option Symbol?",answer:"You can create an option symbol by using the =OptionSymbol() function, which takes as input a stock ticker, expiry date, Call or Put and strike price."},{question:"Are there any pre-build templates available?",answer:"Yes, all the prebuild options strategies templates are available on the website's template section."}],stockQuotesInExcelPage:[{question:"How to add real time stock quotes in excel?",answer:"To validate your Real-Time data, type in one of the streaming functions:\n=qm_stream_last(symbol) \nOnce you input the function, data should start streaming. "},{question:"How do you automatically update stock prices in Excel?",answer:"You can either use streaming functions to stream real time prices inside excel automatically, or you can use =qm_last(symbol) functions and press refresh button at the top left corner of marketxls to update the stock price in excel."},{question:"What is the formula of live stock quotes in excel?",answer:"To validate your Real-Time data, type in one of the streaming functions:\n=qm_stream_last(symbol) \nOnce you input the function, data should start streaming. "},{question:"Can you get historical stock data in Excel?",answer:"MarketXLS allows you to get historical stock data directly in your excel sheet within seconds. You can get the data for a particular date in the past or even choose a time range to get the historical values for that period."},{question:"How do I extract stock data in Excel?",answer:'You can use simple functions like =open("MSFT") to get the open price of the stock symbol. We have similar functions for all the important stock parameters like open,high,low,close,bid,ask,volume,change, etc. MarketXLS al

1so offers real-time stock data in excel.'},{question:"Does MarketXLS provide an Excel function that returns historical adjusted close prices for stocks and ETFs, and is a Barchart data subscription required to use those functions?",answer:'Yes, MarketXLS provides the historical adjusted close prices. You have to use the "Custom Dates" button on the menu bar. It allows you to filter through different dates, ascending/descending order, and different time frames like daily, weekly, or monthly. This does not require a Barchart subscription unless you need stock data from CME, COMEX, CBOT, ICE Canada, etc. The "Custom Dates" function and other historical data functions should work with all MarketXLS subscriptions. The only historical data that you do not get in the Pro plan is "Intraday historical data".'}],optionsProfitCalculatorLpPage:[{question:"What is an option profit calculator?",answer:"An Options profit calculator can tell you whether a particular options trade is likely to make or lose money based on changes in the underlying security's price as well as other factors, such as how many shares are in each contract and what strike prices were used."},{question:"How to calculate options profit?",answer:"The Options Profit Calculator updates everything in real time. Simply drag the strikes to reposition your trade, or adjust IV and other variables to see how it affects your trade\xe2€”this will give you a deeper insight into how options work as you tweak different inputs to find the optimal setup for your strategy. You can use it to construct your own strategies or just see how others are trading in real-time."},{question:"How accurate is the options profit calculator",answer:"While the options profit calculator is pretty accurate, it can't predict the future. The biggest unknown about that future is implied volatility\xe2€”the expected volatility of an option and affected by its supply and demand. High IV can affect many factors, such as upcoming earnings or other uncertainty."}],optionsProfitCalculatorPage:[{question:"How do I calculate options profit and loss in Excel?",answer:"With the MarketXLS Options Profit Calculator Excel template, you enter a stock ticker, build your option legs (up to 10), and the template automatically calculates your P&L at expiration and at every point until expiry using the Black-Scholes pricing model. It generates payoff charts, breakeven prices, max profit, max loss, and probability of profit — all inside Excel with real-time data from MarketXLS."},{question:"What option strategies does the Excel calculator support?",answer:"The template supports any multi-leg option strategy including covered calls, cash-secured puts, vertical spreads (bull call, bear put), iron condors, iron butterflies, straddles, strangles, calendar spreads, diagonal spreads, and fully custom strategies. You can combine up to 10 option legs plus a stock position. It includes 20+ preset strategies that auto-populate with live strikes and premiums."},{question:"What is the Scenario Matrix in the options profit calculator?",answer:"The Scenario Matrix generates three heat-map grids showing how your strategy performs under different conditions: Price vs. IV Change, Price vs. Days to Expiry, and IV Change vs. DTE. Each cell is color-coded red (loss) to green (profit) so you can instantly see where your strategy makes or loses money across hundreds of scenarios."},{question:"How does the Monte Carlo simulation work for options?",answer:"The Monte Carlo engine runs up to 100,000 simulations of your stock price using Geometric Brownian Motion with daily steps. It outputs probability of profit, expected value, median outcome, Value at Risk (VaR at 95%), Conditional VaR (Expected Shortfall), and generates both a P&L histogram and cumulative probability chart — giving you a statistical edge in evaluating your trades."},{question:"Do I need a MarketXLS subscription to use this template?",answer:"The template works best with an active MarketXLS subscription, which provides real-time streaming option prices, live option chains, implied volatility data, and Greeks directly in Excel. However, you can also use the template manually by entering your own strike prices, premiums, and expiry dates — the Black-Sch

1oles engine and all analytics run locally in VBA with no external calls needed."},{question:"What Greeks does the options profit calculator compute?",answer:"The Greeks Lab sheet calculates Delta, Gamma, Theta, Vega, and Rho for each individual leg and for the net position. It shows both per-share values and dollar-weighted (position-adjusted) values, so you know exactly how a $1 price move, 1% IV change, or one day of time decay affects your entire position. It also charts all Greeks across a range of underlying prices."}],IndiaLandingPageQuestionAnswers:[{question:"What is this product?",answer:"An Excel add-in that turns your Excel sheet into a stock research system. It connects your Excel to brokers like Zerodha and AngelOne and streams all the data into your Excel sheets."},{question:"How much does it cost?",answer:"The typical cost started from INR 999 a month."},{question:"Can it get Options data and Greeks?",answer:"Yes, MarketXLS gets all the options data into your sheets, calculates all Greeks, including historical data in your sheets."},{question:"Can it get Live Options Open Interest?",answer:"Yes, along with the greeks MarketXLS gets all Open Interests but live and End of the day."},{question:"How do I use this product?",answer:'MarketXLS will add hundreds of new stock formulas to your Excel. So, just like you use Excel functions, you use functions, for example, =Last("NIFTY:IN") will get you the price of Nifty.'},{question:"How do I analyze a company with this tool?",answer:"We provide custom-made excel sheets that you can use, and the best part is you can create your own with MarketXLS formulas."},{question:"Is it easy to use?",answer:"Yes, it’s a plugin for MS Excel, just like you use Excel formulas, you use MarketXLS stock formulas to get the answers."},{question:"Can I use this tool to analyze company fundamentals?",answer:"Yes, our fundamental data comes from the most premium data sources available in India (MorningStar). If you are analyzing companies, we provide many ready-made Excel sheets that are made with our formulas."},{question:"What stocks does this cover?",answer:"This system covers all NSE stocks, all NIFTY indices and all Mutual Funds. Some plan even offer US data too as an addon."},{question:"Does it work on MAC? or Only Windows?",answer:"MarketXLS work on MACs, Window machines and even in your browser with MS Excel."}]}},87224:function(e){e.exports={frequentlyAskedQuestions:"FrequentlyAskedQuestions_frequentlyAskedQuestions__hQJuQ",title:"FrequentlyAskedQuestions_title__0LWV_",sectionContent:"FrequentlyAskedQuestions_sectionContent__vpRpF",blockWrapper:"FrequentlyAskedQuestions_blockWrapper__sy_cN",active:"FrequentlyAskedQuestions_active__jcBsx",icon:"FrequentlyAskedQuestions_icon__hgK2p",question:"FrequentlyAskedQuestions_question__dLPkz",answer:"FrequentlyAskedQuestions_answer__6nZ0h"}}}]);