Home >> Support Board

Support Board

Date/Time: Thu, 18 Dec 2025 10:58:01 +0000

How to Post a Message for Support

[User Discussion] - Anyone help for spreadsheet code?

View Count: 1548

[2015-01-14 07:59:07] #1 [Go To First Post]
inverter - Posts: 42
where and how to find the codes for the system? on pages sierra has only one example. http://www.sierrachart.com/index.php?l=doc/doc_SystemsAlerts.php#BuyEntryLimit I need a sample code for the second study ..nema idea what to write and where to start ..molim if someone has an example or a link where I can find codes for the moving average difference? Thank you very much in advance


ma_diference.png / V - Attached On 2015-01-14 07:58:52 UTC - Size: 30.69 KB - 443 views

[2015-01-14 15:29:20] #2 [Go To First Post]
Sawtooth - Posts: 4299
The MA Difference study will output its values in a column AA and above. Columns K-N are for autotrading signals, but only when using the Spreadsheet System for Trading study. So to get a signal at the zero crossing of the MA Difference study, try this: cell K3: =AND(AA4<0,AA3>0) cell M3: =AND(AA4>0,AA3<0) where the MA Difference study is in column AA.

[2015-01-14 16:05:21] #3 [Go To First Post]
inverter - Posts: 42
GREAT it works thanks lot. Now the other thing, the signal is ok ... but the price is always returned a little back, I want to signal after the order entry several tick backwards. whether this is possible?

[2015-01-14 16:14:39] #4 [Go To First Post]
inverter - Posts: 42
this ,if possibile


5-10 tick.png / V - Attached On 2015-01-14 16:14:21 UTC - Size: 21.7 KB - 434 views

[2015-01-14 19:33:57] #5 [Go To First Post]
Sawtooth - Posts: 4299
You can set a Limit order at a certain price when the signal occurs. Set cells J71 and J73 to L and put formulas in J22 and J24 that sets the price. Then you'll need to put a formula in J27 or J78 to cancel it if it doesn't get filled. It can get complicated and the actual solution might be beyond what can be given in a forum post. Here the documentation: http://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php Date Time Of Last Edit: 2015-01-14 20:18:10

[2015-01-14 20:45:15] #6 [Go To First Post]
inverter - Posts: 42
means it is possible,, now was a very complicated looks, but I'll try thanks a lot ... if downtime I'll ask more here ok?

[2015-09-05 13:20:53] #7 [Go To First Post]
inverter - Posts: 42
I encountered a problem. I wwap, and vval, and his MA indikator..i would give me work either individually or both spreadsh. I tried all ways,, cross, from..etc. may not support this basic package, or something else? can you give me an example of entry or way, thanks?


chart 1.png / V - Attached On 2015-09-05 13:19:36 UTC - Size: 15.16 KB - 364 views chart also 1.png / V - Attached On 2015-09-05 13:19:50 UTC - Size: 17.92 KB - 361 views spr. none up and down step.png / V - Attached On 2015-09-05 13:20:30 UTC - Size: 13.89 KB - 370 views step ma point.png / V - Attached On 2015-09-05 13:20:47 UTC - Size: 60.74 KB - 395 views

[2015-09-05 13:23:08] #8 [Go To First Post]
inverter - Posts: 42
STEP MA is custom study ,Perhaps there is a problem ... but I doubt it because wwap not working either. thanks

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