Update: Sorry! This video is outdated and won’t work exactly the same way anymore
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: (no longer works – removed)
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.