Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 20:30:32 +0000



Quick Questions re: Spreadsheet System for Trading

View Count: 294

[2024-04-29 23:37:12]
gambotage - Posts: 16
Hi guys,

I have a strategy I'm trying to test to verify that it's functioning correctly and have come into a couple things about behavior which I will describe. I'm sure the answers are somewhere on the site's documentation, I went looking but haven't found anything yet. To preface the questions, I have attached screenshots with the settings that were used while performing the test.

1. Using Standard Replay as the replay type, my signal will evaluate on open (which is what I want) but the signal also appears to fire either on the close of that bar, or the open of the following one, while I have "Alert only once per bar" checked. If there was a secondary signal, the background should also highlight as it does with the original signal. See screenshots.

2. During the replay test, the first position opened with 1 contract and actually used the ATM specifications I defined on the Trade Window for Chart for a bracket order for stop/target (also what I wanted, great). Then between the time the first entry happened & the second (undesired), the bracket order disappeared completely. Is it acceptable to use a twconfig to manage entries and exits when using the Spreadsheet System for Trading or should I be specifying everything fastidiously in the spreadsheet (eg: I didn't even have J26 Order Quantity specified)? Not sure why the ATM would disappear mid-bar.

OK switching gears slightly...

3. Regarding the new Alerts system is there documentation that covers all settings for this?

For example I'd like to setup an Alert to just give the Alert name, Instrument & Price (Telegram timestamps are automatic so Time not needed specifically).

So far in what I've discovered, in order to get the Alert name to send over I also receive the spreadsheet formula for the alert.

Would be nice to have the aforementioned with an accompanying screenshot, which works fantastic. And is fast as hell.

4. Is it possible to configure Alerts propagate go to a specific Telegram room? Again, if the documentation page goes over this would be great to setup also.

Thanks for your consideration of my questions!
Date Time Of Last Edit: 2024-04-29 23:43:37
imageScreenshot 2024-04-29 at 6.58.34 PM.png / V - Attached On 2024-04-29 23:36:32 UTC - Size: 45.36 KB - 55 views
imageScreenshot 2024-04-29 at 6.59.15 PM.png / V - Attached On 2024-04-29 23:36:38 UTC - Size: 43.21 KB - 60 views
imageScreenshot 2024-04-29 at 7.00.22 PM.png / V - Attached On 2024-04-29 23:36:42 UTC - Size: 204.1 KB - 51 views
[2024-04-30 15:00:41]
John - SC Support - Posts: 36238
1. From what you state and show, the additional signal is not breaking the rule of "Signal Once per Bar", as it is occurring at the next bar. Therefore, you would need to figure out why this is occurring with the formulas you have setup.

2. You do not need to specify the Attached Orders in the Spreadsheet. When you do not, the system will use what is setup in the Trade Window. This is not an issue.

We do not know why the orders disappeared as they did. But again, this is something you would have to look into further.

3. All of the information for the Alert options have been updated at the following link:
General Settings Window: Alerts (Global Settings >> General Settings)

4. There is not a way to have the alerts go to an already existing connection/room. When you setup the alerts to Telegram, it creates a new connection within Telegram.
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