This VBA-powered spreadsheet give you live exchange rates for Bitcoin, Etherium, Monero, Dogecoin and 1500 other cryptocurrencies.
This spreadsheet interrogates the coinmarketcap.com API to download the latest data for all the most popular cryptocurrencies, and even those you’ve barely heard of.
This tool is remarkably simply to use. Start by picking one of 1523 cryptocurrencies from a drop-down menu; these include Bitcoin, Etherium, Litecoin, Dogecoin, Ripple, Cardano and more.
After you click the one and only button, the spreadsheet talks to the coinmarketcap.com API and downloaded the latest
exchange rate in USD and equivalent value in Bitcoin.
24 hour trading volume in USD
market capitalization in USD
last updated time (Unix time stamp and the corresponding time/date)
% change over the last 1 hour, 24 hours, and 7 days
total supply and max supply
Clicking the button again simply replaces the existing quotes with the latest data. Doesn’t get any more complicated than that!
Under the hood, some VBA does the heavy-lifting. The code is not locked down behind a password; here’s a screengrab of the code.
Since we’re working with VBA, you have the flexibility to customize the spreadsheet and code. For example, you could script the spreadsheet so that new data is downloaded whenever you select a currency from the download (so you don’t even have to press the button). Just assign this subroutine to the drop-down menu
Sub currencyID_Change() Call cryptoCurrencyEndSub
Or you could get data for several cryptocurrencies at once!
Excel allows you to see the price of cryptocurrency in the fiat currency of your choice — USD, EUR, CAD, and more! For example, if you want to see the price of BTC in USD, you can enter BTC/USD into a cell. Microsoft Excel will see this as a valid input and pull the relevant price.
Manage and analyze your investment holdings with our Stock and Crypto Portfolio Tracker for Excel. Simply input your holdings and our Dashboard will showcase your returns and accumulated growth through dynamic charts, graphs and slicers.
“If you don't believe it or don't get it, I don't have the time to try to convince you, sorry.” – Satoshi Nakamoto. This is an early quote from Satoshi Nakamoto to the Bitcoin doubters on the forums. Since those early days, a whole industry has been created around his invention.
How Do I Acquire a New Cryptocurrency Before Listing? New cryptocurrencies may be available in a presale before they are listed on an exchange. These sales may be announced on social media, news sites, or crypto-focused tracking sites like CoinMarketCap.
TradingView is the market leader when it comes to crypto charts and one of the best crypto charting tools for both traders and investors thanks to a comprehensive and user-friendly platform.
Billionaire investor Warren Buffett described bitcoin (BTC) as a "gambling token" in an interview with CNBC on Wednesday. Echoing the dour opinion of the cryptocurrency that he has aired in the past, the Berkshire Hathaway (BRK.
As might be expected, Bitcoin (BTC -1.58%) is a favorite choice of billionaires looking to extend their wealth into new asset classes such as crypto. Lately, Ethereum (ETH -1.29%) has been attracting its own share of billionaire supporters. And don't forget about meme coins.
From the data ribbon, select From Web which can be found in the Get and Transform group of commands. This will open a From Web setup box. In the HTTP request header parameters(optional) second box enter your API Key and press OK.
This can be done using the formula s – c = p, where s is the selling price, c is the cost of the asset including fees and p is the profit. This is done because the cost and selling price change with each new trade you make.
Simply go to the sheet where the exchange rates are collated. Go to Queries & Connections > Refresh All > Refresh All. Excel would refresh the exchange rates imported from the web, and the formula applied to convert the currency would also be updated automatically.
Address: Suite 769 2454 Marsha Coves, Debbieton, MS 95002
Phone: +813077629322
Job: Real-Estate Executive
Hobby: Archery, Metal detecting, Kitesurfing, Genealogy, Kitesurfing, Calligraphy, Roller skating
Introduction: My name is Gov. Deandrea McKenzie, I am a spotless, clean, glamorous, sparkling, adventurous, nice, brainy person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.