Comparing Options Contracts

Bitcoin Options Price Feed Data and Analysis on LedgerX

This is a spreadsheet I created to compare what call or put options are best to buy, specifically using this for Bitcoin options on LedgerX but can be used with any options really.  You can essentially use this as an API for LedgerX options price data into your own scripts as well by using the ImportRange function.
https://docs.google.com/spreadsheets/d/1dZbFjCrr2FykdPvE4UVLp8kOO5Iox9lmctSmfqSTq1I/edit#gid=0

Sometimes the further out of money contract actually has less upside than something in the money, and this sheet makes it easier to see.  It also tells you how much money you need to have in another contract to make the same return as the first, so you can have less money tied up in one place.

As a live example using this, you can see currently that the December 15K strike calls for Bitcoin are not worth buying, that you'll make more buying the 10K strike unless Bitcoin goes above $25K by December.  Going up any less would lead to the 10K strike making more.


Using this, you can also find the minimum cash to make $1M on $BTC going to $100K by Dec. 2020:
- $10K strike: $30K
- $25K strike: $12K
- $50K strike: $6K
You lose everything if the strike isn't hit in 1.5 yrs, but you avoid locking up $80K if directly invested in BTC instead.