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.

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

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.

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.

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.