Support Board
Date/Time: Sat, 10 May 2025 21:33:50 +0000
Auto trading with the new Spreadsheet System
View Count: 1813
| [2015-03-12 21:55:43] |
| Laurent - Posts: 4 |
|
My an auto trading system uses the same symbol, displayed on multiple Bar Periods Charts, each with the Spreadsheet System for Trading study attached. I use the Chart 1 "Spreadsheet System for Trading" to drive a Buy/Sell trading action, that is generated from the calculated results of all Sheets used in the Study. One for each Chart. How Can I make this work in the NEW Spreadsheet System for Trading ? |
| [2015-03-12 22:42:47] |
| |
|
As long as all of the Sheets being used are within the same Spreadsheet window, then it will work. It sounds like this is the case.
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 |
| [2015-03-12 22:43:47] |
| Sawtooth - Posts: 4214 |
|
Assuming your formulas use functions supported by the New Spreadsheet, it will work in the New Spreadsheets if you use the same-named spreadsheet file on all the charts in the same chartbook. Each chart will appear on its own Sheet#. Reference other sheets like this: =Sheet2!D3 Other things to consider: -When referencing text, the New Spreadsheets are case-sensitive. -The New Spreadsheets do not support: --referencing separate spreadsheet file names. --circular referencing that the Old Spreadsheets used to lock a TRUE condition. --conditional formatting and cell borders. They only support basic text and background coloring. --password protection of workbook structure. |
| [2015-03-13 19:24:04] |
| |
|
This is supported in New Spreadsheets: --circular referencing that the Old Spreadsheets used to lock a TRUE condition. This has been confirmed to work and was supported from the beginning. 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 Date Time Of Last Edit: 2015-03-13 19:26:27
|
| [2015-03-13 20:18:46] |
| Sawtooth - Posts: 4214 |
|
This is supported in New Spreadsheets:
--circular referencing that the Old Spreadsheets used to lock a TRUE condition. This has been confirmed to work and was supported from the beginning. Good news! But I was going by what had been said by Support in a previous post: version 1116 non CLR spreadsheet | Post: 30516 |
| [2015-03-13 20:24:39] |
| |
|
OK but a reference in a cell to itself is not considered a true circular reference.
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 |
To post a message in this thread, you need to log in with your Sierra Chart account: