I have been absolutely tickled pink to learn just how much can really be done with Excel.

I've been wanting to start tracking some of the prices and price movement on my own and without having to buy any software. I was delighted to find out that I could do a lot of what I wanted to do on Excel....

First off.... you can get data into excel by going to the "DATA" tab and then "New Query" and "from other sources" and then "from Web".... then put in the address of an exchanges api, such as "https://api.gdax.com/products/BTC-USD/ticker" or "https://bittrex.com/api/v1.1/public/getticker?market=usdt-ltc".... go through a few steps and you now have that markets data in your excel spreadsheet to do with as you like.

If anyone is interested I've even written a little bit of code to get the data once a min, and then print it out to a graph.... took several hours to figure out (i'm no programmer), but was super cool when I finished :D