Hello!
I have bought and sold shares of a company multiple times whenever there was a dip or rise in the price. I have made total 10 transactions and the online website shows me my networth, Quantity, Investments, Today's gain and Overall gain. I want to replicate that in excel which I can do it with helper rows/columns but my file is kind of a dashboard with lot of data in it and I do not want to add helper rows/columns. First I was not able to understand how the the above parameters are calculated so to understand the same, I downloaded data from my portfolio on the website (shown below) and put it in excel which is attached with this email. I need assistance in writing a formula in the yelllow cells (preferably without having to add additional helper rows/columns). I am showing a pic of my excel sheet below and also a pic of how it is displayed online. The complete details are in the attachemnt.
I have shown it to my friends and some excel champs in my office but they could not do it. Please please please help me with this.
Thank you
EDIT:
If you see the online portfolio screenshot, there is one more important data that I missed.
It shows current invested price 110.13
This also needs to be factored somewhere along with the Live Price (current price) 119.70 for proper calculations
m2.png
m3.png
money.png
Bookmarks