Blabberbox » Comparing Options ContractsShare on Twitter

Comparing Options Contracts

June 12th, 2019 | Posted by pftq in Blabberbox | #
This is a spreadsheet I created to compare what call or put options are best to buy, specifically using this for #Bitcoin $BTC options on @LedgerX but can be used with any options really.  
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 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.
154 unique view(s)

Responses

  1. pftq said,
    Jul-01-2019, 11:41am

    Added tabs pulling live Bitcoin options data and prices from @LedgerX's API.  Anyone else can also pull from this sheet into their own Googlesheet or Excel with Import Range:  https://docs.google.com/spreadsheets/d/1dZbFjCrr2FykdPvE4UVLp8kOO5Iox9lmctSmfqSTq1I/edit#gid=1326954055

Leave a Comment

Name: (Have an account? Login or Register)
Email: (Won't be published)
Website: (Optional)
Comment:
Enter the code from image: