Support Board
Date/Time: Sun, 24 Nov 2024 20:53:48 +0000
Post From: Inaccurate entry time in spreadsheet system for trading
| [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
|