Support Board

Date/Time: Wed, 24 Apr 2024 10:24:16 +0000

Post From: Keeping spreadsheets light

[2013-08-28 05:54:39] Link To Thread - Link To Post [Go To First Post]
vegasfoster - Posts: 444
I'm not making a suggestion, but one thing I've contemplated is dynamically adjusting the rows based upon the number of bars in the chart using a row buffer. For example, you set to your spreadsheet to "Dynamic Update" and then specify a buffer, e.g. 100 rows. If you loaded a renko chart and it had 5625 rows, then the sheet would load 5725 rows and 100 rows would be added if the number of bars increased to 5726 rows or 100 rows would be deleted if the number of bars decreased to 5524. That way the number of rows is kept at a minimum for the loaded chart, but it's not constantly re-sizing on every bar.