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