Login Page - Create Account

Support Board


Date/Time: Thu, 28 Nov 2024 03:54:26 +0000



Is my old spreadsheet of custom studies requiring more RAM than necessary?

View Count: 304

[2023-05-27 14:17:22]
User14953 - Posts: 236
Spreadsheet Study RAM: Is the way I'm using an old spreadsheet of custom studies requiring more RAM than necessary?

- 22 Mb - Start Sierra Chart
- 25 Mb - Load a daily historical futures chart
- 26 Mb - Load Analysis Study showing Volume
- 1,326 Mb - Load Analysis Study that uses an old spreadsheet of custom studies that has been in use for years across many and varied chartbooks some of which contain 20 or more charts
- 33 Mb - Close the daily historical chart

I see Sheet numbers up to Sheet72 listed in the spreadsheet dropdown menu at top left of the spreadsheet.
They all fill down to row 2502.

Is there some 'housekeeping' or something simple I could do to reduce that 1,300 Mb number?
[2023-05-30 13:34:43]
John - SC Support - Posts: 36350
We really do not know what you can do to lower the memory usage for the spreadsheet. If you need the spreadsheet, then it is what it is. You would have to go through it and see what you can do to offload some of the information you are using within the spreadsheet.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-05-30 22:02:43]
Sawtooth - Posts: 4120
Is there some 'housekeeping' or something simple I could do to reduce that 1,300 Mb number?
I've once found that the spreadsheet file got huge and I created a new one with copy/paste of formulas, and the size decreased significantly.

Same formulas, same settings, but much smaller file size.
I have no explanation why that was, but it happened to me.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account