Home >> Support Board

Support Board

Date/Time: Sun, 23 Feb 2025 22:21:12 +0000

How to Post a Message for Support

[User Discussion] - Spreadsheet help to send order

View Count: 858

[2021-01-29 14:58:13] #1 [Go To First Post]
User657945 - Posts: 226
@tomgilb do you have a std spreadsheet to let an input coming from an IDx.SGX created with a Colorbackground trading system let send an order at X ticks below/up the activation price i.e. the Color background get active at 177.01 and I would like to send out an order i.e. 2 ticks below if it is a long and 2 ticks up if it is a short.I'm doing it manually now the formula algo in the Colorbackground works fine but there's typically 2-3- ticks of shifting and I would like to filter them auto in stead of doing manually. thx

[2021-01-29 16:05:20] #2 [Go To First Post]
Sawtooth - Posts: 4174
Use the Spreadsheet System for Trading study. You'll need to use Limit entries. - Set J71/J73 to L - Use these formulas in J22/J24: J22: =E3-J212 J24: =E3+J212 - The triggers must be in K3/M3. - The Order Quantity will need to be set in J26. - In the spreadsheet study settings, set ln:18 to your requirement. - You'll need to manually cancel orders that don't fill. - Trade >> Auto Trading Enabled must be checked.

[2021-01-29 16:43:02] #3 [Go To First Post]
User657945 - Posts: 226
Thx a lot Tom I will try during the weekend and let you know Have a nice weekend Alberto

[2021-02-18 12:45:44] #4 [Go To First Post]
User657945 - Posts: 226
Hi Tom I tried but I'm not able let the order sent to the market any suggestion?

[2021-02-18 16:27:00] #5 [Go To First Post]
Sawtooth - Posts: 4174
Hi Tom I tried but I'm not able let the order sent to the market any suggestion? For live trading: - In the spreadsheet study settings, set 'Send Orders To Trade Service' ln:21 to Yes. - Uncheck Trade >> Trade Simulation Mode On

[2021-02-18 17:29:12] #6 [Go To First Post]
User657945 - Posts: 226
I tried of course in sim mode I will check what in J21 I do not remember right now, thx in any case.May be I found a possible error I mean: the triggers which sintax use it? Since I use the Colorbackground alert condition I inserted the value that give the background to be colored that normally I use in hte Trading system for alert so example ID65.SG1>0. Am I wrong? thx Date Time Of Last Edit: 2021-02-18 17:46:38

[2021-02-18 18:07:17] #7 [Go To First Post]
User657945 - Posts: 226
I test again wiht all set as per your istruction it does not send out any order the Colorbackground triggers but the spreadsheet is not sending out the order. Do you prefer to continue in private mode to avoid may be disturbing the support board? let me know. thx Alberto p.s. I'm the forum with Petr in case Date Time Of Last Edit: 2021-02-18 18:07:38

[2021-02-18 18:09:32] #8 [Go To First Post]
Sawtooth - Posts: 4174
The Trading System Based On Alert Condition study uses Simple Alert syntax: ID65.SG1[0]>0 [0] is the current bar. [-1] is the previous bar. (If it is zero, brackets are not necessary.) The Spreadsheet System for Trading study uses spreadsheet syntax: ID65.SG1@3>0 @3 is the current bar. @4 is the previous bar. (This number is the spreadsheet row.) If you want to reference the Color Background Based On Alert Condition study, find its output to the spreadsheet in columns AA and above.

[2021-02-18 18:25:38] #9 [Go To First Post]
User657945 - Posts: 226
OK that's the point I'm ignorant in using spreadsheet so the value is [ID56.SG1] Background, and is in cell JB should I insert the ID56.sg1 with the brackets? or should I insert =JB? Thx reading sierra istruction should be =$JB$2>0 Date Time Of Last Edit: 2021-02-18 18:41:21

[2021-02-18 19:16:38] #10 [Go To First Post]
Sawtooth - Posts: 4174
If you are using a spreadsheet study, you must use spreadsheet syntax. All formulas in Formula Columns K-Z must go in row 3. You can use an alphanumeric cell reference with this : =JB3>0 (No need to use an absolute reference with $.) However, it is recommended that this reference method be used instead: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study Like this: =ID56.SG1@3 where ID56 is the Color Background study.

[2021-02-18 20:12:33] #11 [Go To First Post]
User657945 - Posts: 226
Tom thx so much it works! You won a virtual Italian Pizza:) But if you'll come to Italy you'll be my guest.

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