{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["USER GUIDE","Closed Positions","Transactions Report","CONVERTER"],"not_rendered":{"images":13,"macros":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]]}
[{"$nulls":22},{"$f":"IF(COUNTA('Closed Positions'!A:A)<3,3,COUNTA('Closed Positions'!A:A))","v":3},"OPEN TIME","TYPE","SIZE","ITEM","ENTRY PRICE","S / L","T / P","CLOSE TIME","EXIT PRICE","TOTAL FEES","PROFIT / LOSS","lev"]
[null,"User Guide",{"$nulls":3},"Important Note:",null,"Please enable macro to use this file.",{"$nulls":4},"To enable macro:",{"$nulls":10},{"$f":"IFERROR(IFERROR(IF(VALUE(CONVERTER!$AH$5)>1,VALUE(LEFT('Closed Positions'!E2,2)&\"/\"&RIGHT(LEFT('Closed Positions'!E2,5),2)&\"/\"&RIGHT(LEFT('Closed Positions'!E2,10),4)),0),VALUE(RIGHT(LEFT('Closed Positions'!E2,5),2)&\"/\"&LEFT('Closed Positions'!E2,2)&\"/\"&RIGHT(LEFT('Closed Positions'!E2,10),4)))+TIMEVALUE(RIGHT('Closed Positions'!E2,5)),\"\")","v":""},{"$f":"IF(X2=\"\",\"\",IF(LEFT('Closed Positions'!B2,1)=\"B\",\"BUY\",\"SELL\"))","v":""},{"$f":"VALUE('Closed Positions'!D2)","v":0},{"$f":"IFERROR(RIGHT('Closed Positions'!B2,IF(Y2=\"buy\",LEN('Closed Positions'!B2)-4,LEN('Closed Positions'!B2)-5)),\"\")","v":""},{"$f":"VALUE('Closed Positions'!J2)","v":0},{"$f":"VALUE('Closed Positions'!M2)","v":0},{"$f":"VALUE('Closed Positions'!L2)","v":0},{"$f":"IFERROR(IFERROR(IF(VALUE(CONVERTER!$AH$5)>1,VALUE(LEFT('Closed Positions'!F2,2)&\"/\"&RIGHT(LEFT('Closed Positions'!F2,5),2)&\"/\"&RIGHT(LEFT('Closed Positions'!F2,10),4)),0),VALUE(RIGHT(LEFT('Closed Positions'!F2,5),2)&\"/\"&LEFT('Closed Positions'!F2,2)&\"/\"&RIGHT(LEFT('Closed Positions'!F2,10),4)))+TIMEVALUE(RIGHT('Closed Positions'!F2,5)),\"\")","v":""},{"$f":"VALUE('Closed Positions'!K2)","v":0},{"$f":"VALUE('Closed Positions'!N2)","v":0},{"$f":"VALUE('Closed Positions'!I2)","v":0},{"$f":"VALUE('Closed Positions'!G2)","v":0},{"$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.2"]
[]
[null,"STEP 1:"]
[]
[null,"Go to eToro portfolio, history, click setting icon and click \"Account Statement\""]
{"$rows_empty":10}
[null,"STEP 2:"]
[null,"Select date report date range to download, and click on excel icon."]
{"$rows_empty":12}
[null,"STEP 3:"]
[null,"Go to CONVERTER sheet, click \"SELECT SOURCE FILE\", locate your eToro Account  Statement file, and click OK"]
{"$rows_empty":13}
[null,"STEP 4:"]
[null,"Click COPY from CONVERTER 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":"Closed Positions","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Transactions Report","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"CONVERTER","index":3,"n_rows":7,"n_cols":35,"rows_kept":7}
[{"$nulls":5},{"$f":"IF(COUNTA('Transactions Report'!A:A)<8,8,COUNTA('Transactions Report'!A:A))","v":8},{"$f":"IF(COUNT(U:U)+5<6,6,COUNT(U:U)+5)","v":6},null,{"$f":"\"u\"&COUNT(U:U)+5","v":"u5"},{"$nulls":11},"Developed by rocketsheets.com, Forex eToro Account Statement Converter v.2"]
[]
[]
[]
[null,"No.",null,"match",null,"open","type","units","item","entry","stop","target","close","exit","fee","Profit","leverage",null,null,5,"OPEN TIME","TYPE","SIZE","ITEM","ENTRY PRICE","S / L","T / P","CLOSE TIME","EXIT PRICE","TOTAL FEES","PROFIT / LOSS","LEVERAGE",null,"28/04/23",{"$f":"VALUE(AH5)","v":{"$error":"#VALUE!"}}]
[null,1,{"$f":"IF('Transactions Report'!I2=\"\",B6,MATCH('Transactions Report'!I2,'Transactions Report'!$I1:I$2,0))","v":1},{"$f":"IF(COUNT(C6)>0,\"\",MATCH('Transactions Report'!I2,'Closed Positions'!A:A,0))","v":""},{"$f":"IF(VALUE('Transactions Report'!I2)>0,\"\",IF(AND('Transactions Report'!I2=\"\",'Transactions Report'!F2>0),\"IN\",\"OUT\"))","v":"OUT"},{"$f":"IFERROR(INDEX('USER GUIDE'!X:X,CONVERTER!D6),CONVERTER!R6)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX('USER GUIDE'!Y:Y,CONVERTER!D6),E6)","v":"OUT"},{"$f":"IFERROR(INDEX('USER GUIDE'!Z:Z,CONVERTER!D6),0)","v":0},{"$f":"IFERROR(INDEX('USER GUIDE'!AA:AA,CONVERTER!D6),\"\")","v":""},{"$f":"IFERROR(INDEX('USER GUIDE'!AB:AB,CONVERTER!D6),0)","v":0},{"$f":"IFERROR(INDEX('USER GUIDE'!AC:AC,CONVERTER!D6),0)","v":0},{"$f":"IFERROR(INDEX('USER GUIDE'!AD:AD,CONVERTER!D6),0)","v":0},{"$f":"IFERROR(INDEX('USER GUIDE'!AE:AE,CONVERTER!D6),CONVERTER!R6)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX('USER GUIDE'!AF:AF,CONVERTER!D6),0)","v":0},{"$f":"IFERROR(INDEX('USER GUIDE'!AG:AG,CONVERTER!D6),0)","v":0},{"$f":"IFERROR(VALUE(IF(OR(E6=\"IN\",E6=\"OUT\"),'Transactions Report'!F2,INDEX('Closed Positions'!I:I,CONVERTER!D6))),\"\")","v":0},{"$f":"IFERROR(INDEX('USER GUIDE'!AI:AI,CONVERTER!D6),0)","v":0},{"$f":"IFERROR(IF(VALUE(CONVERTER!$AH$5)>1,\nVALUE((RIGHT(LEFT('Transactions Report'!A2,10),2)&\"/\"&RIGHT(LEFT('Transactions Report'!A2,5),2)&\"/\"&LEFT('Transactions Report'!A2,2))),0),\nVALUE(RIGHT(LEFT('Transactions Report'!A2,5),2)&\"/\"&RIGHT(LEFT('Transactions Report'!A2,10),2)&\"/\"&LEFT('Transactions Report'!A2,2)))\n+TIMEVALUE(RIGHT('Transactions Report'!A2,8))","v":{"$error":"#VALUE!"}},{"$f":"IF(COUNT(P6)=1,B6,\"\")","v":1},{"$f":"SMALL(S:S,B6)","v":1},{"$f":"IFERROR(INDEX(F:F,T6+$T$5),\"\")","v":""},{"$f":"IFERROR(INDEX(G:G,T6+$T$5),\"\")","v":"OUT"},{"$f":"IFERROR(INDEX(H:H,T6+$T$5),\"\")","v":0},{"$f":"IFERROR(INDEX(I:I,T6+$T$5),\"\")","v":""},{"$f":"IFERROR(INDEX(J:J,T6+$T$5),\"\")","v":0},{"$f":"IFERROR(INDEX(K:K,T6+$T$5),\"\")","v":0},{"$f":"IFERROR(INDEX(L:L,T6+$T$5),\"\")","v":0},{"$f":"IFERROR(INDEX(M:M,T6+$T$5),\"\")","v":""},{"$f":"IFERROR(INDEX(N:N,T6+$T$5),\"\")","v":0},{"$f":"IFERROR(INDEX(O:O,T6+$T$5),\"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(INDEX(P:P,T6+$T$5),\"\")","v":{"v":0,"d":"0.000"}},{"$f":"IFERROR(INDEX(Q:Q,T6+$T$5),\"\")","v":0}]
[null,{"$f":"B6+1","v":2},{"$f":"IF('Transactions Report'!I3=\"\",B7,MATCH('Transactions Report'!I3,'Transactions Report'!$I2:I$2,0))","v":2},{"$f":"IF(COUNT(C7)>0,\"\",MATCH('Transactions Report'!I3,'Closed Positions'!A:A,0))","v":""},{"$f":"IF(VALUE('Transactions Report'!I3)>0,\"\",IF(AND('Transactions Report'!I3=\"\",'Transactions Report'!F3>0),\"IN\",\"OUT\"))","v":"OUT"},{"$f":"IFERROR(INDEX('USER GUIDE'!X:X,CONVERTER!D7),R7)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX('USER GUIDE'!Y:Y,CONVERTER!D7),E7)","v":"OUT"},{"$f":"IFERROR(INDEX('USER GUIDE'!Z:Z,CONVERTER!D7),0)","v":0},{"$f":"IFERROR(INDEX('USER GUIDE'!AA:AA,CONVERTER!D7),\"\")","v":""},{"$f":"IFERROR(INDEX('USER GUIDE'!AB:AB,CONVERTER!D7),0)","v":0},{"$f":"IFERROR(INDEX('USER GUIDE'!AC:AC,CONVERTER!D7),0)","v":0},{"$f":"IFERROR(INDEX('USER GUIDE'!AD:AD,CONVERTER!D7),0)","v":0},{"$f":"IFERROR(INDEX('USER GUIDE'!AE:AE,CONVERTER!D7),R7)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX('USER GUIDE'!AF:AF,CONVERTER!D7),0)","v":0},{"$f":"IFERROR(INDEX('USER GUIDE'!AG:AG,CONVERTER!D7),0)","v":0},{"$f":"IFERROR(VALUE(IF(OR(E7=\"IN\",E7=\"OUT\"),'Transactions Report'!F3,INDEX('Closed Positions'!I:I,CONVERTER!D7))),\"\")","v":0},{"$f":"IFERROR(INDEX('USER GUIDE'!AI:AI,CONVERTER!D7),0)","v":0},{"$f":"IFERROR(IF(VALUE(CONVERTER!$AH$5)>1,\nVALUE((RIGHT(LEFT('Transactions Report'!A3,10),2)&\"/\"&RIGHT(LEFT('Transactions Report'!A3,5),2)&\"/\"&LEFT('Transactions Report'!A3,2))),0),\nVALUE(RIGHT(LEFT('Transactions Report'!A3,5),2)&\"/\"&RIGHT(LEFT('Transactions Report'!A3,10),2)&\"/\"&LEFT('Transactions Report'!A3,2)))\n+TIMEVALUE(RIGHT('Transactions Report'!A3,8))","v":{"$error":"#VALUE!"}},{"$f":"IF(COUNT(P7)=1,B7,\"\")","v":2},2,"","OUT",0,"",0,0,0,"",0,{"v":0,"d":"0.00"},{"v":0,"d":"0.000"},0]