{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Stock","Ticker","Trade Date","Buy/Sell","Price","Fees","Quantity","Total Cost","Current Price","Gross Current Value","Today's Return","Total Return","Market Value","Open","High","Low","Previous Close"]
[{"$error":"#VALUE!"},{"$f":"_FV(A2,\"Ticker symbol\",TRUE)","v":"BX"},"2019-08-27","B",49.012999999999998,6.95,1,{"$f":"E2*G2","v":49.012999999999998},{"$f":"_FV(A2,\"Price\")","v":62.39},{"$f":"G2*I2","v":62.39},{"$f":"IF(D2=\"B\",(I2-N2)*G2,IF(D2=\"S\",0,(I2-N2)*G2))","v":-0.43999999999999773},{"$f":"(I2-E2)*G2","v":13.377000000000002},{"$f":"I2*G2","v":62.39},{"$f":"_FV(A2,\"Open\")","v":62.83},{"$f":"_FV(A2,\"High\")","v":62.83},{"$f":"_FV(A2,\"Low\")","v":61.29},{"$f":"_FV(A2,\"Previous close\",TRUE)","v":62.45}]
[{"$error":"#VALUE!"},{"$f":"_FV(A3,\"Ticker symbol\",TRUE)","v":"BX"},"2019-09-11","S",50.65,6.95,1,{"$f":"E3*G3","v":50.65},{"$f":"_FV(A3,\"Price\")","v":62.39},{"$f":"G3*I3","v":62.39},{"$f":"IF(D3=\"B\",(I3-N3)*G3,IF(D3=\"S\",0,(I3-N3)*G3))","v":0},{"$f":"(I3-E3)*G3","v":11.740000000000002},{"$f":"I3*G3","v":62.39},{"$f":"_FV(A3,\"Open\")","v":62.83},{"$f":"_FV(A3,\"High\")","v":62.83},{"$f":"_FV(A3,\"Low\")","v":61.29},{"$f":"_FV(A3,\"Previous close\",TRUE)","v":62.45}]
[{"$error":"#VALUE!"},{"$f":"_FV(A4,\"Ticker symbol\",TRUE)","v":"SAND"},"2020-07-14","B",9.4,0,25,{"$f":"E4*G4","v":235},{"$f":"_FV(A4,\"Price\")","v":7.28},{"$f":"G4*I4","v":182},{"$f":"(I4-N4)*G4","v":-5.4999999999999938},{"$f":"(I4-E4)*G4","v":-53},{"$f":"I4*G4","v":182},{"$f":"_FV(A4,\"Open\")","v":7.5},{"$f":"_FV(A4,\"High\")","v":7.52},{"$f":"_FV(A4,\"Low\")","v":7.16},{"$f":"_FV(A4,\"Previous close\",TRUE)","v":7.61}]
[{"$error":"#VALUE!"},{"$f":"_FV(A5,\"Ticker symbol\",TRUE)","v":"BABA"},"2020-07-15","B",264.35000000000002,0,1,{"$f":"E5*G5","v":264.35000000000002},{"$f":"_FV(A5,\"Price\")","v":263.8},263.8,{"$f":"(I5-N5)*G5","v":-3.7599999999999909},{"$f":"(I5-E5)*G5","v":-0.55000000000001137},{"$f":"I5*G5","v":263.8},{"$f":"_FV(A5,\"Open\")","v":267.56},{"$f":"_FV(A5,\"High\")","v":267.91000000000003},{"$f":"_FV(A5,\"Low\")","v":263.10000000000002},{"$f":"_FV(A5,\"Previous close\",TRUE)","v":266.08999999999997}]
[{"$error":"#VALUE!"},{"$f":"_FV(A6,\"Ticker symbol\",TRUE)","v":"BEAM"},"2020-11-25","B",41.48,0,3,{"$f":"E6*G6","v":124.44},{"$f":"_FV(A6,\"Price\")","v":72.84},218.52,{"$f":"(I6-N6)*G6","v":6.6300000000000239},{"$f":"(I6-E6)*G6","v":94.080000000000013},{"$f":"I6*G6","v":218.52},{"$f":"_FV(A6,\"Open\")","v":70.63},{"$f":"_FV(A6,\"High\")","v":74.58},{"$f":"_FV(A6,\"Low\")","v":68.89},{"$f":"_FV(A6,\"Previous close\",TRUE)","v":75.260000000000005}]
[{"$error":"#VALUE!"},{"$f":"_FV(A7,\"Ticker symbol\",TRUE)","v":"BEAM"},"2020-12-07","B",68.209999999999994,0,4,{"$f":"E7*G7","v":272.83999999999997},{"$f":"_FV(A7,\"Price\")","v":72.84},291.36,8.8400000000000318,18.520000000000039,291.36,{"$f":"_FV(A7,\"Open\")","v":70.63},{"$f":"_FV(A7,\"High\")","v":74.58},{"$f":"_FV(A7,\"Low\")","v":68.89},{"$f":"_FV(A7,\"Previous close\",TRUE)","v":75.260000000000005}]
[{"$error":"#VALUE!"},{"$f":"_FV(A8,\"Ticker symbol\",TRUE)","v":"SAND"},"2020-08-17","S",9.2200000000000006,0,25,{"$f":"E8*G8","v":230.50000000000003},{"$f":"_FV(A8,\"Price\")","v":7.28},{"$f":"G8*I8","v":182},{"$f":"(I8-N8)*G8","v":-5.4999999999999938},{"$f":"(I8-E8)*G8","v":-48.500000000000007},{"$f":"I8*G8","v":182},{"$f":"_FV(A8,\"Open\")","v":7.5},{"$f":"_FV(A8,\"High\")","v":7.52},{"$f":"_FV(A8,\"Low\")","v":7.16},{"$f":"_FV(A8,\"Previous close\",TRUE)","v":7.61}]
[]
[]
[]
[]
[]
[]
[]
[]
["Totals:",null,null,null,null,null,{"$f":"SUM(G2:G16)","v":60},null,null,null,{"$f":"SUM(K2:K16)","v":0.2700000000000804},{"$f":"SUM(L2:L16)","v":35.667000000000037},{"$f":"SUM(M2:M16)","v":1262.46}]