Publication number: ELQ-76398-1
View all versions & Certificate
Tutorial: Auto Updating Cryptocurrency Portfolio on Excel Spreadsheet
Jackson Zeng explains how to make a spreadsheet that automatically updates cryptocurrency prices.
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 Best Practice includes
1 Video File
Jackson Zeng offers you this Best Practice for free!
view video for free
Add to bookmarks
- Rate this Video File
Write a review
- Dapeng Lan(last updated: 19/11/2019 10:29)good
- mikr17(last updated: 21/05/2019 08:04)
People using this Best Practice also downloaded
Blockchain/ICO Forecasting and Analysis Financial Excel Model TemplateThis ICO model allows you to analyse and create financial projections for cryptocurrencies and blockchains.investmentsforecastfinancial modelinvestorsexcel2,595add_shopping_cart
Cryptocurrency Portfolio Dashboard in Microsoft Excel - Data Live from COINMARKETCAP WebsiteCryptocurrency Portfolio Dashboard in Microsoft Excel - Data Live from COINMARKETCAP Website (Improved & Advanced) May21dashboardexcelportfoliocryptocurrencybitcoin3,425add_shopping_cart
CryptoCurrency Portfolio DashboardA CryptoCurrency Portfolio Dashboard in Microsoft Excel to download.dashboardexcelcryptocurrencybitcoin4,579add_shopping_cart
Cryptocurrency Portfolio Excel TrackerCryptocurrency portfolio tracking tool, allowing you to keep track of all your different cryptocurrency investmentsexcelcryptocurrencycryptocurrency portfoliocryptocurrency performancecryptocurrency template6,232add_shopping_cartfreeby Anders Jensen
Cryptocurrency Investment Tracking SpreadsheetThis concise, easy-to use Excel tool will allow you to easily keep track of all your cyptocurrency investments.trackingcryptocurrencybitcoincryptocurrency portfoliomonero4,493add_shopping_cartfreeby CoinFabrik
Cryptocurrency Real-time Price Tracker in ExcelReal-time Cryptocurrency price-tracker that is connected to worldcoinindex website that updates the price each minute.calculatorexcelspreadsheetcryptocurrencycrypto3,000add_shopping_cartfreeby Crypto Friendly
Crypto Currency Portfolio DashboardFor Trading Future Contracts on Binance Futures in Microsoft Excel - Crypto Currency Portfolio Dashboard.tradingdashboardexcelcryptocurrencybitcoin279add_shopping_cart$19.50by MVsharing
Bitcoin Farm Model - Excel TemplateFinancial model of a BTC (Bitcoin) cryptocurrency mining farm in Microsoft Excel.cryptocurrencycryptobitcoinminingfarming705add_shopping_cart
Bitcoin Cryptocurrency LIFO (Last In First Out) Gain Calculator for TaxationVery easy-to-use handy Excel sheet for calculating the gains (after commissions) in bitcoin trading using LIFO method.cryptocurrencybitcoinbitcoin taxtax calculatorlifo gains5,305add_shopping_cart$19.00by Soni Excel Solutions
Cryptocurrency Portfolio TrackerCryptocurrency Portfolio Tracker in Excel that updates prices and produces a pie chart.excelspreadsheettrackingbitcoinfintech1,460add_shopping_cartfreeby Prks21
Discussion feed for Tutorial: Auto Updating Cryptocurrency Portfolio On Excel Spreadsheet
The user community and author are here to help. Go ahead!