I need a automatically updated Excel spreadsheet.
I want it to take the days ASX (Australian Stock Exchange) top Gainers Losers Data from [login to view URL] or reliable website for each day from now onwards.
I need the current price at close of market and % change, then I need the next day % change and the day after that % change.
Essentially I want it to continuously collect data for each days gainers and losers creating history of data that grows every day.
I'd also like the ASX overall performance in there as well, showing the price and % change, and then % change for the following two days.
Probably made it sound a lot more confusing than it is but the excel template I sent should clear it up, you may notice I only have the next days data % change for the first date 15th and none for second date 16th. Because the data is not out yet :)
Any clarification please message me