Login Page - Create Account

Support Board


Date/Time: Sat, 23 Nov 2024 18:46:42 +0000



Using J80/J81 offsets in Spreadsheets with Manual Order Entry

View Count: 208

[2024-07-31 20:10:20]
User208238 - Posts: 5
Hello, am I able to place a manual trade(On the Dom), while still using the J80/J81 offset as my bracket, when using the Spreadsheets automated trading study? I'll give some context: I have formulas that calculate both my target and stop offset, and when K3 is true and an auto entry happens, the bracket uses the offsets from j80/j81;it works amazing! What I would like to do is have this same offset be calculated on my bracket when I click the dom for a manual entry, can I do this? And if so, how? I tried using a spreadsheet with an empty K3 cell and with offset values in J80/J81, but when I hit market orders it doesn't update the target/stop offset from the spreadsheet. Any Suggestions??
Date Time Of Last Edit: 2024-07-31 20:10:41
[2024-07-31 20:28:07]
Sierra_Chart Engineering - Posts: 17150
No, then this is not supported.

You will need to create a custom study to do what you need:
Advanced Custom Study Interface and Language (ACSIL)
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-07-31 21:16:22]
Sawtooth - Posts: 4118
I would like to do is have this same offset be calculated on my bracket when I click the dom for a manual entry
You could calculate your offsets in 2 Formula Columns, e.g., O3 & P3 (SG5 & SG6), then reference those values with two instances of the Trade Management by Study study, one for the Target and one for the Stoploss.

You would use an Attached Orders config with default offsets, then the Trade Management by Study study would move them.
Attached Orders: Study Controlled Targets and Stops
[2024-08-16 22:19:52]
User208238 - Posts: 5
Thank you Sawtooth! I was able to get the stops in the right place. Do you know if there is a way to do this with the quantity? Have the quantity of the trade modified automatically? I looked to see if I could find a quantity management study but didn't find anything like that.
[2024-08-17 01:19:56]
Sawtooth - Posts: 4118
Have the quantity of the trade modified automatically?
Use a formula in J26 that returns the desired quantity.

If your exit quantity is different, use J82/J83.

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

Login

Login Page - Create Account