Login Page - Create Account

Support Board


Date/Time: Mon, 17 Mar 2025 11:28:05 +0000



[Programming Help] - SpreadSheets for Automated Trading Entry Orders

View Count: 1415

[2022-08-28 18:07:15]
User964846 - Posts: 38
Hey Sierra. I am revisiting automated trading using spreadsheets. I would like to place a limit order at a specified price, somewhat far away from the NBBO, when my order entry signal triggers. This way, my entry will be ready when the price shows up, and not after.

Is this possible yet?
[2022-08-29 07:06:15]
Sierra Chart Engineering - Posts: 104368
Yes you can do this. Refer to:
Spreadsheet Systems, Alerts and Automated Trading: Limit or Stop Prices [J22, J23, J24, J25]
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, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-08-30 20:17:08]
User964846 - Posts: 38
Hey Sierra people. I'm wondering about pushing sierra as far as possible. I would like to set my Long Order Entry, as a moving average. So, when we go below Below a certain moving average, a long entry order is created at a different, lower (longer) moving average.

As time continues though, that lower moving average will change. It may continue higher, ABOVE the already created long entry.
So, I tried to code, cancel the unfilled long entry, if the moving average exceeds X points above or below the current open order (j48).
Unfortunately, the Order Cancellation can take, a very long time to execute.

Is there a way to cancel an open order and place a new order as soon as a new bar appears?? (To keep the open order up to date with the position of the moving average)
Thanks for your time and help, I hope your week goes well.
-Ben
[2022-08-30 21:35:09]
User964846 - Posts: 38
woa woa woa. this is not programming help, this is a spreadsheets question.
[2022-09-06 23:56:57]
OctoPi - Posts: 38
We've made a software on top of SC that does exactly this, among other things.
Entry price is set to your choice of moving average, and it updates every bar ( old order is canceled, new one placed on average line )
We can also do cancel if price moves so far away, cancel if order doesn't fil for x number of bars etc etc.

Check us out if you are into backtesting and auto-trading. We are currently looking for a few beta-testers.

Gotta warn you though, no spreadsheets.
EASY Automated Back-testing. We are licensing the software for $0 for limited time.

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

Login

Login Page - Create Account