Login Page - Create Account

Support Board


Date/Time: Sat, 11 Jan 2025 17:04:05 +0000



Post From: Spreadsheet trading

[2016-11-14 18:02:12]
Sawtooth - Posts: 4148
We will see about adding a new cell indicating the Date-Time of the last order submission
If you are talking about buy limits or buy stops, I would also like this.
But the problem is making it persistent in a Formula Column.

1. If the entry signal is at close of bar, you can do it using the timestamp of the bar after the buy signal bar, with a formula like this, e.g. in cell Z3:
=IF(AND(K5=FALSE,K4),A3-INT(A3),Z4)
Then compare it to J41 with a formula like this (cancelling a long), e.g. in cell J27:
=J41-INT(J41)-Z3>=n/1440) where n is minutes.

2. Attached Orders cannot trigger a MBE based on profit, at least not one based on a spreadsheet formula, but it could be done using a price level in a Formula Column via a formula referencing J10, then using the Trade Management By Study study to move the Attached Order. You may also need to use a Lock A Condition True formula.