Average Book Value

Groundhog

Hi, I've populated all my historic data and to make sure I fully understand how Portfolio Slicer works I've been trying to replicate some of the calculations. I've managed to do cost basis, but please could you explain Avg Book Value to me.

I suspect it quite basic and I'm missing the obvious!

Many thanks in advance

VidasMatelis

Hi,

For any proper tracking you should be using "Cost Basis" as it properly calculates your "Cost Basis".

Avg Book Value formula is:

=CALCULATE(
   DIVIDE(SUMX(Trans, Trans[TotalAmnt]*Report[TransReportExchRate])
      , SUMX(Trans, Trans[QtyChange])
  )
   , FILTER(TransType, OR(TransType[BookValueSign]=1, TransType[TransType]="Split"))
   , DatesBetween(Dates[Date], Blank(), LastDate(Dates[Date]))
) * Report[Qty Held]

So formula is:
1. Calculate average buy cost by dividing total amount spent by number of shares bought.
2. Multiple above number by currently held number of shares.

Groundhog

Thanks Vidas, much appreciated