Login Page - Create Account

Support Board


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



Post From: TROUBLE WITH SPREADSHEET TRADING

[2016-08-16 16:11:42]
Sawtooth - Posts: 4214
What SC version were you using on your old computer?
Were you using Old Spreadsheets on your old computer? They have a .scwbf extension. New Spreadsheets have a .scss extension.

Old Spreadsheets are not supported in versions later than 1310.
The auto-conversion from Old to New spreadsheets works in most cases, but not all.
Your original formula should work in the New Spreadsheets, if you didn't change any studies in the Studies to Graph list.

New Spreadsheets output 1/0 instead of TRUE/FALSE

You can use both the ID#.SG#@# format or the original alpha-column format.

There are two advantages to using the ID#.SG#@# format:
1) You can rearrange studies in the Studies to Graph list without messing up your formulas.
2) You can insert/delete columns without messing up your formulas (if you have enough spare Formula Columns before you insert).
Suggestion: Use the ID#.SG#@# format when referencing study outputs, and use the alpha column format when referencing columns A-G and Formula Columns.