If you are new to Sierra Chart’s spreadsheet studies, here are some tips to avoid confusion:
1) When you add a spreadsheet study to a chart, always give it a name in the Spreadsheet Name field.
-If you don’t give it a name, the default name will be DefaultSpreadsheetStudy and this name will be used again as the default when subsequently adding any of the 3 spreadsheet studies.
2) Spreadsheet studies will by default use sheet numbers (tab positions) relative to the chart number, so ignore any blank sheets.
-For example, if you add a spreadsheet study to chart 11, sheets 1-10 will be blank.
3) You can use the same-named spreadsheet study on all charts in a chartbook, but limit it to the same chart region for all charts.
-You could set the Chart Region separately on each but, to avoid confusion, add a different-named spreadsheet study for each Chart Region.
4) Don’t change the default settings of the Chart Data Output Sheet Number and the Formula Source Sheet Number.
-These are handy options but for now accept the default sheet#/tab position, and manually copy formulas to other sheets.
5) Don’t use the same-named spreadsheet study in more than one chartbook.
-It won’t prevent you from doing this, but if you have both chartbooks open concurrently, they can get into a recalculation loop.
6) Don’t manually add sheets to a spreadsheet study’s workbook.
-It won’t prevent you from doing this, but if you add this same-named spreadsheet study to a chart in the chartbook whose chart number corresponds to your added sheet#, its output will overwrite the entire sheet.
7) If you add studies to your chart after you have added a spreadsheet study, be sure put them at the bottom of the Studies to Graph list.
-Study outputs appear in columns AA and above (or up to column BS and above in v990) in the order they occur in the Studies to Graph list. If your formulas reference any of these columns and a study is added, removed, or repositioned in the list, you will have to edit those formulas to reference the new column.
8) Don’t change the setting of the Number Of Formula Columns (in v947) after you have entered formulas.
-Study outputs appear in columns AA and above (or up to column BS and above in v990) in the order they occur in the Studies to Graph list. If your formulas reference any of these columns you will have to edit them to reference the new column.