Support Board
Date/Time: Thu, 16 Jan 2025 08:38:40 +0000
Post From: V1382 Exits when $J$8=0 even though formula AND Condition is $J$8>0
[2016-04-02 02:07:08] |
Sawtooth - Posts: 4153 |
Working with intrabar entries can be challenging, especially using the spreadsheet study with its limitations. You might consider stepping up to using ACSIL for a project like yours. A trader needs to be able to test how many "bars since entry" (a basic Tradestation function) and that a trade occurred.
The only way to do this in a spreadsheet study is to use a formula column to count bars since the previous arrow (previous TRUE), but this precludes intrabar entries because the flag only occurs at close of bar. The only way to do this in a spreadsheet study with an intrabar entry is to count bars since J42 matched column A, but this only works for the most recent entry, so there is nothing stored historically earlier. An option in Spreadsheet Settings to hold true state, rather than using column H to "lock condition" would be nice.
This would need to be a new study, possibly an addition to the Trading: ... studies in the list, that would output to a spreadsheet column a 1 in the row where it occurred. I would also welcome this.To see a flesh-out example of the locking state, have a look here: http://www.sawtoothtrade.com/example-9.html But even if you got this to work automatically, if would only be for the most recent entry and there would still be nothing stored historically. Date Time Of Last Edit: 2016-04-02 02:26:55
|