
New Member

January 12, 2022

Hi
Mynda's Share Portfolio Dashboard is the basis for the attached workbook.
I want to see the movement per calendar month. I can calculate the first row, but then when I update the formula with # to make it dynamic, it gives me a #REF! error (see column R). How can I update this formula to make it auto fill down.
It would also be nice to plot the current price between the 52week low and 52 week high to see how cheap or expansive the current price is compared to these two values. I can do the first line with a conditional formatting, but cannot make it dynamic. Ideally it should not be filled to the left but only be a vertical line indicating the reading.
Any suggestions on what changes I need to make?
Gabriël


Trusted Members
Moderators

November 1, 2018

1 Guest(s)
