Login Page - Create Account

Support Board


Date/Time: Sat, 10 May 2025 22:20:10 +0000



Post From: Auto trading with the new Spreadsheet System

[2015-03-12 22:43:47]
Sawtooth - Posts: 4214
Assuming your formulas use functions supported by the New Spreadsheet, it will work in the New Spreadsheets if you use the same-named spreadsheet file on all the charts in the same chartbook. Each chart will appear on its own Sheet#. Reference other sheets like this: =Sheet2!D3

Other things to consider:
-When referencing text, the New Spreadsheets are case-sensitive.
-The New Spreadsheets do not support:
--referencing separate spreadsheet file names.
--circular referencing that the Old Spreadsheets used to lock a TRUE condition.
--conditional formatting and cell borders. They only support basic text and background coloring.
--password protection of workbook structure.