Use Excel to Get Updated Bitcoin & Altcoin price

Use Excel to Monitor Bitcoin & Altcoin price

This guide will teach you step by step on how to use excel to get updated Bitcoin & Altcoin price in the easiest way even though you are not an Excel Expert.
You just need to simply follow the below 2 steps:

1. Download Power Query to your Excel
2. Setup Excel and link to https://coinmarketcap.com/

1. Download Power Query to your Excel

Power Query is an amazing data tool for Excel!  It is built by Microsoft to help you import, transform, and automate your data processes.  

Here is a quick list of compatible versions:

• “Free” add-in for Excel 2010 and 2013 for Windows.
• Built-in feature for Excel 2016 for Windows. 

This page will help you determine if you have the right version of Excel, and provide installation instructions.

Video Guide to Installing Power Query

What Version Do I Need?

The download page for Power Query lists which version of Excel are compatible with Power Query.

The following Office versions for Windows are supported:

• Microsoft Office 2016 – All Versions
• Microsoft Office 2013 – All Versions
• Microsoft Office 2010 Professional Plus with Software Assurance

Both 32-bit and 64-bit are supported.  Power Query is not compatible with any Mac versions of Excel yet.

Unfortunately, if you don’t have these versions you will need to upgrade to use Power Query.  To me, Power Query is worth the upgrade to Office 365 alone, and there are a lot of other cool new features too.

How Do I Check My Version of Excel?

Excel 2010

Here’s how to determine your version and 32 or 64 bit in Excel 2010:

1. Click the File button.
2. Click the Help option on the left side menu.
3. The Excel version will be listed under the Product Activated section.
4. The bit version (32-bit or 64-bit) will be listed under the About Microsoft Excel section.

If your Excel looks like the screenshot above, then you are in luck! 🙂  Again, you will need the Professional Plus version of Excel 2010.

Excel 2013

Here’s how to determine your version and 32 or 64 bit in Excel 2013:

1. Click the File button.
2. Click the Account option on the left side menu.
3. The Excel version will be listed under the Subscription Product section.
4. Click the About Excel button.  The bit version (32-bit or 64-bit) will be listed in the first row of the pop-up window.

How to Install Power Query

Excel 2016

Power Query is included with Excel 2016.  It has been renamed and is now on the Data tab of the Ribbon in the Get & Transform section.

This means there is nothing to install.  If you are using Excel 2016, go to the Data tab on the ribbon and press the New Query button to create a query and open the Power Query editor.

It’s important to note that there are some differences in Power Query for different builds of Excel 2016.

If you are on the MSI (Windows Installer) version then you will not get frequent updates to Power Query.  Your ribbon might look different from mine, and you won’t have all the latest features.

If you are on an Office 365 subscription then you have the Click-to-run version and you should get all the latest updates.  

If you are on the ProPlus version of Office 365 then you might be on the Deferred Channel.  The name of the Deferred Channel has been changed to Semi-Annual Channel as of September 2017.  This means you get updates every six months instead of every month.

All the versions and channels make this very confusing, to say the least.  Hopefully this guide helps you figure out how to get Power Query for Excel 2016.

Excel 2010 & 2013

For Excel 2010 and 2013 you will need to download the Power Query add-in and install it.

The installation steps are about the same in Excel 2010 and 2013.

1. Close (exit) Excel completely.
2. Click the following link to go to the download page.
   http://www.microsoft.com/en-us/download/details.aspx?id=39379
   
3. Click the Download button.
4. Click the checkbox for the bit version you are using.  Most likely you will be using 32-bit.
   
5. Click Next
6. The add-in installation file will download.  Click the file to run the installation.
   
7. The Setup Wizard window will open.  Follow the steps to install Power Query.
   
8. Once the installation is complete, open Excel.  You should now see the Power Query tab in the Ribbon.
   

My Power Query Tab Disappeared

If your Power Query tab ever goes missing, you can usually re-enable the add-in by going to the COM Add-ins menu.

There are a few ways to get to the COM Add-ins menu.

1. File menu.
2. Click Options on left side menu.
3. Click Add-ins on left side menu.
4. Select COM Add-ins from the Manage drop-down.
5. Click the Go… button
   
6. That will open the COM Add-ins Window.  If the Power Query check box is not selected, just select it to reload the add-in.
   

There is also a button on the Developer tab that will take you directly to this window.

2. Setup Excel and link to https://coinmarketcap.com/

• Now, Open an empty Excel worksheet. Click on Power Query tab and then choose From Web.

• The below will prompt out and then you need to choose Basic and paste https://coinmarketcap.com/ into URL. Finally Press OK.

• Wait for a few seconds. The below will promp out. Click on Table 0.

• Then, all the Cryptocurrencies prices will be listed as below. Click on Edit button.
  

• The Query Editor will be Prompt Out
  
   You can see all the listed crytocurrencies in this view
  
• Then you can either delete unwanted Column or just leave as is. To delete unwanted column, just right click on the column and choose remove. To get a clean view, i deleted most of it and left Rank, Price and 24h price change.
  
  

• Then, you can filter which currency that you want to monitor. This will further simplify the template. Do it as below.

• So, now you can see a simple template showing the information that you wanted. Click on Close & Load. this will load the information into your Excel.
  
• You will see the Crypto price will be in your excel worksheet.

• If you want to update the latest price, simply right click on the table and choose Refresh. The info will be updated according to the latest information on Coinmarketcap.

• You are done with the Setup now. You can get latest Crypto price on you Excel with 1 or 2 clicks.

Now, With this Crypto info on you Excel Sheet, you can do some VBA or Excel Formula with it. I have done a simple one, to see my gain and loss on the holding Crypto. You can download the Excel from Google Drive. Click Here.

If you are not able to download, please leave comment with your email address, I will send to you.

Hope you enjoy ready. Happy Earning!!!!!☺☺☺

Donation

If you like this guide and would like to do a donation to me, you can donate to the below:

Bitcoin (BTC): 1CxXyr8XepnMWjBPFAERRg7sZNpmirFcZB

Ripple (XRP): rL12t8WFDHDF8QN4iUzC3jNU2WddYRCGk9

Monero (XMR): 44VxXWC2o713phf5otf35vJQ9UDJQgvf58WgAd7UPNsV5Aj33VyMhxu3gF1nzjnRx17aSENaoB9h8Bwr3u9cfJmdKnJM6bv

You may like the below artcles as well:

1. About Bitcoin 

2. 5 methods to buy bitcoin with paypal

3. How to mine Monero with blog

4. Example UI of Monero mining blog

5. How to setup bitcoin wallet

6. Use Excel to get real time Coin’s price

7. Earn Free Bitcoin / Altcoin Here

8. The Easiest PTC Site to Earn Bitcoin with low withdrawal limit