Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Buy price in Holdings

Hi Vidas,

Can I get the Buy price in Holdings. Adding the price field does not give me the last buy price.
The options are min, max, avg etc. but not the latest buy price.
Min: gives dividend price
Max: gives the sales price

Thanks for your help

Comments

  • Hi - check "Cost Basis Per Unit" - it shows average buy price. Remember, you might have multiple buy transactions - directly or through DRIP, so this measure better represents what you are looking for. Formula is:
    =ROUND(DIVIDE(Report[Cost Basis] , Report[Qty Held]), 6)
    
  • Thanks a lot
Sign In or Register to comment.