Prescott AZ USA
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 216
Thanks Received: 603
|
If your formulas are referencing any 'write' cells in column J, or any cell in column H, those values/formulas are not automatically copied to other sheets when duplicating a chart with a spreadsheet study. Further complicating the issue when duplicating a chart is that the Formula Source Sheet Number in the spreadsheet study's settings does not follow the new chart number (although this could be an advantage depending on how you want to configure the system).
The solution might be as simple as copying J and H formulas/values to all of the other sheets, but one way to keep things straightforward is to set the Formula Source Sheet Number of each spreadsheet study so that it matches the chart number it is applied to. Then copy/paste all of the formulas to each sheet so that there is complete separation between charts and their sheets.
|