Update MarketXLS Historical tables automatically
From release number 220.127.116.11, you will be able to keep the historical tables produced by MarketXLS updated with click of a button.
Select any cell within the table and click on update table like shown below..
MarketXLS uses Excel’s Current Region property to automatically understand the range of the cells that make up the historical table. Current Region is the range of cells that get selected when you Press CTRL + A in Excel. For this reason, please note that historical table must be a standalone table which means that the table needs to be separated by blank rows and columns on all sides.
MarketXLS will understand the last date in the table and will try and update the table to the last available day’s prices.
As on August 15th 2017, this only works with tables that have daily OHLCV data produced by marketXLS.