{"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 BPI 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),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, BPITrade 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.","helper","helper","helper","action","helper","sort row","sorted code",{"$nulls":3},"helper shares",null,"find @","len",null,null,"helper","helper","amount",{"$nulls":9},5,"DATE","STOCK","ACTION","PRICE","SHARES","FEES",{"$nulls":7},"28/04/20",{"$f":"VALUE(AT5)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IFERROR(IF(IFERROR(FIND(\"Statement\",Sheet1!A18,1),FIND(\"bpitrade\",Sheet1!A18,1))>0,\"\",Sheet1!A18),Sheet1!A18)","v":0},1,{"$f":"IFERROR(VALUE(LEFT(B6,10)),\"\")","v":"00:00:00"},{"$f":"IF(D6=\"\",E5&\" \"&B6,B6)","v":0},{"$f":"IF(D6=\"\",\"\",SUBSTITUTE(E5,\",\",\"\"))","v":"helper"},{"$f":"RIGHT(LEFT(F6,13),2)","v":"er"},{"$f":"IF(G6=\"SI\",ROW(),IF(G6<>\"BI\",\"\",ROW()))","v":""},{"$f":"SMALL(H$6:H$99999,C6)","v":{"$error":"#NUM!"}},{"$f":"TRIM(INDEX(F$1:F$99999,I6))","v":{"$error":"#NUM!"}},null,null,{"$f":"FIND(\"shares\",J6,1)-2","v":{"$error":"#NUM!"}},{"$f":"LEFT(J6,M6)","v":{"$error":"#NUM!"}},null,{"$f":"FIND(\"@\",J6,1)","v":{"$error":"#NUM!"}},{"$f":"LEN(J6)","v":{"$error":"#NUM!"}},{"$f":"RIGHT(J6,Q6-P6)","v":{"$error":"#NUM!"}},null,{"$f":"LEFT(J6,P6-2)","v":{"$error":"#NUM!"}},{"$f":"RIGHT(T6,LEN(T6)-FIND(\"shares\",T6,1)-6)","v":{"$error":"#NUM!"}},{"$f":"AJ6*AK6","v":{"$error":"#VALUE!"}},{"$nulls":10},{"$f":"IFERROR(LEFT(J6,10),\"\")","v":""},{"$f":"IFERROR(IF(LEN(U6)>6,RIGHT(RIGHT(U6,7),7-FIND(\" \",RIGHT(U6,7))),U6),\"\")","v":""},{"$f":"IFERROR(IF(RIGHT(LEFT(J6,13),2)=\"BI\",\"BUY\",\"SELL\"),\"\")","v":""},{"$f":"IFERROR(VALUE(IFERROR(VALUE(LEFT(R6,FIND(\" \",R6,1))),R6)),\"\")","v":""},{"$f":"IFERROR(IFERROR(VALUE(RIGHT(N6,LEN(N6)-FIND(\"Bought\",N6,1)-5)),\nVALUE(RIGHT(N6,LEN(N6)-FIND(\"Sold\",N6,1)-3))),\"\")","v":""},{"$f":"IF(Y6=\"\",\"\",SUMIFS($R$5:$R$292,$D$5:$D$292,$Y6))","v":""}]
[null,{"$f":"IFERROR(IF(IFERROR(FIND(\"Statement\",Sheet1!A19,1),FIND(\"bpitrade\",Sheet1!A19,1))>0,\"\",Sheet1!A19),Sheet1!A19)","v":0},{"$f":"C6+1","v":2},"00:00:00",0,"0","0","",{"$f":"SMALL(H$6:H$99999,C7)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$f":"LEN(J7)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"AJ7*AK7","v":{"$error":"#VALUE!"}},{"$nulls":10},{"$f":"IFERROR(LEFT(J7,10),\"\")","v":""},{"$f":"IFERROR(IF(LEN(U7)>6,RIGHT(RIGHT(U7,7),7-FIND(\" \",RIGHT(U7,7))),U7),\"\")","v":""},{"$f":"IFERROR(IF(RIGHT(LEFT(J7,13),2)=\"BI\",\"BUY\",\"SELL\"),\"\")","v":""},{"$f":"IFERROR(VALUE(IFERROR(VALUE(LEFT(R7,FIND(\" \",R7,1))),R7)),\"\")","v":""},{"$f":"IFERROR(IFERROR(VALUE(RIGHT(N7,LEN(N7)-FIND(\"Bought\",N7,1)-5)),\nVALUE(RIGHT(N7,LEN(N7)-FIND(\"Sold\",N7,1)-3))),\"\")","v":""},""]
[]
[]
[]
[{"$nulls":39},"*This version only extract buy ans sell transactions, for deposits,fees and dividends please refer to your original ledger report."]

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