Yes you can. Like shown below… You will however require Barchart data subscription along with MarketXLS.


MarketXLS website has no link with the software purchase email. You will need to register on the site or login with Facebook, Twitter or Google to use the site, raise tickets and post in forums etc.

Not as on February 2017.

MarketXLS tries to update everything whenever the sheet recalculates (whenever I change something on the sheet) – and that takes a long time. It’s very cumbersome. Is there anyway to completely block marketXLS from updating automatically?


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 have impact on usability on 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 close price of a specefic day in past will always be the same.

So, unless you want the data to be updating continuously (like may be for real time prices) please copy and paste the formula cells as values. The way to do that is shown below…

How to Convert a Formula to a Static Value in Excel 2013

Copy the cells with formula, paste special them on the same cells as values, so that you see the values in the forumla bar instead of formulas.

Another good option is to turn Excel into Manual Mode as shown below…

My Excel hangs due to too many calculations, and I am not able to do anything until it finishes.

With the Version all licenses are floating. That means you will be able to install and use MarketXLS on any number of PCs. However, only one machine will be active at one time. You can simply apply the same license on any machine. If you want to simultaneously use MarketXLS on 2 or machines you may need additional license. In case you are already a customer and you need additional license we will offer a good discount.

Send us a message at

Yes. They do.

Install MarketXLS again as shown at the link below by downloading setup file from http://www. market / setup. exe

Exactly as shown below…

How to install MarketXLS

The MarketCap with function =MarketCapitalization(“symbol”) is calculated using the shares outstanding from the last filed annual or quarterly report. So, it could be a bit different from the current market Cap.

If you have too many functions in your sheets sometimes it becomes an issue and Excel is always calculating preventing you to do more with Excel. One way to solve this is to turn Excel formula calculation mode to Manual. This way you tell Excel when you calculate your Excel sheets instead of it always calculating.

To turn Excel into a manual mode of calculations ….

Click the File tab, click Options, and then click the Formulas category. In the Calculation options section, under Workbook Calculation, click Manual.

Note    When you click Manual, Excel automatically selects the Recalculate workbook before saving check box. If saving a workbook takes a long time, clearing the Recalculate workbook before saving check box may improve the save time.

  • To manually recalculate all open worksheets, including data tables, and update all open chart sheets, on the Formulas tab, in the Calculation group, click the Calculate Now button.

    Calculation group on the Formulas tab

  • To manually recalculate the active worksheet and any charts and chart sheets linked to this worksheet, on theFormulas tab, in the Calculation group, click the Calculate Sheet button. Or you can also use MarketXLS “Refresh” buttons on the menu.

In case you see no menu in Excel for MarketXLS it may have been disabled. To enable MarketXLS…

Go to File>>Options>> Addins>> COM Addins  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 mail that you received. (remove spaces).

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 (like below). Click on repair and follow the steps further.

repair excel

=Ask(“^GSPC”) for S&P
=Last1(“SPX:IND”) for S&P
=Last1(“CCMP:IND”) for NASDAQ
=Last1(“INDU:IND”) for DJIA

=Last(“^GSPC”)  S&P

=Last(“^DJI”) Dow Jones

=Last(“^IXIC”) Nasdaq Composite


For Canadian stocks simply append .TO at the end of the symbols. =Ask(“IPL.TO”)

Full list of indexes for which prices are available is here:  EU Stocks