Web query refreshed data should get saved

[purusharth]

Hi all,

I have been working on a problem for over a week without any progress. I hope the people over here can help me.

I have a file ( see attached), it gets data from a web query and gets refreshed automatically after 1 min interval.
My request : Cell b1 to b48 contains the value which gets changed every minute. The titles are mentioned from a1 to a48. I want that when b1 gets refreshed to a new value then the old value should get stored somewhere, so that in the end I have 1 min prices of a1.
If would be really appreciated if we can get the time when the data got refreshed and in the 1 min database time is there when that data got saved.

Please look post#10 for correct working file.

Thanking you in anticipation
purusharth