Frequently Asked Questions (FAQ)

MarketXLS functions work just like normal Excel functions, if you have a large spreadsheet with all the formulas in there, every time you do operations like sorting/filtering, etc, MarketXLS functions will automatically calculate and go to the servers to get new information. This sometimes has an impact on the usability of Excel sheets.

To solve this issue it is best to copy and paste all the Formula results as Values once you have got the data. A lot of information does not change frequently like the close price of a specific day in the past will always be the same. So, unless you want the data to be updated continuously (like maybe for real-time prices) please copy and paste the formula cells as values.

Another option is to turn Excel into Manual Mode.

MarketXLS website and forum have no link with the software purchase email. You will need to register on the forum to use it.

Yes, you can. You will however require a Barchart data subscription along with MarketXLS.

For Canadian stocks simply append .TO at the end of the symbols. =Ask(“IPL.TO”) or use “:CA” in the end.

To get values for the Dow Industrials, S&P 500, and NASDAQ, use these stock codes to get the values:

  • S&P 500 – ^SPX
  • 3000 US RUSSELL – ^RUA
  • Russell 1000 US RUSSELL – ^RUI
  • Russell 2000 Growth US – ^RUO
  • Dow Jones – ^DJI

In case you see no menu in Excel for MarketXLS it may have been disabled. To enable MarketXLS… Go to File>>Options>> Add-ins>> COM Add-ins and if you have MarketXLS disabled there then enable it.

If this does not solve it try installing it again as an administrator by downloading the .msi file from the email that you received.

Alternatively, you can also try to repair your Microsoft Excel. To repair Microsoft Excel, follow these steps:

  • Go to Control Panel> Programs
  • Right-click on Microsoft Office/ Microsoft Excel> Select Change
  • A pop-up will appear.
  • Click on repair and follow the steps further.
  • Repair excel

For ASX stocks data, you have to purchase a quote-media data add-on for ASX equities/ETFs. The plan only has delayed data not real-time. The prices should be in AUD.

ASX stocks are only available via a Barchart subscription.

We have lots of videos that can help you use MarketXLS on our website. You can access these videos at the following link:

Here are a few links that will help you get started:

MarketXLS Intro Episode 1 MarketXLS Explainer

No MarketXLS does not cause any changes to your computer’s hard drive. It will only use a small bit of hard disk space for downloaded templates and some stock market data

Yes, we have put all software through a full virus scan. We also use quality control methods to test our software.

The United Kingdom, the United States of America, and some markets in Europe too. Please visit our website for the latest list of exchanges. You can also purchase other exchanges separately from Barchart.

No, you do not need any knowledge of Python or VBA to use MarketXLS.

We have many add-ons. Please visit our website for latest list of add-ons.

We do not offer forecasting at present. When you’re using our templates, you can see trends of your chosen stock tickers.

Yes, we have data available for new IPO’s. The amount of data will vary depending on what is available from the particular stock market.

You may get N/A or NA when there is no information for a given stock. This may have many causes. For example. The particular stock may not have information at a given time. The Stock in question may be in a different stock market to the ones you have subscribed to. There are many reasons that this might happen. Please ask our support team to look into it, we would be more than happy to help.

The amount of hard disk space you need on your computer/laptop is very small indeed. It is needed for some templates. There would also be a little market data which is stored in a very efficient manner. The MarketXLS software add-on to Excel is also very small as it is coded very efficiently by our team of developers.

No, there is no practical limit to the number of stocks you use

The software has been tuned to work on even old versions of excel. There should not be a problem because of our software. If you would need any help, please book a time using the below-mentioned link and our customer support team will be able to help you

You can either decide to refresh only the selected (with your mouse) stocks or the entire stock set by clicking on the Refresh Selected or the Refresh All buttons in the menu at the top.