Support Board
Date/Time: Sun, 24 Nov 2024 21:02:44 +0000
Setting up a Trailing Stop Using Spreadsheet System for Trading Study
View Count: 2748
| [2019-03-23 17:31:43] |
| User94606 - Posts: 327 |
|
How do I setup a trailing stop using the Spreadsheet System for Trading Study? I would like to use a 10 exponential moving average as the trailing stop
|
| [2019-03-24 03:01:38] |
| User701453 - Posts: 176 |
|
Add a Spreadsheet System for Trading Study to your chart. In the "L" column for a long exit based on price less or equal to chosen ema. =and(H3=1, J8 >0, E3<=P3) In the "N" column for a short exit based on price greater or equal to chosen ema. =and(H3=1, J8 <0, E3>=P3) "P3" being the column you ema is listed in,(change "P" letter to whatever your chosen ema is listed in) "H3" is a way to turn on/off the trailing stop with a simple 1 or 0. Enter a "1" to enable trailing stop, enter "0" to disable it. **Make sure "J72" and "J74" are set to "M" for a market orders **Test in sim mode to make any adjustments needed to code etc. **As always your mileage may vary & never guaranteed Date Time Of Last Edit: 2019-03-24 03:03:57
|
| [2019-03-24 04:36:06] |
| Sawtooth - Posts: 4120 |
|
If you only use a spreadsheet formula, you don't have a stop in the market. IMO, it's best to use Attached Orders, and let the Trade Management by Study study move the attached stop. The Trade Management by Study study can directly reference the EMA, or a spreadsheet formula result. Attached Orders: Study Controlled Targets and Stops |
| [2019-03-24 14:24:41] |
| User94606 - Posts: 327 |
|
@tomgilb - what do you mean by "If you only use a spreadsheet formula, you don't have a stop in the market"?
|
| [2019-03-24 16:47:40] |
| User701453 - Posts: 176 |
|
tomgilb idea is probably the best way. I always have a "stop in the market" to save my account, usually a swing high or swing low. But I have used a "hidden stop" (spreadsheet)as my true stoploss. Its usually close to my entry and I don't want the market to see it. The market will tend to reach out grab your stop to the tick and then move in your chosen direction. Its just a process I used in MT4 for forex and applied it to trading futures Date Time Of Last Edit: 2019-03-24 16:49:09
|
| [2019-03-24 17:32:14] |
| User94606 - Posts: 327 |
|
@User7014534 - thank you for your feedback. I need to get myself familiar with the "Trade Management by Study"
|
| [2019-03-24 18:37:38] |
| Sawtooth - Posts: 4120 |
|
what do you mean by "If you only use a spreadsheet formula, you don't have a stop in the market"?
You could place a stop in the market with a spreadsheet formula at the time of a spreadsheet entry, using a price in J23/J25 and "S" in J72/J74, triggered by a formula in L3/N3, but now it becomes complex to program a trailing stop exit using the same L3/N3 cells.If you don't place a stop using this method, or you don't use Attached Orders, you don't have any stop in the market. If you don't use Attached Orders with a spreadsheet entry, you won't have a stop in the market that can be moved programmatically. |
| [2019-03-25 18:03:12] |
| |
|
For this you do want to use a study controlled Stop Attached Order: Attached Orders: Study Controlled Targets and Stops 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 |
| [2021-04-01 10:38:25] |
| Trade-Mekoome - Posts: 7 |
|
Hello! I have lookalike question - is it possible to make Order type for Buy entry in Spreadsheet trading system to be a trailing stop order?
|
| [2021-04-01 21:44:09] |
| |
|
No this is not supported.
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 |
| [2024-04-26 03:02:38] |
| User656492 - Posts: 143 |
|
I'm attempting to do this now and getting very nearly the result I want, but it lags one bar. Specifically, My trailing BUY STOP is in column Q (aka ID8.SG7) of my Spreadsheet System For Trading. My stop controlled by TMS is lagging one bar, showing the value in Q4 rather than Q3. The Order Adjustment Timing is On Bar Close. How do I get TMS to point at Q3? Date Time Of Last Edit: 2024-04-26 03:48:30
|
| [2024-04-26 14:41:01] |
| John - SC Support - Posts: 36238 |
|
The Order Adjustment Timing is On Bar Close.
Change this setting to not adjust on bar close. By definition, with the option to adjust on bar close, you are going to be behind by 1 bar, as a bar is not closed until the next bar starts. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: