Capture Date of highest value of stock Portfolio

[fkatona]

I am trying to capture the date at which my portfolio was at it's highest. I enter the value of my portfolio in H35. F36 is where I am trying to capture the date at which my portfolio was the highest. If a previous date was higher, leave as is.

This presents a problem of a circular reference, but do not know a way around this.


I have the following formula in F36
=IF(H35>G36,(F37),(F36))

In F37 is todays date

G36
=IF(G36<=H35,(H35),(G36))

H35 is value of my portfolio today