New ms access functions - Githubissues

Temtesb / StatisticsCalculationsForExcel

VBA functions for statistics calculations to be used in Excel and Access

Other

7 stars 1 forks source link

New ms access functions #6

Closed seakintruth closed 7 years ago

Temtesb commented 7 years ago

I am trying to parse some stock option data (definitely not work related) and am not able to figure out how to do it. Do you have any tools that can make this able to be imported into Access?

On Mon, Jan 23, 2017 at 11:37 PM, Jeremy D. Gerdes <notifications@github.com

wrote:

Merged #6 https://github.com/Temtesb/StatisticsCalculationsForExcel/pull/6.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/Temtesb/StatisticsCalculationsForExcel/pull/6#event-933936728, or mute the thread https://github.com/notifications/unsubscribe-auth/AYGMRGAw1J16GGxbbrZPe7taccQzLW71ks5rVYAdgaJpZM4Lr2wm .

{"optionChain":{"result":[{"underlyingSymbol":"UVXY","expirationDates":[1485475200,1486080000,1486684800,1487289600,1487894400,1488499200,1489708800,1497571200,1516320000,1547769600,1579219200],"strikes":[2.0,4.0,4.5,5.0,5.5,6.0,6.5,7.0,7.5,8.0,8.5,9.0,9.5,10.0,10.5,11.0,11.5,12.0,12.5,13.0,13.5,14.0,14.5,15.0,16.0,16.5,22.5,24.0,24.5,25.0,25.5,26.0,26.5,27.0,27.5,28.0,28.5,29.0,29.5,30.0,30.5,31.0,31.5,32.0,32.5,33.0,33.5,34.0,34.5,35.0,35.5,36.0,36.5,37.0,37.5,38.0,38.5,39.0,39.5,40.0,40.5,41.0,41.5,42.0,42.5,43.0,44.0,45.0,45.5,46.0,46.5,47.0,47.5,48.0,48.5,49.0,49.5,50.0,51.0,51.5,52.0,53.0,54.0,55.0,55.5,56.0,56.5,57.0,58.0,59.0,60.0],"hasMiniOptions":false,"quote":{"quoteType":"ETF","quoteSourceName":"Nasdaq Real Time Price","currency":"USD","regularMarketPrice":28.4,"regularMarketTime":1484960400,"regularMarketChange":-2.4099998,"regularMarketOpen":30.15,"regularMarketDayHigh":30.3841,"regularMarketDayLow":28.4,"regularMarketVolume":21875988,"marketState":"CLOSED","fiftyDayAverage":38.73125,"fiftyDayAverageChange":-10.331251,"fiftyDayAverageChangePercent":-0.266742,"twoHundredDayAverage":85.76087,"twoHundredDayAverageChange":-57.36087,"twoHundredDayAverageChangePercent":-0.6688466,"longName":"ProShares Ultra VIX Short-Term Futures","exchange":"PCX","sourceInterval":15,"exchangeTimezoneName":"America/New_York","exchangeTimezoneShortName":"EST","gmtOffSetMilliseconds":-18000000,"market":"us_market","postMarketPrice":28.57,"postMarketChange":0.17000008,"regularMarketChangePercent":-7.8221354,"regularMarketPreviousClose":30.81,"bid":0.0,"ask":0.0,"bidSize":0,"askSize":0,"messageBoardId":"finmb_141277002","fullExchangeName":"NYSEArca","averageDailyVolume3Month":8205663,"averageDailyVolume10Day":18183866,"fiftyTwoWeekLowChange":0.0,"fiftyTwoWeekLowChangePercent":0.0,"fiftyTwoWeekHighChange":-1519.6,"fiftyTwoWeekHighChangePercent":-0.98165375,"fiftyTwoWeekLow":28.4,"fiftyTwoWeekHigh":1548.0,"shortName":"ProShares Trust Ultra VIX Short","postMarketChangePercent":0.59859186,"postMarketTime":1484960396,"symbol":"UVXY"},"options":[{"expirationDate":1485475200,"hasMiniOptions":false,"calls":[{"contractSymbol":"UVXY170127C00002000","strike":2.0,"currency":"USD","lastPrice":3.8,"change":0.0,"percentChange":0.0,"volume":300,"openInterest":0,"bid":4.1,"ask":5.25,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483764717,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00004500","strike":4.5,"currency":"USD","lastPrice":2.5,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":1,"bid":1.51,"ask":2.29,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483764717,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00005000","strike":5.0,"currency":"USD","lastPrice":1.38,"change":0.0,"percentChange":0.0,"volume":12,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484163549,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00005500","strike":5.5,"currency":"USD","lastPrice":0.81,"change":0.0,"percentChange":0.0,"volume":34,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484168883,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00006000","strike":6.0,"currency":"USD","lastPrice":0.55,"change":0.0,"percentChange":0.0,"volume":184,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484169190,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00006500","strike":6.5,"currency":"USD","lastPrice":0.38,"change":0.0,"percentChange":0.0,"volume":646,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484167554,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00007000","strike":7.0,"currency":"USD","lastPrice":0.3,"change":0.0,"percentChange":0.0,"volume":588,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484167157,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00007500","strike":7.5,"currency":"USD","lastPrice":0.21,"change":0.0,"percentChange":0.0,"volume":325,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484168074,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00008000","strike":8.0,"currency":"USD","lastPrice":0.19,"change":0.0,"percentChange":0.0,"volume":253,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484168692,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00008500","strike":8.5,"currency":"USD","lastPrice":0.16,"change":0.0,"percentChange":0.0,"volume":216,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484168736,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00009000","strike":9.0,"currency":"USD","lastPrice":0.12,"change":0.0,"percentChange":0.0,"volume":178,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484167949,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00009500","strike":9.5,"currency":"USD","lastPrice":0.17,"change":-0.010000005,"percentChange":-5.555558,"volume":107,"openInterest":106,"bid":0.13,"ask":0.17,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483992353,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00010000","strike":10.0,"currency":"USD","lastPrice":0.1,"change":0.0,"percentChange":0.0,"volume":101,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484163006,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00010500","strike":10.5,"currency":"USD","lastPrice":0.09,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484067417,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00011000","strike":11.0,"currency":"USD","lastPrice":0.1,"change":0.0,"percentChange":0.0,"volume":27,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484158244,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00011500","strike":11.5,"currency":"USD","lastPrice":0.1,"change":-0.10999999,"percentChange":-52.38095,"volume":10,"openInterest":22,"bid":0.07,"ask":0.14,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483717782,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00012000","strike":12.0,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":13,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484163107,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00012500","strike":12.5,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":11,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484163023,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00013000","strike":13.0,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":126,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484161321,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00013500","strike":13.5,"currency":"USD","lastPrice":0.15,"change":0.0,"percentChange":0.0,"volume":11,"openInterest":19,"bid":0.01,"ask":0.49,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483649637,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00014000","strike":14.0,"currency":"USD","lastPrice":0.12,"change":-0.07,"percentChange":-36.842106,"volume":10,"openInterest":92,"bid":0.02,"ask":0.19,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483988465,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00014500","strike":14.5,"currency":"USD","lastPrice":0.78,"change":0.0,"percentChange":0.0,"volume":2,"openInterest":2,"bid":0.46,"ask":0.91,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1481949979,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00015000","strike":15.0,"currency":"USD","lastPrice":0.05,"change":-0.08,"percentChange":-61.538464,"volume":9,"openInterest":437,"bid":0.01,"ask":0.13,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483987548,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00016000","strike":16.0,"currency":"USD","lastPrice":0.3,"change":-0.049999982,"percentChange":-14.285709,"volume":4,"openInterest":66,"bid":0.29,"ask":0.4,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483127802,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00016500","strike":16.5,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484071735,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00022500","strike":22.5,"currency":"USD","lastPrice":5.9,"change":0.0,"percentChange":0.0,"volume":10,"openInterest":0,"bid":5.05,"ask":6.9,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973438,"impliedVolatility":1.2109414453124998,"inTheMoney":true},{"contractSymbol":"UVXY170127C00024000","strike":24.0,"currency":"USD","lastPrice":4.6,"change":0.0,"percentChange":0.0,"volume":4,"openInterest":0,"bid":3.7,"ask":6.15,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973438,"impliedVolatility":1.642579912109375,"inTheMoney":true},{"contractSymbol":"UVXY170127C00025000","strike":25.0,"currency":"USD","lastPrice":4.08,"change":0.0,"percentChange":0.0,"volume":14,"openInterest":5,"bid":3.05,"ask":4.9,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973439,"impliedVolatility":1.43359658203125,"inTheMoney":true},{"contractSymbol":"UVXY170127C00026000","strike":26.0,"currency":"USD","lastPrice":2.95,"change":0.0,"percentChange":0.0,"volume":61,"openInterest":0,"bid":2.48,"ask":3.15,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973439,"impliedVolatility":1.001958115234375,"inTheMoney":true},{"contractSymbol":"UVXY170127C00026500","strike":26.5,"currency":"USD","lastPrice":2.5,"change":0.0,"percentChange":0.0,"volume":20,"openInterest":21,"bid":2.1,"ask":2.77,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973439,"impliedVolatility":0.9882813671875,"inTheMoney":true},{"contractSymbol":"UVXY170127C00027000","strike":27.0,"currency":"USD","lastPrice":2.0,"change":-2.2600002,"percentChange":-53.051643,"volume":165,"openInterest":7,"bid":1.82,"ask":2.37,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946841,"impliedVolatility":0.9863282617187501,"inTheMoney":true},{"contractSymbol":"UVXY170127C00027500","strike":27.5,"currency":"USD","lastPrice":1.75,"change":0.0,"percentChange":0.0,"volume":134,"openInterest":1,"bid":1.53,"ask":2.02,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973439,"impliedVolatility":0.9775392871093751,"inTheMoney":true},{"contractSymbol":"UVXY170127C00028000","strike":28.0,"currency":"USD","lastPrice":0.99,"change":0.0,"percentChange":0.0,"volume":407,"openInterest":134,"bid":1.34,"ask":1.75,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974339,"impliedVolatility":1.0146533642578124,"inTheMoney":true},{"contractSymbol":"UVXY170127C00028500","strike":28.5,"currency":"USD","lastPrice":1.38,"change":0.0,"percentChange":0.0,"volume":591,"openInterest":32,"bid":1.09,"ask":1.53,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973439,"impliedVolatility":1.0234423828125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00029000","strike":29.0,"currency":"USD","lastPrice":1.25,"change":-1.5699999,"percentChange":-55.67376,"volume":1570,"openInterest":435,"bid":0.99,"ask":1.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946475,"impliedVolatility":1.0644578027343752,"inTheMoney":false},{"contractSymbol":"UVXY170127C00029500","strike":29.5,"currency":"USD","lastPrice":1.01,"change":0.0,"percentChange":0.0,"volume":1069,"openInterest":178,"bid":0.88,"ask":1.18,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973439,"impliedVolatility":1.123051259765625,"inTheMoney":false},{"contractSymbol":"UVXY170127C00030000","strike":30.0,"currency":"USD","lastPrice":0.97,"change":-1.03,"percentChange":-51.5,"volume":2919,"openInterest":1299,"bid":0.73,"ask":0.91,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946642,"impliedVolatility":1.08984830078125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00030500","strike":30.5,"currency":"USD","lastPrice":0.8,"change":-1.1700001,"percentChange":-59.390865,"volume":651,"openInterest":684,"bid":0.62,"ask":0.92,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946016,"impliedVolatility":1.169926025390625,"inTheMoney":false},{"contractSymbol":"UVXY170127C00031000","strike":31.0,"currency":"USD","lastPrice":0.75,"change":-1.01,"percentChange":-57.386364,"volume":517,"openInterest":399,"bid":0.52,"ask":0.84,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946434,"impliedVolatility":1.2041055419921873,"inTheMoney":false},{"contractSymbol":"UVXY170127C00031500","strike":31.5,"currency":"USD","lastPrice":0.69,"change":-0.72999996,"percentChange":-51.40845,"volume":360,"openInterest":402,"bid":0.5,"ask":0.76,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945630,"impliedVolatility":1.2636755566406248,"inTheMoney":false},{"contractSymbol":"UVXY170127C00032000","strike":32.0,"currency":"USD","lastPrice":0.56,"change":-0.91,"percentChange":-61.904762,"volume":952,"openInterest":916,"bid":0.42,"ask":0.55,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946883,"impliedVolatility":1.220707021484375,"inTheMoney":false},{"contractSymbol":"UVXY170127C00032500","strike":32.5,"currency":"USD","lastPrice":0.56,"change":-0.71999997,"percentChange":-56.25,"volume":192,"openInterest":155,"bid":0.05,"ask":0.63,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484944982,"impliedVolatility":1.150394873046875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00033000","strike":33.0,"currency":"USD","lastPrice":0.46,"change":-0.78999996,"percentChange":-63.199997,"volume":276,"openInterest":248,"bid":0.34,"ask":0.57,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946440,"impliedVolatility":1.36328443359375,"inTheMoney":false},{"contractSymbol":"UVXY170127C00033500","strike":33.5,"currency":"USD","lastPrice":0.44,"change":0.0,"percentChange":0.0,"volume":28,"openInterest":72,"bid":0.3,"ask":0.53,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973440,"impliedVolatility":1.40234673828125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00034000","strike":34.0,"currency":"USD","lastPrice":0.36,"change":-0.64,"percentChange":-64.0,"volume":61,"openInterest":274,"bid":0.3,"ask":0.44,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946301,"impliedVolatility":1.4257841210937499,"inTheMoney":false},{"contractSymbol":"UVXY170127C00034500","strike":34.5,"currency":"USD","lastPrice":0.32,"change":-0.6,"percentChange":-65.21739,"volume":33,"openInterest":79,"bid":0.23,"ask":0.45,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946170,"impliedVolatility":1.4609401953124999,"inTheMoney":false},{"contractSymbol":"UVXY170127C00035000","strike":35.0,"currency":"USD","lastPrice":0.31,"change":-0.49,"percentChange":-61.25,"volume":897,"openInterest":507,"bid":0.25,"ask":0.31,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946323,"impliedVolatility":1.4492215039062502,"inTheMoney":false},{"contractSymbol":"UVXY170127C00035500","strike":35.5,"currency":"USD","lastPrice":0.26,"change":-0.53000003,"percentChange":-67.08861,"volume":85,"openInterest":51,"bid":0.18,"ask":0.39,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946141,"impliedVolatility":1.5234398828124998,"inTheMoney":false},{"contractSymbol":"UVXY170127C00036000","strike":36.0,"currency":"USD","lastPrice":0.27,"change":-0.65,"percentChange":-70.65217,"volume":57,"openInterest":175,"bid":0.16,"ask":0.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945879,"impliedVolatility":1.50390873046875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00036500","strike":36.5,"currency":"USD","lastPrice":0.42,"change":-0.31000003,"percentChange":-42.465755,"volume":14,"openInterest":65,"bid":0.14,"ask":0.27,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484933624,"impliedVolatility":1.5195336523437497,"inTheMoney":false},{"contractSymbol":"UVXY170127C00037000","strike":37.0,"currency":"USD","lastPrice":0.23,"change":-0.39999998,"percentChange":-63.492058,"volume":290,"openInterest":450,"bid":0.11,"ask":0.32,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946361,"impliedVolatility":1.5976582617187498,"inTheMoney":false},{"contractSymbol":"UVXY170127C00037500","strike":37.5,"currency":"USD","lastPrice":0.22,"change":0.0,"percentChange":0.0,"volume":208,"openInterest":33,"bid":0.1,"ask":0.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973440,"impliedVolatility":1.6289081054687498,"inTheMoney":false},{"contractSymbol":"UVXY170127C00038000","strike":38.0,"currency":"USD","lastPrice":0.19,"change":-0.32,"percentChange":-62.745102,"volume":303,"openInterest":86,"bid":0.15,"ask":0.29,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945859,"impliedVolatility":1.72265763671875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00038500","strike":38.5,"currency":"USD","lastPrice":0.18,"change":-0.45,"percentChange":-71.428566,"volume":127,"openInterest":57,"bid":0.08,"ask":0.19,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484944461,"impliedVolatility":1.6015644921874999,"inTheMoney":false},{"contractSymbol":"UVXY170127C00039000","strike":39.0,"currency":"USD","lastPrice":0.15,"change":-0.26999998,"percentChange":-64.28571,"volume":185,"openInterest":140,"bid":0.07,"ask":0.19,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946061,"impliedVolatility":1.640626796875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00039500","strike":39.5,"currency":"USD","lastPrice":0.14,"change":-0.19000001,"percentChange":-57.575756,"volume":13,"openInterest":40,"bid":0.08,"ask":0.24,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946061,"impliedVolatility":1.76171994140625,"inTheMoney":false},{"contractSymbol":"UVXY170127C00040000","strike":40.0,"currency":"USD","lastPrice":0.14,"change":-0.23,"percentChange":-62.162163,"volume":937,"openInterest":597,"bid":0.12,"ask":0.17,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945911,"impliedVolatility":1.7773448632812499,"inTheMoney":false},{"contractSymbol":"UVXY170127C00040500","strike":40.5,"currency":"USD","lastPrice":0.13,"change":-0.27,"percentChange":-67.5,"volume":57,"openInterest":316,"bid":0.04,"ask":0.23,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945426,"impliedVolatility":1.8007822460937497,"inTheMoney":false},{"contractSymbol":"UVXY170127C00041000","strike":41.0,"currency":"USD","lastPrice":0.19,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":106,"bid":0.03,"ask":0.11,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974341,"impliedVolatility":1.640626796875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00041500","strike":41.5,"currency":"USD","lastPrice":0.34,"change":0.0,"percentChange":0.0,"volume":19,"openInterest":15,"bid":0.02,"ask":0.13,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974341,"impliedVolatility":1.703126484375,"inTheMoney":false},{"contractSymbol":"UVXY170127C00042000","strike":42.0,"currency":"USD","lastPrice":0.11,"change":0.0,"percentChange":0.0,"volume":4,"openInterest":235,"bid":0.02,"ask":0.2,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974341,"impliedVolatility":1.8671881640625,"inTheMoney":false},{"contractSymbol":"UVXY170127C00042500","strike":42.5,"currency":"USD","lastPrice":0.4,"change":0.0,"percentChange":0.0,"volume":23,"openInterest":19,"bid":0.01,"ask":0.19,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974341,"impliedVolatility":1.8789068554687498,"inTheMoney":false},{"contractSymbol":"UVXY170127C00043000","strike":43.0,"currency":"USD","lastPrice":0.17,"change":0.0,"percentChange":0.0,"volume":2,"openInterest":45,"bid":0.06,"ask":0.1,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974341,"impliedVolatility":1.8515632421875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00044000","strike":44.0,"currency":"USD","lastPrice":0.3,"change":0.0,"percentChange":0.0,"volume":10,"openInterest":13,"bid":0.0,"ask":0.09,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974341,"impliedVolatility":1.765626171875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00045000","strike":45.0,"currency":"USD","lastPrice":0.07,"change":0.0,"percentChange":0.0,"volume":789,"openInterest":96,"bid":0.04,"ask":0.08,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.9218753906250001,"inTheMoney":false},{"contractSymbol":"UVXY170127C00045500","strike":45.5,"currency":"USD","lastPrice":0.11,"change":0.0,"percentChange":0.0,"volume":10,"openInterest":10,"bid":0.01,"ask":0.08,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.875000625,"inTheMoney":false},{"contractSymbol":"UVXY170127C00046000","strike":46.0,"currency":"USD","lastPrice":0.1,"change":0.0,"percentChange":0.0,"volume":29,"openInterest":0,"bid":0.05,"ask":0.16,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":2.183598291015625,"inTheMoney":false},{"contractSymbol":"UVXY170127C00046500","strike":46.5,"currency":"USD","lastPrice":0.11,"change":0.0,"percentChange":0.0,"volume":28,"openInterest":32,"bid":0.0,"ask":0.07,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.8828130859374999,"inTheMoney":false},{"contractSymbol":"UVXY170127C00047000","strike":47.0,"currency":"USD","lastPrice":0.09,"change":0.0,"percentChange":0.0,"volume":133,"openInterest":30,"bid":0.0,"ask":0.07,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.9218753906250001,"inTheMoney":false},{"contractSymbol":"UVXY170127C00047500","strike":47.5,"currency":"USD","lastPrice":0.09,"change":0.0,"percentChange":0.0,"volume":100,"openInterest":0,"bid":0.0,"ask":0.06,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.9062504687500001,"inTheMoney":false},{"contractSymbol":"UVXY170127C00048000","strike":48.0,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":168,"openInterest":51,"bid":0.0,"ask":0.06,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.9375003125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00048500","strike":48.5,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":20,"openInterest":0,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.9375003125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00049000","strike":49.0,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":123,"openInterest":629,"bid":0.02,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":2.0468798828125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00049500","strike":49.5,"currency":"USD","lastPrice":0.2,"change":0.0,"percentChange":0.0,"volume":1144,"openInterest":1077,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.984375078125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00050000","strike":50.0,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":253,"openInterest":1134,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.031254921875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00051000","strike":51.0,"currency":"USD","lastPrice":0.06,"change":0.0,"percentChange":0.0,"volume":150,"openInterest":11,"bid":0.0,"ask":0.04,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.031254921875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00051500","strike":51.5,"currency":"USD","lastPrice":0.06,"change":0.0,"percentChange":0.0,"volume":37,"openInterest":0,"bid":0.0,"ask":0.04,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.0625048437499998,"inTheMoney":false},{"contractSymbol":"UVXY170127C00052000","strike":52.0,"currency":"USD","lastPrice":0.06,"change":0.0,"percentChange":0.0,"volume":2,"openInterest":88,"bid":0.0,"ask":0.04,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.0937547656249995,"inTheMoney":false},{"contractSymbol":"UVXY170127C00053000","strike":53.0,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":3,"openInterest":0,"bid":0.0,"ask":0.04,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.1406296484375,"inTheMoney":false},{"contractSymbol":"UVXY170127C00054000","strike":54.0,"currency":"USD","lastPrice":0.06,"change":0.0,"percentChange":0.0,"volume":350,"openInterest":14,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.2500043749999996,"inTheMoney":false},{"contractSymbol":"UVXY170127C00055000","strike":55.0,"currency":"USD","lastPrice":0.06,"change":0.0,"percentChange":0.0,"volume":110,"openInterest":234,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.3125042187499996,"inTheMoney":false},{"contractSymbol":"UVXY170127C00055500","strike":55.5,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":100,"openInterest":0,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.3437541406249993,"inTheMoney":false},{"contractSymbol":"UVXY170127C00056000","strike":56.0,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":54,"openInterest":100,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974344,"impliedVolatility":2.3593791015624994,"inTheMoney":false},{"contractSymbol":"UVXY170127C00056500","strike":56.5,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":21,"openInterest":0,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974344,"impliedVolatility":2.3906290234374996,"inTheMoney":false},{"contractSymbol":"UVXY170127C00057000","strike":57.0,"currency":"USD","lastPrice":0.03,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":110,"bid":0.0,"ask":0.12,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974344,"impliedVolatility":2.69531576171875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00058000","strike":58.0,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":305,"openInterest":61,"bid":0.0,"ask":0.04,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974344,"impliedVolatility":2.4062539843749997,"inTheMoney":false},{"contractSymbol":"UVXY170127C00059000","strike":59.0,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":10,"openInterest":45,"bid":0.0,"ask":0.03,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974344,"impliedVolatility":2.3750040624999995,"inTheMoney":false},{"contractSymbol":"UVXY170127C00060000","strike":60.0,"currency":"USD","lastPrice":0.02,"change":0.0,"percentChange":0.0,"volume":115,"openInterest":489,"bid":0.01,"ask":0.02,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974344,"impliedVolatility":2.43750390625,"inTheMoney":false}],"puts":[{"contractSymbol":"UVXY170127P00004000","strike":4.0,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":63,"bid":0.0,"ask":0.25,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1482433458,"impliedVolatility":9.03125435546875,"inTheMoney":false},{"contractSymbol":"UVXY170127P00004500","strike":4.5,"currency":"USD","lastPrice":0.01,"change":0.0,"percentChange":0.0,"volume":5,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484207896,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00005000","strike":5.0,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":8,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484167775,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00005500","strike":5.5,"currency":"USD","lastPrice":0.21,"change":0.0,"percentChange":0.0,"volume":195,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484168403,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00006000","strike":6.0,"currency":"USD","lastPrice":0.45,"change":0.0,"percentChange":0.0,"volume":93,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484166933,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00006500","strike":6.5,"currency":"USD","lastPrice":0.81,"change":0.0,"percentChange":0.0,"volume":32,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484166902,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00007000","strike":7.0,"currency":"USD","lastPrice":1.14,"change":0.0,"percentChange":0.0,"volume":567,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484164492,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00007500","strike":7.5,"currency":"USD","lastPrice":1.64,"change":0.0,"percentChange":0.0,"volume":42,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484168551,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00008000","strike":8.0,"currency":"USD","lastPrice":1.95,"change":0.0,"percentChange":0.0,"volume":6,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484166230,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00008500","strike":8.5,"currency":"USD","lastPrice":2.49,"change":0.0,"percentChange":0.0,"volume":4,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484163641,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00009000","strike":9.0,"currency":"USD","lastPrice":2.97,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484163077,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00009500","strike":9.5,"currency":"USD","lastPrice":2.71,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":2,"bid":2.78,"ask":3.4,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483547246,"impliedVolatility":13.347657907714844,"inTheMoney":false},{"contractSymbol":"UVXY170127P00010000","strike":10.0,"currency":"USD","lastPrice":3.32,"change":0.0,"percentChange":0.0,"volume":20,"openInterest":191,"bid":3.6,"ask":3.9,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483635432,"impliedVolatility":14.195313627929687,"inTheMoney":false},{"contractSymbol":"UVXY170127P00010500","strike":10.5,"currency":"USD","lastPrice":2.61,"change":-0.19000006,"percentChange":-6.785716,"volume":2,"openInterest":25,"bid":2.53,"ask":3.25,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483126205,"impliedVolatility":11.824221359863284,"inTheMoney":false},{"contractSymbol":"UVXY170127P00011000","strike":11.0,"currency":"USD","lastPrice":3.72,"change":0.0,"percentChange":0.0,"volume":108,"openInterest":276,"bid":4.35,"ask":4.7,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483460592,"impliedVolatility":14.566407145996095,"inTheMoney":false},{"contractSymbol":"UVXY170127P00011500","strike":11.5,"currency":"USD","lastPrice":4.86,"change":0.0,"percentChange":0.0,"volume":20,"openInterest":21,"bid":4.9,"ask":5.4,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483764740,"impliedVolatility":15.191406755371094,"inTheMoney":false},{"contractSymbol":"UVXY170127P00012000","strike":12.0,"currency":"USD","lastPrice":5.69,"change":0.46000004,"percentChange":8.795412,"volume":2,"openInterest":85,"bid":5.15,"ask":5.95,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483733831,"impliedVolatility":15.332031667480468,"inTheMoney":false},{"contractSymbol":"UVXY170127P00012500","strike":12.5,"currency":"USD","lastPrice":5.35,"change":0.0,"percentChange":0.0,"volume":4,"openInterest":17,"bid":4.85,"ask":5.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1482432556,"impliedVolatility":13.847657595214844,"inTheMoney":false},{"contractSymbol":"UVXY170127P00013000","strike":13.0,"currency":"USD","lastPrice":5.59,"change":0.0,"percentChange":0.0,"volume":100,"openInterest":116,"bid":6.2,"ask":6.95,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483460592,"impliedVolatility":15.992187504882812,"inTheMoney":false},{"contractSymbol":"UVXY170127P00013500","strike":13.5,"currency":"USD","lastPrice":5.61,"change":0.0,"percentChange":0.0,"volume":50,"openInterest":50,"bid":5.1,"ask":6.2,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483159519,"impliedVolatility":13.757813901367188,"inTheMoney":false},{"contractSymbol":"UVXY170127P00014000","strike":14.0,"currency":"USD","lastPrice":5.99,"change":0.0,"percentChange":0.0,"volume":51,"openInterest":97,"bid":5.55,"ask":6.65,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483032694,"impliedVolatility":13.972657517089843,"inTheMoney":false},{"contractSymbol":"UVXY170127P00014500","strike":14.5,"currency":"USD","lastPrice":6.09,"change":0.0,"percentChange":0.0,"volume":3,"openInterest":3,"bid":5.9,"ask":6.8,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1481949995,"impliedVolatility":13.849610718994143,"inTheMoney":false},{"contractSymbol":"UVXY170127P00015000","strike":15.0,"currency":"USD","lastPrice":6.47,"change":0.0,"percentChange":0.0,"volume":2,"openInterest":2,"bid":6.45,"ask":7.25,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1481949995,"impliedVolatility":14.117188676757813,"inTheMoney":false},{"contractSymbol":"UVXY170127P00016000","strike":16.0,"currency":"USD","lastPrice":8.07,"change":0.0,"percentChange":0.0,"volume":109,"openInterest":106,"bid":7.45,"ask":8.45,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483033285,"impliedVolatility":14.761719523925784,"inTheMoney":false},{"contractSymbol":"UVXY170127P00022500","strike":22.5,"currency":"USD","lastPrice":0.02,"change":0.0,"percentChange":0.0,"volume":6,"openInterest":0,"bid":0.0,"ask":0.11,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":1.140629296875,"inTheMoney":false},{"contractSymbol":"UVXY170127P00024000","strike":24.0,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":75,"openInterest":25,"bid":0.0,"ask":0.09,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":0.8359391406249999,"inTheMoney":false},{"contractSymbol":"UVXY170127P00024500","strike":24.5,"currency":"USD","lastPrice":0.07,"change":0.0,"percentChange":0.0,"volume":47,"openInterest":0,"bid":0.02,"ask":0.13,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":0.8398453515625,"inTheMoney":false},{"contractSymbol":"UVXY170127P00025000","strike":25.0,"currency":"USD","lastPrice":0.1,"change":0.0,"percentChange":0.0,"volume":134,"openInterest":0,"bid":0.05,"ask":0.15,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":0.8007832421875,"inTheMoney":false},{"contractSymbol":"UVXY170127P00025500","strike":25.5,"currency":"USD","lastPrice":0.15,"change":0.0,"percentChange":0.0,"volume":123,"openInterest":30,"bid":0.06,"ask":0.24,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":0.789064609375,"inTheMoney":false},{"contractSymbol":"UVXY170127P00026000","strike":26.0,"currency":"USD","lastPrice":0.24,"change":0.0,"percentChange":0.0,"volume":129,"openInterest":0,"bid":0.16,"ask":0.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":0.7929708203125,"inTheMoney":false},{"contractSymbol":"UVXY170127P00026500","strike":26.5,"currency":"USD","lastPrice":0.45,"change":0.24999999,"percentChange":124.999985,"volume":223,"openInterest":194,"bid":0.32,"ask":0.5,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946871,"impliedVolatility":0.867188828125,"inTheMoney":false},{"contractSymbol":"UVXY170127P00027000","strike":27.0,"currency":"USD","lastPrice":0.6,"change":0.3,"percentChange":100.0,"volume":259,"openInterest":394,"bid":0.55,"ask":0.8,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946033,"impliedVolatility":0.9687503125,"inTheMoney":false},{"contractSymbol":"UVXY170127P00027500","strike":27.5,"currency":"USD","lastPrice":0.84,"change":0.42,"percentChange":100.0,"volume":347,"openInterest":236,"bid":0.7,"ask":1.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946871,"impliedVolatility":0.9775392871093751,"inTheMoney":false},{"contractSymbol":"UVXY170127P00028000","strike":28.0,"currency":"USD","lastPrice":1.04,"change":0.45999998,"percentChange":79.31035,"volume":407,"openInterest":124,"bid":0.93,"ask":1.23,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946675,"impliedVolatility":0.9648441015625,"inTheMoney":false},{"contractSymbol":"UVXY170127P00028500","strike":28.5,"currency":"USD","lastPrice":1.42,"change":0.0,"percentChange":0.0,"volume":283,"openInterest":101,"bid":1.21,"ask":1.64,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":1.0351610742187503,"inTheMoney":true},{"contractSymbol":"UVXY170127P00029000","strike":29.0,"currency":"USD","lastPrice":1.81,"change":0.87999994,"percentChange":94.62365,"volume":606,"openInterest":211,"bid":1.52,"ask":1.93,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946061,"impliedVolatility":1.0488328808593752,"inTheMoney":true},{"contractSymbol":"UVXY170127P00029500","strike":29.5,"currency":"USD","lastPrice":2.17,"change":0.8900001,"percentChange":69.531265,"volume":396,"openInterest":473,"bid":1.9,"ask":2.69,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946061,"impliedVolatility":1.2500037499999999,"inTheMoney":true},{"contractSymbol":"UVXY170127P00030000","strike":30.0,"currency":"USD","lastPrice":2.41,"change":0.97,"percentChange":67.36111,"volume":730,"openInterest":669,"bid":2.21,"ask":2.72,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945727,"impliedVolatility":1.126957490234375,"inTheMoney":true},{"contractSymbol":"UVXY170127P00030500","strike":30.5,"currency":"USD","lastPrice":2.38,"change":0.7700001,"percentChange":47.82609,"volume":45,"openInterest":94,"bid":2.65,"ask":3.2,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484940127,"impliedVolatility":1.2148476757812499,"inTheMoney":true},{"contractSymbol":"UVXY170127P00031000","strike":31.0,"currency":"USD","lastPrice":3.29,"change":1.1800001,"percentChange":55.92418,"volume":568,"openInterest":262,"bid":3.0,"ask":3.55,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945985,"impliedVolatility":1.19922275390625,"inTheMoney":true},{"contractSymbol":"UVXY170127P00031500","strike":31.5,"currency":"USD","lastPrice":3.1,"change":0.0,"percentChange":0.0,"volume":36,"openInterest":69,"bid":3.4,"ask":3.85,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974384,"impliedVolatility":1.1640666796875,"inTheMoney":true},{"contractSymbol":"UVXY170127P00032000","strike":32.0,"currency":"USD","lastPrice":4.25,"change":0.0,"percentChange":0.0,"volume":63,"openInterest":0,"bid":3.85,"ask":4.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974384,"impliedVolatility":1.2109414453124998,"inTheMoney":true},{"contractSymbol":"UVXY170127P00032500","strike":32.5,"currency":"USD","lastPrice":4.4,"change":0.0,"percentChange":0.0,"volume":30,"openInterest":31,"bid":4.05,"ask":4.85,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974384,"impliedVolatility":1.162113564453125,"inTheMoney":true},{"contractSymbol":"UVXY170127P00033000","strike":33.0,"currency":"USD","lastPrice":5.05,"change":0.0,"percentChange":0.0,"volume":27,"openInterest":100,"bid":4.45,"ask":5.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974384,"impliedVolatility":1.15234798828125,"inTheMoney":true},{"contractSymbol":"UVXY170127P00033500","strike":33.5,"currency":"USD","lastPrice":4.7,"change":0.0,"percentChange":0.0,"volume":11,"openInterest":6,"bid":4.65,"ask":5.7,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974384,"impliedVolatility":0.8828136718749999,"inTheMoney":true},{"contractSymbol":"UVXY170127P00034000","strike":34.0,"currency":"USD","lastPrice":5.25,"change":0.0,"percentChange":0.0,"volume":15,"openInterest":15,"bid":5.3,"ask":6.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974384,"impliedVolatility":1.19141029296875,"inTheMoney":true},{"contractSymbol":"UVXY170127P00035000","strike":35.0,"currency":"USD","lastPrice":6.75,"change":1.0500002,"percentChange":18.421057,"volume":41,"openInterest":123,"bid":6.25,"ask":7.35,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484943303,"impliedVolatility":1.32422212890625,"inTheMoney":true},{"contractSymbol":"UVXY170127P00036000","strike":36.0,"currency":"USD","lastPrice":6.7,"change":0.5999999,"percentChange":9.836064,"volume":40,"openInterest":52,"bid":6.95,"ask":8.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484926200,"impliedVolatility":0.9765627343750001,"inTheMoney":true},{"contractSymbol":"UVXY170127P00037000","strike":37.0,"currency":"USD","lastPrice":7.4,"change":0.0,"percentChange":0.0,"volume":28,"openInterest":4,"bid":7.6,"ask":9.5,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974385,"impliedVolatility":2.46094134765625,"inTheMoney":true},{"contractSymbol":"UVXY170127P00045500","strike":45.5,"currency":"USD","lastPrice":16.5,"change":0.0,"percentChange":0.0,"volume":10,"openInterest":0,"bid":16.45,"ask":17.9,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974385,"impliedVolatility":2.031254921875,"inTheMoney":true},{"contractSymbol":"UVXY170127P00060000","strike":60.0,"currency":"USD","lastPrice":29.0,"change":0.0,"percentChange":0.0,"volume":7,"openInterest":7,"bid":30.1,"ask":32.4,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974387,"impliedVolatility":4.582035522460938,"inTheMoney":true}]}]}],"error":null}}

seakintruth commented 7 years ago

The functions I have been working on are in the StatisticsHandlingArrays.bas file

-----Original Message----- From: Temtesb [mailto:notifications@github.com] Sent: Tuesday, January 24, 2017 7:58 PM To: Temtesb/StatisticsCalculationsForExcel Cc: Gerdes, Jeremy D CIV NNSY, C105.4; State change Subject: [Non-DoD Source] Re: [Temtesb/StatisticsCalculationsForExcel] New ms access functions (#6)

I am trying to parse some stock option data (definitely not work related) and am not able to figure out how to do it. Do you have any tools that can make this able to be imported into Access?

On Mon, Jan 23, 2017 at 11:37 PM, Jeremy D. Gerdes <notifications@github.com

wrote:

Merged #6 https://github.com/Temtesb/StatisticsCalculationsForExcel/pull/6.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/Temtesb/StatisticsCalculationsForExcel/pull/6#even t-933936728, or mute the thread https://github.com/notifications/unsubscribe-auth/AYGMRGAw1J16GGxbbrZ Pe7taccQzLW71ks5rVYAdgaJpZM4Lr2wm .

{"optionChain":{"result":[{"underlyingSymbol":"UVXY","expirationDates":[1485475200,1486080000,1486684800,1487289600,1487894400,1488499200,1489708800,1497571200,1516320000,1547769600,1579219200],"strikes":[2.0,4.0,4.5,5.0,5.5,6.0,6.5,7.0,7.5,8.0,8.5,9.0,9.5,10.0,10.5,11.0,11.5,12.0,12.5,13.0,13.5,14.0,14.5,15.0,16.0,16.5,22.5,24.0,24.5,25.0,25.5,26.0,26.5,27.0,27.5,28.0,28.5,29.0,29.5,30.0,30.5,31.0,31.5,32.0,32.5,33.0,33.5,34.0,34.5,35.0,35.5,36.0,36.5,37.0,37.5,38.0,38.5,39.0,39.5,40.0,40.5,41.0,41.5,42.0,42.5,43.0,44.0,45.0,45.5,46.0,46.5,47.0,47.5,48.0,48.5,49.0,49.5,50.0,51.0,51.5,52.0,53.0,54.0,55.0,55.5,56.0,56.5,57.0,58.0,59.0,60.0],"hasMiniOptions":false,"quote":{"quoteType":"ETF","quoteSourceName":"Nasdaq Real Time Price","currency":"USD","regularMarketPrice":28.4,"regularMarketTime":1484960400,"regularMarketChange":-2.4099998,"regularMarketOpen":30.15,"regularMarketDayHigh":30.3841,"regularMarketDayLow":28.4,"regularMarketVolume":21875988,"marketState":"CLOSED","fiftyDayAverage":38.73125,"fiftyDayAverageChange":-10.331251,"fiftyDayAverageChangePercent":-0.266742,"twoHundredDayAverage":85.76087,"twoHundredDayAverageChange":-57.36087,"twoHundredDayAverageChangePercent":-0.6688466,"longName":"ProShares Ultra VIX Short-Term Futures","exchange":"PCX","sourceInterval":15,"exchangeTimezoneName":"America/New_York","exchangeTimezoneShortName":"EST","gmtOffSetMilliseconds":-18000000,"market":"us_market","postMarketPrice":28.57,"postMarketChange":0.17000008,"regularMarketChangePercent":-7.8221354,"regularMarketPreviousClose":30.81,"bid":0.0,"ask":0.0,"bidSize":0,"askSize":0,"messageBoardId":"finmb_141277002","fullExchangeName":"NYSEArca","averageDailyVolume3Month":8205663,"averageDailyVolume10Day":18183866,"fiftyTwoWeekLowChange":0.0,"fiftyTwoWeekLowChangePercent":0.0,"fiftyTwoWeekHighChange":-1519.6,"fiftyTwoWeekHighChangePercent":-0.98165375,"fiftyTwoWeekLow":28.4,"fiftyTwoWeekHigh":1548.0,"shortName":"ProShares Trust Ultra VIX Short","postMarketChangePercent":0.59859186,"postMarketTime":1484960396,"symbol":"UVXY"},"options":[{"expirationDate":1485475200,"hasMiniOptions":false,"calls":[{"contractSymbol":"UVXY170127C00002000","strike":2.0,"currency":"USD","lastPrice":3.8,"change":0.0,"percentChange":0.0,"volume":300,"openInterest":0,"bid":4.1,"ask":5.25,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483764717,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00004500","strike":4.5,"currency":"USD","lastPrice":2.5,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":1,"bid":1.51,"ask":2.29,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483764717,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00005000","strike":5.0,"currency":"USD","lastPrice":1.38,"change":0.0,"percentChange":0.0,"volume":12,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484163549,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00005500","strike":5.5,"currency":"USD","lastPrice":0.81,"change":0.0,"percentChange":0.0,"volume":34,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484168883,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00006000","strike":6.0,"currency":"USD","lastPrice":0.55,"change":0.0,"percentChange":0.0,"volume":184,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484169190,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00006500","strike":6.5,"currency":"USD","lastPrice":0.38,"change":0.0,"percentChange":0.0,"volume":646,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484167554,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00007000","strike":7.0,"currency":"USD","lastPrice":0.3,"change":0.0,"percentChange":0.0,"volume":588,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484167157,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00007500","strike":7.5,"currency":"USD","lastPrice":0.21,"change":0.0,"percentChange":0.0,"volume":325,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484168074,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00008000","strike":8.0,"currency":"USD","lastPrice":0.19,"change":0.0,"percentChange":0.0,"volume":253,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484168692,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00008500","strike":8.5,"currency":"USD","lastPrice":0.16,"change":0.0,"percentChange":0.0,"volume":216,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484168736,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00009000","strike":9.0,"currency":"USD","lastPrice":0.12,"change":0.0,"percentChange":0.0,"volume":178,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484167949,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00009500","strike":9.5,"currency":"USD","lastPrice":0.17,"change":-0.010000005,"percentChange":-5.555558,"volume":107,"openInterest":106,"bid":0.13,"ask":0.17,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483992353,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00010000","strike":10.0,"currency":"USD","lastPrice":0.1,"change":0.0,"percentChange":0.0,"volume":101,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484163006,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00010500","strike":10.5,"currency":"USD","lastPrice":0.09,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484067417,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00011000","strike":11.0,"currency":"USD","lastPrice":0.1,"change":0.0,"percentChange":0.0,"volume":27,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484158244,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00011500","strike":11.5,"currency":"USD","lastPrice":0.1,"change":-0.10999999,"percentChange":-52.38095,"volume":10,"openInterest":22,"bid":0.07,"ask":0.14,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483717782,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00012000","strike":12.0,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":13,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484163107,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00012500","strike":12.5,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":11,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484163023,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00013000","strike":13.0,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":126,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484161321,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00013500","strike":13.5,"currency":"USD","lastPrice":0.15,"change":0.0,"percentChange":0.0,"volume":11,"openInterest":19,"bid":0.01,"ask":0.49,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483649637,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00014000","strike":14.0,"currency":"USD","lastPrice":0.12,"change":-0.07,"percentChange":-36.842106,"volume":10,"openInterest":92,"bid":0.02,"ask":0.19,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483988465,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00014500","strike":14.5,"currency":"USD","lastPrice":0.78,"change":0.0,"percentChange":0.0,"volume":2,"openInterest":2,"bid":0.46,"ask":0.91,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1481949979,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00015000","strike":15.0,"currency":"USD","lastPrice":0.05,"change":-0.08,"percentChange":-61.538464,"volume":9,"openInterest":437,"bid":0.01,"ask":0.13,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483987548,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00016000","strike":16.0,"currency":"USD","lastPrice":0.3,"change":-0.049999982,"percentChange":-14.285709,"volume":4,"openInterest":66,"bid":0.29,"ask":0.4,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483127802,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00016500","strike":16.5,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484071735,"impliedVolatility":1.0000000000000003E-5,"inTheMoney":true},{"contractSymbol":"UVXY170127C00022500","strike":22.5,"currency":"USD","lastPrice":5.9,"change":0.0,"percentChange":0.0,"volume":10,"openInterest":0,"bid":5.05,"ask":6.9,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973438,"impliedVolatility":1.2109414453124998,"inTheMoney":true},{"contractSymbol":"UVXY170127C00024000","strike":24.0,"currency":"USD","lastPrice":4.6,"change":0.0,"percentChange":0.0,"volume":4,"openInterest":0,"bid":3.7,"ask":6.15,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973438,"impliedVolatility":1.642579912109375,"inTheMoney":true},{"contractSymbol":"UVXY170127C00025000","strike":25.0,"currency":"USD","lastPrice":4.08,"change":0.0,"percentChange":0.0,"volume":14,"openInterest":5,"bid":3.05,"ask":4.9,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973439,"impliedVolatility":1.43359658203125,"inTheMoney":true},{"contractSymbol":"UVXY170127C00026000","strike":26.0,"currency":"USD","lastPrice":2.95,"change":0.0,"percentChange":0.0,"volume":61,"openInterest":0,"bid":2.48,"ask":3.15,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973439,"impliedVolatility":1.001958115234375,"inTheMoney":true},{"contractSymbol":"UVXY170127C00026500","strike":26.5,"currency":"USD","lastPrice":2.5,"change":0.0,"percentChange":0.0,"volume":20,"openInterest":21,"bid":2.1,"ask":2.77,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973439,"impliedVolatility":0.9882813671875,"inTheMoney":true},{"contractSymbol":"UVXY170127C00027000","strike":27.0,"currency":"USD","lastPrice":2.0,"change":-2.2600002,"percentChange":-53.051643,"volume":165,"openInterest":7,"bid":1.82,"ask":2.37,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946841,"impliedVolatility":0.9863282617187501,"inTheMoney":true},{"contractSymbol":"UVXY170127C00027500","strike":27.5,"currency":"USD","lastPrice":1.75,"change":0.0,"percentChange":0.0,"volume":134,"openInterest":1,"bid":1.53,"ask":2.02,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973439,"impliedVolatility":0.9775392871093751,"inTheMoney":true},{"contractSymbol":"UVXY170127C00028000","strike":28.0,"currency":"USD","lastPrice":0.99,"change":0.0,"percentChange":0.0,"volume":407,"openInterest":134,"bid":1.34,"ask":1.75,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974339,"impliedVolatility":1.0146533642578124,"inTheMoney":true},{"contractSymbol":"UVXY170127C00028500","strike":28.5,"currency":"USD","lastPrice":1.38,"change":0.0,"percentChange":0.0,"volume":591,"openInterest":32,"bid":1.09,"ask":1.53,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973439,"impliedVolatility":1.0234423828125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00029000","strike":29.0,"currency":"USD","lastPrice":1.25,"change":-1.5699999,"percentChange":-55.67376,"volume":1570,"openInterest":435,"bid":0.99,"ask":1.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946475,"impliedVolatility":1.0644578027343752,"inTheMoney":false},{"contractSymbol":"UVXY170127C00029500","strike":29.5,"currency":"USD","lastPrice":1.01,"change":0.0,"percentChange":0.0,"volume":1069,"openInterest":178,"bid":0.88,"ask":1.18,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973439,"impliedVolatility":1.123051259765625,"inTheMoney":false},{"contractSymbol":"UVXY170127C00030000","strike":30.0,"currency":"USD","lastPrice":0.97,"change":-1.03,"percentChange":-51.5,"volume":2919,"openInterest":1299,"bid":0.73,"ask":0.91,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946642,"impliedVolatility":1.08984830078125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00030500","strike":30.5,"currency":"USD","lastPrice":0.8,"change":-1.1700001,"percentChange":-59.390865,"volume":651,"openInterest":684,"bid":0.62,"ask":0.92,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946016,"impliedVolatility":1.169926025390625,"inTheMoney":false},{"contractSymbol":"UVXY170127C00031000","strike":31.0,"currency":"USD","lastPrice":0.75,"change":-1.01,"percentChange":-57.386364,"volume":517,"openInterest":399,"bid":0.52,"ask":0.84,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946434,"impliedVolatility":1.2041055419921873,"inTheMoney":false},{"contractSymbol":"UVXY170127C00031500","strike":31.5,"currency":"USD","lastPrice":0.69,"change":-0.72999996,"percentChange":-51.40845,"volume":360,"openInterest":402,"bid":0.5,"ask":0.76,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945630,"impliedVolatility":1.2636755566406248,"inTheMoney":false},{"contractSymbol":"UVXY170127C00032000","strike":32.0,"currency":"USD","lastPrice":0.56,"change":-0.91,"percentChange":-61.904762,"volume":952,"openInterest":916,"bid":0.42,"ask":0.55,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946883,"impliedVolatility":1.220707021484375,"inTheMoney":false},{"contractSymbol":"UVXY170127C00032500","strike":32.5,"currency":"USD","lastPrice":0.56,"change":-0.71999997,"percentChange":-56.25,"volume":192,"openInterest":155,"bid":0.05,"ask":0.63,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484944982,"impliedVolatility":1.150394873046875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00033000","strike":33.0,"currency":"USD","lastPrice":0.46,"change":-0.78999996,"percentChange":-63.199997,"volume":276,"openInterest":248,"bid":0.34,"ask":0.57,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946440,"impliedVolatility":1.36328443359375,"inTheMoney":false},{"contractSymbol":"UVXY170127C00033500","strike":33.5,"currency":"USD","lastPrice":0.44,"change":0.0,"percentChange":0.0,"volume":28,"openInterest":72,"bid":0.3,"ask":0.53,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973440,"impliedVolatility":1.40234673828125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00034000","strike":34.0,"currency":"USD","lastPrice":0.36,"change":-0.64,"percentChange":-64.0,"volume":61,"openInterest":274,"bid":0.3,"ask":0.44,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946301,"impliedVolatility":1.4257841210937499,"inTheMoney":false},{"contractSymbol":"UVXY170127C00034500","strike":34.5,"currency":"USD","lastPrice":0.32,"change":-0.6,"percentChange":-65.21739,"volume":33,"openInterest":79,"bid":0.23,"ask":0.45,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946170,"impliedVolatility":1.4609401953124999,"inTheMoney":false},{"contractSymbol":"UVXY170127C00035000","strike":35.0,"currency":"USD","lastPrice":0.31,"change":-0.49,"percentChange":-61.25,"volume":897,"openInterest":507,"bid":0.25,"ask":0.31,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946323,"impliedVolatility":1.4492215039062502,"inTheMoney":false},{"contractSymbol":"UVXY170127C00035500","strike":35.5,"currency":"USD","lastPrice":0.26,"change":-0.53000003,"percentChange":-67.08861,"volume":85,"openInterest":51,"bid":0.18,"ask":0.39,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946141,"impliedVolatility":1.5234398828124998,"inTheMoney":false},{"contractSymbol":"UVXY170127C00036000","strike":36.0,"currency":"USD","lastPrice":0.27,"change":-0.65,"percentChange":-70.65217,"volume":57,"openInterest":175,"bid":0.16,"ask":0.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945879,"impliedVolatility":1.50390873046875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00036500","strike":36.5,"currency":"USD","lastPrice":0.42,"change":-0.31000003,"percentChange":-42.465755,"volume":14,"openInterest":65,"bid":0.14,"ask":0.27,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484933624,"impliedVolatility":1.5195336523437497,"inTheMoney":false},{"contractSymbol":"UVXY170127C00037000","strike":37.0,"currency":"USD","lastPrice":0.23,"change":-0.39999998,"percentChange":-63.492058,"volume":290,"openInterest":450,"bid":0.11,"ask":0.32,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946361,"impliedVolatility":1.5976582617187498,"inTheMoney":false},{"contractSymbol":"UVXY170127C00037500","strike":37.5,"currency":"USD","lastPrice":0.22,"change":0.0,"percentChange":0.0,"volume":208,"openInterest":33,"bid":0.1,"ask":0.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484973440,"impliedVolatility":1.6289081054687498,"inTheMoney":false},{"contractSymbol":"UVXY170127C00038000","strike":38.0,"currency":"USD","lastPrice":0.19,"change":-0.32,"percentChange":-62.745102,"volume":303,"openInterest":86,"bid":0.15,"ask":0.29,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945859,"impliedVolatility":1.72265763671875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00038500","strike":38.5,"currency":"USD","lastPrice":0.18,"change":-0.45,"percentChange":-71.428566,"volume":127,"openInterest":57,"bid":0.08,"ask":0.19,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484944461,"impliedVolatility":1.6015644921874999,"inTheMoney":false},{"contractSymbol":"UVXY170127C00039000","strike":39.0,"currency":"USD","lastPrice":0.15,"change":-0.26999998,"percentChange":-64.28571,"volume":185,"openInterest":140,"bid":0.07,"ask":0.19,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946061,"impliedVolatility":1.640626796875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00039500","strike":39.5,"currency":"USD","lastPrice":0.14,"change":-0.19000001,"percentChange":-57.575756,"volume":13,"openInterest":40,"bid":0.08,"ask":0.24,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946061,"impliedVolatility":1.76171994140625,"inTheMoney":false},{"contractSymbol":"UVXY170127C00040000","strike":40.0,"currency":"USD","lastPrice":0.14,"change":-0.23,"percentChange":-62.162163,"volume":937,"openInterest":597,"bid":0.12,"ask":0.17,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945911,"impliedVolatility":1.7773448632812499,"inTheMoney":false},{"contractSymbol":"UVXY170127C00040500","strike":40.5,"currency":"USD","lastPrice":0.13,"change":-0.27,"percentChange":-67.5,"volume":57,"openInterest":316,"bid":0.04,"ask":0.23,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945426,"impliedVolatility":1.8007822460937497,"inTheMoney":false},{"contractSymbol":"UVXY170127C00041000","strike":41.0,"currency":"USD","lastPrice":0.19,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":106,"bid":0.03,"ask":0.11,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974341,"impliedVolatility":1.640626796875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00041500","strike":41.5,"currency":"USD","lastPrice":0.34,"change":0.0,"percentChange":0.0,"volume":19,"openInterest":15,"bid":0.02,"ask":0.13,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974341,"impliedVolatility":1.703126484375,"inTheMoney":false},{"contractSymbol":"UVXY170127C00042000","strike":42.0,"currency":"USD","lastPrice":0.11,"change":0.0,"percentChange":0.0,"volume":4,"openInterest":235,"bid":0.02,"ask":0.2,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974341,"impliedVolatility":1.8671881640625,"inTheMoney":false},{"contractSymbol":"UVXY170127C00042500","strike":42.5,"currency":"USD","lastPrice":0.4,"change":0.0,"percentChange":0.0,"volume":23,"openInterest":19,"bid":0.01,"ask":0.19,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974341,"impliedVolatility":1.8789068554687498,"inTheMoney":false},{"contractSymbol":"UVXY170127C00043000","strike":43.0,"currency":"USD","lastPrice":0.17,"change":0.0,"percentChange":0.0,"volume":2,"openInterest":45,"bid":0.06,"ask":0.1,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974341,"impliedVolatility":1.8515632421875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00044000","strike":44.0,"currency":"USD","lastPrice":0.3,"change":0.0,"percentChange":0.0,"volume":10,"openInterest":13,"bid":0.0,"ask":0.09,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974341,"impliedVolatility":1.765626171875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00045000","strike":45.0,"currency":"USD","lastPrice":0.07,"change":0.0,"percentChange":0.0,"volume":789,"openInterest":96,"bid":0.04,"ask":0.08,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.9218753906250001,"inTheMoney":false},{"contractSymbol":"UVXY170127C00045500","strike":45.5,"currency":"USD","lastPrice":0.11,"change":0.0,"percentChange":0.0,"volume":10,"openInterest":10,"bid":0.01,"ask":0.08,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.875000625,"inTheMoney":false},{"contractSymbol":"UVXY170127C00046000","strike":46.0,"currency":"USD","lastPrice":0.1,"change":0.0,"percentChange":0.0,"volume":29,"openInterest":0,"bid":0.05,"ask":0.16,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":2.183598291015625,"inTheMoney":false},{"contractSymbol":"UVXY170127C00046500","strike":46.5,"currency":"USD","lastPrice":0.11,"change":0.0,"percentChange":0.0,"volume":28,"openInterest":32,"bid":0.0,"ask":0.07,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.8828130859374999,"inTheMoney":false},{"contractSymbol":"UVXY170127C00047000","strike":47.0,"currency":"USD","lastPrice":0.09,"change":0.0,"percentChange":0.0,"volume":133,"openInterest":30,"bid":0.0,"ask":0.07,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.9218753906250001,"inTheMoney":false},{"contractSymbol":"UVXY170127C00047500","strike":47.5,"currency":"USD","lastPrice":0.09,"change":0.0,"percentChange":0.0,"volume":100,"openInterest":0,"bid":0.0,"ask":0.06,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.9062504687500001,"inTheMoney":false},{"contractSymbol":"UVXY170127C00048000","strike":48.0,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":168,"openInterest":51,"bid":0.0,"ask":0.06,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.9375003125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00048500","strike":48.5,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":20,"openInterest":0,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.9375003125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00049000","strike":49.0,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":123,"openInterest":629,"bid":0.02,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":2.0468798828125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00049500","strike":49.5,"currency":"USD","lastPrice":0.2,"change":0.0,"percentChange":0.0,"volume":1144,"openInterest":1077,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974342,"impliedVolatility":1.984375078125,"inTheMoney":false},{"contractSymbol":"UVXY170127C00050000","strike":50.0,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":253,"openInterest":1134,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.031254921875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00051000","strike":51.0,"currency":"USD","lastPrice":0.06,"change":0.0,"percentChange":0.0,"volume":150,"openInterest":11,"bid":0.0,"ask":0.04,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.031254921875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00051500","strike":51.5,"currency":"USD","lastPrice":0.06,"change":0.0,"percentChange":0.0,"volume":37,"openInterest":0,"bid":0.0,"ask":0.04,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.0625048437499998,"inTheMoney":false},{"contractSymbol":"UVXY170127C00052000","strike":52.0,"currency":"USD","lastPrice":0.06,"change":0.0,"percentChange":0.0,"volume":2,"openInterest":88,"bid":0.0,"ask":0.04,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.0937547656249995,"inTheMoney":false},{"contractSymbol":"UVXY170127C00053000","strike":53.0,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":3,"openInterest":0,"bid":0.0,"ask":0.04,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.1406296484375,"inTheMoney":false},{"contractSymbol":"UVXY170127C00054000","strike":54.0,"currency":"USD","lastPrice":0.06,"change":0.0,"percentChange":0.0,"volume":350,"openInterest":14,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.2500043749999996,"inTheMoney":false},{"contractSymbol":"UVXY170127C00055000","strike":55.0,"currency":"USD","lastPrice":0.06,"change":0.0,"percentChange":0.0,"volume":110,"openInterest":234,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.3125042187499996,"inTheMoney":false},{"contractSymbol":"UVXY170127C00055500","strike":55.5,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":100,"openInterest":0,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974343,"impliedVolatility":2.3437541406249993,"inTheMoney":false},{"contractSymbol":"UVXY170127C00056000","strike":56.0,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":54,"openInterest":100,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974344,"impliedVolatility":2.3593791015624994,"inTheMoney":false},{"contractSymbol":"UVXY170127C00056500","strike":56.5,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":21,"openInterest":0,"bid":0.0,"ask":0.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974344,"impliedVolatility":2.3906290234374996,"inTheMoney":false},{"contractSymbol":"UVXY170127C00057000","strike":57.0,"currency":"USD","lastPrice":0.03,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":110,"bid":0.0,"ask":0.12,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974344,"impliedVolatility":2.69531576171875,"inTheMoney":false},{"contractSymbol":"UVXY170127C00058000","strike":58.0,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":305,"openInterest":61,"bid":0.0,"ask":0.04,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974344,"impliedVolatility":2.4062539843749997,"inTheMoney":false},{"contractSymbol":"UVXY170127C00059000","strike":59.0,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":10,"openInterest":45,"bid":0.0,"ask":0.03,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974344,"impliedVolatility":2.3750040624999995,"inTheMoney":false},{"contractSymbol":"UVXY170127C00060000","strike":60.0,"currency":"USD","lastPrice":0.02,"change":0.0,"percentChange":0.0,"volume":115,"openInterest":489,"bid":0.01,"ask":0.02,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974344,"impliedVolatility":2.43750390625,"inTheMoney":false}],"puts":[{"contractSymbol":"UVXY170127P00004000","strike":4.0,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":63,"bid":0.0,"ask":0.25,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1482433458,"impliedVolatility":9.03125435546875,"inTheMoney":false},{"contractSymbol":"UVXY170127P00004500","strike":4.5,"currency":"USD","lastPrice":0.01,"change":0.0,"percentChange":0.0,"volume":5,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484207896,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00005000","strike":5.0,"currency":"USD","lastPrice":0.04,"change":0.0,"percentChange":0.0,"volume":8,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484167775,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00005500","strike":5.5,"currency":"USD","lastPrice":0.21,"change":0.0,"percentChange":0.0,"volume":195,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484168403,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00006000","strike":6.0,"currency":"USD","lastPrice":0.45,"change":0.0,"percentChange":0.0,"volume":93,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484166933,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00006500","strike":6.5,"currency":"USD","lastPrice":0.81,"change":0.0,"percentChange":0.0,"volume":32,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484166902,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00007000","strike":7.0,"currency":"USD","lastPrice":1.14,"change":0.0,"percentChange":0.0,"volume":567,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484164492,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00007500","strike":7.5,"currency":"USD","lastPrice":1.64,"change":0.0,"percentChange":0.0,"volume":42,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484168551,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00008000","strike":8.0,"currency":"USD","lastPrice":1.95,"change":0.0,"percentChange":0.0,"volume":6,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484166230,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00008500","strike":8.5,"currency":"USD","lastPrice":2.49,"change":0.0,"percentChange":0.0,"volume":4,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484163641,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00009000","strike":9.0,"currency":"USD","lastPrice":2.97,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":0,"bid":0.0,"ask":0.0,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484163077,"impliedVolatility":0.500005,"inTheMoney":false},{"contractSymbol":"UVXY170127P00009500","strike":9.5,"currency":"USD","lastPrice":2.71,"change":0.0,"percentChange":0.0,"volume":1,"openInterest":2,"bid":2.78,"ask":3.4,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483547246,"impliedVolatility":13.347657907714844,"inTheMoney":false},{"contractSymbol":"UVXY170127P00010000","strike":10.0,"currency":"USD","lastPrice":3.32,"change":0.0,"percentChange":0.0,"volume":20,"openInterest":191,"bid":3.6,"ask":3.9,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483635432,"impliedVolatility":14.195313627929687,"inTheMoney":false},{"contractSymbol":"UVXY170127P00010500","strike":10.5,"currency":"USD","lastPrice":2.61,"change":-0.19000006,"percentChange":-6.785716,"volume":2,"openInterest":25,"bid":2.53,"ask":3.25,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483126205,"impliedVolatility":11.824221359863284,"inTheMoney":false},{"contractSymbol":"UVXY170127P00011000","strike":11.0,"currency":"USD","lastPrice":3.72,"change":0.0,"percentChange":0.0,"volume":108,"openInterest":276,"bid":4.35,"ask":4.7,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483460592,"impliedVolatility":14.566407145996095,"inTheMoney":false},{"contractSymbol":"UVXY170127P00011500","strike":11.5,"currency":"USD","lastPrice":4.86,"change":0.0,"percentChange":0.0,"volume":20,"openInterest":21,"bid":4.9,"ask":5.4,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483764740,"impliedVolatility":15.191406755371094,"inTheMoney":false},{"contractSymbol":"UVXY170127P00012000","strike":12.0,"currency":"USD","lastPrice":5.69,"change":0.46000004,"percentChange":8.795412,"volume":2,"openInterest":85,"bid":5.15,"ask":5.95,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483733831,"impliedVolatility":15.332031667480468,"inTheMoney":false},{"contractSymbol":"UVXY170127P00012500","strike":12.5,"currency":"USD","lastPrice":5.35,"change":0.0,"percentChange":0.0,"volume":4,"openInterest":17,"bid":4.85,"ask":5.3,"contractSize":"REGULAR","expirati on":1485475200,"lastTradeDate":1482432556,"impliedVolatility":13.847657595214844,"inTheMoney":false},{"contractSymbol":"UVXY170127P00013000","strike":13.0,"currency":"USD","lastPrice":5.59,"change":0.0,"percentChange":0.0,"volume":100,"openInterest":116,"bid":6.2,"ask":6.95,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483460592,"impliedVolatility":15.992187504882812,"inTheMoney":false},{"contractSymbol":"UVXY170127P00013500","strike":13.5,"currency":"USD","lastPrice":5.61,"change":0.0,"percentChange":0.0,"volume":50,"openInterest":50,"bid":5.1,"ask":6.2,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483159519,"impliedVolatility":13.757813901367188,"inTheMoney":false},{"contractSymbol":"UVXY170127P00014000","strike":14.0,"currency":"USD","lastPrice":5.99,"change":0.0,"percentChange":0.0,"volume":51,"openInterest":97,"bid":5.55,"ask":6.65,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483032694,"impliedVolatility":13.972657517089843,"inTheMoney":false},{"contractSymbol":"UVXY170127P00014500","strike":14.5,"currency":"USD","lastPrice":6.09,"change":0.0,"percentChange":0.0,"volume":3,"openInterest":3,"bid":5.9,"ask":6.8,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1481949995,"impliedVolatility":13.849610718994143,"inTheMoney":false},{"contractSymbol":"UVXY170127P00015000","strike":15.0,"currency":"USD","lastPrice":6.47,"change":0.0,"percentChange":0.0,"volume":2,"openInterest":2,"bid":6.45,"ask":7.25,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1481949995,"impliedVolatility":14.117188676757813,"inTheMoney":false},{"contractSymbol":"UVXY170127P00016000","strike":16.0,"currency":"USD","lastPrice":8.07,"change":0.0,"percentChange":0.0,"volume":109,"openInterest":106,"bid":7.45,"ask":8.45,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1483033285,"impliedVolatility":14.761719523925784,"inTheMoney":false},{"contractSymbol":"UVXY170127P00022500","strike":22.5,"currency":"USD","lastPrice":0.02,"change":0.0,"percentChange":0.0,"volume":6,"openInterest":0,"bid":0.0,"ask":0.11,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":1.140629296875,"inTheMoney":false},{"contractSymbol":"UVXY170127P00024000","strike":24.0,"currency":"USD","lastPrice":0.05,"change":0.0,"percentChange":0.0,"volume":75,"openInterest":25,"bid":0.0,"ask":0.09,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":0.8359391406249999,"inTheMoney":false},{"contractSymbol":"UVXY170127P00024500","strike":24.5,"currency":"USD","lastPrice":0.07,"change":0.0,"percentChange":0.0,"volume":47,"openInterest":0,"bid":0.02,"ask":0.13,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":0.8398453515625,"inTheMoney":false},{"contractSymbol":"UVXY170127P00025000","strike":25.0,"currency":"USD","lastPrice":0.1,"change":0.0,"percentChange":0.0,"volume":134,"openInterest":0,"bid":0.05,"ask":0.15,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":0.8007832421875,"inTheMoney":false},{"contractSymbol":"UVXY170127P00025500","strike":25.5,"currency":"USD","lastPrice":0.15,"change":0.0,"percentChange":0.0,"volume":123,"openInterest":30,"bid":0.06,"ask":0.24,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":0.789064609375,"inTheMoney":false},{"contractSymbol":"UVXY170127P00026000","strike":26.0,"currency":"USD","lastPrice":0.24,"change":0.0,"percentChange":0.0,"volume":129,"openInterest":0,"bid":0.16,"ask":0.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":0.7929708203125,"inTheMoney":false},{"contractSymbol":"UVXY170127P00026500","strike":26.5,"currency":"USD","lastPrice":0.45,"change":0.24999999,"percentChange":124.999985,"volume":223,"openInterest":194,"bid":0.32,"ask":0.5,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946871,"impliedVolatility":0.867188828125,"inTheMoney":false},{"contractSymbol":"UVXY170127P00027000","strike":27.0,"currency":"USD","lastPrice":0.6,"change":0.3,"percentChange":100.0,"volume":259,"openInterest":394,"bid":0.55,"ask":0.8,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946033,"impliedVolatility":0.9687503125,"inTheMoney":false},{"contractSymbol":"UVXY170127P00027500","strike":27.5,"currency":"USD","lastPrice":0.84,"change":0.42,"percentChange":100.0,"volume":347,"openInterest":236,"bid":0.7,"ask":1.05,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946871,"impliedVolatility":0.9775392871093751,"inTheMoney":false},{"contractSymbol":"UVXY170127P00028000","strike":28.0,"currency":"USD","lastPrice":1.04,"change":0.45999998,"percentChange":79.31035,"volume":407,"openInterest":124,"bid":0.93,"ask":1.23,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946675,"impliedVolatility":0.9648441015625,"inTheMoney":false},{"contractSymbol":"UVXY170127P00028500","strike":28.5,"currency":"USD","lastPrice":1.42,"change":0.0,"percentChange":0.0,"volume":283,"openInterest":101,"bid":1.21,"ask":1.64,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974383,"impliedVolatility":1.0351610742187503,"inTheMoney":true},{"contractSymbol":"UVXY170127P00029000","strike":29.0,"currency":"USD","lastPrice":1.81,"change":0.87999994,"percentChange":94.62365,"volume":606,"openInterest":211,"bid":1.52,"ask":1.93,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946061,"impliedVolatility":1.0488328808593752,"inTheMoney":true},{"contractSymbol":"UVXY170127P00029500","strike":29.5,"currency":"USD","lastPrice":2.17,"change":0.8900001,"percentChange":69.531265,"volume":396,"openInterest":473,"bid":1.9,"ask":2.69,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484946061,"impliedVolatility":1.2500037499999999,"inTheMoney":true},{"contractSymbol":"UVXY170127P00030000","strike":30.0,"currency":"USD","lastPrice":2.41,"change":0.97,"percentChange":67.36111,"volume":730,"openInterest":669,"bid":2.21,"ask":2.72,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945727,"impliedVolatility":1.126957490234375,"inTheMoney":true},{"contractSymbol":"UVXY170127P00030500","strike":30.5,"currency":"USD","lastPrice":2.38,"change":0.7700001,"percentChange":47.82609,"volume":45,"openInterest":94,"bid":2.65,"ask":3.2,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484940127,"impliedVolatility":1.2148476757812499,"inTheMoney":true},{"contractSymbol":"UVXY170127P00031000","strike":31.0,"currency":"USD","lastPrice":3.29,"change":1.1800001,"percentChange":55.92418,"volume":568,"openInterest":262,"bid":3.0,"ask":3.55,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484945985,"impliedVolatility":1.19922275390625,"inTheMoney":true},{"contractSymbol":"UVXY170127P00031500","strike":31.5,"currency":"USD","lastPrice":3.1,"change":0.0,"percentChange":0.0,"volume":36,"openInterest":69,"bid":3.4,"ask":3.85,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974384,"impliedVolatility":1.1640666796875,"inTheMoney":true},{"contractSymbol":"UVXY170127P00032000","strike":32.0,"currency":"USD","lastPrice":4.25,"change":0.0,"percentChange":0.0,"volume":63,"openInterest":0,"bid":3.85,"ask":4.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974384,"impliedVolatility":1.2109414453124998,"inTheMoney":true},{"contractSymbol":"UVXY170127P00032500","strike":32.5,"currency":"USD","lastPrice":4.4,"change":0.0,"percentChange":0.0,"volume":30,"openInterest":31,"bid":4.05,"ask":4.85,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974384,"impliedVolatility":1.162113564453125,"inTheMoney":true},{"contractSymbol":"UVXY170127P00033000","strike":33.0,"currency":"USD","lastPrice":5.05,"change":0.0,"percentChange":0.0,"volume":27,"openInterest":100,"bid":4.45,"ask":5.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974384,"impliedVolatility":1.15234798828125,"inTheMoney":true},{"contractSymbol":"UVXY170127P00033500","strike":33.5,"currency":"USD","lastPrice":4.7,"change":0.0,"percentChange":0.0,"volume":11,"openInterest":6,"bid":4.65,"ask":5.7,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974384,"impliedVolatility":0.8828136718749999,"inTheMoney":true},{"contractSymbol":"UVXY170127P00034000","strike":34.0,"currency":"USD","lastPrice":5.25,"change":0.0,"percentChange":0.0,"volume":15,"openInterest":15,"bid":5.3,"ask":6.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974384,"impliedVolatility":1.19141029296875,"inTheMoney":true},{"contractSymbol":"UVXY170127P00035000","strike":35.0,"currency":"USD","lastPrice":6.75,"change":1.0500002,"percentChange":18.421057,"volume":41,"openInterest":123,"bid":6.25,"ask":7.35,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484943303,"impliedVolatility":1.32422212890625,"inTheMoney":true},{"contractSymbol":"UVXY170127P00036000","strike":36.0,"currency":"USD","lastPrice":6.7,"change":0.5999999,"percentChange":9.836064,"volume":40,"openInterest":52,"bid":6.95,"ask":8.3,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484926200,"impliedVolatility":0.9765627343750001,"inTheMoney":true},{"contractSymbol":"UVXY170127P00037000","strike":37.0,"currency":"USD","lastPrice":7.4,"change":0.0,"percentChange":0.0,"volume":28,"openInterest":4,"bid":7.6,"ask":9.5,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974385,"impliedVolatility":2.46094134765625,"inTheMoney":true},{"contractSymbol":"UVXY170127P00045500","strike":45.5,"currency":"USD","lastPrice":16.5,"change":0.0,"percentChange":0.0,"volume":10,"openInterest":0,"bid":16.45,"ask":17.9,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974385,"impliedVolatility":2.031254921875,"inTheMoney":true},{"contractSymbol":"UVXY170127P00060000","strike":60.0,"currency":"USD","lastPrice":29.0,"change":0.0,"percentChange":0.0,"volume":7,"openInterest":7,"bid":30.1,"ask":32.4,"contractSize":"REGULAR","expiration":1485475200,"lastTradeDate":1484974387,"impliedVolatility":4.582035522460938,"inTheMoney":true}]}]}],"error":null}}

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/Temtesb/StatisticsCalculationsForExcel/pull/6#issuecomment-274988435 , or mute the thread https://github.com/notifications/unsubscribe-auth/AYCPrUO3smLtzN1lDfMg8Q4dgbYG2__5ks5rVp4tgaJpZM4Lr2wm . https://github.com/notifications/beacon/AYCPrXKBfIwQ02Tq4daed2_X9LF4JH4hks5rVp4tgaJpZM4Lr2wm.gif