ZackChua95
New Member
- Joined
- May 21, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- MacOS
Hi all!
I've recently found an issue with my formula when I am filling up the shares I re-bought.
In 2021, I've bought bought 6 TSLA shares and sold all. However, the portfolio side would still reflect the average cost of all my shares without any reset.
Because it did not reset, in 2022 I bought more TSLA shares, it will add in the average along with my past shares that are all being sold. Is there a formula to reset the average cost to 0 if I had no more shares?
Thank you for reading through and assisting me on this in advance.
Cheers,
Zack
*PS, do excuse my poor English
*Ignore the realised profit part, I didn't manage to find a code for it
I've recently found an issue with my formula when I am filling up the shares I re-bought.
In 2021, I've bought bought 6 TSLA shares and sold all. However, the portfolio side would still reflect the average cost of all my shares without any reset.
Because it did not reset, in 2022 I bought more TSLA shares, it will add in the average along with my past shares that are all being sold. Is there a formula to reset the average cost to 0 if I had no more shares?
Thank you for reading through and assisting me on this in advance.
Cheers,
Zack
*PS, do excuse my poor English
*Ignore the realised profit part, I didn't manage to find a code for it