Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 21:46:23 +0000



Spreadsheet Trading: Tgts and Stps in trade win get overwritten by the system with 1pt stp

View Count: 214

[2024-02-06 14:09:05]
Andre - Posts: 31
Hi,

On my Spreadsheet trading system (SIM), the stops and targets in the trade window, which is attached to the chart, get overwritten even though i save the values that i want in the trade window menu like described in the documentation.

This has started to happen with the new update. The target gets deleted and the stop values always get overwritten with 1pt offset (ES future). E.g. from Tgt +7pt, Stp -5pt to Stp -1pt.

I use the TMS and get the stop levels from the spreadsheet but I usually had a wide "emergency stop" which came from the trade window in case something went wrong with the spreadsheet or internet connection but that does not work anymore. Also, I can not use TMS if the stop level on the spreadsheet is more than 1pt since the overwritten stop will be "in the way".

Secondly,

On the spreadsheet, in column K-N, from row 192 downwards, it does not update/recalculate anymore if I cange soemthing in e.g. K3. It used to do that. It does not impact me since I only use the rows higher up but I thought I highlight it in case other users have the same issue.

Thank you for your help in advance.
[2024-02-06 18:41:44]
John - SC Support - Posts: 36280
If you have Stops and Targets defined in the Spreadsheet, then this will override what is in the Trade Window. The opposite is also true, if you do not have anything defined, then the setup for the Attached Orders in the Trade Window will be used. Refer to the following:
Spreadsheet Systems, Alerts and Automated Trading: Attached Order Target Offset (write only) [J80]

Also, keep in mind that there is a new Input on the Spreadsheets for "Use Column I and J Values Version 2", which reorders where the information in Columns I and J will show up. There were a few releases where this was set to "Yes" by default, and then we changed it to "No" by default. So you have to make sure how this is set for what you want, and make sure that if you are using an existing spreadsheet, that when you change this setting, the values in the J column are not removed, so you could have something in a cell that you do not want.
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:

Login

Login Page - Create Account