Login Page - Create Account

Support Board


Date/Time: Sun, 29 May 2022 01:25:30 +0000



Automated Trading Question

View Count: 1048

[2013-09-19 15:23:02]
Richard Reyes - Posts: 98
I am running an Excel spreadsheet automated trading system. How do I "flatten" (cell j29) or "cancel" (cell j27) all working orders when "cummulative closed profit/loss" (cell j11) reaches a certain figure (+10000), while simultaneously "disabling auto trading" (cell j28)? Many Thanks
[2013-09-19 16:48:11]
Sierra Chart Engineering - Posts: 102918
What you can do is check the Position quantity is 0 and the Cumulative Closed Profit/Loss is equal to or over a certain amount in a formula used in: "disabling auto trading" (cell j28).
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-19 19:07:14]
Richard Reyes - Posts: 98
I have entered the following formula in "Disable Auto Trading" (cell J28) ... =(F11>=10000) and the trading system keeps trading well past 10000. I am trading GBP/CHF. I do not understand what I need to do with cell J8, "Position Quantity" as this cell is "read only." Please advise.
[2013-09-19 22:43:56]
Sierra Chart Engineering - Posts: 102918
Use:
=AND(J11>=10000,J8=0)
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