{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Kraken","BitMex","Kelly","README"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":18,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Kraken","index":0,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,6],[12,8,13,12],[16,8,18,9],[16,11,18,12],[17,1,17,2],[17,3,17,4],[17,5,17,6],[18,1,18,2],[18,3,18,4],[18,5,18,6]]}
[]
[null,{"$f":"IF(C4<C12,\"LONG\",IF(C4>C12,\"SHORT\",\"Margin Trade Calculator\"))","v":"SHORT"},null,null,null,null,null,null,"Trade Balance",2000,null,"Front Run Calculator"]
[null,null,null,"DCA",null,null,null,null,"Max Loss Risk",0.1,null,{"$f":"$L$7+($L$7*M3)","v":8856.3538934344433},5.5100000000000001E-3]
[null,"Entry Price",9000,null,{"$f":"((C6*C4)+(D6*D4))/(C6+D6)","v":9000},"Position Volume",{"$f":"IFERROR(C6/C4,\"\")","v":0.754},null,"Maker Fee",1.1999999999999999E-3,null,{"$f":"$L$7+($L$7*M4)","v":8837.8574655757329},3.4099999999999998E-3]
[null,"Leverage",5,null,{"$f":"((C6*C5)+(D6*D5))/(C6+D6)","v":5},"Margin Size",{"$f":"IFERROR(C6/C5,\"\")","v":1357.2},null,"Taker Fee",2.2000000000000001E-3,null,{"$f":"$L$7+($L$7*M5)","v":8826.4072959489113},2.1099999999999999E-3]
[null,"Position Size",6786,null,{"$f":"C6+D6","v":6786},"Margin Call (80%)",10212.519893899205,{"$f":"(J2+(C6*((G4*IF(B2=\"SHORT\",(G6*-1),G6))+IF(B2=\"SHORT\",C6,(C6*-1)))/C6))/(C6/C5)","v":0.79999999999999949},null,null,null,{"$f":"$L$7+($L$7*M6)","v":8819.3610377170226},1.31E-3]
[null,null,{"$f":"(J2*J3)-F19","v":9.0399999999988268E-3},null,null,"Liquidation (40%)",10932.519893899203,{"$f":"(J2+(C6*((G4*IF(B2=\"SHORT\",(G7*-1),G7))+IF(B2=\"SHORT\",C6,(C6*-1)))/C6))/(C6/C5)","v":0.40000000000000074},"Finance Fee",1E-4,null,8807.8227898623027,"target"]
[null,"Order Type","LM",null,null,"Break Even Price",{"$f":"IFERROR(((C6+(IF(B2=\"SHORT\",(G13+G10)*-1,G13+G10)))/C6)*C4,\"\")","v":8807.8227898623027},null,"Rollover (h)",4,null,{"$f":"$L$7+($L$7*M8)","v":8796.2845420075828},-1.31E-3]
[null,"Expected Duration",720,"hours",null,{"$f":"G8-G9","v":0},8807.8227898623009,null,null,null,null,{"$f":"$L$7+($L$7*M9)","v":8789.2382837756941},-2.1099999999999999E-3]
[null,null,null,null,null,"Estimated Finance",{"$f":"(CEILING(C9/J8,1)*J7)*C6","v":122.14800000000001},null,"Confidence",0.5,null,{"$f":"$L$7+($L$7*M10)","v":8777.7881141488724},-3.4099999999999998E-3]
[null,null,null,"portion","profit %","Est. Fees @ Profit",{"$f":"(IF(OR(C8=\"LL\",C8=\"LM\"),J4,J5)*C6)+(IF(OR(C8=\"LL\",C8=\"ML\"),J4,J5)*(C6*(1+C16)))","v":25.062959999999997},null,null,null,null,{"$f":"$L$7+($L$7*M11)","v":8759.291686290162},-5.5100000000000001E-3]
[null,"Profit Target 1",7800,1,{"$f":"IFERROR(IF(D12>0,IF($B$2=\"LONG\",(C12-$C$4),($C$4-C12))/$C$4,0),\"\")","v":0.13333333333333333},"Est. Fees @ Loss",{"$f":"(IF(OR(C8=\"LL\",C8=\"LM\"),J4,J5)*C6)+(IF(OR(C8=\"LL\",C8=\"ML\"),J4,J5)*(C6*(1-G16)))","v":22.956284},null,"Describe Trade Setup"]
[null,"Profit Target 2",null,0,{"$f":"IFERROR(IF(D13>0,IF($B$2=\"LONG\",(C13-$C$4),($C$4-C13))/$C$4,0),\"\")","v":0},"Est. Fees @ Even",{"$f":"(IF(OR(C8=\"LL\",C8=\"LM\"),J4,J5)*C6)+(IF(OR(C8=\"LL\",C8=\"ML\"),J4,J5)*(C6*(G9/C4)))","v":22.753616443823582},null,"What support/resistance, indicators, price action patterns, or other system was used to identify this trade setup?"]
[null,"Profit Target 3",null,0,{"$f":"IFERROR(IF(D14>0,IF($B$2=\"LONG\",(C14-$C$4),($C$4-C14))/$C$4,0),\"\")","v":0}]
[null,"Profit Target 4",null,{"$f":"100%-SUM(D12:D14)","v":0},{"$f":"IFERROR(IF(D15>0,IF($B$2=\"LONG\",(C15-$C$4),($C$4-C15))/$C$4,0),\"\")","v":0},"Stop Loss",9070]
[null,"Blended Profit %",{"$f":"(E12*D12)+(E13*D13)+(E14*D14)+(E15*D15)","v":0.13333333333333333},null,null,"Loss % (at stop)",{"$f":"IFERROR(IF(B2=\"LONG\",(C4-G15),(G15-C4))/C4,\"\")","v":7.7777777777777776E-3},null,"Stop Loss Treatment",null,null,"Profit Taking Plan"]
[null,null,null,null,null,null,null,null,"Hard (automated), soft (manual), open hedge (counter-future, 2nd instrument, covered call / protective put), etc…",null,null,"Limit order, trailing stop loss, laddered scale out, etc…"]
[null,"Target Profit",null,"Risk Ratio",null,"Max Loss"]
[null,{"$f":"IFERROR((C16*C6)-(G11+G10),\"\")","v":757.58903999999995},null,{"$f":"IFERROR(_xlfn.CONCAT(ROUND(B19/F19,2),\" : 1\"),\"\")","v":"3.79 : 1"},null,{"$f":"IFERROR((G16*C6)+(G11+G10),\"\")","v":199.99096}]

{"sheet":"BitMex","index":1,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,6],[12,8,13,12],[16,8,18,9],[16,11,18,12],[17,1,17,2],[17,3,17,4],[17,5,17,6],[18,1,18,2],[18,3,18,4],[18,5,18,6]]}
[]
[null,{"$f":"IF(C4<C12,\"LONG\",IF(C4>C12,\"SHORT\",\"Margin Trade Calculator\"))","v":"LONG"},null,null,null,null,null,null,"Equity at Entry",{"$f":"J3*C4","v":11700},null,"Front Run Calculator"]
[null,null,null,"DCA",null,null,null,null,"Wallet Balance",1.3,null,{"$f":"$L$7+($L$7*M3)","v":5960.6632799999998},5.5100000000000001E-3]
[null,"Entry Price",9000,null,{"$f":"((C6*C4)+(D6*D4))/(C6+D6)","v":9000},"Position Volume",{"$f":"IFERROR(C6/C4,\"\")","v":0.35777777777777775},null,"Max Loss Risk",0.02,null,{"$f":"$L$7+($L$7*M4)","v":5948.2144799999996},3.4099999999999998E-3]
[null,"Max Safe Leverage",{"$f":"IF(D5=\"\",MIN(C6/F19,100),D5)","v":13.761993960013763},null,null,"Margin Size",{"$f":"IFERROR(C6/C5/C4,\"\")","v":2.5997524691358024E-2},null,"Maker Fee",-2.5000000000000001E-4,null,{"$f":"$L$7+($L$7*M5)","v":5940.5080799999996},2.1099999999999999E-3]
[null,"Position Size",3220,null,{"$f":"C6+D6","v":3220},{"$f":"_xlfn.CONCAT(\"Liq. Price at \",ROUND(C5,0),\" lev\")","v":"Liq. Price at 14 lev"},{"$f":"IFERROR(ROUND((IF(B2=\"LONG\",(C4) + ((C4) * (((1 / ((C5) + 1) * (-1)) * 100) + (((0.005) - (1 / (C5) * (0.005))) * 100))) / 100, (C4) + ((C4) * (((1 / ((C5) - 1)) * 100) - (((0.005) + (1 / (C5) * (0.005))) * 100))) / 100))/5,1)*5,\"\")","v":8432},null,"Taker Fee",7.5000000000000002E-4,null,{"$f":"$L$7+($L$7*M6)","v":5935.7656800000004},1.31E-3]
[null,null,{"$f":"(J2*J4)-F19","v":2.2277777777787833E-2},null,null,"Liq. Price on Cross",{"$f":"IFERROR(ROUND((IF(B2=\"LONG\",(C4) + ((C4) * (((1 / ((C6/J2) + 1) * (-1)) * 100) + (((0.005) - (1 / (C6/J2) * (0.005))) * 100))) / 100, (C4) + ((C4) * (((1 / ((C6/J2) - 1)) * 100) - (((0.005) + (1 / (C6/J2) * (0.005))) * 100))) / 100))/5,1)*5,\"\")","v":1824},null,"Est. Funding",3.6999999999999999E-4,null,5928,"target"]
[null,"Order Type","LM",null,null,"Break Even Price",{"$f":"IFERROR(ROUND((((C6+(IF(B2=\"SHORT\",(G13)*-1,G13)))/C6)*C4)/5,1)*5,\"\")","v":9001},null,"Rollover (h)",8,null,{"$f":"$L$7+($L$7*M8)","v":5920.2343199999996},-1.31E-3]
[null,"Expected Duration",360,"hours",null,{"$f":"G8-G9","v":4786.5272308808462},4214.4727691191538,null,null,null,null,{"$f":"$L$7+($L$7*M9)","v":5915.4919200000004},-2.1099999999999999E-3]
[null,null,null,null,null,"Est. Funding",{"$f":"(CEILING(C9/J8,1)*J7)*C6","v":53.612999999999992},null,"Confidence",0.6,null,{"$f":"$L$7+($L$7*M10)","v":5907.7855200000004},-3.4099999999999998E-3]
[null,null,null,"portion","profit %","Est. Fees @ Profit",{"$f":"(IF(OR(C8=\"LL\",C8=\"LM\"),J5,J6)*C6)+(IF(OR(C8=\"LL\",C8=\"ML\"),J5,J6)*(C6*(1+C16)))","v":1.8783333333333334},null,null,null,null,{"$f":"$L$7+($L$7*M11)","v":5895.3367200000002},-5.5100000000000001E-3]
[null,"Profit Target 1",10000,1,{"$f":"IFERROR(IF(D12>0,IF($B$2=\"LONG\",(C12-$C$4),($C$4-C12))/$C$4,0),\"\")","v":0.1111111111111111},"Est. Fees @ Loss",{"$f":"(IF(OR(C8=\"LL\",C8=\"LM\"),J5,J6)*C6)+(IF(OR(C8=\"LL\",C8=\"ML\"),J5,J6)*(C6*(1-G16)))","v":1.4758333333333331},null,"Describe Trade Setup"]
[null,"Profit Target 2",null,0,{"$f":"IFERROR(IF(D13>0,IF($B$2=\"LONG\",(C13-$C$4),($C$4-C13))/$C$4,0),\"\")","v":0},"Est. Fees @ Even",{"$f":"(IF(OR(C8=\"LL\",C8=\"LM\"),J5,J6)*C6)+(IF(OR(C8=\"LL\",C8=\"ML\"),J5,J6)*(C6*(G9/C4)))","v":0.32588352638030627},null,"What support/resistance, indicators, price action patterns, or other system was used to identify this trade setup?"]
[null,"Profit Target 3",null,0,{"$f":"IFERROR(IF(D14>0,IF($B$2=\"LONG\",(C14-$C$4),($C$4-C14))/$C$4,0),\"\")","v":0}]
[null,"Profit Target 4",null,{"$f":"100%-SUM(D12:D14)","v":0},{"$f":"IFERROR(IF(D15>0,IF($B$2=\"LONG\",(C15-$C$4),($C$4-C15))/$C$4,0),\"\")","v":0},"Stop Loss",8500]
[null,"Blended Profit %",{"$f":"(E12*D12)+(E13*D13)+(E14*D14)+(E15*D15)","v":0.1111111111111111},null,null,"Loss % (at stop)",{"$f":"IFERROR(IF(B2=\"LONG\",(C4-G15),(G15-C4))/C4,\"\")","v":5.5555555555555552E-2},null,"Stop Loss Treatment",null,null,"Profit Taking Plan"]
[null,null,null,null,null,null,null,null,"Hard (automated), soft (manual), open hedge (counter-future, 2nd instrument, covered call / protective put), etc…",null,null,"Limit order, trailing stop loss, laddered scale out, etc…"]
[null,"Target Profit",null,"Risk Ratio",null,"Max Loss"]
[null,{"$f":"IFERROR((C16*C6)-(G11+G10),\"\")","v":302.28644444444444},null,{"$f":"IFERROR(_xlfn.CONCAT(ROUND(B19/F19,2),\" : 1\"),\"\")","v":"1.29 : 1"},null,{"$f":"IFERROR((G16*C6)+(G12+G10),\"\")","v":233.97772222222221}]

