{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["DataSet","1. Mathermatical Formula","2. Alternate Formula","3. SUM Function","4. VBA Macro"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DataSet","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Change of Price in Stocks"]
[]
[null,"Company","Yesterday","Today"]
[null,"PHLX Gold",117.3,110.2]
[null,"CBOE Volatility",22.57,21.83]
[null,"KBW Bank ",106.82,118.2]
[null,"Alerian MLP",225.41,230.45]

{"sheet":"1. Mathermatical Formula","index":1,"n_rows":9,"n_cols":23,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Use of Mathematical Formula",null,null,null,null,null,"Practise Yourself"]
[]
[null,"Company","Yesterday","Today","% Change",null,null,"Company","Yesterday","Today","% Change"]
[null,"PHLX Gold",117.3,110.2,{"$f":"(D5-C5)/C5","v":-6.0528559249786826E-2},null,null,"PHLX Gold",117.3,110.2]
[null,"CBOE Volatility",22.57,21.83,{"$f":"(D6-C6)/C6","v":-3.2786885245901724E-2},null,null,"CBOE Volatility",22.57,21.83]
[null,"KBW Bank ",106.82,118.2,0.10653435686201096,null,null,"KBW Bank ",106.82,118.2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(D6-C6)/C6","v":-3.2786885245901724E-2}]
[null,"Alerian MLP",225.41,230.45,2.2359256465995264E-2,null,null,"Alerian MLP",225.41,230.45,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(D7-C7)/C7","v":0.10653435686201096}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(D8-C8)/C8","v":2.2359256465995264E-2}]

{"sheet":"2. Alternate Formula","index":2,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Use of Alternative Mathematical Formula",null,null,null,null,null,"Practise Yourself"]
[]
[null,"Company","Yesterday","Today","% Change",null,null,"Company","Yesterday","Today","% Change"]
[null,"PHLX Gold",117.3,110.2,{"$f":"(D5/C5)-1","v":-6.052855924978684E-2},null,null,"PHLX Gold",117.3,110.2]
[null,"CBOE Volatility",22.57,21.83,{"$f":"(D6/C6)-1","v":-3.2786885245901676E-2},null,null,"CBOE Volatility",22.57,21.83]
[null,"KBW Bank ",106.82,118.2,{"$f":"(D7/C7)-1","v":0.10653435686201096},null,null,"KBW Bank ",106.82,118.2]
[null,"Alerian MLP",225.41,230.45,{"$f":"(D8/C8)-1","v":2.2359256465995347E-2},null,null,"Alerian MLP",225.41,230.45]

{"sheet":"3. SUM Function","index":3,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Use of SUM Function",null,null,null,null,null,"Practise Yourself"]
[]
[null,"Company","Yesterday","Today","% Change",null,null,"Company","Yesterday","Today","% Change"]
[null,"PHLX Gold",117.3,110.2,{"$f":"SUM(D5,-C5)/C5*100","v":-6.0528559249786822},null,null,"PHLX Gold",117.3,110.2]
[null,"CBOE Volatility",22.57,21.83,{"$f":"SUM(D6,-C6)/C6*100","v":-3.2786885245901725},null,null,"CBOE Volatility",22.57,21.83]
[null,"KBW Bank ",106.82,118.2,{"$f":"SUM(D7,-C7)/C7*100","v":10.653435686201096},null,null,"KBW Bank ",106.82,118.2]
[null,"Alerian MLP",225.41,230.45,{"$f":"SUM(D8,-C8)/C8*100","v":2.2359256465995263},null,null,"Alerian MLP",225.41,230.45]

{"sheet":"4. VBA Macro","index":4,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Use of VBA Macro",null,null,null,null,null,"Practise Yourself"]
[]
[null,"Company","Yesterday","Today","% Change",null,null,"Company","Yesterday","Today","% Change"]
[null,"PHLX Gold",117.3,110.2,{"$f":"IFERROR((D5 - C5)/C5,0)","v":-6.0528559249786826E-2},null,null,"PHLX Gold",117.3,110.2]
[null,"CBOE Volatility",22.57,21.83,{"$f":"IFERROR((D6 - C6)/C6,0)","v":-3.2786885245901724E-2},null,null,"CBOE Volatility",22.57,21.83]
[null,"KBW Bank ",106.82,118.2,0.10653435686201096,null,null,"KBW Bank ",106.82,118.2]
[null,"Alerian MLP",225.41,230.45,2.2359256465995264E-2,null,null,"Alerian MLP",225.41,230.45]