I already have an excel spreadsheet set up to use a web query to get up to the minute refreshes of a stock with various financial data from yahoo finance.
Every minute it refreshes, the "Last trade" cell changes to the lastest trade value (say A1 is the cell thats changing value every minute)


My Question....

I'd like if someone could help me with a macro that would recognize when cell A1 changes, pushes the old value below, and displays the new value. so every time it refreshes, it keeps pushing the old value down one cell. over the course of the 8hr. day it will accumulate 480 values vertically stacked.

Thanks to whoever can help.... i've been going crazy.

my main objective is to plot the realtime intraday chart for some stocks and i need to obtain the data this way.....