Blabberbox » 42 » Comparing Options ContractsShare on Twitter

Comparing Options Contracts

June 12th, 2019 | Posted by pftq in 42 | #

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.
Last Updated Jan 31st, 2020 | 976 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

  2. pftq said,
    Jul-18-2019, 04:57pm

    Added rough estimate of deltas to be able to see what contracts would move most:  https://docs.google.com/spreadsheets/d/1dZbFjCrr2FykdPvE4UVLp8kOO5Iox9lmctSmfqSTq1I/edit#gid=1326954055

  3. pftq said,
    Jul-27-2021, 08:21am

    ETH contracts added to the sheet: https://docs.google.com/spreadsheets/d/1dZbFjCrr2FykdPvE4UVLp8kOO5Iox9lmctSmfqSTq1I/edit#gid=1584230668

Leave a Comment

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