Hello all,

On my current spreadsheet I want to insert a function that will grab a stock quote from a program I am running. I can do this with no issue BUT is there a way I can have this function move to the cell (A5) below it (A6) once I have imputed a new value into the current cell (A5). Basically i have historical data of stock prices but for the current day I want to show the current price in addition to the historical data since to get an up to the minute results. At the end of the day, I would insert the new historical data but want the function that is displaying the current price to move to the next cell so I don't have to recopy in the function... is this possible?

Another way I was thinking was to have a separate spreadsheet hold all the current prices and create a function that would place it into the current price on the spreadsheet with the historical data. And if I wanted to go to a new day there could be one cell where I input the row# and it would skip down to the next cell so I could add in the historical prices without needing to do anything to replace all the equations. Would there be a formula i could use for this?

Please not I am using a normal excel doc to do this.

Thanks!!!