Support Board
Date/Time: Fri, 29 Nov 2024 14:50:08 +0000
Post From: Spreadsheet trading - buy / sell if condition remains true for X duration?
| [2023-02-06 00:58:32] |
| j4ytr4der_ - Posts: 938 |
|
I was searching for something else but thought I should comment on this. I'm doing this now - calculating how much time has passed since something, in order to do something else. It's not hard, though it does rely on the time being accurate in the spreadsheet (something you probably shouldn't always take for granted!) You can simply do j41 - j93 for example, to know how much time since your last entry order. Then you can compare against TIMEVALUE("xx:xx:xx") and do something when time is =, >, or < that amount. I'm using this to pull entries that have been out for too long, and combining with distance off current price, etc. You can do the same thing to check how long since last trade entry, exit, order entry/exit, or really anything you want if you just capture J41 into a locking cell at the moment of the event you want to track duration since. Hope this helps someone! |