Login Page - Create Account

Support Board


Date/Time: Fri, 26 Apr 2024 01:17:18 +0000



Post From: Spreadsheet

[2019-06-21 17:18:29]
AndreyPoroshin - Posts: 102
Spreadsheet Systems, Alerts and Automated Trading: Disable Auto Trading [J28]

=OR(J41-INT(J41) < TIMEVALUE("17:10:00"), J41-INT(J41) > TIMEVALUE("15:54:50") )
=AND(J8 = 0, OR(OR(FRACTIME(J41) < TIMEVALUE("17:00:00"), FRACTIME(J41) > TIMEVALUE("15:54:00")), AND(FRACTIME(J41) > TIMEVALUE("08:29:00"), FRACTIME(J41) < TIMEVALUE("09:30:00"))))
These formulas are from your documentation.
These formulas do not allow to open positions at any time. What is wrong with them? I need to enter the market at 5:05 pm and get out at 3:54 pm Also in the middle of the day I would like not to trade at the open of the market from 8:30 to 9:30