{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Kraken","BitMex","Sentiment","Volatility","Pivots","Kelly","Gann","BTC Prices","Hedge","README"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":1,"defined_names":24,"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":[[12,8,13,12],[16,8,18,9],[16,11,18,12],[1,1,1,6],[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,"Trade Balance",2000,null,"Front Run Calculator"]
[null,null,null,"DCA",null,null,null,null,"Max Loss Risk",0.2,null,{"$f":"$L$7+($L$7*M3)","v":5713.1286520175781},5.5100000000000001E-3]
[null,"Entry Price",5800,null,{"$f":"((C6*C4)+(D6*D4))/(C6+D6)","v":5800},"Position Volume",{"$f":"IFERROR(C6/C4,\"\")","v":1.1841379310344828},null,"Maker Fee",1.1999999999999999E-3,null,{"$f":"$L$7+($L$7*M4)","v":5701.1968262085493},3.4099999999999998E-3]
[null,"Leverage",5,null,{"$f":"((C6*C5)+(D6*D5))/(C6+D6)","v":5},"Margin Size",{"$f":"IFERROR(C6/C5,\"\")","v":1373.6},null,"Taker Fee",2.2000000000000001E-3,null,{"$f":"$L$7+($L$7*M5)","v":5693.810457850579},2.1099999999999999E-3]
[null,"Position Size",6868,null,{"$f":"C6+D6","v":6868},"Margin Call (80%)",6560.9924286546302,{"$f":"(J2+(C6*((G4*IF(B2=\"SHORT\",(G6*-1),G6))+IF(B2=\"SHORT\",C6,(C6*-1)))/C6))/(C6/C5)","v":2.1120559114735009},null,null,null,{"$f":"$L$7+($L$7*M6)","v":5689.2650003995204},1.31E-3]
[null,null,{"$f":"(J2*J3)-F19","v":-148.75319999999999},null,null,"Liquidation (40%)",7024.9924286546284,{"$f":"(J2+(C6*((G4*IF(B2=\"SHORT\",(G7*-1),G7))+IF(B2=\"SHORT\",C6,(C6*-1)))/C6))/(C6/C5)","v":2.5120559114734986},"Finance Fee",1E-4,null,5681.8218138234115,"target"]
[null,"Order Type","LL",null,null,"Break Even Price",{"$f":"IFERROR(((C6+(IF(B2=\"SHORT\",(G13+G10)*-1,G13+G10)))/C6)*C4,\"\")","v":5918.1781861765885},null,"Rollover (h)",4,null,{"$f":"$L$7+($L$7*M8)","v":5674.3786272473026},-1.31E-3]
[null,"Expected Duration",720,"hours",null,{"$f":"G8-G9","v":236.35637235317608},5681.8218138234124,null,null,null,null,{"$f":"$L$7+($L$7*M9)","v":5669.833169796244},-2.1099999999999999E-3]
[null,null,null,null,null,"Estimated Finance",{"$f":"(CEILING(C9/J8,1)*J7)*C6","v":123.62400000000001},null,"Confidence",0.5,null,{"$f":"$L$7+($L$7*M10)","v":5662.4468014382737},-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":22.522303448275864},null,null,null,null,{"$f":"$L$7+($L$7*M11)","v":5650.5149756292449},-5.5100000000000001E-3]
[null,"Profit Target 1",10050,1,{"$f":"IFERROR(IF(D12>0,IF($B$2=\"LONG\",(C12-$C$4),($C$4-C12))/$C$4,0),\"\")","v":0.73275862068965514},"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":16.000071724137932},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":16.315272872552939},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",5460]
[null,"Blended Profit %",{"$f":"(E12*D12)+(E13*D13)+(E14*D14)+(E15*D15)","v":0.73275862068965514},null,null,"Loss % (at stop)",{"$f":"IFERROR(IF(B2=\"LONG\",(C4-G15),(G15-C4))/C4,\"\")","v":5.8620689655172413E-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":4886.4399034482758},null,{"$f":"IFERROR(_xlfn.CONCAT(ROUND(B19/F19,2),\" : 1\"),\"\")","v":"8.9 : 1"},null,{"$f":"IFERROR((G16*C6)+(G11+G10),\"\")","v":548.75319999999999}]

{"sheet":"BitMex","index":1,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,8,18,9],[16,11,18,12],[12,8,13,12],[1,1,1,6],[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,"Equity Value",{"$f":"J3*C4","v":19160.375},null,"Front Run Calculator"]
[null,null,null,"DCA",null,null,null,null,"Wallet Balance",3.25,null,{"$f":"$L$7+($L$7*M3)","v":5960.6632799999998},5.5100000000000001E-3]
[null,"Entry Price",5895.5,null,{"$f":"((C6*C4)+(D6*D4))/(C6+D6)","v":5895.5},"Position Volume",{"$f":"IFERROR(C6/C4,\"\")","v":8.481044864727334},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":21.405007170523096},null,null,"Margin Size",{"$f":"IFERROR(C6/C5/C4,\"\")","v":0.39621780068387963},null,"Maker Fee",-2.5000000000000001E-4,null,{"$f":"$L$7+($L$7*M5)","v":5940.5080799999996},2.1099999999999999E-3]
[null,"Position Size",50000,null,{"$f":"C6+D6","v":50000},{"$f":"_xlfn.CONCAT(\"Liq. Price at \",ROUND(C5,0),\" lev\")","v":"Liq. Price at 21 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":6153.5},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":-1952.6945439318124},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":9517.5},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":5894},null,"Rollover (h)",8,null,{"$f":"$L$7+($L$7*M8)","v":5920.2343199999996},-1.31E-3]
[null,"Expected Duration",8,"hours",null,{"$f":"G8-G9","v":1679.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":18.5},null,"Confidence",0.65,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":49.135993554405907},null,null,null,null,{"$f":"$L$7+($L$7*M11)","v":5895.3367200000002},-5.5100000000000001E-3]
[null,"Profit Target 1",2101,1,{"$f":"IFERROR(IF(D12>0,IF($B$2=\"LONG\",(C12-$C$4),($C$4-C12))/$C$4,0),\"\")","v":0.64362649478415745},"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":23.279408023068441},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":14.307349477053393},null,"Major algo swing laddered entry setup between .618 and .65"]
[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",6166]
[null,"Blended Profit %",{"$f":"(E12*D12)+(E13*D13)+(E14*D14)+(E15*D15)","v":0.64362649478415745},null,null,"Loss % (at stop)",{"$f":"IFERROR(IF(B2=\"LONG\",(C4-G15),(G15-C4))/C4,\"\")","v":4.5882452718174878E-2},null,"Stop Loss Treatment",null,null,"Profit Taking Plan"]
[null,null,null,null,null,null,null,null,"Will take a soft stop if 15m candle closes above the .65 (5906).  Hard stop loss at the lesser of (liquidation-7) or 6160.",null,null,"Taking position on June 28 XBT futures. Will probably take partial profits on the way down and re-enter on pullbacks.  Time and wave structure will reveal better plans on the way down."]
[null,"Target Profit",null,"Risk Ratio",null,"Max Loss"]
[null,{"$f":"IFERROR((C16*C6)-(G11+G10),\"\")","v":32113.688745653468},null,{"$f":"IFERROR(_xlfn.CONCAT(ROUND(B19/F19,2),\" : 1\"),\"\")","v":"13.75 : 1"},null,{"$f":"IFERROR((G16*C6)+(G12+G10),\"\")","v":2335.9020439318124}]

{"sheet":"Sentiment","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[6,1,6,4]]}
[null,"BTC Sentiment"]
[]
[null,null,"Current Sentiment ",{"$f":"'BTC Prices'!N28/100","v":0.38828090228636597}]
[null,null,"Current BitMEX Price",{"$f":"BitMEX_LastPrice[BitMEX_LastPrice]","v":7586}]
[null,null,"Current Market Index",{"$f":"VALUE('BTC Prices'!N29)","v":7641.2896834599997}]
[]
[null,"Rolling-60 Minute Sentiment Price Range Predictions",null,null,null,null,"This dashboard will have much more on"]
[null,null,null,null,null,null,"it in the near future, but for now enjoy"]
[null,null,"Lower","Median","Upper",null,"these sentiment-based price predictions!"]
[null,"BitMEX Adjusted",{"$f":"HourlySentimentLowerPricePrediction[HourlySentimentLowerPricePrediction]-'BTC Prices'!P6","v":7408.0308290516214},{"$f":"HourlySentimentMedianPricePrediction8[HourlySentimentMedianPricePrediction (2)]-'BTC Prices'!P6","v":7536.1081919180042},{"$f":"HourlySentimentUpperPricePrediction9[HourlySentimentUpperPricePrediction (2)]-'BTC Prices'!P6","v":7664.185554784387}]
[null,"Broad Market Index",{"$f":"HourlySentimentLowerPricePrediction[HourlySentimentLowerPricePrediction]","v":7463.320512511621},{"$f":"HourlySentimentMedianPricePrediction8[HourlySentimentMedianPricePrediction (2)]","v":7591.3978753780038},{"$f":"HourlySentimentUpperPricePrediction9[HourlySentimentUpperPricePrediction (2)]","v":7719.4752382443867}]
[null,null,"Last Updated:",{"$f":"LastTimestamp[[#Totals],[LastTimestamp]]","v":"2019-06-04T22:39:00"},"(UTC)"]
[null,null,null,"*Updates every 5 minutes"]

{"sheet":"Volatility","index":3,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,5,2,7],[18,5,18,7],[7,5,7,7],[8,3,8,9],[9,2,9,10],[14,7,14,8],[14,4,14,5],[4,1,4,2]]}
[null,"BTC Volatility"]
[]
[null,null,"Historical Volatility",{"$f":"L4*SQRT(365)","v":0.78495888712062056},null,{"$f":"'BTC Prices'!A2","v":"2019-06-04"},null,null,null,null,"Sample Size",15]
[null,null,"Implied Volatility (Deribit)",{"$f":"'BTC Prices'!N10","v":0.88695000000000002},null,null,null,null,null,null,"Volatility Mean",{"$f":"_xlfn.STDEV.S('BTC Prices'!I2:I16)","v":4.1086625976872404E-2}]
[null,{"$f":"_xlfn.CONCAT('BTC Prices'!N6,CHAR(13),CHAR(10),'BTC Prices'!N8)","v":"BTC-7JUN19-7500-C\r\nBTC-7JUN19-7750-P"},null,null,null,null,"Today's Open"]
[null,{"$f":"IF('BTC Prices'!P3<B10, _xlfn.CONCAT(\"Current: \", ROUND('BTC Prices'!P3,0)), \"\")","v":""},{"$f":"IF(AND(VALUE('BTC Prices'!P3)<C9,VALUE('BTC Prices'!P3)>B10), _xlfn.CONCAT(\"Current: \", ROUND('BTC Prices'!P3,0)), \"\")","v":""},{"$f":"IF(AND(VALUE('BTC Prices'!P3)<E8,VALUE('BTC Prices'!P3)>C9), _xlfn.CONCAT(\"Current: \", ROUND('BTC Prices'!P3,0)), \"\")","v":"Current: 7586"},null,{"$f":"IF(AND(VALUE('BTC Prices'!P3)<G6,VALUE('BTC Prices'!P3)>E8), _xlfn.CONCAT(\"Current: \", ROUND('BTC Prices'!P3,0)), \"\")","v":""},{"$f":"'BTC Prices'!C2","v":8100.5},{"$f":"IF(AND(VALUE('BTC Prices'!P3)>G6,VALUE('BTC Prices'!P3)<I8), _xlfn.CONCAT(\"Current: \", ROUND('BTC Prices'!P3,0)), \"\")","v":""},null,{"$f":"IF(AND(VALUE('BTC Prices'!P3)>I8,VALUE('BTC Prices'!P3)<K9), _xlfn.CONCAT(\"Current: \", ROUND('BTC Prices'!P3,0)), \"\")","v":""},{"$f":"IF(AND(VALUE('BTC Prices'!P3)>K9,VALUE('BTC Prices'!P3)<L10), _xlfn.CONCAT(\"Current: \", ROUND('BTC Prices'!P3,0)), \"\")","v":""},{"$f":"IF(VALUE('BTC Prices'!P3)>L10, _xlfn.CONCAT(\"Current: \", ROUND('BTC Prices'!P3,0)), \"\")","v":""}]
[null,{"$f":"_xlfn.CONCAT(\"3α (\", ROUND(ABS($G$6-B10)/$G$6*100,2), \"%)\")","v":"3α (12.33%)"},{"$f":"_xlfn.CONCAT(\"2α (\", ROUND(ABS($G$6-C9)/$G$6*100,2), \"%)\")","v":"2α (8.22%)"},null,{"$f":"_xlfn.CONCAT(\"1α (\", ROUND(ABS($G$6-E8)/$G$6*100,2), \"%)\")","v":"1α (4.11%)"},null,null,null,{"$f":"_xlfn.CONCAT(\"1α (\", ROUND(ABS($G$6-I8)/$G$6*100,2), \"%)\")","v":"1α (4.11%)"},null,{"$f":"_xlfn.CONCAT(\"2α (\", ROUND(ABS($G$6-K9)/$G$6*100,2), \"%)\")","v":"2α (8.22%)"},{"$f":"_xlfn.CONCAT(\"3α (\", ROUND(ABS($G$6-L10)/$G$6*100,2), \"%)\")","v":"3α (12.33%)"}]
[null,null,null,null,{"$f":"$G$6-($G$6*$L$4*1)","v":7767.6777862743447},{"$f":"_xlfn.CONCAT(ROUND(I8-E8,0), \" (68%)\")","v":"666 (68%)"},null,null,{"$f":"$G$6+($G$6*$L$4*1)","v":8433.3222137256544}]
[null,null,{"$f":"$G$6-($G$6*$L$4*2)","v":7434.8555725486904},{"$f":"_xlfn.CONCAT(ROUND(K9-C9,0), \" (95%)\")","v":"1331 (95%)"},null,null,null,null,null,null,{"$f":"$G$6+($G$6*$L$4*2)","v":8766.1444274513105}]
[null,{"$f":"$G$6-($G$6*$L$4*3)","v":7102.0333588230351},{"$f":"_xlfn.CONCAT(ROUND(L10-B10,0), \" (99%)\")","v":"1997 (99%)"},null,null,null,null,null,null,null,null,{"$f":"$G$6+($G$6*$L$4*3)","v":9098.9666411769649}]
[]
[null,{"$f":"$G$6 - ((_xlfn.T.INV.2T(0.0028,($L$3-1)) * _xlfn.STDEV.S('BTC Prices'!B2:B16)))","v":6570.4748249294971},{"$f":"$G$6 - ((_xlfn.T.INV.2T(0.0456,($L$3-1)) * _xlfn.STDEV.S('BTC Prices'!B2:B16)))","v":7172.4757402455925},null,{"$f":"$G$6 - ((_xlfn.T.INV.2T(0.3174,($L$3-1)) * _xlfn.STDEV.S('BTC Prices'!B2:B16)))","v":7661.9695120398765},null,"T-Distribution",null,{"$f":"$G$6 + ((_xlfn.T.INV.2T(0.3174,($L$3-1)) * _xlfn.STDEV.S('BTC Prices'!B2:B16)))","v":8539.0304879601244},null,{"$f":"$G$6 + ((_xlfn.T.INV.2T(0.0456,($L$3-1)) * _xlfn.STDEV.S('BTC Prices'!B2:B16)))","v":9028.5242597544075},{"$f":"$G$6 + ((_xlfn.T.INV.2T(0.0028,($L$3-1)) * _xlfn.STDEV.S('BTC Prices'!B2:B16)))","v":9630.5251750705029}]
[]
[null,null,null,null,null,null,"ATR",null,null,null,"Periods",14]
[null,null,null,null,"measured from yesterday's low",null,{"$f":"AVERAGE('BTC Prices'!J2:J15)","v":500.17857142857144},"measured from yesterday's high"]
[null,"2.5 x","2 x","1.5 x","1 x","0.5 x",{"$f":"G15/G6","v":6.1746629396774451E-2},"0.5 x","1 x","1.5 x","2 x","2.5 x"]
[null,{"$f":"'BTC Prices'!E3-($G$15*2.5)","v":6779.5535714285716},{"$f":"'BTC Prices'!E3-($G$15*2)","v":7029.6428571428569},{"$f":"'BTC Prices'!E3-($G$15*1.5)","v":7279.7321428571431},{"$f":"'BTC Prices'!E3-($G$15*1)","v":7529.8214285714284},{"$f":"'BTC Prices'!E3-($G$15*0.5)","v":7779.9107142857147},null,{"$f":"'BTC Prices'!D3+($G$15*0.5)","v":8994.5892857142862},{"$f":"'BTC Prices'!D3+($G$15*1)","v":9244.6785714285706},{"$f":"'BTC Prices'!D3+($G$15*1.5)","v":9494.7678571428569},{"$f":"'BTC Prices'!D3+($G$15*2)","v":9744.8571428571431},{"$f":"'BTC Prices'!D3+($G$15*2.5)","v":9994.9464285714294}]
[null,{"$f":"$G$6-($G$15*2.5)","v":6850.0535714285716},{"$f":"$G$6-($G$15*2)","v":7100.1428571428569},{"$f":"$G$6-($G$15*1.5)","v":7350.2321428571431},{"$f":"$G$6-($G$15*1)","v":7600.3214285714284},{"$f":"$G$6-($G$15*0.5)","v":7850.4107142857147},null,{"$f":"$G$6+($G$15*0.5)","v":8350.5892857142862},{"$f":"$G$6+($G$15*1)","v":8600.6785714285706},{"$f":"$G$6+($G$15*1.5)","v":8850.7678571428569},{"$f":"$G$6+($G$15*2)","v":9100.8571428571431},{"$f":"$G$6+($G$15*2.5)","v":9350.9464285714294}]
[null,null,null,null,null,"measured from today's open"]

{"sheet":"Pivots","index":4,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,4,16,4]]}
[null,"BTC Pivots"]
[]
[null,null,null,{"$f":"IF(BitMEX_LastPrice[BitMEX_LastPrice]>C4,BitMEX_LastPrice[BitMEX_LastPrice],\"\")","v":""},"Current Price",null,"Today's Open",{"$f":"'BTC Prices'!C2","v":8100.5}]
[null,"R3",{"$f":"C8+(BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]])","v":8856.5},{"$f":"IF(BitMEX_LastPrice[BitMEX_LastPrice]=C4,C4,\"\")","v":""},null,null,"Today's High",{"$f":"'BTC Prices'!D2","v":8100.5}]
[null,null,null,{"$f":"IF(AND(BitMEX_LastPrice[BitMEX_LastPrice]<C4,BitMEX_LastPrice[BitMEX_LastPrice]>C6),BitMEX_LastPrice[BitMEX_LastPrice],\"\")","v":""},null,null,"Today's Low",{"$f":"'BTC Prices'!E2","v":7500}]
[null,"R2",{"$f":"C10+('BTC Prices'!D3-'BTC Prices'!E3)","v":9006},{"$f":"IF(BitMEX_LastPrice[BitMEX_LastPrice]=C6,C6,\"\")","v":""}]
[null,null,null,{"$f":"IF(AND(BitMEX_LastPrice[BitMEX_LastPrice]<C6,BitMEX_LastPrice[BitMEX_LastPrice]>C8),BitMEX_LastPrice[BitMEX_LastPrice],\"\")","v":""}]
[null,"R1",{"$f":"C10+(C10-'BTC Prices'!E3)","v":8553},{"$f":"IF(BitMEX_LastPrice[BitMEX_LastPrice]=C8,C8,\"\")","v":""},null,null,null,"All data on this page is taken from"]
[null,null,null,{"$f":"IF(AND(BitMEX_LastPrice[BitMEX_LastPrice]<C8,BitMEX_LastPrice[BitMEX_LastPrice]>C10),BitMEX_LastPrice[BitMEX_LastPrice],\"\")","v":""},null,null,null,"BitMEX"]
[null,"Daily Pivot",{"$f":"('BTC Prices'!D3+'BTC Prices'!E3+'BTC Prices'!B3)/3","v":8291.5},{"$f":"IF(BitMEX_LastPrice[BitMEX_LastPrice]=C10,C10,\"\")","v":""}]
[null,null,null,{"$f":"IF(AND(BitMEX_LastPrice[BitMEX_LastPrice]<C10,BitMEX_LastPrice[BitMEX_LastPrice]>C12),BitMEX_LastPrice[BitMEX_LastPrice],\"\")","v":""}]
[null,"S1",{"$f":"C10-('BTC Prices'!D3-C10)","v":7838.5},{"$f":"IF(BitMEX_LastPrice[BitMEX_LastPrice]=C12,C12,\"\")","v":""}]
[null,null,null,{"$f":"IF(AND(BitMEX_LastPrice[BitMEX_LastPrice]<C12,BitMEX_LastPrice[BitMEX_LastPrice]>C14),BitMEX_LastPrice[BitMEX_LastPrice],\"\")","v":7586}]
[null,"S2",{"$f":"C10-('BTC Prices'!D3-'BTC Prices'!E3)","v":7577},{"$f":"IF(BitMEX_LastPrice[BitMEX_LastPrice]=C14,C14,\"\")","v":""}]
[null,null,null,{"$f":"IF(AND(BitMEX_LastPrice[BitMEX_LastPrice]<C14,BitMEX_LastPrice[BitMEX_LastPrice]>C16),BitMEX_LastPrice[BitMEX_LastPrice],\"\")","v":""}]
[null,"S3",{"$f":"C12-('BTC Prices'!D3-'BTC Prices'!E3)","v":7124},{"$f":"IF(BitMEX_LastPrice[BitMEX_LastPrice]=C16,C16,\"\")","v":""}]
[null,null,null,{"$f":"IF(BitMEX_LastPrice[BitMEX_LastPrice]<C16,BitMEX_LastPrice[BitMEX_LastPrice],\"\")","v":""}]

{"sheet":"Kelly","index":5,"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.33]
[]
[null,null,"Average Reward to Risk Ratio (e.g. 4.0  = 4:1)",null,10]
[]
[]
[null,null,"Kelly Ratio",null,{"$f":"IFERROR(((((E4*(E6+1))-1)/E6)),\"\")","v":0.26300000000000001}]
[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":"13% Half Kelly"}]
[null,null,null,null,{"$f":"IF($E$9>0, _xlfn.CONCAT((ROUND($E$9/4*100, 0)),\"% Quarter Kelly\"),\"\")","v":"7% Quarter Kelly"}]
[null,null,"* recommended risk per trade is a quarter Kelly"]

{"sheet":"Gann","index":6,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,6,2,7]]}
[null,"Gann Square of 9 Calculator",null,null,null,null,null,null,null,null,null,0.125]
[null,null,null,null,null,null,null,null,null,null,null,0.25]
[null,null,null,null,null,"Current Price",null,null,null,null,null,0.375]
[null,null,null,{"$f":"E4-1","v":76},{"$f":"FLOOR(G4,1)","v":77},6077,{"$f":"SQRT(F4)","v":77.955115290787688},{"$f":"IF(INT(G4)=G4,G4+1,CEILING(G4,1))","v":78},{"$f":"H4+1","v":79},null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,0.625]
[null,{"$f":"($H$4+L2)*($H$4+L2)","v":6123.0625},{"$f":"IF(AND($F$4>=B6,$F$4<E6),VALUE($F$4),\"\")","v":""},null,{"$f":"($H$4+L3)*($H$4+L3)","v":6142.640625},{"$f":"IF(AND($F$4>=E6,$F$4<H6),VALUE($F$4),\"\")","v":""},null,{"$f":"($H$4+L4)*($H$4+L4)","v":6162.25},null,"Buy at/above",{"$f":"IF(C10<>\"\",VALUE(C9),IF(C8<>\"\",VALUE(C7),IF(D7<>\"\",VALUE(E7),IF(F7<>\"\",VALUE(G7),IF(G8<>\"\",VALUE(G9),IF(G10<>\"\",VALUE(G11),IF(F11<>\"\",VALUE(E11),IF(D11<>\"\",VALUE(C11),IF(B11<>\"\",VALUE(B9),IF(B8<>\"\",VALUE(B6),IF(C6<>\"\",VALUE(E6),IF(F6<>\"\",VALUE(H6),IF(H7<>\"\",VALUE(H9),IF(H10<>\"\",VALUE(H12),IF(G12<>\"\",VALUE(E12),IF(D12<>\"\",VALUE(B12),\"\"))))))))))))))))","v":6084},0.75,"Sell at/below",{"$f":"IF(C10<>\"\",VALUE(D10),IF(C8<>\"\",VALUE(C9),IF(D7<>\"\",VALUE(C7),IF(F7<>\"\",VALUE(E7),IF(G8<>\"\",VALUE(G7),IF(G10<>\"\",VALUE(G9),IF(F11<>\"\",VALUE(G11),IF(D11<>\"\",VALUE(E11),IF(B11<>\"\",VALUE(C11),IF(B8<>\"\",VALUE(B9),IF(C6<>\"\",VALUE(B6),IF(F6<>\"\",VALUE(E6),IF(H7<>\"\",VALUE(H6),IF(H10<>\"\",VALUE(H9),IF(G12<>\"\",VALUE(H12),IF(D12<>\"\",VALUE(E12),\"\"))))))))))))))))","v":6064.515625}]
[null,null,{"$f":"($E$4+L2)*($E$4+L2)","v":5967.5625},{"$f":"IF(AND($F$4>=C7,$F$4<E7),VALUE($F$4),\"\")","v":""},{"$f":"($E$4+L3)*($E$4+L3)","v":5986.890625},{"$f":"IF(AND($F$4>=E7,$F$4<G7),VALUE($F$4),\"\")","v":""},{"$f":"($E$4+L4)*($E$4+L4)","v":6006.25},{"$f":"IF(AND($F$4>=H6,$F$4<H9),VALUE($F$4),\"\")","v":""},null,"Target 1",{"$f":"J14*0.9995","v":6100.4638671875},0.875,"Target 1",{"$f":"J17*1.0005","v":6048.0850312499997}]
[null,{"$f":"IF(AND($F$4>=B9,$F$4<B6),VALUE($F$4),\"\")","v":""},{"$f":"IF(AND($F$4>=C9,$F$4<C7),VALUE($F$4),\"\")","v":""},{"$f":"POWER(($D$4+L2),2)","v":5814.0625},{"$f":"POWER(($D$4+L3),2)","v":5833.140625},{"$f":"POWER(($D$4+L4),2)","v":5852.25},{"$f":"IF(AND($F$4>=G7,$F$4<G9),VALUE($F$4),\"\")","v":""},null,null,"Target 2",{"$f":"K14*0.9995","v":6120.0009687500005},1,"Target 2",{"$f":"K17*1.0005","v":6028.6534453124996}]
[null,{"$f":"($H$4+L1)*($H$4+L1)","v":6103.515625},{"$f":"($E$4+L1)*($E$4+L1)","v":5948.265625},{"$f":"POWER(($D$4+L1),2)","v":5795.015625},{"$f":"POWER(D4,2)","v":5776},{"$f":"POWER(($D$4+L5),2)","v":5871.390625},{"$f":"($E$4+L5)*($E$4+L5)","v":6025.640625},{"$f":"($H$4+L5)*($H$4+L5)","v":6181.890625},null,"Target 3",{"$f":"L14*0.9995","v":6139.5693046875003},null,"Target 3",{"$f":"L17*1.0005","v":6009.2531249999993}]
[null,null,{"$f":"IF(AND($F$4>=D10,$F$4<C9),VALUE($F$4),\"\")","v":""},{"$f":"POWER(($D$4+L8),2)","v":5929},{"$f":"POWER(($D$4+L7),2)","v":5909.765625},{"$f":"POWER(($D$4+L6),2)","v":5890.5625},{"$f":"IF(AND($F$4>=G9,$F$4<G11),VALUE($F$4),\"\")","v":""},{"$f":"IF(AND($F$4>=H9,$F$4<H12),VALUE($F$4),\"\")","v":""},null,"Target 4",{"$f":"M14*0.9995","v":6159.1688750000003},null,"Target 4",{"$f":"M17*1.0005","v":5989.8840703124997}]
[null,{"$f":"IF(AND($F$4>=C11,$F$4<B9),VALUE($F$4),\"\")","v":""},{"$f":"($E$4+L8)*($E$4+L8)","v":6084},{"$f":"IF(AND($F$4>=E11,$F$4<C11),VALUE($F$4),\"\")","v":6077},{"$f":"($E$4+L7)*($E$4+L7)","v":6064.515625},{"$f":"IF(AND($F$4>=G11,$F$4<E11),VALUE($F$4),\"\")","v":""},{"$f":"($E$4+L6)*($E$4+L6)","v":6045.0625},null,null,"Target 5",{"$f":"N14*0.9995","v":6178.7996796875004},null,"Target 5",{"$f":"N17*1.0005","v":5970.54628125}]
[null,{"$f":"($H$4+L8)*($H$4+L8)","v":6241},null,{"$f":"IF(AND($F$4>=E12,$F$4<B12),VALUE($F$4),\"\")","v":""},{"$f":"($H$4+L7)*($H$4+L7)","v":6221.265625},null,{"$f":"IF(AND($F$4>=H12,$F$4<E12),VALUE($F$4),\"\")","v":""},{"$f":"($H$4+L6)*($H$4+L6)","v":6201.5625}]
[null,null,null,null,null,null,null,null,null,"Resistance 1","Resistance 2","Resistance 3","Resistance 4","Resistance 5"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(C10<>\"\",VALUE(C7),IF(C8<>\"\",VALUE(E7),IF(D7<>\"\",VALUE(G7),IF(F7<>\"\",VALUE(G9),IF(G8<>\"\",VALUE(G11),IF(G10<>\"\",VALUE(E11),IF(F11<>\"\",VALUE(C11),IF(D11<>\"\",VALUE(B9),IF(B11<>\"\",VALUE(B6),IF(B8<>\"\",VALUE(E6),IF(C6<>\"\",VALUE(H6),IF(F6<>\"\",VALUE(H9),IF(H7<>\"\",VALUE(H12),IF(H10<>\"\",VALUE(E12),IF(G12<>\"\",VALUE(B12),IF(D12<>\"\",VALUE(B12),\"\"))))))))))))))))","v":6103.515625},{"$f":"IF(C10<>\"\",VALUE(E7),IF(C8<>\"\",VALUE(G7),IF(D7<>\"\",VALUE(G9),IF(F7<>\"\",VALUE(G11),IF(G8<>\"\",VALUE(E11),IF(G10<>\"\",VALUE(C11),IF(F11<>\"\",VALUE(B9),IF(D11<>\"\",VALUE(B6),IF(B11<>\"\",VALUE(E6),IF(B8<>\"\",VALUE(H6),IF(C6<>\"\",VALUE(H9),IF(F6<>\"\",VALUE(H12),IF(H7<>\"\",VALUE(E12),IF(H10<>\"\",VALUE(B12),IF(G12<>\"\",VALUE(B12),IF(D12<>\"\",VALUE(B12),\"\"))))))))))))))))","v":6123.0625},{"$f":"IF(C10<>\"\",VALUE(G7),IF(C8<>\"\",VALUE(G9),IF(D7<>\"\",VALUE(G11),IF(F7<>\"\",VALUE(E11),IF(G8<>\"\",VALUE(C11),IF(G10<>\"\",VALUE(B9),IF(F11<>\"\",VALUE(B6),IF(D11<>\"\",VALUE(E6),IF(B11<>\"\",VALUE(H6),IF(B8<>\"\",VALUE(H9),IF(C6<>\"\",VALUE(H12),IF(F6<>\"\",VALUE(E12),IF(H7<>\"\",VALUE(B12),IF(H10<>\"\",VALUE(B12),IF(G12<>\"\",VALUE(B12),IF(D12<>\"\",VALUE(B12),\"\"))))))))))))))))","v":6142.640625},{"$f":"IF(C10<>\"\",VALUE(G9),IF(C8<>\"\",VALUE(G11),IF(D7<>\"\",VALUE(E11),IF(F7<>\"\",VALUE(C11),IF(G8<>\"\",VALUE(B9),IF(G10<>\"\",VALUE(B6),IF(F11<>\"\",VALUE(E6),IF(D11<>\"\",VALUE(H6),IF(B11<>\"\",VALUE(H9),IF(B8<>\"\",VALUE(H12),IF(C6<>\"\",VALUE(E12),IF(F6<>\"\",VALUE(B12),IF(H7<>\"\",VALUE(B12),IF(H10<>\"\",VALUE(B12),IF(G12<>\"\",VALUE(B12),IF(D12<>\"\",VALUE(B12),\"\"))))))))))))))))","v":6162.25},{"$f":"IF(C10<>\"\",VALUE(G11),IF(C8<>\"\",VALUE(E11),IF(D7<>\"\",VALUE(C11),IF(F7<>\"\",VALUE(B9),IF(G8<>\"\",VALUE(B6),IF(G10<>\"\",VALUE(E6),IF(F11<>\"\",VALUE(H6),IF(D11<>\"\",VALUE(H9),IF(B11<>\"\",VALUE(H12),IF(B8<>\"\",VALUE(E12),IF(C6<>\"\",VALUE(B12),IF(F6<>\"\",VALUE(B12),IF(H7<>\"\",VALUE(B12),IF(H10<>\"\",VALUE(B12),IF(G12<>\"\",VALUE(B12),IF(D12<>\"\",VALUE(B12),\"\"))))))))))))))))","v":6181.890625}]
[]
[null,null,null,null,null,null,null,null,null,"Support 1","Support 2","Support 3","Support 4","Support 5"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(C10<>\"\",VALUE(E10),IF(C8<>\"\",VALUE(D10),IF(D7<>\"\",VALUE(C9),IF(F7<>\"\",VALUE(C7),IF(G8<>\"\",VALUE(E7),IF(G10<>\"\",VALUE(G7),IF(F11<>\"\",VALUE(G9),IF(D11<>\"\",VALUE(G11),IF(B11<>\"\",VALUE(E11),IF(B8<>\"\",VALUE(C11),IF(C6<>\"\",VALUE(B9),IF(F6<>\"\",VALUE(B6),IF(H7<>\"\",VALUE(E6),IF(H10<>\"\",VALUE(H6),IF(G12<>\"\",VALUE(H9),IF(D12<>\"\",VALUE(H12),\"\"))))))))))))))))","v":6045.0625},{"$f":"IF(C10<>\"\",VALUE(F10),IF(C8<>\"\",VALUE(E10),IF(D7<>\"\",VALUE(D10),IF(F7<>\"\",VALUE(C9),IF(G8<>\"\",VALUE(C7),IF(G10<>\"\",VALUE(E7),IF(F11<>\"\",VALUE(G7),IF(D11<>\"\",VALUE(G9),IF(B11<>\"\",VALUE(G11),IF(B8<>\"\",VALUE(E11),IF(C6<>\"\",VALUE(C11),IF(F6<>\"\",VALUE(B9),IF(H7<>\"\",VALUE(B6),IF(H10<>\"\",VALUE(E6),IF(G12<>\"\",VALUE(H6),IF(D12<>\"\",VALUE(H9),\"\"))))))))))))))))","v":6025.640625},{"$f":"IF(C10<>\"\",VALUE(F9),IF(C8<>\"\",VALUE(F10),IF(D7<>\"\",VALUE(E10),IF(F7<>\"\",VALUE(D10),IF(G8<>\"\",VALUE(C9),IF(G10<>\"\",VALUE(C7),IF(F11<>\"\",VALUE(E7),IF(D11<>\"\",VALUE(G7),IF(B11<>\"\",VALUE(G9),IF(B8<>\"\",VALUE(G11),IF(C6<>\"\",VALUE(E11),IF(F6<>\"\",VALUE(C11),IF(H7<>\"\",VALUE(B9),IF(H10<>\"\",VALUE(B6),IF(G12<>\"\",VALUE(E6),IF(D12<>\"\",VALUE(H6),\"\"))))))))))))))))","v":6006.25},{"$f":"IF(C10<>\"\",VALUE(F8),IF(C8<>\"\",VALUE(F9),IF(D7<>\"\",VALUE(F10),IF(F7<>\"\",VALUE(E10),IF(G8<>\"\",VALUE(D10),IF(G10<>\"\",VALUE(C9),IF(F11<>\"\",VALUE(C7),IF(D11<>\"\",VALUE(E7),IF(B11<>\"\",VALUE(G7),IF(B8<>\"\",VALUE(G9),IF(C6<>\"\",VALUE(G11),IF(F6<>\"\",VALUE(E11),IF(H7<>\"\",VALUE(C11),IF(H10<>\"\",VALUE(B9),IF(G12<>\"\",VALUE(B6),IF(D12<>\"\",VALUE(E6),\"\"))))))))))))))))","v":5986.890625},{"$f":"IF(C10<>\"\",VALUE(E8),IF(C8<>\"\",VALUE(F8),IF(D7<>\"\",VALUE(F9),IF(F7<>\"\",VALUE(F10),IF(G8<>\"\",VALUE(E10),IF(G10<>\"\",VALUE(D10),IF(F11<>\"\",VALUE(C9),IF(D11<>\"\",VALUE(C7),IF(B11<>\"\",VALUE(E7),IF(B8<>\"\",VALUE(G7),IF(C6<>\"\",VALUE(G9),IF(F6<>\"\",VALUE(G11),IF(H7<>\"\",VALUE(E11),IF(H10<>\"\",VALUE(C11),IF(G12<>\"\",VALUE(B9),IF(D12<>\"\",VALUE(B6),\"\"))))))))))))))))","v":5967.5625}]

{"sheet":"BTC Prices","index":7,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
["Date","Price","Open","High","Low","Vol.","Change %",null,"Return","ATR",null,null,"Deribit Stuff",null,null,"BitMEX Stuff"]
["2019-06-04",7589,8100.5,8100.5,7500,"-",-6.3100000000000003E-2,null,{"$f":"(B3/BTCDailyOHLC[[#This Row],[Price]])-1","v":6.7334299644221884E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B3), ABS(BTCDailyOHLC[[#This Row],[Low]]-B3))","v":600.5},null,null,"Current BTC Index Price",{"$f":"deribit_index()","v":7587.13},null,"BitMEX_LastPrice"]
["2019-06-03",8100,8737.5,8744.5,8030,"-",-7.2999999999999995E-2,null,{"$f":"(B4/BTCDailyOHLC[[#This Row],[Price]])-1","v":7.8765432098765409E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B4), ABS(BTCDailyOHLC[[#This Row],[Low]]-B4))","v":714.5},null,null,"Current BTC Perpetual Price",{"$f":"deribit_price(\"BTC-PERPETUAL\")","v":7584.25},null,7586]
["2019-06-02",8738,8555,8852.5,8549,"-",2.1299999999999999E-2,null,{"$f":"(B5/BTCDailyOHLC[[#This Row],[Price]])-1","v":-2.0885786221103264E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B5), ABS(BTCDailyOHLC[[#This Row],[Low]]-B5))","v":303.5},null,null,"Next Weekly Options Expiry",{"$f":"IF(WEEKDAY(TODAY()+1)>5,7,0)+TODAY()+1+(6-WEEKDAY(TODAY()+1))","v":"2019-06-07"}]
["2019-06-01",8555.5,8546,8636,8456,"-",5.9999999999999995E-4,null,{"$f":"(B6/BTCDailyOHLC[[#This Row],[Price]])-1","v":-6.4286131728130691E-4},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B6), ABS(BTCDailyOHLC[[#This Row],[Low]]-B6))","v":180},null,null,"Closest ITM Options Strike",{"$f":"FLOOR((N3/250),1)*250","v":7500},null,"Index Offset"]
["2019-05-31",8550,8274,8579,8119,"-",3.3300000000000003E-2,null,{"$f":"(B7/BTCDailyOHLC[[#This Row],[Price]])-1","v":-3.2222222222222263E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B7), ABS(BTCDailyOHLC[[#This Row],[Low]]-B7))","v":460},null,null,"Instrument Name",{"$f":"DERIBIT_OPTION_NAME(N4, N5, \"call\")","v":"BTC-7JUN19-7500-C"},null,{"$f":"N29-BitMEX_LastPrice[BitMEX_LastPrice]","v":55.289683459999651}]
["2019-05-30",8274.5,8665,9099,7944.5,"-",-4.5100000000000001E-2,null,{"$f":"(B8/BTCDailyOHLC[[#This Row],[Price]])-1","v":4.7253610490059827E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B8), ABS(BTCDailyOHLC[[#This Row],[Low]]-B8))","v":1154.5},null,null,"BTC Implied Volatility for Call",{"$f":"deribit_iv(N6)","v":0.88700000000000001}]
["2019-05-29",8665.5,8721.5,8775,8442.5,"-",-6.4000000000000003E-3,null,{"$f":"(B9/BTCDailyOHLC[[#This Row],[Price]])-1","v":6.4047083261207227E-3},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B9), ABS(BTCDailyOHLC[[#This Row],[Low]]-B9))","v":332.5},null,null,"Put Instrument Name",{"$f":"DERIBIT_OPTION_NAME(N4, N5+250, \"put\")","v":"BTC-7JUN19-7750-P"}]
["2019-05-28",8721,8779.5,8823.5,8563,"-",-6.7000000000000002E-3,null,{"$f":"(B10/BTCDailyOHLC[[#This Row],[Price]])-1","v":6.7652792110997062E-3},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B10), ABS(BTCDailyOHLC[[#This Row],[Low]]-B10))","v":260.5},null,null,"BTC Implied Volatility for Put",{"$f":"deribit_iv(N8)","v":0.88690000000000002},null,"FLOOR((N3/250),1)*250"]
["2019-05-27",8780,8749.5,8964,8660,"-",3.3999999999999998E-3,null,{"$f":"(B11/BTCDailyOHLC[[#This Row],[Price]])-1","v":-3.4168564920273869E-3},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B11), ABS(BTCDailyOHLC[[#This Row],[Low]]-B11))","v":304},null,null,"Average BTC Implied Volatility",{"$f":"AVERAGE(N7,N9)","v":0.88695000000000002},null,"FLOOR(N3/(IF(WEEKDAY(TODAY()+1)>5,250,125)),1)*(IF(WEEKDAY(TODAY()+1)>5,250,125))"]
["2019-05-26",8750,8067.5,8870,7883.5,"-",8.4699999999999998E-2,null,{"$f":"(B12/BTCDailyOHLC[[#This Row],[Price]])-1","v":-7.8057142857142825E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B12), ABS(BTCDailyOHLC[[#This Row],[Low]]-B12))","v":986.5}]
["2019-05-25",8067,7997.5,8173,7938.5,"-",8.8000000000000005E-3,null,{"$f":"(B13/BTCDailyOHLC[[#This Row],[Price]])-1","v":-8.6773273831659559E-3},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B13), ABS(BTCDailyOHLC[[#This Row],[Low]]-B13))","v":234.5}]
["2019-05-24",7997,7875.5,8194,7801.5,"-",1.55E-2,null,{"$f":"(B14/BTCDailyOHLC[[#This Row],[Price]])-1","v":-1.5255720895335778E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B14), ABS(BTCDailyOHLC[[#This Row],[Low]]-B14))","v":392.5}]
["2019-05-23",7875,7624,7982,7460,"-",3.2899999999999999E-2,null,{"$f":"(B15/BTCDailyOHLC[[#This Row],[Price]])-1","v":-3.1809523809523843E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B15), ABS(BTCDailyOHLC[[#This Row],[Low]]-B15))","v":522},null,null,"Sentiment Stuff"]
["2019-05-22",7624.5,7958.5,8057,7500,"-",-4.2000000000000003E-2,null,{"$f":"(B16/BTCDailyOHLC[[#This Row],[Price]])-1","v":4.3871729293724071E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B16), ABS(BTCDailyOHLC[[#This Row],[Low]]-B16))","v":557},null,null,"HourlySentimentLowerPricePrediction"]
["2019-05-21",7959,8009.5,8126.5,7808,"-",-6.3E-3,null,{"$f":"(B17/BTCDailyOHLC[[#This Row],[Price]])-1","v":6.3450182183690806E-3},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B17), ABS(BTCDailyOHLC[[#This Row],[Low]]-B17))","v":318.5},null,null,7463.320512511621]
["2019-05-20",8009.5,8206.5,8206.5,7580,"-",-2.4E-2,null,{"$f":"(B18/BTCDailyOHLC[[#This Row],[Price]])-1","v":2.4595792496410418E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B18), ABS(BTCDailyOHLC[[#This Row],[Low]]-B18))","v":626.5},null,null,"HourlySentimentMedianPricePrediction (2)"]
["2019-05-19",8206.5,7258,8320,7245.5,"-",0.13059999999999999,null,{"$f":"(B19/BTCDailyOHLC[[#This Row],[Price]])-1","v":-0.11551818680314385},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B19), ABS(BTCDailyOHLC[[#This Row],[Low]]-B19))","v":1074.5},null,null,7591.3978753780038]
["2019-05-18",7258.5,7352.5,7489,7202,"-",-1.2699999999999999E-2,null,{"$f":"(B20/BTCDailyOHLC[[#This Row],[Price]])-1","v":1.288144933526203E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B20), ABS(BTCDailyOHLC[[#This Row],[Low]]-B20))","v":287},null,null,"HourlySentimentUpperPricePrediction (2)"]
["2019-05-17",7352,7884.5,7940,6380,"-",-6.7500000000000004E-2,null,{"$f":"(B21/BTCDailyOHLC[[#This Row],[Price]])-1","v":7.2429270946681168E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B21), ABS(BTCDailyOHLC[[#This Row],[Low]]-B21))","v":1560},null,null,7719.4752382443867]
["2019-05-16",7884.5,8203.5,8400,7650,"-",-3.9600000000000003E-2,null,{"$f":"(B22/BTCDailyOHLC[[#This Row],[Price]])-1","v":4.12201154163232E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B22), ABS(BTCDailyOHLC[[#This Row],[Low]]-B22))","v":750},null,null,"LastTimestamp"]
["2019-05-15",8209.5,7997.5,8325,7856,"-",2.6499999999999999E-2,null,{"$f":"(B23/BTCDailyOHLC[[#This Row],[Price]])-1","v":-2.5823740788111338E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B23), ABS(BTCDailyOHLC[[#This Row],[Low]]-B23))","v":469},null,null,1559687940000]
["2019-05-14",7997.5,7827,8339,7627,"-",2.18E-2,null,{"$f":"(B24/BTCDailyOHLC[[#This Row],[Price]])-1","v":-2.1319162238199407E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B24), ABS(BTCDailyOHLC[[#This Row],[Low]]-B24))","v":712},null,null,{"$f":"LastTimestamp[LastTimestamp]/(1000*60*60*24)+25569","v":"2019-06-04T22:39:00"}]
["2019-05-13",7827,6972.5,8177,6863.5,"-",0.1221,null,{"$f":"(B25/BTCDailyOHLC[[#This Row],[Price]])-1","v":-0.10879008560112435},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B25), ABS(BTCDailyOHLC[[#This Row],[Low]]-B25))","v":1313.5}]
["2019-05-12",6975.5,7218,7585,6781.5,"-",-3.4000000000000002E-2,null,{"$f":"(B26/BTCDailyOHLC[[#This Row],[Price]])-1","v":3.519460970539745E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B26), ABS(BTCDailyOHLC[[#This Row],[Low]]-B26))","v":803.5},null,null,"Name","Value"]
["2019-05-11",7221,6341.5,7459,6341.5,"-",0.13869999999999999,null,{"$f":"(B27/BTCDailyOHLC[[#This Row],[Price]])-1","v":-0.12179753496745604},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B27), ABS(BTCDailyOHLC[[#This Row],[Low]]-B27))","v":1117.5},null,null,"datetime","2019-06-04 21:39:00"]
["2019-05-10",6341.5,6142,6424,6103.5,"-",3.2800000000000003E-2,null,{"$f":"(B28/BTCDailyOHLC[[#This Row],[Price]])-1","v":-3.1774816683749929E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B28), ABS(BTCDailyOHLC[[#This Row],[Low]]-B28))","v":320.5},null,null,"subject","BTC.X"]
["2019-05-09",6140,5939,6163.5,5930,"-",3.39E-2,null,{"$f":"(B29/BTCDailyOHLC[[#This Row],[Price]])-1","v":-3.2817589576547235E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B29), ABS(BTCDailyOHLC[[#This Row],[Low]]-B29))","v":233.5},null,null,"sent_score","38.82809022863668"]
["2019-05-08",5938.5,5738,6000,5645,"-",3.49E-2,null,{"$f":"(B30/BTCDailyOHLC[[#This Row],[Price]])-1","v":-3.3762734697314167E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B30), ABS(BTCDailyOHLC[[#This Row],[Low]]-B30))","v":355},null,null,"lastclose","7641.289683460"]
["2019-05-07",5738,5684.5,5975,5684.5,"-",9.2999999999999992E-3,null,{"$f":"(B31/BTCDailyOHLC[[#This Row],[Price]])-1","v":-9.2366678285116244E-3},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B31), ABS(BTCDailyOHLC[[#This Row],[Low]]-B31))","v":290.5},null,null,"sentiment_rank","141"]
["2019-05-06",5685,5715.5,5753,5557.5,"-",-5.3E-3,null,{"$f":"(B33/BTCDailyOHLC[[#This Row],[Price]])-1","v":1.4775725593667577E-2},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B33), ABS(BTCDailyOHLC[[#This Row],[Low]]-B33))","v":211.5},null,null,"svolume","32466"]
["2019-05-05",5715.5,5769,5783,5608,"-",-9.2999999999999992E-3,null,{"$f":"(B33/BTCDailyOHLC[[#This Row],[Price]])-1","v":9.3605108914356361E-3},{"$f":"MAX((BTCDailyOHLC[[#This Row],[High]]-BTCDailyOHLC[[#This Row],[Low]]), ABS(BTCDailyOHLC[[#This Row],[High]]-B33), ABS(BTCDailyOHLC[[#This Row],[Low]]-B33))","v":175},null,null,"aggregate_data","[Record]"]
["2019-05-04",5769,5657.5,5850,5505,"-",1.9699999999999999E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ben:",0.22026022000000001]
[null,{"$f":"B60*B3","v":1784.107782}]
[null,{"$f":"_xlfn.DAYS(TODAY(),DATEVALUE(\"3/9/2018\"))","v":452}]

{"sheet":"Hedge","index":8,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,1,13,6]]}
[null,"Hedging Calulator"]
[]
[]
[null,"This is the next planned feature to be"]
[null,"developed in this spreadsheet.  Will"]
[null,"probably include a protective put"]
[null,"calculator at first, and evolve to"]
[null,"encompass other hedging strategies."]
[]
[]
[]
[null,"You can find the most recent version"]
[null,"of this speadsheet at:"]
[null,"http://kickstudios.com/tools"]

{"sheet":"README","index":9,"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],[26,1,26,9],[18,1,18,2],[24,1,24,2]]}
[null,"Notes, Credits, and Donations",null,null,null,null,null,null,"Version",0.94]
[]
[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,"Deribit Affiliate Link","https://www.deribit.com/reg-5157.3831"]
[null,"Binance Affiliate Link","https://www.binance.com/?ref=15261616"]
[]
[]
[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"]