{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","GE Stock Prices","Pic"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":1,"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":"Cover","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[7,1,8,2]]}
[]
[]
[null,"Excel Magic Trick 1546"]
[null,"Get Previous Row?"]
[null,"Power Query"]
[null,null,null,null,"Change in Stock Price Formula"]
[]
[null,"M Code Lookup"]
[]
[]
[]
[]
[]
[]
[null,"Excel Magic Trick 1546: Power Query Get Previous Row? Stock Price Change Formula. M Code Lookup"]
[null,{"$f":"LEN(B15)","v":95}]

{"sheet":"GE Stock Prices","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Date","GE Close","Difference",null,"Power Query Two-Way Lookup:"]
["2019-03-08",9.58,{"$f":"IF(ROWS(C$2:C2)=1,\"\",B2-B1)","v":""},null,"Syntax:"]
["2019-03-11",9.9,{"$f":"IF(ROWS(C$2:C3)=1,\"\",B3-B2)","v":0.32000000000000028},null,"Power Query is base 0"]
["2019-03-12",9.76,{"$f":"IF(ROWS(C$2:C4)=1,\"\",B4-B3)","v":-0.14000000000000057},null,"Two-Way Lookup: TableName{RowIndexNumber}[Column Name]"]
["2019-03-13",10.02,{"$f":"IF(ROWS(C$2:C5)=1,\"\",B5-B4)","v":0.25999999999999979},null,"Two-Way Lookup: TableName{[Lookup Operator]}[Column Name]"]
["2019-03-14",10.3,{"$f":"IF(ROWS(C$2:C6)=1,\"\",B6-B5)","v":0.28000000000000114},null,"Formula we use: AddedIndex{[Index]}[GEClose]"]
["2019-03-15",9.9600000000000009,{"$f":"IF(ROWS(C$2:C7)=1,\"\",B7-B6)","v":-0.33999999999999986},null,null,null,"AddedIndex = Full Table with Columns and Rows"]
["2019-03-18",10.199999999999999,{"$f":"IF(ROWS(C$2:C8)=1,\"\",B8-B7)","v":0.23999999999999844},null,null,null,"{ } = Positional Index Operator"]
["2019-03-19",10.19,{"$f":"IF(ROWS(C$2:C9)=1,\"\",B9-B8)","v":-9.9999999999997868E-3},null,null,null,"[Index] = Lookup Operator"]
["2019-03-20",10.220000000000001,{"$f":"IF(ROWS(C$2:C10)=1,\"\",B10-B9)","v":3.0000000000001137E-2},null,null,null,"[GEClose] = Field Access Operator"]
["2019-03-21",10.27,{"$f":"IF(ROWS(C$2:C11)=1,\"\",B11-B10)","v":4.9999999999998934E-2}]
["2019-03-22",9.98,{"$f":"IF(ROWS(C$2:C12)=1,\"\",B12-B11)","v":-0.28999999999999915},null,"Full Formula for Change in Stock Price From Previous Day:"]
["2019-03-25",9.8800000000000008,{"$f":"IF(ROWS(C$2:C13)=1,\"\",B13-B12)","v":-9.9999999999999645E-2},null," = Table.AddColumn(AddedIndex, \"ChangeInPrice\", each if [Index] = - 1 then null else "]
["2019-03-26",10.1,{"$f":"IF(ROWS(C$2:C14)=1,\"\",B14-B13)","v":0.21999999999999886},null,null,"[GEClose]-AddedIndex{[Index]}[GEClose]"]
["2019-03-27",9.9600000000000009,{"$f":"IF(ROWS(C$2:C15)=1,\"\",B15-B14)","v":-0.13999999999999879},null,null,")"]
["2019-03-28",9.89,{"$f":"IF(ROWS(C$2:C16)=1,\"\",B16-B15)","v":-7.0000000000000284E-2}]
["2019-03-29",9.99,{"$f":"IF(ROWS(C$2:C17)=1,\"\",B17-B16)","v":9.9999999999999645E-2}]
["2019-04-01",10.1,{"$f":"IF(ROWS(C$2:C18)=1,\"\",B18-B17)","v":0.10999999999999943}]
["2019-04-02",10.24,{"$f":"IF(ROWS(C$2:C19)=1,\"\",B19-B18)","v":0.14000000000000057}]
["2019-04-03",10.1,{"$f":"IF(ROWS(C$2:C20)=1,\"\",B20-B19)","v":-0.14000000000000057}]
["2019-04-04",10.029999999999999,{"$f":"IF(ROWS(C$2:C21)=1,\"\",B21-B20)","v":-7.0000000000000284E-2}]
["2019-04-08",9.49,{"$f":"IF(ROWS(C$2:C22)=1,\"\",B22-B21)","v":-0.53999999999999915}]

{"sheet":"Pic","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Power Query Two-Way Lookup:"]
[null,null,null,null,"Syntax:"]
[null,null,null,null,"Power Query is base 0"]
[null,null,null,null,"Two-Way Lookup: TableName{RowIndexNumber}[Column Name]"]
[null,null,null,null,"Two-Way Lookup: TableName{[Lookup Operator]}[Column Name]"]
[null,null,null,null,"Formula we use: AddedIndex{[Index]}[GEClose]"]
[null,null,null,null,null,null,"AddedIndex = Full Table with Columns and Rows"]
[null,null,null,null,null,null,"{ } = Positional Index Operator"]
[null,null,null,null,null,null,"[Index] = Lookup Operator"]
[null,null,null,null,null,null,"[GEClose] = Field Access Operator"]
[]
[null,null,null,null,"Full Formula for Change in Stock Price From Previous Day:"]
[null,null,null,null," = Table.AddColumn(AddedIndex, \"ChangeInPrice\", each if [Index] = - 1 then null else "]
[null,null,null,null,null,"[GEClose]-AddedIndex{[Index]}[GEClose]"]
[null,null,null,null,null,")"]