{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["USER GUIDE","CONVERTER","Sheet1"],"not_rendered":{"images":14,"macros":1,"external_links":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!$AT$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!$AT$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 your FMS ledger"]
{"$rows_empty":10}
[null,"STEP 2:",{"$nulls":14},"System Requirements:"]
[null,"Go to \"CONVERTER\" sheet of this file and click \"SELECT SOURCE FILE\"",{"$nulls":14},"MS Excel, Adobe Reader"]
{"$rows_empty":12}
[null,"STEP 3:"]
[null,"Locate your ledger PDF file and click \"OK\""]
{"$rows_empty":13}
[null,"STEP 4:"]
[null,"Wait until the conversion process is complete. 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 at rocketsheets.com"]

{"sheet":"CONVERTER","index":1,"n_rows":11,"n_cols":47,"rows_kept":11,"merged":[[10,39,15,39]]}
[{"$nulls":5},{"$f":"ROUNDUP(COUNTA(Sheet1!A:A)*1.3,0)","v":0},{"$f":"IF(F1<8,8,F1)","v":8},{"$f":"IF(COUNT(AJ6:AJ99999)+5<6,6,COUNT(AJ6:AJ99999)+5)","v":6},null,{"$f":"\"u\"&COUNT(AG:AG)+5","v":"u5"},{"$nulls":22},"Developed by Rocketsheets, FMS Ledger Converter v.0"]
[]
[{"$nulls":38},"E:\\00-SPREADSHEET\\02 - STOCK TRADING\\19-eTORO converter\\eToroAccountStatement-gagambatrader-01-04-2020-30-04-2020.xlsx"]
[{"$nulls":38},"eToroAccountStatement-gagambatrader-01-04-2020-30-04-2020.xlsx"]
[null,null,"No.","no.","helper","helper","date","helper","stock","helper","action","helper","helper","helper","shares","helper","PRICE ","fees","ave.price","amount",null,"price","helper","helper","sort",{"$nulls":6},5,"DATE","STOCK","ACTION","PRICE","SHARES","FEES",{"$nulls":7},"28/04/20",{"$f":"VALUE(AT5)","v":{"$error":"#VALUE!"}}]
[null,null,1,{"$f":"IF(OR(E6=\"\",E6=\"http\"),D5,E6)","v":"helper"},{"$f":"IFERROR(TRIM(LEFT(Sheet1!A9,FIND(\"/\",Sheet1!A9)-3)),E5)","v":"helper"},{"$f":"LEFT(Sheet1!A9,FIND(\"/\",Sheet1!A9)+7)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(VALUE(RIGHT(F6,LEN(F6)-FIND(\" \",LEFT(Sheet1!A9,FIND(\"/\",Sheet1!A9)+7)))),\"\")","v":""},{"$f":"RIGHT(Sheet1!A9,LEN(Sheet1!A9)+1-FIND(\"shares\",Sheet1!A9))","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(TRIM(SUBSTITUTE(IFERROR(LEFT(H6,FIND(\"@\",H6)-1),H6),\"shares\",\"\")),\"\")","v":""},{"$f":"IF(I6=\"\",\"\",VALUE(D6))","v":""},{"$f":"IFERROR(IFERROR(IF(FIND(\"BI-\",Sheet1!A9)>0,\"BUY\",\"\"),IF(FIND(\"SI-\",Sheet1!A9)>0,\"SELL\",\"\")),\"\")","v":""},{"$f":"IF(K6=\"\",\"\",VALUE(D6))","v":""},{"$f":"RIGHT(Sheet1!A9,LEN(Sheet1!A9)+1-IFERROR(FIND(\"+\",Sheet1!A9),FIND(\"-\",Sheet1!A9))-1)","v":{"$error":"#VALUE!"}},{"$f":"LEFT(M6,FIND(\" \",M6,FIND(\" \",M6,FIND(\" \",M6)+1)+1))","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(VALUE(LEFT(N6,FIND(\" \",N6))),\"\")","v":""},{"$f":"RIGHT(N6,LEN(N6)-FIND(\" \",N6))","v":{"$error":"#VALUE!"}},{"$f":"LEFT(P6,FIND(\" \",P6))","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(ABS((Q6*O6)-T6),\"\")","v":""},{"$f":"T6/O6","v":{"$error":"#VALUE!"}},{"$f":"VALUE(RIGHT(P6,LEN(P6)-FIND(\" \",P6)))","v":{"$error":"#VALUE!"}},null,{"$f":"IFERROR(VALUE(Q6),\"\")","v":""},{"$f":"IFERROR(INDEX(I$5:I$292,MATCH(C6,J$5:J$292,0)),\"\")","v":""},{"$f":"IF(W6=\"\",\"\",C6)","v":""},{"$f":"IFERROR(SMALL(X$5:X$292,C6),\"\")","v":""},{"$nulls":7},{"$f":"IF(Y6=\"\",\"\",SUMIFS($G$5:$G$292,$D$5:$D$292,$Y6))","v":""},{"$f":"INDEX(I$5:I$292,MATCH(Y6,J$5:J$292,0))","v":""},{"$f":"INDEX(K$5:K$292,MATCH(Y6,L$5:L$292,0))","v":""},{"$f":"IF(AH6=\"\",\"\",SUMIFS($V$5:$V$292,$D$5:$D$292,$Y6))","v":""},{"$f":"IF(Y6=\"\",\"\",SUMIFS($O$5:$O$292,$D$5:$D$292,$Y6))","v":""},{"$f":"IF(Y6=\"\",\"\",SUMIFS($R$5:$R$292,$D$5:$D$292,$Y6))","v":""}]
[null,null,{"$f":"C6+1","v":2},{"$f":"IF(OR(E7=\"\",E7=\"http\"),D6,E7)","v":"helper"},{"$f":"IFERROR(TRIM(LEFT(Sheet1!A10,FIND(\"/\",Sheet1!A10)-3)),E6)","v":"helper"},{"$f":"LEFT(Sheet1!A10,FIND(\"/\",Sheet1!A10)+7)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(VALUE(RIGHT(F7,LEN(F7)-FIND(\" \",LEFT(Sheet1!A10,FIND(\"/\",Sheet1!A10)+7)))),\"\")","v":""},{"$f":"RIGHT(Sheet1!A10,LEN(Sheet1!A10)+1-FIND(\"shares\",Sheet1!A10))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(I7=\"\",\"\",VALUE(D7))","v":""},{"$f":"IFERROR(IFERROR(IF(FIND(\"BI-\",Sheet1!A10)>0,\"BUY\",\"\"),IF(FIND(\"SI-\",Sheet1!A10)>0,\"SELL\",\"\")),\"\")","v":""},{"$f":"IF(K7=\"\",\"\",VALUE(D7))","v":""},{"$f":"RIGHT(Sheet1!A10,LEN(Sheet1!A10)+1-IFERROR(FIND(\"+\",Sheet1!A10),FIND(\"-\",Sheet1!A10))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"",{"$f":"RIGHT(N7,LEN(N7)-FIND(\" \",N7))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"",{"$f":"T7/O7","v":{"$error":"#VALUE!"}},{"$f":"VALUE(RIGHT(P7,LEN(P7)-FIND(\" \",P7)))","v":{"$error":"#VALUE!"}},null,"",{"$f":"IFERROR(INDEX(I$5:I$292,MATCH(C7,J$5:J$292,0)),\"\")","v":""},{"$f":"IF(W7=\"\",\"\",C7)","v":""},{"$f":"IFERROR(SMALL(X$5:X$292,C7),\"\")","v":""},{"$nulls":7},"",{"$f":"INDEX(I$5:I$292,MATCH(Y7,J$5:J$292,0))","v":""},{"$f":"INDEX(K$5:K$292,MATCH(Y7,L$5:L$292,0))","v":""},"","",""]
[]
[]
[]
[{"$nulls":39},"*This version only extract buy ans sell transactions, for deposits and dividends please refer to your original ledger report."]

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