calculating delta between a daily updating value

[Sachin Filinto]

I have a table of values which update once a day through a web query. I need a way to calculate the delta between each update daily.
Below is a representation of the table with the query removed to simplify.

As shown in the picture, the date and value change daily. suggestions on how to approach this would be appreciated. I assume I would have to build a table inserting the date and value on a daily basis ?

the enclosed excel file has the web query removed to simplify & reduce size of the file.

Thanks in advance.

 

[NARAYANK991]

Hi ,

The easiest way would be to have a macro which when you run it , transfers data from the web-query table into a table in another worksheet , so that a complete history is maintained.

This archival table can be used for any kind of reporting that you want.

Narayan