Login Page - Create Account

Support Board


Date/Time: Fri, 03 May 2024 23:37:55 +0000



[Programming Help] - Spreadsheet Study trading system

View Count: 773

[2018-08-01 07:18:21]
User852086 - Posts: 41
What are the recommendations for running multiple spreadsheet systems.
I would like to run similar strategies on multiple symbols on the same trading account.
Is it better to run inside the same chartbook with different sheets or separate chartbooks for each symbol with dedicated spreadsheet? Or maybe different instances of Sierra for each ? What is most reliable solution?
[2018-08-01 08:33:46]
Sierra Chart Engineering - Posts: 104368
This is explained here:
Automated Trading Management: Using Multiple Automated Trading Systems at the Same Time
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
[2018-08-01 13:49:52]
Sawtooth - Posts: 3993
If you are using the same strategy for all symbols, it is easier to manage within the same chartbook, using the same-named spreadsheet, because you only need to modify one sheet's formulas, since the Formula Source Sheet Number of each symbol's spreadsheet study can be set to use the same sheet. Also, you'll be able to reference other sheets in the same-named spreadsheet, which is not possible in uniquely named spreadsheets, or across chartbooks.

You could then also add a sheet that is not associated with a chart, and combine all user variables on that one sheet. The J26 Order Quantity is a user variable that must be used on each sheet, so you'll have at least this one.

The key things are:
-Don't use the same symbol on more than one trading chart.
-Pay attention to the Formula Source Sheet Number setting on each.
[2018-08-02 04:10:13]
User852086 - Posts: 41
thanks mate, will do
[2018-08-02 14:37:39]
User735640 - Posts: 14
tomgilb I sent you a direct message request relating to trend lines as I did not want to high jack this thread.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account