Login Page - Create Account

Support Board


Date/Time: Mon, 20 May 2024 14:53:56 +0000



Post From: Understanding Spreadsheets Behavior - Saving and Applying to New Chart

[2017-05-16 15:40:33]
User930315 - Posts: 55
I'm having trouble figuring out how to save and apply a modified Spreadsheet System for Trading to a new chart.

I started with the Spreadsheet System for Trading and made a significant amount of changes in allowed fields and renamed it Autotrading.scss. It was part of a 5 chart chartbook and the modifications were made on Sheet5. The other sheets were not modified.

I would like to be able to add this modified spreadsheet study to any chart, independent of other charts in the chartbook and have not figured out how to do this. No matter what I've tried the study always opens on Sheet5. I would like to have a completely separate copy of the study running on Sheet2, for instance.

After searching the Support Board and documentation I've changed the setting for the Chart Data Output Sheet Number to "0" and saved the two studies on my chart as Study Collection, but when I apply it to a new chart (say chart #2) my formulas open in Sheet 5 even if chart #5 does not exist.

Nor do get the desired behavior when I manually apply the modified spreadsheet, make changes to the settings and then add the 2nd study to the chart.

How do I get all formulas originally entered in Sheet5 to open on the same sheet number as a different chart (or to be applied to the correct sheet number) when I try to apply the spreadsheet to a new chart? Is it possible to do this?

Any hints/guidance would be appreciated.
Date Time Of Last Edit: 2017-05-16 18:39:14