Everyone's individual MVP Portfolio pages are fixe

Everyone's individual MVP Portfolio pages are fixed and running.  Note:  The Alerted Gains, which is essentially the performance of your portfolio from the alerted price to the current trading price is automatically updated when you check your page or refresh your browser.  The High of Year % must be manually updated, so this will be done at the close everyday.

If anyone is a genius at writing excel formula's I could use help automating the High of Year %.  The formula's I have tried return circular references.  If someone knows a good formula for this you would save me so much time.  The issue is that the HOD, which I use to manually update the high of year column, refreshes daily, which is the issue I am encountering.  For now I will update it manually, but if anyone can think of a good formula to automate that column than I am all ears.  TIA