{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["USER GUIDE","CONVERTER","Sheet1"],"not_rendered":{"images":13,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"USER GUIDE","index":0,"n_rows":74,"n_cols":36,"rows_kept":74,"merged":[[1,1,3,3]]}
[]
[null,"User Guide",{"$nulls":3},"Important Note:",null,"Please enable macro to use this file.",{"$nulls":4},"To enable macro:",{"$nulls":22},{"$f":"IF((COUNT(X:X)+1)<2,\"\",(COUNT(X:X)+1))","v":""}]
[{"$nulls":5},"To view the Developer tab:",{"$nulls":6},"Go to Developer tab>>Macro Security>>Enable All Macro>>OK"]
[{"$nulls":5},"Go to File>>Options>>Customize Ribbon>>Check Developer>>OK",{"$nulls":6},">>Save>>Close the file>>Re-open the file",{"$nulls":6},"V.0"]
[]
[null,"STEP 1:"]
[]
[null,"Download your TradeHistory csv file from your broker."]
{"$rows_empty":10}
[null,"STEP 2:"]
[null,"Go to \"CONVERTER\" sheet and click \"SELECT SOURCE FILE\", locate the file, and click OK"]
{"$rows_empty":15}
[null,"STEP 3:"]
[null,"Click COPY from CONVERTER sheet."]
{"$rows_empty":11}
[null,"STEP 4:"]
[null,"Paste your trade data in your Trading Journal"]
{"$rows_empty":23}
[null,"You can check out the sample of our trading journal at rocketsheets.com, contact us or visit our website for more info."]

{"sheet":"CONVERTER","index":1,"n_rows":7,"n_cols":42,"rows_kept":7}
[{"$nulls":5},{"$f":"COUNT(Sheet1!B:B)+1","v":1},{"$f":"IF(COUNT(AA:AA)+5<6,6,COUNT(AA:AA)+5)","v":6},null,{"$f":"\"u\"&COUNT(AA:AA)+5","v":"u5"},{"$nulls":17},"Developed by rocketsheets.com, TradeZero Ledger Converter v.0"]
[{"$nulls":5},{"$f":"C6+F3+4","v":4}]
[{"$nulls":5},{"$f":"COUNTIF(Sheet1!A:A,\"trades\")","v":0},{"$nulls":26},"D:\\00-SPREADSHEET\\02 - FREE EXCELS PRODUCTS\\21-Trade Zero\\Version 00\\04 - Sample Ledger\\sample ledger\\TradeHistory20201007053105.csv"]
[{"$nulls":32},"TradeHistory20201007053105.csv"]
[null,"No.","match","Date/Time",null,null,"date","symbol","quantity","T. Price","quantity","Comm/Fee","unique","matach","basis","Code",{"$nulls":5},"combine","stock","action","price","shares","DATE","STOCK","ACTION","PRICE","SHARES","FEES",{"$f":"LEFT(AG4,LEN(AG4)-4)","v":"TradeHistory20201007053105"},{"$nulls":7},"28/04/20",{"$f":"VALUE(AO5)","v":{"$error":"#VALUE!"}}]
[null,1,null,null,{"$f":"IF(V6=1,B6,\"\")","v":""},null,{"$f":"Sheet1!B2+Sheet1!J2","v":"00:00:00"},{"$nulls":4},{"$f":"SUM(Sheet1!K2:Q2)","v":0},{"v":1e-05,"d":"0.00001"},null,null,{"$f":"Sheet1!F2","v":0},{"$nulls":6},{"$f":"Sheet1!G2","v":0},{"$f":"IF(P6=0,\"\",IF(P6=\"B\",\"BUY\",IF(P6=\"S\",\"SELL\",IF(P6=\"SS\",\"SHORT\",\"COVER\"))))","v":""},{"$f":"Sheet1!I2","v":0},{"$f":"Sheet1!H2","v":0},{"$f":"IF(AND(COUNT(G6)=1,G6<>0),G6,\"\")","v":""},{"$f":"IFERROR(W6,\"\")","v":0},{"$f":"IFERROR(X6,\"\")","v":""},{"$f":"IFERROR(Y6,\"\")","v":{"v":0,"d":"0.000"}},{"$f":"IFERROR(Z6,\"\")","v":0},{"$f":"IFERROR(L6,\"\")","v":0}]
[null,{"$f":"B6+1","v":2},null,null,{"$f":"IF(V7=1,B7,\"\")","v":""},null,{"$f":"Sheet1!B3+Sheet1!J3","v":"00:00:00"},{"$nulls":4},{"$f":"SUM(Sheet1!K3:Q3)","v":0},{"$f":"M6+0.00001","v":{"v":2e-05,"d":"0.00002"}},null,null,{"$f":"Sheet1!F3","v":0},{"$nulls":6},{"$f":"Sheet1!G3","v":0},{"$f":"IF(P7=0,\"\",IF(P7=\"B\",\"BUY\",IF(P7=\"S\",\"SELL\",IF(P7=\"SS\",\"SHORT\",\"COVER\"))))","v":""},{"$f":"Sheet1!I3","v":0},{"$f":"Sheet1!H3","v":0},{"$f":"IF(AND(COUNT(G7)=1,G7<>0),G7,\"\")","v":""},{"$f":"IFERROR(W7,\"\")","v":0},{"$f":"IFERROR(X7,\"\")","v":""},{"$f":"IFERROR(Y7,\"\")","v":{"v":0,"d":"0.000"}},{"$f":"IFERROR(Z7,\"\")","v":0},{"$f":"IFERROR(L7,\"\")","v":0}]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}