Support Board

Date/Time: Tue, 30 Apr 2024 19:00:38 +0000

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

[2014-05-05 01:01:10] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3986
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