{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["USER GUIDE","CONVERTER","Sheet1"],"not_rendered":{"images":15,"macros":1,"defined_names":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],[54,12,56,18]]}
[]
[null,"User Guide",{"$nulls":3},"Important Note:",null,"Please enable macro to use this file.",{"$nulls":4},"To enable macro:",{"$nulls":22},{"$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,"Download Binance Futures Order Trade History."]
[]
[null,"Go to Orders ► Futures Order ► Trade History ► Click Export ► Select Date Range ► Click Export"]
{"$rows_empty":8}
[null,"STEP 2:"]
[null,"Go to \"CONVERTER\" sheet and click \"SELECT SOURCE FILE\", locate your Trade History file, and click OK"]
{"$rows_empty":15}
[null,"STEP 3:"]
[null,"Click COPY icon from CONVERTER sheet."]
{"$rows_empty":11}
[null,"STEP 4:"]
[null,"Paste your trade data in your Trading Journal and adjust the decimals number format."]
[]
[{"$nulls":12},"IMPORTANT NOTE:"]
[{"$nulls":12},"► Currency of price,fees & profits will be your Qoute Asset, Example: USDT"]
[{"$nulls":12},"► Profit column in the trade log sheet are net profit (Profit - Fees)"]
[{"$nulls":12},"► The original trade history action \"side\" are only BUY & SELL, this spreadsheets autoconvert trade action to SHORT & COVER if your bias is on the SELL side."]
{"$rows_empty":18}
[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":7,"n_cols":35,"rows_kept":7}
[{"$nulls":5},{"$f":"IF(COUNTA(Sheet1!B:B)<8,8,COUNTA(Sheet1!C:C)+20)","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, Binance Futures Ledger Converter v.2"]
[]
[{"$nulls":8},{"$f":"SMALL(F$5:F$99990,B26)","v":{"$error":"#NUM!"}}]
[{"$nulls":8},{"$f":"IFERROR(SMALL(G$5:G$99990,B26),\"\")","v":""},{"$f":"SMALL(I3:I4,1)","v":{"$error":"#NUM!"}}]
[null,"No.",{"$nulls":3},"date value",null,"match","Sorted Date","Pair","side","Price","share","fee","helper","total fee","ACTION","profit","helper on changing side",null,"DATE","PAIR","ACTION / SIDE","PRICE","SHARES","FEES",{"$nulls":7},"28/04/20",{"$f":"VALUE(AH5)","v":{"$error":"#VALUE!"}}]
[null,1,{"$f":"IF(OR(W6=\"buy\",W6=\"cover\"),Y6,-Y6)","v":{"$error":"#VALUE!"}},{"$f":"SMALL(F$5:G$99990,B6)","v":{"$error":"#NUM!"}},{"$f":"MATCH(D6,$F$5:$F$99990,0)","v":{"$error":"#NUM!"}},{"$f":"IF(Sheet1!A2=\"\",\"\",VALUE(Sheet1!A2)-(ROW()/100000))","v":""},{"$f":"IFERROR(IF(IF(AND(OR(Q6=\"buy\",Q6=\"short\"),R6<>0),SUMIFS($O5:O$6,$J5:J$6,J6),0)<>0,I6-0.00005,\"\"),\"\")","v":""},{"$f":"MATCH(I6,F$5:F$99990,0)","v":{"$error":"#NUM!"}},{"$f":"SMALL(F$5:F$99990,B6)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!B:B,$H6)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!C:C,$H6)","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!D:D,$H6))","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!E:E,$H6))","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!G:G,$H6))","v":{"$error":"#NUM!"}},{"$f":"IF(K6=\"buy\",M6,-M6)","v":{"$error":"#NUM!"}},{"$f":"ROUND(SUMIF($J$6:J6,J6,$O$6:O6),4)","v":{"$error":"#NUM!"}},{"$f":"IF(AND(P6<0,O6<0),\"SHORT\",IF(AND(O6>0,P6<=0),\"COVER\",K6))","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!I:I,$H6))","v":{"$error":"#NUM!"}},{"$f":"SUMIFS($C5:C$6,$V5:V$6,V6)","v":{"$error":"#VALUE!"}},{"$f":"IF(U6=\"\",\"\",MATCH(U6,$I$6:$I$99990,0))","v":""},{"$f":"IFERROR(D6,\"\")","v":""},{"$f":"IFERROR(IF(T6=\"\",\"\",INDEX($J$6:$J$99990,T6)),V5)","v":""},{"$f":"IFERROR(IF(T6=\"\",\"\",INDEX($Q$6:$Q$99990,T6)),IF(W5=\"short\",\"COVER\",\"SELL\"))","v":""},{"$f":"IFERROR(IF(T6=\"\",\"\",INDEX($L$6:$L$99990,T6)),X7)","v":""},{"$f":"IF(ISERROR(T5),IFERROR(IF(T6=\"\",\"\",INDEX($M$6:$M$99990,T6)),ABS(S6))-Y5,IFERROR(IF(T6=\"\",\"\",INDEX($M$6:$M$99990,T6)),ABS(S6)))","v":""},{"$f":"IFERROR(IF(T6=\"\",\"\",INDEX($N$6:$N$99990,T6)),0)","v":""}]
[null,{"$f":"B6+1","v":2},{"$f":"IF(OR(W7=\"buy\",W7=\"cover\"),Y7,-Y7)","v":{"$error":"#VALUE!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(Sheet1!A3=\"\",\"\",VALUE(Sheet1!A3)-(ROW()/100000))","v":""},{"$f":"IFERROR(IF(IF(AND(OR(Q7=\"buy\",Q7=\"short\"),R7<>0),SUMIFS($O$6:O6,$J$6:J6,J7),0)<>0,I7-0.00005,\"\"),\"\")","v":""},{"$f":"MATCH(I7,F$5:F$99990,0)","v":{"$error":"#NUM!"}},{"$f":"SMALL(F$5:F$99990,B7)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!B:B,$H7)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!C:C,$H7)","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!D:D,$H7))","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!E:E,$H7))","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!G:G,$H7))","v":{"$error":"#NUM!"}},{"$f":"IF(K7=\"buy\",M7,-M7)","v":{"$error":"#NUM!"}},{"$f":"ROUND(SUMIF($J$6:J7,J7,$O$6:O7),4)","v":{"$error":"#NUM!"}},{"$f":"IF(AND(P7<0,O7<0),\"SHORT\",IF(AND(O7>0,P7<=0),\"COVER\",K7))","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!I:I,$H7))","v":{"$error":"#NUM!"}},{"$f":"SUMIFS($C$6:C6,$V$6:V6,V7)","v":{"$error":"#VALUE!"}},"",{"$f":"IFERROR(D7,\"\")","v":""},"","","","",{"$f":"IFERROR(IF(T7=\"\",\"\",INDEX($N$6:$N$99990,T7)),0)","v":""}]

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