Support Board
Date/Time: Tue, 26 Nov 2024 20:14:50 +0000
Post From: link sierra spreadsheet to external excel
[2014-06-01 20:23:51] |
Sawtooth - Posts: 4120 |
I've never tried this but... The Spreadsheet System for Trading study does not have the option to Use Excel, but the Spreadsheet Study study does. Add this to the chart, and it will create a new .xls from where you should be able to use VBA, and then reference the cell from the Spreadsheet System for Trading study's spreadsheet. Two things that may mitigate its proper functionality: -The reason Use Excel is not available in the Spreadsheet System for Trading: Excel to Spreadsheets -The use of external Excel sheets is allowed but if there are any issues, it is not supported. http://www.sierrachart.com/index.php?l=doc/doc_WorksheetStudyInputs.html#UseExcel Date Time Of Last Edit: 2014-06-01 20:55:52
|