Login Page - Create Account

Support Board


Date/Time: Sat, 04 May 2024 08:42:33 +0000



Post From: Spreadsheet auto trading cancelling orders

[2018-06-14 02:30:08]
Sawtooth - Posts: 3993
Unfortunately the price of a working order is not output to the spreadsheet.

You would have to capture a price at the entry signal bar, and create a persistent variable of it, then compare it to the current price. The caveat is that slippage might cause the captured persistent variable to not be the exact price of the actual working order.

Here are some formula examples of persistent variables, but none are specific to your need:
Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables
Spreadsheet Example Formulas and Usage: Cancel Unfilled Working Order n Minutes After Entry