Log In
Register
Home
New Member
January 12, 2022
Offline
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
Offline
If you have BYROW available to you, you could use:
=BYROW(A3#,LAMBDA(a,(INDEX(STOCKHISTORY(a,EOMONTH(TODAY(),-4)-1,,2,0),1,2)-INDEX(STOCKHISTORY(a,EOMONTH(TODAY(),-5)-1,,2),2,2))/INDEX(STOCKHISTORY(a,EOMONTH(TODAY(),-5)-1,,2),2,2)))
1 Guest(s)
