Support Board
Date/Time: Fri, 16 Oct 2026 06:03:08 +0000
Position Quantity is zero in Spreadsheet
View Count: 299
| [2026-08-26 15:44:49] |
| User512353 - Posts: 190 |
|
SC2944 Using Spreadsheet Study Spreadsheet System Alert Spreadsheet System Alert for Trading all with v2 values. In Spreadsheet System Alert for Trading the value v2:J31 (Position Quantity) and v2:J32 (Position Average Price) are filled correctly. In Spreadsheet Study Spreadsheet System Alert only v2:J32 (Position Average Price) is filled, whereas v2:J31 (Position Quantity) remains zero. I would consider this a bug. I mean, in v1 these values were not available for Spreadsheet Study Spreadsheet System Alert but if in v2 the v2:J32 (Position Average Price) is made available, then v2:J31 (Position Quantity) should also be there. |
| [2026-08-26 23:35:07] |
| Sierra_Chart Engineering - Posts: 25192 |
|
We are checking on this.
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, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-08-27 19:31:12] |
| Sierra_Chart Engineering - Posts: 25192 |
|
This will be solved in the next release.
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, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-08-31 10:01:22] |
| User512353 - Posts: 190 |
|
SC2946 installed today. Something is broken now with all spreadsheet studies: - Chart output of columns of a Spreadsheet Study has disappeared. - All references from a Spreadsheet System/Alert to a Spreadsheet Study are zero, e.g. if Spreadsheet Study is ID2, then referencing ID2.SGx in Spreadsheet System/Alert is zero. - Similarly, using a Study Subgraph Reference to access a subgraph of a Spreadsheet Study always delivers zero. I also checked for Position Avg.Price v2:J32 and Position Quantity v2:J31. I cannot tell what happens when a trade is executed by the spreadsheet, because of the above problem. But if I manually enter a position, both Position Size and Position Avg.Price remain zero for Spreadsheet Study Spreadsheet System/Alert while Spreadsheet System for Trading is ok. My understanding was that your "solution" would be to have Position Size and Position Avg.Price available in Spreadsheet Study Spreadsheet System/Alert and not to remove it. Or am I wrong? Date Time Of Last Edit: 2026-08-31 10:14:18
|
| [2026-08-31 11:08:56] |
| User512353 - Posts: 190 |
|
Update: It seems that Spreadsheet Study Spreadsheet System/Alert do not update any cells at all. Spreadsheet System for Trading seems ok. |
| [2026-08-31 11:14:25] |
| User512353 - Posts: 190 |
|
Update2: They do update, but only when a new bar opens and thus a new row is created. Otherwise no updates with new market data. Spreadsheet System for Trading is ok. Date Time Of Last Edit: 2026-08-31 11:14:43
|
| [2026-08-31 11:16:34] |
| User512353 - Posts: 190 |
|
Update 3: They do not update with EVERY new bar. Only sporadically. |
| [2026-08-31 11:32:42] |
| User512353 - Posts: 190 |
|
Update 4: The above applies only for spreadsheets with v2 values. I opened another chartbook with v1 values in the same SC instance, and this appears to behave normally. |
| [2026-08-31 13:23:23] |
| User512353 - Posts: 190 |
|
Correction to post#4 : The chart output has not disappeared, but all values are zero. Thus the chart region appears empty, but there is one small line at the top, which is probably the zero value, and the scale is void. |
| [2026-08-31 22:04:14] |
| Sierra_Chart Engineering - Posts: 25192 |
|
There have been no changes to spreadsheet studies to cause the issues you are describing.
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, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-09-01 11:44:15] |
| User512353 - Posts: 190 |
|
You wrote in post #3 above that the original issue would be "solved in the next release", which by then was the release that would come after 2945. We now have 2946. The original issue is NOT resolved (depending on the interpretation of what you meant by 'resolved'). In fact it got worse: Not only is Position Quantity v2:J31 still zero, but now also Position Avg.Price v2:J32 is zero, which was previously, in 2945, not zero for Spreadsheet Study Spreadsheet System/Alert. The other issues reported above come on top of that. Did you try to reproduce the new problems with v2 spreadsheets? Please indicate if you are working on this or not, and if yes, when a solution can be expected. Otherwise I would have to downgrade to 2945. |
| [2026-09-01 15:32:33] |
| Sierra_Chart Engineering - Posts: 25192 |
|
We see what the problem is. An exception is occurring. Go back to the version you were using previously. This is critical. But we will have a new release out in about 30 minutes. We cannot support what you want in the original post. 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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2026-09-01 15:45:23
|
| [2026-09-01 15:42:46] |
| Sierra_Chart Engineering - Posts: 25192 |
|
We are working on the release now. This is a critical issue. We apologize for it. There was just one tiny change that we would not have expected to cause any problem at all, but there was not a check for a nullptr in a trading related component. This is now fixed. This is what led to all of these other issues due to instability. 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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2026-09-01 15:43:40
|
To post a message in this thread, you need to log in with your Sierra Chart account: