Support Board
Date/Time: Thu, 28 Nov 2024 10:43:34 +0000
[User Discussion] - Help With Spreadsheet System for Trading
View Count: 296
| [2023-05-07 20:40:21] |
| bradyfans - Posts: 16 |
|
I have a spreadsheet system for trading that doesn't signal any trades, although there are areas where it seems as if a trade should have been triggered. Any help figuring this out would be appreciated. I am trying to have a system that buys the close of a bullish engulfing between 1000 and 1500, only if price has previously broken the lower daily range band sometime between 0630 and 1500. Price does not have to be below the range band for the trade to trigger, the band just must have been broken at some point during the specified time (0630-1500). Opposite for the sell signal: buys the close of a bearish engulfing between 1000 and 1200, only if price has previously broken the lower daily range band sometime between 0630 and 1500. Price does not have to be below the range band for the trade to trigger, the band just must have been broken at some point. ID3.SG1 is the upper daily range band ID3.SG2 is the lower daily range band ID6.SG1 is the bullish engulfing ID6.SG2 is the bearish engulfing Cell K3: =AND($J$8=0,P3=1,ID6.SG1@3=64,R3=1) Cell M3: =AND($J$8=0,Q3=1,ID6.SG2@3=65,R3=1) Cell P: =IF(AND(E3<ID3.SG2@3,FRACTIME($J$41)>=TIME(6,30,0),FRACTIME($J$41)<TIME(15,0,0)),1,IF(INT(A3)>INT(A4),0,P4)) Cell Q: =IF(AND(E3>ID3.SG1@3,FRACTIME($J$41)>=TIME(6,30,0),FRACTIME($J$41)<TIME(15,0,0)),1,IF(INT(A3)>INT(A4),0,Q4)) Cell R: =AND(FRACTIME(MROUND(A3,1/86400))>TIMEVALUE("10:00:00"),FRACTIME(MROUND(A3,1/86400))<TIMEVALUE("15:00:00")) Thanks for any input. |
| [2023-05-07 23:04:01] |
| Sawtooth - Posts: 4120 |
|
I think you'll need to reference the previous bar of the Daily Range Band in your persistent TRUE formulas. Try this: P3: =IF(AND(E3<ID3.SG2@4,FRACTIME($J$41)>=TIME(6,30,0),FRACTIME($J$41)<TIME(15,0,0)),1,IF(INT(A3)>INT(A4),0,P4)) Q3: =IF(AND(E3>ID3.SG1@4,FRACTIME($J$41)>=TIME(6,30,0),FRACTIME($J$41)<TIME(15,0,0)),1,IF(INT(A3)>INT(A4),0,Q4)) |
| [2023-05-11 02:28:59] |
| bradyfans - Posts: 16 |
|
Thank you so much for the help!
|
To post a message in this thread, you need to log in with your Sierra Chart account: