Login Page - Create Account

Support Board


Date/Time: Sun, 07 Dec 2025 23:30:17 +0000



Post From: Handling Stop and Limit orders with the Spreadsheet for trading

[2025-11-07 15:15:22]
Sawtooth - Posts: 4295
the order placed (entry limit order) when the conditions were TRUE (or 1) won't be removed from the chart despite now the cell K3/ M3 are 0.
This is normal behavior.
You will need to have a formula that cancels an unfilled BuyEntry/SellEntry order.

Here are two v1 examples:
Spreadsheet Example Formulas and Usage: Cancel Unfilled Working Order n Minutes After Entry
Spreadsheet Example Formulas and Usage: Cancel an Unfilled Order After n Bars

Review for Limit entries (v1):
K3/M3 is the trigger
J22/J24 is the price
J71/J73 is the order type

BTW, I'm curious, why are you using V2?
Reasons not to:
- V2 Documentation is messy, confusing, and incomplete.
- V1 users know the location of column J cells, so help now must transliterate.
- V1 has existed for decades without issue, and this is where the knowledge base is.
- V2 is essentially unnecessary.
Date Time Of Last Edit: 2025-11-07 15:18:27