Update: Video is outdated
For cryptocurrency brokerage services, go to calebandbrown.com
How to make a spreadsheet with automatically updated prices from coinmarketcap API.
API data link here: https://api.coinmarketcap.com/v1/ticker/
Example File: https://drive.google.com/file/d/0B__HlHJ29Ar6R2tFUk5lWFdpUFU/view?usp=sharing
When you open it, there will be a yellow banner at the top where you need to enable external data to allow excel to connect to the internet and retrieve the coinmarketcap data.