Support Board
Date/Time: Sun, 22 Dec 2024 16:37:08 +0000
SPREADSHEETS - 'Number of Rows' question
View Count: 1622
| [2015-08-14 15:06:56] |
| bekitz3 - Posts: 83 |
|
Looking at the documentation at the following link under the section Number of Rows: http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html The line item Decreasing Number of Rows Input: states the following: If you decrease the value of the Number of Rows input, then the data that was previously outputted to a Sheet on a Spreadsheet for those rows will still remain.
Maybe I'm doing something wrong, but I haven't been able to produce this functionality. If I start with a 1000 rows then change to 2000 rows the spreadsheet populates accordingly. If I switch back to 1000, the spreadsheet adjusts back to 1000 rows.....but shouldn't the spreadsheet stay populated with 2000 rows??I understand why this functionality would be useful because you can populate your chart with historical plots far back in time by increasing the row setting, then switch to a lower value to reduce CPU burden, memory demands, etc when chart recalcs or new bars add to the sheet. Any support would be appreciated. |
| [2015-08-14 15:40:08] |
| Sawtooth - Posts: 4141 |
|
That quote from the documentation is true for Old Spreadsheets but not New Spreadsheets. Even with Old Spreadsheets, the left-over data is there but not updated nor useable by the spreadsheet study, so it is not useful to reduce the computational burden. With New Spreadsheets, the data is erased when the Number of Rows is decreased. To see further back than the Number of Rows setting, scroll the chart into the past, start a Replay Chart, then press Pause. This will give you a lookback from that point equal to the Number of Rows setting. |
| [2015-08-14 20:20:11] |
| bekitz3 - Posts: 83 |
|
Thx tomgilb! That replay option sounds like a workaround. I'm also wondering if a person could disconnect from the data feed and then increase the # of rows to a much larger # in order to get more history and avoid new bar updating of the spreadsheet. Any ideas of what the max # of rows that is feasible? Is there a hard cap? |
| [2015-08-14 20:21:09] |
| bekitz3 - Posts: 83 |
|
That quote from the documentation is true for Old Spreadsheets but not New Spreadsheets.
SC Support,can you please update your documentation to reflect this discrepancy. Thx. |
| [2015-08-15 00:27:14] |
| Sawtooth - Posts: 4141 |
|
I'm also wondering if a person could disconnect from the data feed and then increase the # of rows to a much larger # in order to get more history and avoid new bar updating of the spreadsheet.
That would be another workaround that should be OK for offline work.Any ideas of what the max # of rows that is feasible? Is there a hard cap?
For Old Spreadsheets it's about 100,000 rows.For New Spreadsheets it's as many rows as the loaded data creates bars, up to about 1,000,000. Date Time Of Last Edit: 2015-08-15 11:16:42
|
| [2015-08-15 04:44:10] |
| bekitz3 - Posts: 83 |
|
For New Spreadsheets it's as many rows as the loaded data creates bars.
Is there currently a way to determine how many bars are loaded into a chart?
|
| [2015-08-15 11:20:29] |
| Sawtooth - Posts: 4141 |
|
The New Spreadsheets limit is about 1,000,000 rows. Set it for this amount, and then scroll down the spreadsheet to see how many rows were used. Then you could set it for the number of rows you need.
|
To post a message in this thread, you need to log in with your Sierra Chart account: