SPCsoft Galaxy Updates: Comfort Attendance Reached 2K Users

The Comfort Attendance add-on was published in July 2024. As of today, it has reached over 2K users

Please support us in publishing free add-ons for people and communities.

Personal Investor Lab: Performance Tuning

The user-customizable charts in the dashboard are refreshed for every security, which consumes part of the Google Apps Script 5-minute runtime limit. Currently, Google Apps Script does not provide a way to suspend chart refreshes during script execution.

To reduce the runtime, the add-on has been enhanced to eliminate unnecessary chart refreshes. For example, charts are no longer refreshed for securities without any 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 only when required. 

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

The add-on can reduce unnecessary chart refresh runtime by controlling when chart data is copied.