Support Board
Date/Time: Sun, 24 Nov 2024 20:49:28 +0000
[User Discussion] - Inaccurate entry time in spreadsheet system for trading
View Count: 200
| [2024-05-01 23:07:41] |
| User827002 - Posts: 36 |
|
In column P, I want it to show a 1 on the most recent sell entry. The formula I'm using is "=if(and(J5<0,J41-J42<2/1440,J41-J42>0/1440),1,0)". Sometimes a 1 will appear in P3 temporarily, but I'm looking for it show me a 1 in P6 if the entry was 3 minutes ago. The reason I can't reference column M is because my entry happens on a moving average crossover, so sometimes it will put me in a trade, and the signal will disappear because price doesn't always stay across the moving average. Do you have any ideas that I can try?
|
| [2024-05-02 00:42:33] |
| Sawtooth - Posts: 4120 |
|
Do you have any ideas that I can try?
It's not possible to capture an intrabar event in a spreadsheet study, except only the most recent.You need to use an absolute reference when referencing a column J value: =if(and($J$5<0,$J$41-$J$42<2/1440,$J$41-$J$42>0/1440),1,0) You don't need to use the IF function when returning 1/0: =and($J$5<0,$J$41-$J$42<2/1440,$J$41-$J$42>0/1440) Try this in P3: =AND(ROW()<>3,$J$42>A3,$J$42<A2) Date Time Of Last Edit: 2024-05-02 12:03:05
|
| [2024-05-02 03:39:51] |
| User827002 - Posts: 36 |
|
That worked, thank you!
|
To post a message in this thread, you need to log in with your Sierra Chart account: