{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["USER GUIDE","DATA","RESULT"],"not_rendered":{"images":14,"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 cTrader History tab, select Period, Check \"Export to Excel\", right click and select \"Create Statement\""]
{"$rows_empty":10}
[null,"STEP 2:"]
[null,"Open the excel report, select and copy all data (Ctrl+C)"]
{"$rows_empty":12}
[null,"STEP 3:"]
[null,"Select DATA sheet of this workbook, 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":17,"n_cols":26,"rows_kept":17}
["PASTE DATA HERE : ***Right Click and PASTE AS VALUE or MATCH DESTINATION FORMAT***",{"$nulls":17},"ITEM","ENTRY PRICE","S / L","T / P","CLOSE TIME","EXIT PRICE","TOTAL FEES","PROFIT / LOSS"]
[{"$nulls":18},{"$f":"DATA!B2","v":0},{"$f":"VALUE(DATA!F2)","v":0},null,null,{"$f":"VALUE(DATA!E2)","v":"00:00:00"},{"$f":"VALUE(DATA!G2)","v":0},{"$f":"VALUE(DATA!I2+DATA!J2)","v":0},{"$f":"DATA!L2","v":0}]
[{"$nulls":18},{"$f":"DATA!B3","v":0},{"$f":"VALUE(DATA!F3)","v":0},null,null,{"$f":"VALUE(DATA!E3)","v":"00:00:00"},{"$f":"VALUE(DATA!G3)","v":0},{"$f":"VALUE(DATA!I3+DATA!J3)","v":0},{"$f":"DATA!L3","v":0}]
[{"$nulls":18},{"$f":"DATA!B4","v":0},{"$f":"VALUE(DATA!F4)","v":0},null,null,{"$f":"VALUE(DATA!E4)","v":"00:00:00"},{"$f":"VALUE(DATA!G4)","v":0},{"$f":"VALUE(DATA!I4+DATA!J4)","v":0},{"$f":"DATA!L4","v":0}]
[{"$nulls":18},{"$f":"DATA!B5","v":0},{"$f":"VALUE(DATA!F5)","v":0},null,null,{"$f":"VALUE(DATA!E5)","v":"00:00:00"},{"$f":"VALUE(DATA!G5)","v":0},{"$f":"VALUE(DATA!I5+DATA!J5)","v":0},{"$f":"DATA!L5","v":0}]
[{"$nulls":18},{"$f":"DATA!B6","v":0},{"$f":"VALUE(DATA!F6)","v":0},null,null,{"$f":"VALUE(DATA!E6)","v":"00:00:00"},{"$f":"VALUE(DATA!G6)","v":0},{"$f":"VALUE(DATA!I6+DATA!J6)","v":0},{"$f":"DATA!L6","v":0}]
[{"$nulls":18},{"$f":"DATA!B7","v":0},{"$f":"VALUE(DATA!F7)","v":0},null,null,{"$f":"VALUE(DATA!E7)","v":"00:00:00"},{"$f":"VALUE(DATA!G7)","v":0},{"$f":"VALUE(DATA!I7+DATA!J7)","v":0},{"$f":"DATA!L7","v":0}]
[{"$nulls":18},{"$f":"DATA!B8","v":0},{"$f":"VALUE(DATA!F8)","v":0},null,null,{"$f":"VALUE(DATA!E8)","v":"00:00:00"},{"$f":"VALUE(DATA!G8)","v":0},{"$f":"VALUE(DATA!I8+DATA!J8)","v":0},{"$f":"DATA!L8","v":0}]
[{"$nulls":18},{"$f":"DATA!B9","v":0},{"$f":"VALUE(DATA!F9)","v":0},null,null,{"$f":"VALUE(DATA!E9)","v":"00:00:00"},{"$f":"VALUE(DATA!G9)","v":0},{"$f":"VALUE(DATA!I9+DATA!J9)","v":0},{"$f":"DATA!L9","v":0}]
[{"$nulls":18},{"$f":"DATA!B10","v":0},{"$f":"VALUE(DATA!F10)","v":0},null,null,{"$f":"VALUE(DATA!E10)","v":"00:00:00"},{"$f":"VALUE(DATA!G10)","v":0},{"$f":"VALUE(DATA!I10+DATA!J10)","v":0},{"$f":"DATA!L10","v":0}]
[{"$nulls":18},{"$f":"DATA!B11","v":0},{"$f":"VALUE(DATA!F11)","v":0},null,null,{"$f":"VALUE(DATA!E11)","v":"00:00:00"},{"$f":"VALUE(DATA!G11)","v":0},{"$f":"VALUE(DATA!I11+DATA!J11)","v":0},{"$f":"DATA!L11","v":0}]
[{"$nulls":18},{"$f":"DATA!B12","v":0},{"$f":"VALUE(DATA!F12)","v":0},null,null,{"$f":"VALUE(DATA!E12)","v":"00:00:00"},{"$f":"VALUE(DATA!G12)","v":0},{"$f":"VALUE(DATA!I12+DATA!J12)","v":0},{"$f":"DATA!L12","v":0}]
[{"$nulls":18},{"$f":"DATA!B13","v":0},{"$f":"VALUE(DATA!F13)","v":0},null,null,{"$f":"VALUE(DATA!E13)","v":"00:00:00"},{"$f":"VALUE(DATA!G13)","v":0},{"$f":"VALUE(DATA!I13+DATA!J13)","v":0},{"$f":"DATA!L13","v":0}]
[{"$nulls":18},{"$f":"DATA!B14","v":0},{"$f":"VALUE(DATA!F14)","v":0},null,null,{"$f":"VALUE(DATA!E14)","v":"00:00:00"},{"$f":"VALUE(DATA!G14)","v":0},{"$f":"VALUE(DATA!I14+DATA!J14)","v":0},{"$f":"DATA!L14","v":0}]
[{"$nulls":18},{"$f":"DATA!B15","v":0},{"$f":"VALUE(DATA!F15)","v":0},null,null,{"$f":"VALUE(DATA!E15)","v":"00:00:00"},{"$f":"VALUE(DATA!G15)","v":0},{"$f":"VALUE(DATA!I15+DATA!J15)","v":0},{"$f":"DATA!L15","v":0}]
[{"$nulls":18},{"$f":"DATA!B16","v":0},{"$f":"VALUE(DATA!F16)","v":0},null,null,{"$f":"VALUE(DATA!E16)","v":"00:00:00"},{"$f":"VALUE(DATA!G16)","v":0},{"$f":"VALUE(DATA!I16+DATA!J16)","v":0},{"$f":"DATA!L16","v":0}]
[{"$nulls":18},{"$f":"DATA!B17","v":0},{"$f":"VALUE(DATA!F17)","v":0},null,null,{"$f":"VALUE(DATA!E17)","v":"00:00:00"},{"$f":"VALUE(DATA!G17)","v":0},{"$f":"VALUE(DATA!I17+DATA!J17)","v":0},{"$f":"DATA!L17","v":0}]

{"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 cTrader Account Statement Converter v.0 (CTAS.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)","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(AND(DATA!N2<>\"\",DATA!F2=\"\"),A6,IF(OR(DATA!C2=\"buy\",DATA!C2=\"sell\"),A6,\"\"))","v":""},{"$f":"VALUE(DATA!D2)","v":"00:00:00"},{"$f":"UPPER(DATA!C2)","v":""},{"$f":"VALUE(SUBSTITUTE(DATA!H2,\" Lots\",\"\"))","v":{"$error":"#VALUE!"}},{"$f":"DATA!B2","v":0},{"$f":"VALUE(DATA!F2)","v":0},null,null,{"$f":"VALUE(DATA!E2)","v":"00:00:00"},{"$f":"VALUE(DATA!G2)","v":0},{"$f":"VALUE(DATA!I2+DATA!J2)","v":0},{"$f":"VALUE(SUBSTITUTE(DATA!L2,\" \",\"\"))","v":{"$error":"#VALUE!"}},1E-8,{"$nulls":4},{"$f":"S7","v":""},{"$f":"IF(S6=\"\",\"\",\"IN\")","v":""},{"$nulls":5},{"$f":"S6","v":""},null,null,{"$f":"IFERROR(DATA!M2-AC7-AB7,\"\")","v":""}]
[{"$f":"A6+1","v":7},{"$f":"IF(AND(DATA!N3<>\"\",DATA!F3=\"\"),A7,IF(OR(DATA!C3=\"buy\",DATA!C3=\"sell\"),A7,\"\"))","v":""},{"$f":"VALUE(DATA!D3)","v":"00:00:00"},{"$f":"UPPER(DATA!C3)","v":""},{"$f":"VALUE(SUBSTITUTE(DATA!H3,\" Lots\",\"\"))","v":{"$error":"#VALUE!"}},{"$f":"DATA!B3","v":0},{"$f":"VALUE(DATA!F3)","v":0},null,null,{"$f":"VALUE(DATA!E3)","v":"00:00:00"},{"$f":"VALUE(DATA!G3)","v":0},{"$f":"VALUE(DATA!I3+DATA!J3)","v":0},{"$f":"VALUE(SUBSTITUTE(DATA!L3,\" \",\"\"))","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":"IFERROR(INDEX(E:E,MATCH($R7,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(F:F,MATCH($R7,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(G:G,MATCH($R7,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(H:H,MATCH($R7,$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(I:I,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)))-AB7,\"\")","v":""}]