{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["USER GUIDE","DATA","RESULT"],"not_rendered":{"images":10,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"USER GUIDE","index":0,"n_rows":74,"n_cols":20,"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":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.1"]
[]
[null,"STEP 1:"]
[]
[null,"Go to MT5 History tab, sort entry time column from old to new, right click, click report and select HTML (Internet Explorer)"]
{"$rows_empty":10}
[null,"STEP 2:"]
[null,"Select All (Ctrl+A) and copy all data (Ctrl+C)"]
{"$rows_empty":12}
[null,"STEP 3:"]
[null,"Select DATA sheet, paste as value in the highligted cell, and click GENERATE"]
{"$rows_empty":13}
[null,"STEP 4:"]
[null,"Click COPY from RESULT sheet."]
{"$rows_empty":12}
[null,"STEP 5:"]
[null,"Paste your trade data in your Trading Journal."]
{"$rows_empty":10}
[null,"You can check out the sample of our trading journal below, contact us or visit our website for more info."]

{"sheet":"DATA","index":1,"n_rows":1,"n_cols":1,"rows_kept":1}
["PASTE DATA HERE : ***Right Click and PASTE AS VALUE or MATCH DESTINATION FORMAT***"]

{"sheet":"RESULT","index":2,"n_rows":98,"n_cols":40,"rows_kept":98}
[1,null,{"$f":"INDEX(DATA!C:C,MATCH(\"balance:\",DATA!A:A,0))","v":{"$error":"#N/A"}},null,{"$f":"VALUE(SUBSTITUTE(C1,\" \",\"\"))","v":{"$error":"#N/A"}},{"$f":"IF(F2<8,8,F2)","v":8},{"$f":"IF((COUNT(RESULT!V:V)+5)<6,6,COUNT(RESULT!V:V)+5)","v":6},{"$f":"IFERROR(MATCH(\"Type\",DATA!D12:D99999,0)+11,12)","v":12},{"$f":"MIN(H1,F1)","v":8},{"$nulls":12},"Developed by rocketsheets.com, Forex MT5 Account Statement Converter v.1.6 (MT5AS)",{"$nulls":11},{"$f":"\"S\"&COUNT(V:V)+5","v":"S5"}]
[2,null,{"$f":"INDEX(DATA!C:C,MATCH(\"closed trade p/l:\",DATA!A:A,0))","v":{"$error":"#N/A"}},null,{"$f":"VALUE(SUBSTITUTE(C2,\" \",\"\"))","v":{"$error":"#N/A"}},{"$f":"COUNTA(DATA!A:A)","v":1},{"$f":"IFERROR(MATCH(\"direction\",DATA!E:E,0),F2)","v":1},null,"trade data rows"]
[3,{"$nulls":4},"total data rows",{"$f":"IFERROR(MATCH(\"deals\",DATA!A:A,0),F2)","v":1}]
[4]
[5,{"$f":"IF(OR(DATA!J5=\"\",COUNT(TRIM(DATA!J5))=0),\"\",IF(OR(DATA!D5=\"buy\",DATA!D5=\"sell\"),A5,\"\"))","v":""},"Open Time","type","SYMBOLE","Item","Price","S / L","T / P","Close Time","Price","Fees","Profit","deposit date","Open Time",{"$nulls":3},"IN Category","Sort Date Entry",null,"OPEN TIME","TYPE","SIZE","ITEM","ENTRY PRICE","S / L","T / P","CLOSE TIME","EXIT PRICE","TOTAL FEES","PROFIT / LOSS"]
[6,{"$f":"IF(OR(DATA!J6=\"\",COUNT(TRIM(DATA!J6))=0),\"\",IF(OR(DATA!D6=\"buy\",DATA!D6=\"sell\"),A6,\"\"))","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(DATA!A6,\".\",\"/\")),\"\")","v":""},{"$f":"UPPER(DATA!D6)","v":""},{"$f":"UPPER(DATA!C6)","v":""},{"$f":"IFERROR(VALUE(TEXT(DATA!E6,\"#0.00\")),DATA!E6)","v":0},{"$f":"IF(DATA!F6=\"\",0,VALUE(SUBSTITUTE(DATA!F6,\" \",\"\")))","v":0},{"$f":"IF(DATA!G6=\"\",\"\",VALUE(SUBSTITUTE(DATA!G6,\" \",\"\")))","v":""},{"$f":"IF(DATA!H6=\"\",\"\",VALUE(SUBSTITUTE(DATA!H6,\" \",\"\")))","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(DATA!I6,\".\",\"/\")),\"\")","v":""},{"$f":"IF(DATA!J6=\"\",0,VALUE(SUBSTITUTE(DATA!J6,\" \",\"\")))","v":0},{"$f":"IFERROR(IF(DATA!F6=\"\",\"\",DATA!K6+DATA!L6),\"cancel\")","v":""},{"$f":"IF(N6=\"\",VALUE(SUBSTITUTE(DATA!M6,\" \",\"\")),VALUE(SUBSTITUTE(DATA!L6,\" \",\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(D6=\"BALANCE\",D6=\"credit\"),C6+(ROW()/100000),\"\")","v":""},{"$f":"IFERROR(INDEX(C:C,MATCH($Q6,RESULT!$B:$B,0))+P6,\"\")","v":""},1E-8,{"$f":"IF(SMALL(RESULT!B:B,RESULT!A1)>$H$1,\"\",SMALL(RESULT!B:B,RESULT!A1))","v":{"$error":"#NUM!"}},null,{"$f":"COUNTIF($U$6:U6,\"IN\")","v":1},{"$f":"SMALL(N:O,RESULT!A1)","v":{"$error":"#NUM!"}},{"$f":"IFERROR(INDEX(Q:Q,MATCH(T6,O:O,0)),\"IN\")","v":"IN"},{"$f":"IFERROR(IFERROR(INDEX(RESULT!C:C,MATCH(RESULT!$U6,$B:$B,0)),SMALL(AN:AN,S6)),\"\")","v":""},{"$f":"IFERROR(INDEX(RESULT!D:D,MATCH(RESULT!$U6,$B:$B,0)),IF(V6=\"\",\"\",IF(AF6>0,\"IN\",\"OUT\")))","v":""},{"$f":"IFERROR(INDEX(RESULT!F:F,MATCH(RESULT!$U6,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(RESULT!E:E,MATCH(RESULT!$U6,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(RESULT!G:G,MATCH(RESULT!$U6,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(RESULT!H:H,MATCH(RESULT!$U6,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(RESULT!I:I,MATCH(RESULT!$U6,$B:$B,0)),\"\")","v":""},{"$f":"IF(Y6=\"\",V6,IFERROR(INDEX(RESULT!J:J,MATCH(RESULT!$U6,$B:$B,0)),V6))","v":""},{"$f":"IFERROR(INDEX(RESULT!K:K,MATCH(RESULT!$U6,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(RESULT!L:L,MATCH(RESULT!$U6,$B:$B,0)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IFERROR(VALUE(INDEX(RESULT!M:M,MATCH(RESULT!$U6,$B:$B,0))),INDEX(M:M,MATCH(V6,N:N,0))),\"\")","v":""},{"$nulls":7},{"$f":"IFERROR(SMALL(N:N,A1),\"\")","v":""}]
[{"$f":"A6+1","v":7},{"$f":"IF(OR(DATA!J7=\"\",COUNT(TRIM(DATA!J7))=0),\"\",IF(OR(DATA!D7=\"buy\",DATA!D7=\"sell\"),A7,\"\"))","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(DATA!A7,\".\",\"/\")),\"\")","v":""},{"$f":"UPPER(DATA!D7)","v":""},{"$f":"UPPER(DATA!C7)","v":""},{"$f":"IFERROR(VALUE(TEXT(DATA!E7,\"#0.00\")),DATA!E7)","v":0},{"$f":"IF(DATA!F7=\"\",0,VALUE(SUBSTITUTE(DATA!F7,\" \",\"\")))","v":0},{"$f":"IF(DATA!G7=\"\",\"\",VALUE(SUBSTITUTE(DATA!G7,\" \",\"\")))","v":""},{"$f":"IF(DATA!H7=\"\",\"\",VALUE(SUBSTITUTE(DATA!H7,\" \",\"\")))","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(DATA!I7,\".\",\"/\")),\"\")","v":""},{"$f":"IF(DATA!J7=\"\",0,VALUE(SUBSTITUTE(DATA!J7,\" \",\"\")))","v":0},{"$f":"IFERROR(IF(DATA!F7=\"\",\"\",DATA!K7+DATA!L7),\"cancel\")","v":""},{"$f":"IF(N7=\"\",VALUE(SUBSTITUTE(DATA!M7,\" \",\"\")),VALUE(SUBSTITUTE(DATA!L7,\" \",\"\")))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(D7=\"BALANCE\",D7=\"credit\"),C7+(ROW()/100000),\"\")","v":""},{"$f":"IFERROR(INDEX(C:C,MATCH($Q7,RESULT!$B:$B,0))+P7,\"\")","v":""},{"$f":"P6+0.00000001","v":2E-8},{"$f":"IF(SMALL(RESULT!B:B,RESULT!A2)>$H$1,\"\",SMALL(RESULT!B:B,RESULT!A2))","v":{"$error":"#NUM!"}},null,{"$f":"COUNTIF($U$6:U7,\"IN\")","v":2},{"$f":"SMALL(N:O,RESULT!A2)","v":{"$error":"#NUM!"}},{"$f":"IFERROR(INDEX(Q:Q,MATCH(T7,O:O,0)),\"IN\")","v":"IN"},{"$f":"IFERROR(IFERROR(INDEX(RESULT!C:C,MATCH(RESULT!$U7,$B:$B,0)),SMALL(AN:AN,S7)),\"\")","v":""},{"$f":"IFERROR(INDEX(RESULT!D:D,MATCH(RESULT!$U7,$B:$B,0)),IF(V7=\"\",\"\",IF(AF7>0,\"IN\",\"OUT\")))","v":""},{"$f":"IFERROR(INDEX(RESULT!F:F,MATCH(RESULT!$U7,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(RESULT!E:E,MATCH(RESULT!$U7,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(RESULT!G:G,MATCH(RESULT!$U7,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(RESULT!H:H,MATCH(RESULT!$U7,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(RESULT!I:I,MATCH(RESULT!$U7,$B:$B,0)),\"\")","v":""},{"$f":"IF(Y7=\"\",V7,IFERROR(INDEX(RESULT!J:J,MATCH(RESULT!$U7,$B:$B,0)),V7))","v":""},{"$f":"IFERROR(INDEX(RESULT!K:K,MATCH(RESULT!$U7,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(RESULT!L:L,MATCH(RESULT!$U7,$B:$B,0)),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IFERROR(VALUE(INDEX(RESULT!M:M,MATCH(RESULT!$U7,$B:$B,0))),INDEX(M:M,MATCH(V7,N:N,0))),\"\")","v":""},{"$nulls":7},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},{"$f":"IFERROR(SMALL(N:N,A33),\"\")","v":""}]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},{"$f":"IFERROR(SMALL(N:N,A65),\"\")","v":""}]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]
[{"$nulls":39},""]