Home >> Support Board

Support Board

Date/Time: Mon, 29 Apr 2024 03:54:12 +0000

How to Post a Message for Support

[User Discussion] - spreadsheet question

View Count: 968

[2015-05-03 22:19:15] #1 [Go To First Post]
User120827 - Posts: 77
hi If I have a spreadsheet that I want to use in multiple chartbooks with multiple charts, how do I do that ? Do I have to make duplicates ? I have a simple autotrade spreadsheet set up that I would like to use on several instruments. Can the same one be used in different locations and on different instruments ? shane

[2015-05-03 23:14:36] #2 [Go To First Post]
Sawtooth - Posts: 3982
You can use the same-named spreadsheet on all of your charts in the same chartbook, even on different instruments. Each chart will be on its own sheet, and by default, will be numbered the same as the chart number. Use the Spreadsheet Name field to name each one the same name, or you can copy the spreadsheet and its settings with a Save Single study collection on the source chart. Be sure to check 'Prompt to Remove Existing Studies'. Then from the destination chart go to Analysis and select the study collection.

[2015-05-04 01:26:01] #3 [Go To First Post]
User120827 - Posts: 77
hi Thanks Tom I appreciate your help once again ! 1 more question. Lets say I want to have a slightly different version of the spreadsheet. How do you make a copy with some minor changes and save that ? shane Date Time Of Last Edit: 2015-05-04 02:05:38

[2015-05-04 03:24:07] #4 [Go To First Post]
Sawtooth - Posts: 3982
The same-named spreadsheet study on each chart need not have the same Settings, and each sheet can have unique formulas. If each sheet has unique formulas, be sure that the Formula Source Sheet Number matches the sheet#/chart#. Date Time Of Last Edit: 2015-05-04 15:16:05

[2015-05-04 11:14:35] #5 [Go To First Post]
User120827 - Posts: 77
hi Ok, great ! thank you for your help on this. shane

[2015-05-04 13:55:33] #6 [Go To First Post]
Sawtooth - Posts: 3982
Shane, see the correction in post $4. The Settings do not need to be the same.

[2015-05-04 14:05:39] #7 [Go To First Post]
User120827 - Posts: 77
hi ok thanks ! shane

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