Support Board
Date/Time: Thu, 16 Jan 2025 08:39:59 +0000
Post From: V1382 Exits when $J$8=0 even though formula AND Condition is $J$8>0
| [2016-04-02 01:00:36] |
| User791263 - Posts: 151 |
|
I've had nearly 2 weeks more to study intrabar entries. SC Eng was correct that the true condition goes true then not inside the bar; the trade occurs; no flag is visible. Tom is right that exits wont exit from flat positions. But the positions are not flat when my settings allow the trades to enter,but a 0 is left in K & M columns though entries occurred. ie: I'm not flat when those trades do happen but no 1 is in K or M columns. A trader needs to be able to test how many "bars since entry" (a basic Tradestation function) and that a trade occurred. An option in Spreadsheet Settings to hold true state, rather than using column H to "lock condition" would be nice. I'm having trouble understanding the example & modifying the H3 , H4, H5 etc circular references to hold true until L or N go true to reset it. I saw one example where the user was trying to count times the condition "bars since entry" was true for bars since a certain time, but Tom explained there is no cell available to hold variables. Too bad. That would be useful. "Bars since entry" is not crucial, but helpful. I care what happens within 10- 12 bars of entry, or to know position is older-greater than that. Mostly I want L & N to be able to test whether K & M were true. I need to locate-know the bar where true occurred, for debugging-improvements ie: auditing market status at that bar (backtesting). SC, that is where an option setting would be great-just post a 1 in the row if ever true within the bar. My intrabar entry requirement may be common, so please, if not going to add the setting option, could SC improve (flesh out) the example at http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetAdditionalInfo.html#StateLocking Such Col H method on the example sheet is still cryptic. Is the text in H3, H5 and H7 supposed to be formulas, such as K3=1 or TRUE? I don't understant the abstract examples given by SC, Tom & Sawtooth. How about just use my requirement as the example? It seems very like SC's existing example, but that one appears incomplete. Just use a K3 condition like AND(P3<-200,P3>-300. M3 similar. |