Log In
Register
Home
April 6, 2022
Offline
I was intrigued by Mynda's Stocks Dashboard so decided to replicate it for my own needs.
I was unable to calculate the Average Cost & Cost of Holding. I have attached a sample sheet with data. Including info from Investment Provider site.
Cell G8 must be £358.96, not sure how this is arrived at.
Thanks so much for your time.
Kasey
VIP
Trusted Members
December 7, 2016
Offline
Hello,
I am not sure I understod this correct, I have followed the instructions but am far off from your wanted value. Do check if this is usable or not.
Br,
Anders
April 6, 2022
Offline
Hi
I can't get my head round it either. Very confusing
Thanks
Trusted Members
October 17, 2018
Offline
I have no idea of all these calculations but the formula in column G you have now does not really seem to work
In G6 I did the following and COUNTIFS($B$6:B6,"<>Sold") returns the number of rows <> Sold =SUMPRODUCT(($E$6:E6)*(COUNTIFS($B$6:B6,"<>Sold")))/F6
I cannot imagine how G8 could be = 358.96 I'll leave that to the number crackers
Moderators
January 31, 2022
Online
I started by recreating the scenario that was given in the picture. Then I copied that and filled in the numbers from your own example and arrived at a Cost of Holding of 362.62, which is slightly off from your number but that could well be due to rounding. See attached.
VIP
Trusted Members
December 7, 2016
Offline
Hello,
With the help by Hans’s and Riny’s comments I did some changes and now got the wanted result.
Hopefully it works with the real data too.
Br,
Anders
April 6, 2022
Offline
Oh great @Anders, please could you share your worksheet?
I get 362.62 like @Riny
Thanks
1 Guest(s)
