I built two sheets (with data retrieval scripts) to help monitor your portfolio & compare investments

Sheet 1: https://docs.google.com/spreadsheets/d/1ofxrHbo3vqv5xHeU5kLFg_27gQGGib9tz3oku1exN6k/

Sheet 2: https://docs.google.com/spreadsheets/d/1FXa4sQZ_IR_NrXmm7TBwZhGEuhH8k4rsstn_uqIjSoY/

Hey all, I'm sharing two spreadsheet templates with data retrieval scripts to help monitor your stock portfolios and compare investments.

I recommend probably using these templates to build your own personalized sheets. You can copy formulas and such over.

As always, feedback kindly welcomed!

Note: Presently, the script in Sheet 2 that retrieves future dividend estimates, ex-dividend + payment dates, and NAVs only works for Canadian stocks and ETFs; you would either have to write your own script or enter these data in manually for non-Canadian investments. Dividend history should work for all dividend-paying tickers on Yahoo Finance.