Personal Investor Lab: Performance Tuning

The charts in the dashboard are refreshed for every security, which consumes part of the Google Apps Script 5-minute runtime limit. To reduce the runtime, the add-on has been enhanced to skip unnecessary chart updates, such as securities without alerts.

To activate the enhancement, please follow the steps below:

1. Expand the Chart_Table named range to cover all columns.

     The add-on will copy the table data to the adjacent columns automatically. 

2. Update all dashboard charts to use the copied data range instead of the original table range.

   Charts will not be refreshed unless the copied chart data is updated by the add-on.