Support Board
Date/Time: Mon, 06 May 2024 03:13:53 +0000
Spreadsheet for automated trading
View Count: 860
[2020-03-10 21:13:05] |
Rustam - Posts: 19 |
Hi. I have problems with the spreadsheet for auto trading. I have set the study HIGH/LOW for Time Period - Extended. I just want to backtest something. When High crosses from below (3 Ticks) i want open a long position (buy market) and vice versa when the low crosses from above. I tried every commands, but it won´t work. Can someone help me pls ? Sorry for my english. The screen Images function for sierra dont work for me. |
Screen Shot 10.03.2020 at 22.10.png / V - Attached On 2020-03-10 21:11:56 UTC - Size: 460.13 KB - 214 views Attachment Deleted. |
[2020-03-12 00:06:30] |
Sierra Chart Engineering - Posts: 104368 |
The CROSSFROMBELOW function requires 2 parameters in order to know the two lines to see if they are crossing. You only have 1. Refer to the information here: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#CROSSFROMBELOW_Function With regards to the image uploading not working, you just need to update to the latest release to solve that: Software Download: Fast Update 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 |
[2020-03-12 14:51:15] |
Rustam - Posts: 19 |
Which command do i need? i want to take a buy market order when the Price gets 3 ticks over the High-Line from below or the price gets 3 ticks under the Low-line from above ? I tried everything but i get #syntax error. |
[2020-03-12 18:12:53] |
Sierra Chart Engineering - Posts: 104368 |
Tell us the exact formula that is giving that error.
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 |
[2020-03-12 19:24:09] |
Rustam - Posts: 19 |
=CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@4,ID22.SG1@3:ID22.SG1@4) I don't know about the commands. I have another problem. Suddenly the Alert manager opens, even though the option is issued. Before that there were no problems and I didn't change anything. http://www.sierrachart.com/image.php?Image=1584040483851.png |
[2020-03-17 04:41:26] |
Sierra Chart Engineering - Posts: 104368 |
Check this setting: General Settings Window: Show Alerts Log On Study Alert (Global Settings >> General Settings >> Alerts >> Additional Settings) 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 |
[2020-03-17 06:28:11] |
Rustam - Posts: 19 |
and what about my auto trading commands ?
|
[2020-03-17 18:57:05] |
Sierra Chart Engineering - Posts: 104368 |
We do not provide formula programming help. Are you receiving a syntax error with a particular formula?
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 |
[2020-03-17 20:36:08] |
Rustam - Posts: 19 |
With the command in post #7 I get a Syntax error
|
To post a message in this thread, you need to log in with your Sierra Chart account: