Home >> Support Board

Support Board

Date/Time: Fri, 26 Apr 2024 22:14:38 +0000

How to Post a Message for Support

Automated Trading Question

View Count: 1362

[2013-09-19 15:23:02] #1 [Go To First Post]
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] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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] #3 [Go To First Post]
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] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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: