Running Stock Cost Basis

[dw_22801]

Hi,

I am trying to keep a running cost basis on the stock I own where I just enter buy and sell transactions, and it keeps a current total shares owned and current cost basis. On the ETH tab, I enter buys and sells, and the Summary table to the right pulls the current balance of shares. Can't quite figure out how to make the cost basis calculate. Any ideas?


Thanks

[Estevaoba]

Have you tried this?

Sheet ETH:
H4=SUM(H3,[@[Per/ETH Cost]]*[@['# ETH]])
Drag down.

Or:
H11=SUMPRODUCT(Table1['# ETH],Table1[Per/ETH Cost])

[FlameRetired]

If I have understood the concepts try this

Please Login or Register  to view this content.

[dw_22801]

Thanks for your help!

[FlameRetired]

You're welcome. Thanks for the feedback and the rep.