Support Board

Date/Time: Sat, 20 Apr 2024 12:37:21 +0000

Post From: Spreadsheet Study For Trading - IndexToEvaluate is out of bounds

[2022-09-11 20:11:20] Link To Thread - Link To Post [Go To First Post]
User656492 - Posts: 115
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!