Login Page - Create Account

Support Board


Date/Time: Mon, 06 May 2024 01:20:25 +0000



Post From: Programming a Limit Order Entry with Tick Offset

[2020-02-09 18:27:39]
Sawtooth - Posts: 3993
When using Limit entries in the Spreadsheet System for Trading study:
- the entry signal is in K3/M3.
- the Limit price is in J22/J24. You will reference J21 for the offset, like this (previous High minus 2 ticks):
=C4-J21*2
- the Order Type is in J71/J73.

Spreadsheet Systems, Alerts and Automated Trading: Limit or Stop Prices [J22, J23, J24, J25]
Spreadsheet Systems, Alerts and Automated Trading: Buy Entry: Order Type [J71]

You'll also need a way to cancel an unfilled order. Here are a couple of 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
Date Time Of Last Edit: 2020-02-09 18:47:20