{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["USER GUIDE","DATA","RESULT"],"not_rendered":{"images":11,"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.2"]
[]
[null,"STEP 1:"]
[]
[null,"Go to MT4 Account History tab, sort entry time column from old to new, right click and Save as Detailed Report"]
{"$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":7,"n_cols":31,"rows_kept":7}
[1,null,{"$f":"INDEX(DATA!C:C,MATCH(\"balance:\",DATA!A:A,0))","v":{"$error":"#N/A"}},{"$f":"VALUE(SUBSTITUTE(C1,\" \",\"\"))","v":{"$error":"#N/A"}},null,{"$f":"IF(ROUND(COUNTA(DATA!K:K)*1.5,0)<8,8,ROUND(COUNTA(DATA!K:K)*1.5,0))","v":8},{"$f":"IF((COUNT(S:S)+5)<6,6,COUNT(S:S)+5)","v":6},{"$nulls":11},"Developed by AA Excel Spreadsheets, Forex MT4 Account Statement Converter v.0 (MT4AS.v0)",{"$nulls":11},{"$f":"\"S\"&COUNT(S:S)+5","v":"S5"}]
[2,null,{"$f":"INDEX(DATA!C:C,MATCH(\"closed trade p/l:\",DATA!A:A,0))","v":{"$error":"#N/A"}},{"$f":"VALUE(SUBSTITUTE(C2,\" \",\"\"))","v":{"$error":"#N/A"}}]
[3,null,{"$f":"SUMIF(DATA!C:C,\"balance\",DATA!N:N)-E3","v":0},{"$f":"VALUE(SUBSTITUTE(C3,\" \",\"\"))","v":0}]
[4]
[5,null,"Open Time","Type","Size","Item","Price","S / L","T / P","Close Time","Price","Fees","Profit",null,null,"Open Time","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(D6=\"balance\",\"\",IF(AND(DATA!N6<>\"\",DATA!F6=\"\"),A6,IF(OR(DATA!C6=\"buy\",DATA!C6=\"sell\"),A6,\"\")))","v":""},{"$f":"VALUE(SUBSTITUTE(DATA!B6,\".\",\"/\"))","v":{"$error":"#VALUE!"}},{"$f":"UPPER(DATA!C6)","v":""},{"$f":"IF(DATA!F6=\"\",0,DATA!D6)","v":0},{"$f":"UPPER(DATA!E6)","v":""},{"$f":"IF(DATA!F6=\"\",\"\",DATA!F6)","v":""},{"$f":"IF(DATA!G6=\"\",\"\",DATA!G6)","v":""},{"$f":"IF(DATA!H6=\"\",\"\",DATA!H6)","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(DATA!I6,\".\",\"/\")),\"\")","v":""},{"$f":"IF(DATA!J6=\"\",0,DATA!J6)","v":0},{"$f":"IFERROR(IF(DATA!F6=\"\",0,DATA!K6+DATA!L6+DATA!M6),\"cancel\")","v":0},{"$f":"VALUE(SUBSTITUTE(DATA!N6,\" \",\"\"))","v":{"$error":"#VALUE!"}},1E-8,{"$nulls":4},{"$f":"S7","v":""},{"$f":"IF(S6=\"\",\"\",\"IN\")","v":""},{"$nulls":5},{"$f":"S6","v":""},null,null,{"$f":"IFERROR(IF(DATA!C6=\"balance\",M6,D1-(D2+D3)),\"\")","v":""}]
[{"$f":"A6+1","v":7},{"$f":"IF(AND(DATA!N7<>\"\",DATA!F7=\"\"),A7,IF(OR(DATA!C7=\"buy\",DATA!C7=\"sell\"),A7,\"\"))","v":""},{"$f":"VALUE(SUBSTITUTE(DATA!B7,\".\",\"/\"))","v":{"$error":"#VALUE!"}},{"$f":"UPPER(DATA!C7)","v":""},{"$f":"IF(DATA!F7=\"\",0,DATA!D7)","v":0},{"$f":"UPPER(DATA!E7)","v":""},{"$f":"IF(DATA!F7=\"\",0,DATA!F7)","v":0},{"$f":"IF(DATA!G7=\"\",\"\",DATA!G7)","v":""},{"$f":"IF(DATA!H7=\"\",\"\",DATA!H7)","v":""},{"$f":"IFERROR(VALUE(SUBSTITUTE(DATA!I7,\".\",\"/\")),\"\")","v":""},{"$f":"IF(DATA!J7=\"\",0,DATA!J7)","v":0},{"$f":"IFERROR(IF(DATA!F7=\"\",0,DATA!K7+DATA!L7+DATA!M7),\"cancel\")","v":0},{"$f":"VALUE(SUBSTITUTE(DATA!N7,\" \",\"\"))","v":{"$error":"#VALUE!"}},{"$f":"N6+0.00000001","v":2E-8},{"$f":"SMALL(B:B,A1)","v":{"$error":"#NUM!"}},{"$f":"IFERROR(INDEX(C:C,MATCH($O7,$B:$B,0))+N7,\"\")","v":""},{"$f":"SMALL(P:P,A1)","v":{"$error":"#NUM!"}},{"$f":"INDEX(O:O,MATCH(Q7,P:P,0))","v":{"$error":"#NUM!"}},{"$f":"IFERROR(INDEX(C:C,MATCH($R7,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(D:D,MATCH($R7,$B:$B,0))=\"balance\",IF(AC7<0,\"OUT\",\"IN\"),INDEX(D:D,MATCH($R7,$B:$B,0))),\"\")","v":""},"","","","","",{"$f":"IF(V7=\"\",S7,IFERROR(INDEX(J:J,MATCH($R7,$B:$B,0)),\"\"))","v":""},{"$f":"IFERROR(INDEX(K:K,MATCH($R7,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(L:L,MATCH($R7,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(VALUE(INDEX(M:M,MATCH($R7,$B:$B,0))),\"\")","v":""}]