Tutorial: Auto Updating Cryptocurrency Portfolio on Excel Spreadsheet
  • Tutorial: Auto Updating Cryptocurrency Portfolio on Excel Spreadsheet
  • Tutorial: Auto Updating Cryptocurrency Portfolio on Excel Spreadsheet
Originally published: 25/01/2018 11:14
Publication number: ELQ-76398-1
View all versions & Certificate
certified

Tutorial: Auto Updating Cryptocurrency Portfolio on Excel Spreadsheet

Jackson Zeng explains how to make a spreadsheet that automatically updates cryptocurrency prices.

Description
This video shows you how to make an auto-updating cryptocurrency portfolio using Excel. If you have been interested in cryptocurrency for a while, you will probably have quite a few coins that you are interested in, but the problem is that not every coin is on the same exchange and not every wallet holds the same coin. This makes it near impossible to keep track of.

The Excel spreadsheet that Jackson Zeng has created automatically updates the prices, allowing him to have a good idea of where his money is and how much the money is worth. There are websites that do this for you but they generally do not give you as much control. By making your own Excel spreadsheet, you will have full control.

API data link: https://api.coinmarketcap.com/v1/ticker/
Example File: https://drive.google.com/file/d/0B__H...

When opening the link, you will see a yellow banner at the top of the page where you will need to enable external data to allow excel to connect to the internet and retrieve the data.

Video length: 19:10

This business tool includes
1 Video File

Jackson Zeng offers you this business tool for free!

view video for free

Add to bookmarks

Discuss

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Tutorial: Auto Updating Cryptocurrency Portfolio On Excel Spreadsheet?

The user community and author are here to help. Go ahead!

please wait...