3-session multi-symbol %change since market open

Here is a chartbook/spreadsheet study that will plot up to 15 symbols correlated as a percent change. This spreadsheet will also allow up to 3 start times per 24hrs so, for example, you can reset the line at the start of the London, New York, and Asian sessions, all on one chart.

 Click on each of these links to download:
Pct Chg from Mkt Open.cht
Pct Chg from Mkt Open.scss
and put both files in your Sierra Chart \Data folder, then open the chartbook.

- Chart #1 is the Primary chart.  Chart #2  is a Secondary chart.
- Change the symbols of both charts to your choice.
- On the Subgraphs tab of the '%Chg from Mkt Open' study (ID1) on Chart #1, change the Short Names of each SG#  to match the chosen symbols.
- SG1 is the symbol on the Primary  chart; other SG#s are symbols from Secondary charts.

 The default chartbook has only two symbols. To add an additional symbol:
​
1) Duplicate Chart #2 (the Secondary chart) and change the symbol. The duplicated Chart#/Sheet# will be Chart #3/Sheet3.

2) Focus the new duplicated Secondary chart, press Analysis >> Studies >> choose '%Chg from Mkt Open' (ID1) >> Settings button, and confirm the Formula Source Sheet Number is set to 2. 
-The formulas on Sheet1 are unique to the Primary chart, and its Formula Source Sheet Number is set to 1 . The formulas on Sheet2 and above are all the same, so their   Formula Source Sheet Numbers   are all set to 2,    for all Secondary charts.

3) On the spreadsheet, copy/paste the formula from Sheet1 cell L3 to Sheet1 cell M3, then edit it to reference Sheet3 (=Sheet3!K3). Then label column M with the symbol in cell M2.

4) Focus the Primary chart, press Analysis >> Studies >> choose '%Chg from Mkt Open'  (ID1) ​ >> Settings button >> Subgraphs tab, and set the SG3 Draw Style to Line, choose your color, and enter the symbol in the Short Name field. Press OK and OK.

5) Reload and Recalculate (press Insert) the duplicated chart and the primary chart.

6) To add another symbol, repeat all steps as needed, incrementing the destination column and the referenced sheet# in step 3, and the subgraph Draw Style in step 4.
​
 -You can minimize all charts except the Primary chart, and you can minimize the spreadsheet.
-The 3 market open times are determined by the settings of the 3 Time Line studies on the Primary chart.
-All lines are displayed on the Primary chart via Sheet1’s columns K-Y. This means you can have a max of 15 symbols.

 Version 1c: corrected formulas and chart settings to assure zero start at session change.