Support Board
Date/Time: Tue, 16 Dec 2025 05:04:08 +0000
Post From: Help with Spreadsheet trading study.
| [2017-08-08 21:05:14] |
| Sawtooth - Posts: 4299 |
|
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 |