Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 13:49:02 +0000



Post From: How to Plot Calculated Data from Spreadsheet and...

[2014-05-05 01:01:10]
Sawtooth - Posts: 4120
The same-named spreadsheet study can be used on all charts in a chartbook, even if some charts are detached to other monitors. Spreadsheets are not detachable to other monitors.

You can use the standalone spreadsheets for derived data instead of a spare sheet on the spreadsheet study's spreadsheet. You can reference that standalone spreadsheet from spreadsheet study spreadsheets and vice versa.
Go to File >> New Spreadsheet. If it already exists, File >> Open Spreadsheet.

You can use the Chart Data Output Sheet Number and Formula Source Sheet Number settings to disassociate the sheet number from the chart number. The use of these settings can get confusing if your system is complex, so be careful.
http://www.sierrachart.com/index.php?l=doc/doc_WorksheetStudyInputs.html