Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 20:30:41 +0000



spreadsheet study to execute only one trade each day

View Count: 1869

[2013-07-14 23:57:54]
User38304 - Posts: 5
Hi, I'm trying to migrate a strategy to Sierra, using the spreadsheet study for trading.
My strategy takes one entry per day, when certain conditions become true.
I can't seem to find a way to do this, having searched the forums, and read the following help
http://www.sierrachart.com/index.php?l=doc/doc_WS_AddInfo.html#StateLocking

The above seems close, but I can't manually reset each day.
Could you point me in the right direction please?
[2013-07-15 06:28:42]
Sierra Chart Engineering - Posts: 104368
Our recommendation is to use the Daily Total Trades spreadsheet field. It is documented here:
http://www.sierrachart.com/index.php?l=doc/doc_SystemsAlerts.php#CellJ52

You can just check to see if this is greater than 1 and disable auto trading if it is.

The documentation has just been updated to give the formula you need to use.

Thinking about this some more, how order fills are processed and how the Spreadsheet System for Trading study works, this really is the recommended method to do it. It is very reliable and straightforward. If there any issues, please let us know.
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
Date Time Of Last Edit: 2013-07-15 06:50:22
[2013-07-15 08:45:38]
User38304 - Posts: 5
Thanks both, back on track now.
And thanks for updating the documentation Sierra Chart Eng, presumably it should be =J52 >= 1 rather than =J52 > 1 to only take one trade a day, in case you thought it mattered for others
[2013-07-15 09:02:26]
Sierra Chart Engineering - Posts: 104368
Yes, you are right. We will correct the documentation.
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

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

Login

Login Page - Create Account