I'm gathering my assets information (cash, RSP, margin, etc) in an excel to keep track of my saving progress over time.
I'm struggling about which amount to put, for example, I invested 1000$ this year, made 1 trade of 30$ profit (Realized). Made 1 trade of 10$ loss (realized). Then bought some shares which currently has an unrealized gain of 70$ (unrealized).
In my assets cell, Should I put:
The amount I invested in (1000)
The amount invested plus realized gain /loss (1020)
The amount invested plus realized and unrealized gain. (1090)