Visualizing Bitcoin Adventures

I’ve been riding a Bitcoin (and Ethereum) roller coaster for a year .. and its been a fun little diversion.   However, its hard to see the journey .. it feels like I’ve come out ahead, but have I really?

I doodled various (complicated) ways to try to show stuff via a 3D graph .. but when I actually went to play, this 2D version works just as well:

image

  • Vertical (down) drops ==  I transferred bitcoin (either to another account, or buying something with bitcoin).
  • To the top-left = I bought bitcoin for USD
  • To the bottom-right = I sold bitcoin for USD (for buying something usually)
  • Note: A similar chart would exist for my Ethereum account.  No, i did not buy a switch for $90, it was more than that.
  • Steep curve vs Shallow curve gives a feeling for price.   buy Steep, sell Shallow is the desire.
  • I could beat myself up .. if only I hadn’t spent the bitcoin, I’d have so much more now…
  • Currently, my experiment is net-positive.  Even if bitcoin goes to $0 right now.

How I created this

  • Download transaction report from Coinbase.   This is a .CSV file, which I then open in excel.
  • Their report has a “Amount” (Column C) which has + for bitcoin added, – for bitcoin removed.
  • Their report has a “Transfer Total” (Column H) .. but it isn’t signed. 
  • Their report also has a Transfer Fee column .. I’m ignoring that for this graph.    I did sum it up, I’ve paid $30 in fees this year.
  • Add a new column, “Signed Transfer Total”   formula is something like “=IF(H27<>0,H27*SIGN(-C27),0)” – to get a signed USD column.  Note that I’m reversing the sign so that a plus in bitcoin is a minus in USD.
  • Add a new column, “USD Balance”, which sums up all the Signed Transfer Total to date.   Something like “=SUM(J$6:J27)”.  For simplicity I added it right next to their bitcoin balance column
  • Grab those two columns and chart it, scatterplot, lines
  • Adjust the vertical size of the graph till you get something that works for you.  

In summary

I do not regret this Bitcoin experiment.

I do hope to leave stuff in Bitcoin, i think it will continue to grow for a while.

Tagged with:
Posted in Code

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories
Tags
.net 3d 3d-printing 4k abc15 algorithms ames android anonymous types asp.net audio editing aws backup basecamp beatunes biorhythm bitcoin bittorrent blender blog boston marathon bpm c# caffeine campfire candycrush car carmax charity chiropractor cities-skylines clog clone codelouisville codepalousa coding coffee collaboration color run ComputerElbow ComputerVision configuration consulting cooking crash course crashplan crestwood cycling dabda dan dapper DataSet ddl diabetes dictation dotnetcore dotnetmud downtown e-cycling elite excel exercise expiration facebook feature-branching firefall flipflops Flow FL Studio focus food forecastle fortresscraft franklinplanner gadgets game-design games git github google docs google maps gopro gps grandpa greenshot hack half marathon headless health heart rate hiren ignew integration testing interop inventory ios ipad itunes javascript jobs karma kdf keyboards keys kittens lamont laptop lavalamp lego life lifehack linq linqtotwitter linux los angeles louisville mandelbulber massage therapy mastery-teaching maths merge metformin Minecraft miniature modeling monitor mud muhammad ali institute music mvc mycartracks netfabb nexus10 node nostalgia nutrition nwipe oldham county grand slam opal openjscad openscad owin pacedj paper mockup pepakura performance photoscan politics pomodoro postgresql powershell premiere prius process product-management project-management qa ReFS resharper review rmi roman road 5k RSI rubiks running samsung 700t sandals schedule scooter scribblelive selenium service shapeways sleep slic3r sneakersync snot software software-engineering solidoodle soylent spacegame speaking sql sqlite SSDT SSIS standing state-machine stayfocusd stonehearth sunset tablet teaching team teamcity teamtreehouse terraform tesla testing tfs time timelapse torque touch tracks trs80 Tuple tutor twitter ubuntu unit testing utilities video video editing visual studio vscode vsvim warp stabilizer windows 8 windows home server wordpress wpf xml
Archives
%d bloggers like this: