Login Page - Create Account

Support Board


Date/Time: Fri, 29 Nov 2024 14:37:28 +0000



Post From: Spreadsheet trading - buy / sell if condition remains true for X duration?

[2022-07-28 14:26:48]
mattvk - Posts: 32
My goal is to define buy / sell orders to be true when trade criteria is met and remains true for X duration.

Practical example: buy exit when price crosses below a moving average and remains below it for 5 seconds.

Essentially starting a timer when the condition is true and only executing the trade when the target duration has elapsed without the condition becoming false again. The main objective of this is to ignore momentary price spikes that would otherwise trigger the order.

Is this possible using the spreadsheet system for trading?