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 August 2016.
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…
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…
The license is based on machine. You will not be able to install the same license on 2 machines. In case you are moving your PC or Computer, please send us an email at support @ market xls. com (remove spaces). We will disable the old machine license and send a new licence key for the new PC/Computer.
Do the technical analysis and pattern scan features work if I import my own data and use the same formatting?
Yes. They do.
Install MarketXLS again as shown at the link below by downloading setup file from http://www. market xls.com / setup. exe
Exactly as shown below…
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.
- 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 exe file from www.marketxls.com/ setup .exe (remove spaces).
=Ask(“^GSPC”) for S&P
=Last1(“SPX:IND”) for S&P
=Last1(“CCMP:IND”) for NASDAQ
=Last1(“INDU:IND”) for DJIA
=Last(“^DJI”) Dow Jones
=Last(“^IXIC”) Nasdaq Composite
For Canadian stocks simply append .TO at the end of the symbols. =Ask(“IPL.TO”)