Improving Investment Spreadsheet Performance

September’s Dividend Meter update will be running a few days late; however, I’m excited to report the stock dividend portfolio’s annual income has broken through $6,600.00! Until I finish the update, I’d like to share with you a quick video for improving the performance of your dividend or investment spreadsheet.

Sometimes the import formulas in Google Sheets get stuck on “Loading..”. The reality is stock dividend figures do not change that frequently. Maybe once a year, if you’re fortunate, a company will increase the dividend. So, rather than all cells relying on an import column to finish loading, your spreadsheet can quickly calculate values if it has a dividend column with static numbers. Here’s the modification I made to my spreadsheet:

Leave a Comment

Your email address will not be published. Required fields are marked *