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 business tool includes
1 Video File
Jackson Zeng offers you this business tool for free!
view video for free
Add to bookmarks
- No review yet!
People using this tool also downloaded
Cryptocurrency Portfolio Excel TrackerCryptocurrency portfolio tracking tool, allowing you to keep track of all your different cryptocurrency investmentsexcelcryptocurrencycryptocurrency portfoliocryptocurrency performancecryptocurrency templatecryptocurrency trackerico investmentscryptocurrency marketcryptojourney1,042 remove_red_eyefreeby 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 portfoliomonerocryptocurrency investmentethereumzcashcryptocurrency valueinvestment tracking1,238 remove_red_eyefreeby CoinFabrik
Cryptocurrency Real-time Price Tracker in ExcelReal-time Cryptocurrency price-tracker that is connected to worldcoinindex website that updates the price each minute.calculatorexcelspreadsheetcryptocurrencycryptoprice trackerbitcoinfintechreal time656 remove_red_eye
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 gainslast in first outbitcoin tax calculatorcryptocurrency tax calculatorlifo calculatorbtc tax calculator284 remove_red_eye$10.00by Tejasvita Soni
Cryptocurrency ICO Excel TrackerCryptocurrency ICO tracker spreadsheet with YouTube tutorial.templateexcelbitcoinethereumcryptocurrency trackerico trackercryptocurrency invesmentico investmentcryptocurrency ico905 remove_red_eyefreeby Paul Mc
How to Use Google Sheets to Track Cryptocurrency PricesA comprehensive guide on how to use Google Sheets to track cryptocurrency prices.trackercryptocurrencybitcoingoogle sheets131 remove_red_eyefreeby CoinStaker
Beginner's Guide to Technical Analysis for Trading CryptocurrenciesAn introduction to technical analysis with regards to cryptocurrency.graphscryptocurrencybitcointechnical analysiscandlestick patternforexanalysing130 remove_red_eyefreeby Crypto Oracle
Cryptocurrency Portfolio TrackerCryptocurrency Portfolio Tracker in Excel that updates prices and produces a pie chart.excelspreadsheettrackingbitcoinfintechcryptocurrecyportfliokeeping track233 remove_red_eyefreeby Prks21
How to Buy Bitcoin Using CoinbaseThis video will demonstrate how to buy bitcoin using Coinbase.buyingcryptocurrencycryptobitcoincoinbasewalletsaltcoinico33 remove_red_eye
5 Cryptocurrency Lessons for New Traders and Investors5 essential lessons for Cryptocurrency beginners.marketcryptocurrencybitcoincryptocurrency investmentethereumcryptocurrency tradingcryptocurrency beginnercryptocurrency exchange100 remove_red_eyefreeby Chris Dunn
Any questions on Tutorial: Auto Updating Cryptocurrency Portfolio On Excel Spreadsheet?
The user community and author are here to help. Go ahead!