Support Board
Date/Time: Sat, 28 Dec 2024 09:19:46 +0000
Overlaying Spreadsheet Study
View Count: 1278
| [2016-04-21 23:45:15] |
| TechTrader - Posts: 116 |
|
When overlaying a "Spreadsheet Study" on to a "Spreadsheet System for Trading Study" the maximum "Number of Formula Columns" (60)are transferred even though the "Spreadsheet Study" "Number of Formula Columns" is set to 16. As a result there are many additional columns transferred that have only zero's in them.
|
| [2016-04-21 23:51:24] |
| Sawtooth - Posts: 4143 |
|
The way to avoid this is to use a SMA with a length of 1, Based On the Spreadsheet Study's column, then use the Study/Price Overlay study to overlay the SMA on the chart with the Spreadsheet System for Trading study.
Date Time Of Last Edit: 2016-04-21 23:56:38
|
| [2016-04-22 05:48:00] |
| TechTrader - Posts: 116 |
|
Thanks for the workaround tomgilb.
|
| [2016-04-23 00:21:36] |
| |
|
What do you mean by this: When overlaying a "Spreadsheet Study" on to a "Spreadsheet System for Trading Study"
What exactly are you doing? 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 |
| [2016-04-23 03:54:29] |
| TechTrader - Posts: 116 |
|
I use a "Spreadsheet Study" with large range bars. Calculations are performed on the PREVIOUS completed bar, NOT the current bar in progress. These calculations are then applied to a "Spreadsheet System for Trading" study using the "Study/Price Overlay" study. The "Spreadsheet System for Trading" study has much smaller range bars with calculations combining both the large range bar calculations and the smaller range bar calculations. This gives me a visual on both the larger range bar calculations and the smaller range bar calculations in the single window. My original query was if the "Spreadsheet Study" has only 16 formula columns (as set by the "Settings and Inputs" menu, why the "Study/Price Overlay" study needs to transfer all the unused columns.(ie 60). |
| [2016-04-23 05:31:30] |
| |
|
This is an easy solution. You just need to set this Input to Yes: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html#SubgraphsIgnore 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 |
| [2016-04-23 08:58:45] |
| TechTrader - Posts: 116 |
|
Thanks for that solution Support - much tidier!
|
To post a message in this thread, you need to log in with your Sierra Chart account: