a thoughtful web.
Good ideas and conversation. No ads, no tracking.   Login or Take a Tour!
comment by kleinbl00
kleinbl00  ·  3172 days ago  ·  link  ·    ·  parent  ·  post: Good fantasy stock portfolio

It's actually not that tough to build out a backtested portfolio in Google Sheets. The formula "=INDEX(GoogleFinance(C52, "PRICE", $B$60),2,2)" will give you the value of the stock symbol at C52 on date B60. Once you do that you can plug in any date you want (or do other stupid stuff) so that you know what it would have cost you to buy, say, Netflix on October 15, 2007.

Once you have that, you can plug your numbers into a portfolio on Seeking Alpha or whatever and get instantaneous gains and losses not only for the day but for however long you've held your positions.