Login Page - Create Account

Support Board


Date/Time: Sun, 04 Dec 2022 21:39:38 +0000



Spreadsheet Study For Trading - IndexToEvaluate is out of bounds

View Count: 232

[2022-09-11 20:11:20]
User656492 - Posts: 74
I'm struggling with Spreadsheet System for Trading.

I see a 1 in K3, and I see the Buy Entry (somewhat) correctly marked on the chart, but the trade is not executing. I say 'somewhat' because it also shows 1 in K4 and K5, as the position size remains zero, even though position size should be 1.

One possibly odd thing is that in the log, it's showing current time and not the supposedly simulated time. I don't know if this is relevant.

Trading against SIM, Send to Trade Service = yes, Auto Trading Enabled Global and Auto Trading Enabled Chart are both checked.
Chart Trade mode = on, Attach Trade Window to Chart = on.
Use Attached Orders is off.


The chart book has one chart and one spreadsheet.
The chart has a variety of studies, some of which are being used as explained here:

This is Cell K3: =AND( E3 > AG3, E3 > AB3, OR(AI3 > 0, AI4 > 0, AI5 > 0, AI6 > 0, AI7 > 0), $J$8 = 0)

In the spreadsheet, each cell as the following value:
E3: 4000.75
AG3: 3994.77
AB3: 3997.75
AI3: 0
AI4: 0
AI5: 1
AI6: 0
AI7: 0
$J$8 = 0
J26 = 1
J85 = FALSE
J86 is empty
J87 is empty
J88 = FALSE
J89 is empty

I'm seeing "Signal Ignored because 'IndexToEvaluate' is out of bounds." in the extended trade activity log.

Please help?

Thank you!
[2022-09-12 07:01:55]
Sierra_Chart Engineering - Posts: 5464
We need to see the actual log entry that you are referring to:
One possibly odd thing is that in the log, it's showing current time and not the supposedly simulated time. I don't know if this is relevant.
The Date-Time at the very end, will always be the current time and that is not relevant.

This must be set to No:
Send to Trade Service = yes,



I'm seeing "Signal Ignored because 'IndexToEvaluate' is out of bounds." in the extended trade activity log.
We should look into this. We would need to get the Chart and Spreadsheet file. Instructions to provide the chart:
Support Board Posting Information: Providing Chartbook with Only a Single Chart

Instructions to provide the spreadsheet:
Support Board Posting Information: Attaching a File (Optional)
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: 2022-09-12 17:44:30
[2022-09-12 20:24:21]
User656492 - Posts: 74
Here's an update. While removing all unrelated studies (a non-trivial task) so that you can focus your attention on what matters when reviewing the chart book, I discovered that if I remove all cells in columns K-N, the error is still produced.

Buy Entry | Signal ignored because 'IndexToEvaluate' is out of bounds. | Cell: K |
Sell Entry | Signal ignored because 'IndexToEvaluate' is out of bounds. | Cell: M |

So I deleted that spreadsheet and built it again from scratch.

The first time I ran it on playback, the errors were gone.
Then I flipped the Send To Trade Service to YES and the errors returned.
I turned Send to Trade Service to NO and the errors remained.

This is version 2425

Do you still want to see the chart book?
[2022-09-13 01:11:54]
User656492 - Posts: 74
An additional update.

I created a new intraday chart.
I created a new SS for trading.
I put on a couple of studies.

I turned on extended logging and ... I still see this error repeating in the log.
[2022-09-13 01:24:17]
User656492 - Posts: 74
In fact:

1.) New Intraday Chart. F.US.EPU22, 2500 Trades
2.) Add Spreadsheet study, creating new file name.
3.) Turn on extended logging
4.) Watch the log window fill with these errors.

Spreadsheet System - F.US.EPU22[M] 2500 Trades #1 | Spreadsheet: BLANK | Buy Entry | Signal ignored because current Alert Condition formula is FALSE | Cell: K3 | Bar start date-time: 2022-09-12 20:20:53 | 2022-09-12 21:22:12.480
Spreadsheet System - F.US.EPU22[M] 2500 Trades #1 | Spreadsheet: BLANK | Buy Exit (Sell) | Signal ignored because current Alert Condition formula is FALSE | Cell: L3 | Bar start date-time: 2022-09-12 20:20:53 | 2022-09-12 21:22:12.480
Spreadsheet System - F.US.EPU22[M] 2500 Trades #1 | Spreadsheet: BLANK | Sell Entry | Signal ignored because current Alert Condition formula is FALSE | Cell: M3 | Bar start date-time: 2022-09-12 20:20:53 | 2022-09-12 21:22:12.480
Spreadsheet System - F.US.EPU22[M] 2500 Trades #1 | Spreadsheet: BLANK | Sell Exit (Buy) | Signal ignored because current Alert Condition formula is FALSE | Cell: N3 | Bar start date-time: 2022-09-12 20:20:53 | 2022-09-12 21:22:12.480
[2022-09-13 08:52:38]
Sierra_Chart Engineering - Posts: 5464
At the very least give us the Chartbook. We still need it. We do not see the significance of the information in post #5.
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
[2022-09-13 12:28:39]
User656492 - Posts: 74
Will upload shortly. The significance of post # 5 is that it was also a new chart book. Sorry to be unclear about that.
[2022-09-13 12:53:52]
User656492 - Posts: 74
CB and SS uploaded (private)
Private File
Private File
Attachment Deleted.
[2022-09-14 10:42:51]
Sierra_Chart Engineering - Posts: 5464
Thank you we will test this as soon as possible.
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
[2022-09-15 15:07:11]
User656492 - Posts: 74
Any news here? I'm stuck. Can't execute my trading system.
[2022-09-16 19:49:04]
Sierra_Chart Engineering - Posts: 5464
No, this requires in-depth analysis. It is not something we can get to quickly.

It is also not a problem we have ever heard about before. At least not in recent years.
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
[2022-09-19 16:46:03]
User656492 - Posts: 74
What do you recommend I do to get Spreadsheet trading working again? All of my spreadsheets, in new chart books, produce the same error.

I need a solution.

Reinstall Sierra?
Delete some configuration file?

Help would be appreciated.
[2022-09-26 11:52:02]
Sierra_Chart Engineering - Posts: 5464
We apologize for the delay. We will work on this today.
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
[2022-09-27 17:42:09]
Sierra_Chart Engineering - Posts: 5464
We have now looked into this. Do not use a negative Study Subgraph Graphical Displacement.
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
[2022-09-27 18:11:19]
User656492 - Posts: 74
Thanks. I will check this after close.

Isn't that displacement solely for text display?
[2022-09-29 19:31:09]
Sierra_Chart Engineering - Posts: 5464
No, it also affects formula evaluation.
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
[2022-09-29 20:18:08]
User656492 - Posts: 74
I can verify that this displacement issue was the cause. Thanks for sorting it out! I would never have thought to look at that!

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

Login

Login Page - Create Account