Login Page - Create Account

Support Board


Date/Time: Wed, 24 Apr 2024 18:36:31 +0000



[Programming Help] - Programming a Limit Order Entry with Tick Offset

View Count: 1018

[2020-02-09 17:45:53]
tommartin321 - Posts: 74
Hello,

Using a Spreadsheet Study, how can I set a Limit order entry with a tick Offset? For example, my system generates a Long at 3142.75, I only want my limit order filled if price pulls back two ticks (3142.25).

I understand how to do it manually using the "Trading: Triggered Limit Order Entry" study and then right clicking on the click. Is there a way to trigger this study automatically from within the spreadsheet?


Thank you,

Tom
[2020-02-09 18:27:39]
Sawtooth - Posts: 3976
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
[2020-02-10 02:57:29]
tommartin321 - Posts: 74
Thank you tomgilb

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account