Login Page - Create Account

Support Board


Date/Time: Wed, 01 Jan 2025 00:45:35 +0000



Spreadsheet Study - can't load more than 1000 rows

View Count: 845

[2016-01-16 02:43:04]
rhovega - Posts: 279
Hi,

I can't increase the number of rows to load beyond 1000, even if I put more. Number of days is not the issue (1000 rows is just a few days). I am running version 1354. Please help.

Thanks
[2016-01-16 17:38:55]
Sierra Chart Engineering - Posts: 104368
You need to check to make sure that the Spreadsheet Study is on the chart and referring to the correct Spreadsheet and Sheet within the Spreadsheet where you want to see more rows.

There must be something wrong with one of those.
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
[2016-01-16 19:57:09]
rhovega - Posts: 279
Thank you. solved. Same solution for both my last questions related to spreadsheet study (other was not outputting into chart).

There's something I yet don't understand. Allow me to illustrate.

I added a spreadsheet to chart #3.
- If the study makes reference to sheet 0, anything (ie signals) I do in sheet 0 does not show up in the chart.
- If the study makes reference to sheet 3, anything (ie signals) I do in sheet 3 gets deleted from the spreadsheet.
- If the study makes reference to sheet other than 3 or 0, then it works.

I thought the spreadsheet study should make reference to either sheet 0 (for sharing studies across instruments) or the same sheet # as the chart #.

Thank you!
[2016-01-16 22:38:22]
Sierra Chart Engineering - Posts: 104368

- If the study makes reference to sheet 0, anything (ie signals) I do in sheet 0 does not show up in the chart.
How is the Spreadsheet Study making reference to Sheet 0?

- If the study makes reference to sheet 3, anything (ie signals) I do in sheet 3 gets deleted from the spreadsheet.
Refer to the documentation for Formula Source Sheet Number to understand this behavior.

Although, from our perspective this is all kind of vague so we do not fully understanding what you are doing and what is happening.
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: 2016-01-16 22:39:16

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

Login

Login Page - Create Account