home Videos Tutorial: Auto Updating Cryptocurrency Portfolio on Excel Spreadsheet

Tutorial: Auto Updating Cryptocurrency Portfolio on Excel Spreadsheet





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.

source

Leave a Reply

Your email address will not be published. Required fields are marked *