Login Page - Create Account

Support Board


Date/Time: Wed, 24 Apr 2024 07:42:07 +0000



End of day condition

View Count: 1904

[2013-09-04 22:06:19]
User42282 - Posts: 41
Hi,
pls, is there a working way how to set exit condition to the end of trading hours? The question is related to spreadsheet system for trading.

I use exact time for exit condition, but it is unreliable. Either the data ends earlier (for some special days), either there is no bar close (volume chart)... and there is plenty of reasons why this is not working properly. Thank you in advance.
Mirek
[2013-09-05 16:18:08]
Sierra Chart Engineering - Posts: 104368
What cell are you comparing to determine the last traded time? You need to use J41:
http://www.sierrachart.com/index.php?l=doc/doc_SystemsAlerts.php#CellJ41
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
[2013-09-05 19:33:26]
User42282 - Posts: 41
Thanks for replying. I simply use A3 but I dont think this is a problem. I guess my question was not clear. I know some other platforms support "EOD exit" condition, however I have no idea, how this is implemented.
Lets have an exit of all positions every day at 15:10. Usually it works fine. In some cases there are missing data for this exact time, for example (shortened trading hours). Then the condition waits for another 24 hours (at least).
[2013-09-05 20:51:13]
Sierra Chart Engineering - Posts: 104368
You could make the comparison to the time returned by NOW():
http://www.sierrachart.com/index.php?l=doc/doc_WorksheetFunctions.html
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
[2013-09-05 22:00:55]
Sawtooth - Posts: 3976
NOW() only updates when the chart updates, so it wouldn't be any better than using J41.
[2013-09-06 03:22:51]
Sierra Chart Engineering - Posts: 104368
Yes, this is true. However, it always returns the most current time.
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