Hello,

I am currently working on one minute data of oil prices. The file contains one minute data of several years. It comes in the form of date, time, open price , high price , low price, close price.
I would like to have in one additional column the percentage change of each and every minute in a given day relative to the last day close price. Any ideas how can I formulate it on the excel sheet?
The thing is that for each day there is a different number of lines. The formula has to identify the change in the date in order to refer to last day close price.


Thanks a lot for any help with that.

Hidai