Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 22:16:39 +0000



[User Discussion] - Automated trading from a Chart Study Value

View Count: 1199

[2014-10-19 20:11:15]
User87521 - Posts: 81
I would like to set up an automated trade based off of a study input value. (or multiple values if possible) Does this need to be programmed via a spreadsheet, or is there some way to use the Chart studies themselves. It looks like the auto trading is based on price but I would like other inputs.

For example. If period close = less than exponential moving average (50) then sell stop. (buy stop - etc.)

Is this possible? Is there any documentation?
[2014-10-22 05:04:04]
Sierra Chart Engineering - Posts: 104368
The easiest way to do this is to use the Spreadsheet System for Trading study. It is documented on this page:
https://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php
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
[2014-11-16 16:52:07]
User87521 - Posts: 81
Thanks for pointing me in the right direction. This is working well. Can you point me to a resource that will list/outline all the commands that can be used in the spreadsheet system?

I am trying to set up an IF/THEN type of condition but cannot figure out the syntax. Its been more than a couple decades since I did any programming. I am trying to do this:

If AE4<=0 then sell when AE3<AE4 OR If AE4>0 then sell when AE3<0.

Thanks again.
[2014-11-16 18:14:11]
Sawtooth - Posts: 3952
Try this:
=OR(AND(AE4<=0,AE3<AE4),AND(AE4>0,AE3<0))
[2014-11-16 21:17:04]
User87521 - Posts: 81
Thanks very much Tom. It seems to be working in backtesting. On to forward testing tomorrow.

Do you know of an online resource (or book) one could consult for these commands?
[2014-11-16 21:33:44]
Sawtooth - Posts: 3952
I use these:
http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html
http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP005204211.aspx
(not all of the Excel functions are available in spreadsheet studies)

Also, there are some examples here:
http://www.sawtoothtrade.com/examples.html
Date Time Of Last Edit: 2015-08-14 02:10:59
[2014-11-16 21:40:09]
User87521 - Posts: 81
Excellent Tom. Thanks.

I searched for this on the Sierra website and nothing came up. Wrong parameters obviously.


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

Login

Login Page - Create Account