Support Board
Date/Time: Sun, 11 May 2025 20:21:19 +0000
Post From: Spreadsheet Study For Trading - IndexToEvaluate is out of bounds
| [2022-09-11 20:11:20] |
| User656492 - Posts: 146 |
|
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! |