Login Page - Create Account

Support Board


Date/Time: Sat, 20 Apr 2024 10:25:14 +0000



Spreadsheet Study

View Count: 1331

[2013-11-28 14:29:34]
fspisem1 - Posts: 12
Could you tell me,
how is possible show more than 1000 rows in
"Spreadsheet Study" ?
There is value "Number of Rows" and possibility to change this value to more than 1000, but the result shows only last 1000 rows (1002 - 2 is header).

Is there possibility to show more than 1000 rows or possibility to show rows from beginning?

Thank you for answer.

[2013-11-29 01:37:04]
Sierra Chart Engineering - Posts: 104368
Do you know if you are running the non-CLR version of Sierra Chart?

If you are not sure, then probably you are not.

Does the chart contain more than 1000 bars?
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2013-11-29 10:34:50]
fspisem1 - Posts: 12
I think, it is CLR version. Version is 990.
Yes chart contain absolutely more tahan 1000 bars, there are all bars of contract month.

I have test it again.
I have found that if I set "Number of Rows" to value 2000 than grid show 2000 records, but if I set "Number of Rows" 32 000 , 9 000 000 etc. than grid show always only 1000 rows.

Could be possible show all contract month in Spreadsheet Study?
Or could be possibility show rows from begining - I need values from start - beginning of contract month.
Thank you for answer.


[2013-12-01 21:12:30]
Sierra Chart Engineering - Posts: 104368
As long as the Number of Rows setting is the same as or exceeds the number of bars in the chart, all data in the chart will be outputted.

We have tested a setting of 40000, and the resulting spreadsheet output is attached. The chart did not have 40000 bars, however the number of bars it did have was outputted.

To increase the amount of data in the chart, refer to help topic 42.1:
Http://www.sierrachart.com/index.php?l=doc/helpdetails42.html
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2013-12-01 21:13:02
image2013-12-02_101103.png / V - Attached On 2013-12-01 21:12:10 UTC - Size: 37.48 KB - 358 views

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

Login

Login Page - Create Account