I spent a lot of time creating this and I’m hoping some people might like to try it out and give me feedback so that I can improve upon it. I did all the work without using any Apps Script so its all done using Google sheets built in functionality.
You will need to have the history of all your stock trades with the following information:
Date, Ticker, Shares, Trade Price, Buy or Sell
if you have this information then you could be a tester
this is a screenshot of a sample dashboard:
https://www.dropbox.com/s/eo39gv6cgsws6sw/Copy%20of%20Stock%…
please reach out to me by replying here and I can send you a link and give you instructions on how to set it up.