Take regular readings of Values in a Dynamic Excel Sheet Connected to Web

Hello All,

I have a spreadsheet which is connected to web to fetch the stock prices and the excel sheet refreshes frequently updating the stock prices.

I would like to take a reading of the stock price separately for every 5 minutes so that i can see how the price has moved over the day for every 5 min or 1 min interval.

Could anybody help me with this? I hope i am clear in explaining my question.

Thanks in Advance.