Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 03 May 2024 16:35:14 +0000
Help with Spreadsheet trading study.
View Count: 1696
| [2017-08-06 12:07:56] |
| fjgaspar - Posts: 62 |
|
Hi, I am trying to initiate in begin to automated trading with spreadsheets, and I don't know well where to start. I have read de documentation, but I don't know how to do simple things. As when I have studied other programming languages, I try to start by a simple 'hello word', so I am trying to do a kind of simple hello word without success (not even know where to begin). Very simple thing: a chart in an 8 tick range. If a bar is green (i.e. close > open), buy a limit order at high (when the follow bar begins, I mean, when you have the confirmation that the previous bar was green) if no position open. If short position is open, close the position and put a buy limit order at that price. When a bar is red (i.e close < open), if a long position is open, close the long and put a limit sell order at low of red bar. If a limit order doens't executes when the current bar finishes, cancel it. Anyone can help me with the formulas to wrrite in Buy entry, buy exit, sell entry and sell exit? Thanks |
| [2017-08-08 21:05:14] |
| Sawtooth - Posts: 3992 |
|
What you want to do is not that simple. You'll need trigger formulas, like these: K3: =E3>B3 M3: =E3<B3 You'll need to set the Limit prices, like this: J22: =C4 J24: =D4 You'll need to set the order type to L in cells J71 and J73. You'll need a formula in J27 to cancel unfilled orders. You'll need to set these in the spreadsheet study settings: Cancel All Orders On Entries And Reversals to Yes. Allow Entry With Working Orders to Yes. Signal Only On Bar Close to Yes. Support Reversals to Yes. Even with all of these, there will probably be some tweaking. Here are some basic tips for spreadsheet studies: http://www.sawtoothtrade.com/tip-1.html |
| [2017-08-08 21:36:56] |
| |
|
We do not provide formula programming help. But we can refer you to a programmer. Or you can rely on what tomgilb has said above. 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 Date Time Of Last Edit: 2017-08-08 21:37:04
|
| [2017-08-09 06:14:54] |
| fjgaspar - Posts: 62 |
|
Thank you so much for the help. I will try as soon as I can.
|
To post a message in this thread, you need to log in with your Sierra Chart account: