{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["TRANSACTIONS","LOG","SUMMARY","SETTINGS"],"not_rendered":{"charts":5,"images":6,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":13},"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":"TRANSACTIONS","index":0,"n_rows":3,"n_cols":16,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,1,13]]}
["TRADING TRACKER"]
[]
["ENTRY DATE","TICKER","AVERAGE COST","SHARES","FEES","INVESTMENT TOTAL","SALE VALUE","PROFIT (LOSS)","RETURN %","STRATEGY","EXIT DATE","# OF DAYS HELD","HOLDING CATEGORY","STATUS","SHARES SOLD","INVESTMENT SOLD"]

{"sheet":"LOG","index":1,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DATE","TICKER","ACTION","SHARES","PRICE","FEES","TOTAL VALUE"]

{"sheet":"SUMMARY","index":2,"n_rows":52,"n_cols":22,"rows_kept":52,"cut":false,"hidden":false,"merged":[[48,1,48,3],[48,7,48,18],[8,5,10,15],[24,17,24,22],[25,17,25,22],[18,9,18,10],[11,5,14,14],[16,9,16,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Sum of PROFIT (LOSS)\",SETTINGS!$W$1)","v":500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"totalprofitloss/GETPIVOTDATA(\"INVESTMENT TOTAL\",SETTINGS!$BE$1)","v":0.1}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(F12<0,\"TOTAL LOSS DURING PERIOD\",\"TOTAL PROFIT DURING PERIOD\")","v":"TOTAL PROFIT DURING PERIOD"}]
[]
[]
[null,null,null,null,null,{"$f":"totalprofitloss","v":500}]
[]
[]
[]
[null,null,null,null,null,null,"BEST RETURNS",null,null,null,null,null,"WORST RETURNS"]
[null,null,null,null,null,null,null,"RETURN % ",null,{"$f":"IFERROR(totalreturn,\"\")","v":0.1},null,null,null,"RETURN % "]
[null,null,null,null,null,null,"AMZN",0.1,null,null,null,null,"AMZN",0.1]
[null,null,null,null,null,null,null,null,null,"OVERALL RETURN"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fees as a % of Investment Dollars"]
[null,null,null,null,null,null,null,null,"SHOW PROFITS BY:",null,"DAY",null,null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Fees \",SETTINGS!$BD$1)/GETPIVOTDATA(\"Investment Total \",SETTINGS!$BD$1)","v":4.0000000000000001E-3}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"BY TICKER",null,null,null,null,null,"PROFIT/LOSS BY STRATEGY"]
[]
[null,null,null,"PROFIT (LOSS) "]
[null,44896,"AMZN",500]

{"sheet":"SETTINGS","index":3,"n_rows":5,"n_cols":60,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"STRATEGIES",null,"MINIMUM HOLDING PERIOD","HOLDING CATEGORY",null,null,null,null,"STATUS","CLOSED",null,"# OF DAYS HELD","Count of TICKER",null,null,null,"TICKER","Sum of Profit","Sum of Loss","Sum of PROFIT (LOSS)",null,null,null,null,"STATUS","CLOSED",null,null,null,null,null,null,null,null,"STATUS","CLOSED",null,"Sum of PROFIT (LOSS)",null,null,null,"STRATEGY","Sum of INVESTMENT TOTAL",null,null,"HOLDING CATEGORY","Sum of INVESTMENT TOTAL",null,null,"Fees ","Investment Total ",null,null,"Average of # OF DAYS HELD"]
[null,null,null,null,null,null,"Buy and Hold",null,0,"Intraday",null,null,null,null,null,null,null,30,1,null,null,null,"AMZN",500,0,500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,null,null,null,"Buy and Hold",5000,null,null,"Long",5000,null,null,20,5000,null,null,30]
[null,null,null,null,null,null,"Contrarian",null,5,"Short",null,null,null,null,"Sum of PROFIT (LOSS)",null,null,null,null,null,null,null,"Grand Total",500,0,500,null,null,null,null,"EXIT DATE","Profit ","Loss ",null,null,null,null,null,null,null,"STRATEGY","Sum of Profit","Sum of Loss","Sum of PROFIT (LOSS)"]
[null,null,null,null,null,null,"Speculative",null,10,"Medium",null,null,null,null,500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44896,500,0,null,null,null,null,null,null,null,"Buy and Hold",500,0,500]
[null,null,null,null,null,null,null,null,15,"Long",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",500,0,500]