Date/Time: Sun, 31 May 2020 17:32:06 +0000
Post From: Keeping spreadsheets light
|vegasfoster - Posts: 444 | Ending Date: 2014-11-03 [Expired]|
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.