I am importing stockmarket data into Excel via the DownloaderXL add-in published by Yaskov Anatoliy.
This application automatically provides historical market pricing and charts for specified funds/indicies. I need to update the charts to include extra horizontal lines -40% and -60% lower than the closing price for the last day. I am refreshing the data on a daily basis so the solution needs to be dynamic.
Any help/advice would be welcome.