Login Page - Create Account

Support Board


Date/Time: Sat, 27 Apr 2024 21:47:51 +0000



Post From: Spreadsheet trading study: canceling an unfilled limit order

[2018-02-23 17:38:46]
Shane - Posts: 31
Tom:

Thank you for the suggestion. Below is what I have implemented and have been running for two days with no issues.


In P3: =IF(K3,1,P4+1)
In Q3: =IF(M3,1,Q4+1)

In J27: =OR(AND(P4 >= H6 + 1, J4 > 0), AND(Q4 >= H6 + 1, J4 < 0))
(where H6 stores the number of bars

SC support:

You might consider changing the website to reflect this simpler solution. The formulas currently displayed are overly complex and require an unrealistic scenario (alternating buy and sell orders).

No response necessary (I don't see a way to close the ticket/thread.)

Many thanks,
shane