Support Board
Date/Time: Tue, 04 Mar 2025 09:16:45 +0000
[Programming Help] - Spreadsheet System for trading
View Count: 1142
| [2021-12-06 18:07:13] |
| User956550 - Posts: 12 |
|
Hello, When I use the spreadsheet system for trading, I use the field K3 BuyEntry and write my parameters inside. If all parameters are ok a long trade is startet. Now my problem: I don’t want to use L3 BuyExit, I want to use a trailing stop and target. The Tradewindow is attached to the chart and I can see the trade started by the Spreadsheet in the Trading Dom and in the Tradewindow, but the target and the trailing stop do not work. If I start a Trade manual in the Tradewindow everything works , but not when it was started by the Spreadsheet. I tried it with a 1 in Field J80 and J81 but it does not work. Where is the mistake? Thank you for your answer |
| [2021-12-06 20:00:16] |
| Sawtooth - Posts: 4179 |
|
On the Trade Window, 'Use Attached Orders' must be checked.
|
| [2021-12-06 20:36:06] |
| User956550 - Posts: 12 |
|
Yes, attached orders is checked on the Trade window. But it does not work
|
| [2021-12-06 21:05:35] |
| Sawtooth - Posts: 4179 |
|
Values in cells J80/J81 are the offset from the entry price, in points, not ticks.
Date Time Of Last Edit: 2021-12-06 23:29:45
|
| [2021-12-06 21:10:05] |
| User956550 - Posts: 12 |
|
Ok, but than there is no trailing stop.Is it not possible that the parameters from the trade window will work? For example trailing stop or go break even after 10Points?
Date Time Of Last Edit: 2021-12-06 21:11:44
|
| [2021-12-06 21:36:00] |
| Sawtooth - Posts: 4179 |
|
J80/J81 are for the initial Attached Orders target/stoploss only. And only for a static target/stoploss. Spreadsheet Systems, Alerts and Automated Trading: Attached Order Target Offset (write only) [J80] J80/J81 are intended for dynamic offsets controlled by a formula. If the offsets are always the same, you don't need to use J80/J81. Just use a Trade Window config with the offsets. If you need dynamic offsets, followed by a trailing or BE stoploss, then the best solution IMO is: - Use J80/J81 for the initial Attached Orders offsets. - Use a Formula Column with a formula that outputs the trailing stoploss price, then reference that column/subgraph with the Trade Management by Study study. Attached Orders: Study Controlled Targets and Stops |
| [2021-12-06 21:43:26] |
| User956550 - Posts: 12 |
|
Ok! Thank you! But this is my problem! I tried it like this, but it doesn’t work. And I don’t know why. Attached orders are allowed in the Tradewindow but they do not work, no Target no Trailingstop nothing. When i start a Trade manual, for example I push the buy button, everything works like I want it.
|
| [2021-12-06 22:28:47] |
| Sawtooth - Posts: 4179 |
|
If the spreadsheet is entering an order but there are no Attached Orders, it's going to be something unusual: - The spreadsheet sheet with the formulas must be the one associated with the chart where the entries are expected, either (by default) the Sheet# matches the Chart#, or the Formula Source Sheet Number setting must match the sheet with the formulas. - There can only be one autotrading chart in the chartbook with the same symbol. - You can't have more than one chartbook concurrently autotrading with the same-named spreadsheet file. For the Spreadsheet System for Trading study to place a SIM order: - Cell K3/M3 must go TRUE/1. - 'Send Order To Trade Service' must be set to No, and Trade >> Trade Simulation Mode On must be checked. - Trade >> Auto Trading Enabled - Global, and Trade >> Auto Trading Enabled - Chart must both be checked. - Cell J28 must be FALSE/0 - Cells J85-J87 must not be limiting entry. To see an explanation why there is no entry, check the Trade >> Trade Service Log Date Time Of Last Edit: 2021-12-06 23:33:28
|
| [2021-12-06 22:51:52] |
| User956550 - Posts: 12 |
|
Thanks a lot for your help!!! I will check all your points and hope I will find the failure. |
| [2021-12-06 23:05:39] |
| User956550 - Posts: 12 |
|
Now it works!!!
|
To post a message in this thread, you need to log in with your Sierra Chart account: