{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["USER GUIDE","CONVERTER","Sheet1"],"not_rendered":{"images":11,"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(#REF!)<3,3,COUNTA(#REF!))","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(#REF!,2)&\"/\"&RIGHT(LEFT(#REF!,5),2)&\"/\"&RIGHT(LEFT(#REF!,10),4)),0),VALUE(RIGHT(LEFT(#REF!,5),2)&\"/\"&LEFT(#REF!,2)&\"/\"&RIGHT(LEFT(#REF!,10),4)))+TIMEVALUE(RIGHT(#REF!,5)),\"\")","v":""},{"$f":"IF(X2=\"\",\"\",IF(LEFT(#REF!,1)=\"B\",\"BUY\",\"SELL\"))","v":""},{"$f":"VALUE(#REF!)","v":{"$error":"#REF!"}},{"$f":"IFERROR(RIGHT(#REF!,IF(Y2=\"buy\",LEN(#REF!)-4,LEN(#REF!)-5)),\"\")","v":""},{"$f":"VALUE(#REF!)","v":{"$error":"#REF!"}},{"$f":"VALUE(#REF!)","v":{"$error":"#REF!"}},{"$f":"VALUE(#REF!)","v":{"$error":"#REF!"}},{"$f":"IFERROR(IFERROR(IF(VALUE(CONVERTER!$AH$5)>1,VALUE(LEFT(#REF!,2)&\"/\"&RIGHT(LEFT(#REF!,5),2)&\"/\"&RIGHT(LEFT(#REF!,10),4)),0),VALUE(RIGHT(LEFT(#REF!,5),2)&\"/\"&LEFT(#REF!,2)&\"/\"&RIGHT(LEFT(#REF!,10),4)))+TIMEVALUE(RIGHT(#REF!,5)),\"\")","v":""},{"$f":"VALUE(#REF!)","v":{"$error":"#REF!"}},{"$f":"VALUE(#REF!)","v":{"$error":"#REF!"}},{"$f":"VALUE(#REF!)","v":{"$error":"#REF!"}},{"$f":"VALUE(#REF!)","v":{"$error":"#REF!"}},{"$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 you myTrade monthly ledger"]
{"$rows_empty":10}
[null,"STEP 2:"]
[null,"Go to \"CONVERTER\" sheet of this file and click \"SELECT SOURCE FILE\""]
{"$rows_empty":12}
[null,"STEP 3:"]
[null,"Locate your ledger file and click \"OK\""]
{"$rows_empty":13}
[null,"STEP 4:"]
[null,"Convertion done. 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":"CONVERTER","index":1,"n_rows":11,"n_cols":35,"rows_kept":11}
[null,{"$f":"IF(ISNUMBER(Sheet1!I1),ROW(),\"\")","v":""},{"$nulls":3},{"$f":"ROUNDUP(COUNTA(Sheet1!A:A)*1.3,0)","v":0},{"$f":"IF(F1<8,8,F1)","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":10},"Developed by AA Excel Spreadsheets, myTrade Ledger Converter v.0"]
[null,{"$f":"IF(ISNUMBER(Sheet1!D2),ROW(),\"\")","v":""}]
[null,{"$f":"IF(ISNUMBER(Sheet1!D3),ROW(),\"\")","v":""},{"$nulls":24},"E:\\00-SPREADSHEET\\02 - STOCK TRADING\\19-eTORO converter\\eToroAccountStatement-gagambatrader-01-04-2020-30-04-2020.xlsx"]
[null,{"$f":"IF(ISNUMBER(Sheet1!D4),ROW(),\"\")","v":""},{"$nulls":24},"eToroAccountStatement-gagambatrader-01-04-2020-30-04-2020.xlsx"]
[null,{"$f":"IF(ISNUMBER(Sheet1!D5),ROW(),\"\")","v":""},"No.",null,"date","code","type","symbol","price","shares","gr6ss","net","fee","ref","totalshares","aveprice",{"$nulls":3},5,"DATE","STOCK","ACTION","PRICE","SHARES","FEES",{"$nulls":7},"28/04/20",{"$f":"VALUE(AH5)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(ISNUMBER(Sheet1!D6),ROW(),\"\")","v":""},1,{"$f":"SMALL(B:B,C6)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!A:A,CONVERTER!$D6)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!B:B,CONVERTER!$D6)","v":{"$error":"#NUM!"}},{"$f":"IF(F6=\"s\",\"SELL\",IF(F6=\"P\",\"BUY\",\"\"))","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!E:E,CONVERTER!$D6)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!H:H,CONVERTER!$D6)","v":{"$error":"#NUM!"}},{"$f":"ABS(INDEX(Sheet1!G:G,CONVERTER!$D6))","v":{"$error":"#NUM!"}},{"$f":"J6*I6","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!I:I,CONVERTER!$D6)","v":{"$error":"#NUM!"}},{"$f":"ABS(K6-L6)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!D:D,CONVERTER!$D6)","v":{"$error":"#NUM!"}},{"$f":"SUMIF(N:N,N6,J:J)","v":{"$error":"#NUM!"}},{"$f":"IFERROR(SUMIF(N:N,N6,K:K)/O6,\"\")","v":""},{"$f":"COUNTIF($N$4:N6,N6)","v":1},{"$f":"IF(P6=\"\",\"\",IF(Q6=1,ROW(),\"\"))","v":""},null,{"$f":"SMALL(R:R,C6)","v":{"$error":"#NUM!"}},{"$f":"IFERROR(IF(T6=\"\",\"\",INDEX(E:E,$T6)),\"\")","v":""},{"$f":"IFERROR(IF(T6=\"\",\"\",INDEX(H:H,T6)),\"\")","v":""},{"$f":"IFERROR(IF(T6=\"\",\"\",INDEX(G:G,T6)),\"\")","v":""},{"$f":"IFERROR(IF(T6=\"\",\"\",INDEX(P:P,$T6)),\"\")","v":""},{"$f":"IFERROR(IF(T6=\"\",\"\",INDEX(O:O,$T6)),\"\")","v":""},{"$f":"IFERROR(IF(T6=\"\",\"\",INDEX(M:M,$T6)),\"\")","v":""}]
[null,{"$f":"IF(ISNUMBER(Sheet1!D7),ROW(),\"\")","v":""},{"$f":"C6+1","v":2},{"$f":"SMALL(B:B,C7)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!A:A,CONVERTER!$D7)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!B:B,CONVERTER!$D7)","v":{"$error":"#NUM!"}},{"$f":"IF(F7=\"s\",\"SELL\",IF(F7=\"P\",\"BUY\",\"\"))","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!E:E,CONVERTER!$D7)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!H:H,CONVERTER!$D7)","v":{"$error":"#NUM!"}},{"$f":"ABS(INDEX(Sheet1!G:G,CONVERTER!$D7))","v":{"$error":"#NUM!"}},{"$f":"J7*I7","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!I:I,CONVERTER!$D7)","v":{"$error":"#NUM!"}},{"$f":"ABS(K7-L7)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!D:D,CONVERTER!$D7)","v":{"$error":"#NUM!"}},{"$f":"SUMIF(N:N,N7,J:J)","v":{"$error":"#NUM!"}},{"$f":"IFERROR(SUMIF(N:N,N7,K:K)/O7,\"\")","v":""},{"$f":"COUNTIF($N$4:N7,N7)","v":2},{"$f":"IF(P7=\"\",\"\",IF(Q7=1,ROW(),\"\"))","v":""},null,{"$f":"SMALL(R:R,C7)","v":{"$error":"#NUM!"}},{"$f":"IFERROR(IF(T7=\"\",\"\",INDEX(E:E,$T7)),\"\")","v":""},{"$f":"IFERROR(IF(T7=\"\",\"\",INDEX(H:H,T7)),\"\")","v":""},{"$f":"IFERROR(IF(T7=\"\",\"\",INDEX(G:G,T7)),\"\")","v":""},{"$f":"IFERROR(IF(T7=\"\",\"\",INDEX(P:P,$T7)),\"\")","v":""},{"$f":"IFERROR(IF(T7=\"\",\"\",INDEX(O:O,$T7)),\"\")","v":""},{"$f":"IFERROR(IF(T7=\"\",\"\",INDEX(M:M,$T7)),\"\")","v":""}]
[]
[]
[{"$nulls":27},"*This version only extract buy ans sell transactions, for deposits and dividends"]
[{"$nulls":27},"   Please refer to your original ledger report."]

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