Login Page - Create Account

Support Board


Date/Time: Mon, 23 Dec 2024 05:18:47 +0000



[User Discussion] - Anyone help for spreadsheet code?

View Count: 1418

[2015-01-14 07:59:07]
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
imagema_diference.png / V - Attached On 2015-01-14 07:58:52 UTC - Size: 30.69 KB - 401 views
[2015-01-14 15:29:20]
Sawtooth - Posts: 4141
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]
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]
inverter - Posts: 42
this ,if possibile
image5-10 tick.png / V - Attached On 2015-01-14 16:14:21 UTC - Size: 21.7 KB - 391 views
[2015-01-14 19:33:57]
Sawtooth - Posts: 4141
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]
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]
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?
imagechart 1.png / V - Attached On 2015-09-05 13:19:36 UTC - Size: 15.16 KB - 321 views
imagechart also 1.png / V - Attached On 2015-09-05 13:19:50 UTC - Size: 17.92 KB - 311 views
imagespr. none up and down step.png / V - Attached On 2015-09-05 13:20:30 UTC - Size: 13.89 KB - 324 views
imagestep ma point.png / V - Attached On 2015-09-05 13:20:47 UTC - Size: 60.74 KB - 349 views
[2015-09-05 13:23:08]
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:

Login

Login Page - Create Account