Login Page - Create Account

Support Board


Date/Time: Thu, 19 Sep 2024 23:50:09 +0000



Post From: link sierra spreadsheet to external excel

[2014-06-01 20:23:51]
Sawtooth - Posts: 4091
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