{"sheet":"Kelly","index":2,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[8,4,8,5]]}
[null,"Kelly Criterion / Ratio",null,null,null,null,null,null,null,null,0.125]
[]
[]
[null,null,"Win Rate Percentage (e.g. 40%)",null,0.4]
[]
[null,null,"Average Reward to Risk Ratio (e.g. 4.0  = 4:1)",null,3]
[]
[]
[null,null,"Kelly Ratio",null,{"$f":"IFERROR(((((E4*(E6+1))-1)/E6)),\"\")","v":0.20000000000000004}]
[null,null,null,null,{"$f":"IF(E9<0,\"Negative Expectancy, do not trade.\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF($E$9>0, _xlfn.CONCAT((ROUND($E$9/2*100, 0)),\"% Half Kelly\"),\"\")","v":"10% Half Kelly"}]
[null,null,null,null,{"$f":"IF($E$9>0, _xlfn.CONCAT((ROUND($E$9/4*100, 0)),\"% Quarter Kelly\"),\"\")","v":"5% Quarter Kelly"}]
[null,null,"* recommended risk per trade is a quarter Kelly"]

{"sheet":"README","index":3,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,3,28,9],[2,1,2,2],[4,1,4,2],[18,1,18,2],[24,1,24,2],[26,1,26,9]]}
[null,"Notes, Credits, and Donations",null,null,null,null,null,null,"Version",0.95]
[]
[null,"This spreadsheet was created by Kevin Dostalek (CryptoKick) over the course of 2017-2019 to assist with trading in both bull and bear market conditions. Understanding your risk and reward potential is critical for a disciplined aproach to trading consistency."]
[]
[null,"If you find the work done here helpful and would like to give something back to the author, please consider donating below or simply using some of the author's affiliate links, which does not cost you anything. In fact you usually gain discounts from doing it, but it also gives the author some support for his efforts. There are also courses available (see below)."]
[]
[null,"DONATE BTC","3Jm5rSbCQVHYSgVB1oqFPkpBv7ypCTyFGi"]
[null,"DONATE XLM","GAZEQP3RT2ESNCSF3CDFM743FDKLBWFU4LW47UWMKZPKP26ZXOUEHBR4"]
[]
[null,"TradingView Affiliate Link ","https://tradingview.go2cloud.org/SH3fT"]
[null,"CoinTracking Affiliate Link","https://cointracking.info?ref=K754189"]
[null,"BitMEX Affiliate Link","https://www.bitmex.com/register/mEiVy5"]
[]
[]
[]
[]
[null,"UDEMY Courses"]
[]
[null,"I currently have 1 course live on Udemy with plans for additional courses in the coming months. Here are the first two, please visit the link below to get DISCOUNT CODES for major % off retail prices."]
[]
[null,"Creating Custom Indicators in TradingView with PineScript"]
[null,"Creating TradingView Strategies for Backtesting and Automation"]
[]
[null,"You can find a full list of current and upcoming course (along with discount codes) at:"]
[null,"http://kickstudios.com/courses"]
[]
[null,"Thank you for reading and considering supporting my work!  If you donated/used link/bought course and don't care about being annonymous, please drop me a note at tips@kickstudios.com so I can personally thank you!"]
[]
[null,null,"The most current version of this spreadsheet tool can always be found at  ","http://kickstudios.com/tools"]