Login Page - Create Account

Support Board


Date/Time: Sun, 28 Apr 2024 16:18:01 +0000



Duplicate SpreadsheetforTradingStudy

View Count: 714

[2017-05-10 19:14:00]
User14683 - Posts: 34
My auto trading is working great, using the SpreadsheetforTradingStudy.
Is there an easy way to duplicate this exactly on another market(s), without having to type all the formula to another market and its Spreadsheet?
[2017-05-10 19:28:18]
Sierra Chart Engineering - Posts: 104368
This is good to know.

To duplicate it just requires that you save it as a Study Collection and apply it to another chart. Refer to:
Study Collections

Make sure you have set the Chart Data Output Sheet Number Input to 0:
Spreadsheet Study Inputs: Chart Data Output Sheet Number

And also understand this Input:
Spreadsheet Study Inputs: Formula Source Sheet Number
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
[2017-05-11 14:51:23]
User14683 - Posts: 34
I think I messed up somewhere. I went trough the documentation, saved a Study Collection and applied it successfully to my other 9 chart (markets).
I did set the Chart Data Output Sheet Number input to 0.
I also read through your bottom recommendation a few times to understand it, but what I thought would happen, did not (I though sheet 1 would work on chart 1, sheet 2 on chart 2 etc).
All hell broke loose. Sheet 1 reflected all the other market data and flickered up and down with all the market data.
Maybe I should just keep every chart and its spreadsheet separate (even if I have to copy and paste all the formulas into every spreadsheet).
Is there a way I can keep a chart and its spreadsheet separate from pulling the other market data in, without having to open 10 instances of SC?
[2017-05-11 22:11:11]
Sierra Chart Engineering - Posts: 104368
Are these other 9 charts all in the same Chartbook. They need to be.


Is there a way I can keep a chart and its spreadsheet separate from pulling the other market data in, without having to open 10 instances of SC?
Yes. What you need to do is for each instance of the Spreadsheet System for Trading study, use a different Spreadsheet Name:
Chart Studies: Settings and Inputs Tab >> Spreadsheet Name / DLL File and Function Name
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:

Login

Login Page - Create Account