Home >> Support Board

Support Board

Date/Time: Tue, 23 Apr 2024 20:41:49 +0000

How to Post a Message for Support

Spreadsheet Study For Trading - IndexToEvaluate is out of bounds

View Count: 420

[2022-09-11 20:11:20] #1 [Go To First Post]
User656492 - Posts: 123
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] #2 [Go To First Post]
Sierra_Chart Engineering - Posts: 14062
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] #3 [Go To First Post]
User656492 - Posts: 123
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] #4 [Go To First Post]
User656492 - Posts: 123
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] #5 [Go To First Post]
User656492 - Posts: 123
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] #6 [Go To First Post]
Sierra_Chart Engineering - Posts: 14062
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] #7 [Go To First Post]
User656492 - Posts: 123
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] #8 [Go To First Post]
User656492 - Posts: 123
CB and SS uploaded (private)


Private File Private File Attachment Deleted.

[2022-09-14 10:42:51] #9 [Go To First Post]
Sierra_Chart Engineering - Posts: 14062
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] #10 [Go To First Post]
User656492 - Posts: 123
Any news here? I'm stuck. Can't execute my trading system.

[2022-09-16 19:49:04] #11 [Go To First Post]
Sierra_Chart Engineering - Posts: 14062
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] #12 [Go To First Post]
User656492 - Posts: 123
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] #14 [Go To First Post]
Sierra_Chart Engineering - Posts: 14062
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] #15 [Go To First Post]
Sierra_Chart Engineering - Posts: 14062
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] #16 [Go To First Post]
User656492 - Posts: 123
Thanks. I will check this after close. Isn't that displacement solely for text display?

[2022-09-29 19:31:09] #17 [Go To First Post]
Sierra_Chart Engineering - Posts: 14062
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] #18 [Go To First Post]
User656492 - Posts: 123
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: