Login Page - Create Account

Support Board


Date/Time: Wed, 15 Jan 2025 18:51:23 +0000



Post From: Help with Spreadsheet trading study.

[2017-08-08 21:05:14]
Sawtooth - Posts: 4153
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