Sunday, October 8, 2017

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. 
Complete Guide to Installing Power Query
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.

Excel 2010 Version and 32 or 64 bit
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.

Excel 2013 Version and 32 or 64 bit

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.
Power Query in Excel 2016 for Windows Data Tab of Ribbon Get and Transform
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
    Power Query Download Page
  3. Click the Download button.
  4. Click the checkbox for the bit version you are using.  Most likely you will be using 32-bit.
    Download Power Query Select Bit Version
  5. Click Next
  6. The add-in installation file will download.  Click the file to run the installation.
    Power Query Run Installer
  7. The Setup Wizard window will open.  Follow the steps to install Power Query.
    Power Query Installation Window - Setup Wizard
  8. Once the installation is complete, open Excel.  You should now see the Power Query tab in the Ribbon.
    Power Query Tab of the Ribbon Excel 2010Power Query Tab of the Ribbon Excel 2013

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
    Excel 2010 Options Menu for COM Add-ins
  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.
    COM Add-ins Menu for Power Query

There is also a button on the Developer tab that will take you directly to this window.
COM Add-ins Button on the Developer Tab of the Excel Ribbon

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

10 comments:

  1. Earn FREE Bitcoin simply by using Google Add referrals and earn $1000s of bitcoin
    How to get bitcoins with referral network and earn more
    Invest your time and effort inviting new users and you will guarantee a high passive income for yourself for a long time

    ReplyDelete
  2. Promax7 is The world’s most consumer grade miner. Most power - efficient Ethereum bitcoin miners. Our R&D team has developed compact and efficient miners PROMAX 7.1 and PROMAX 7.2, ethereum miner,GPU Miners,Promax Miner 7.1 & 7.2,Cryptocurrency Hardware ,Bitcoin Miner 2018,ethereum GPU Miners,Latest Miner, Cryptocurrency, ethereum Miner We have tested our devices for the highest performance and in toughest conditions

    ReplyDelete
  3. Easily buy, sell, store and pay digital currency ✓Free account with associated wallets bitvavo ✓Purchase the currency of the future directly ✓ Choose from 14 different digital currencies.

    ReplyDelete
  4. Ivyn Software Suite is a set of products, made up of several software modules, included for free, that provide powerful business tools, capable of creating an extended network of users and services. Ivyn Software Suite and Ivyn Mining Farm Our platform lets parties “e-merge” in the smart economy, offering a crypto payment solution without incurring in any exchange and time delays.

    ReplyDelete
  5. The QuarkChain ICO (QKC Token) is using an evolved 2-layer architecture to create blockchain scalability using sharding technology. We have witnessed their Testnet achieve 2,000 transactions per second (TPS) and their current goal is 10,000 TPS. The QuarkChain ICO (QKC Token) While other projects are aiming for similar scaling, QuarkChain's technology may become viable before some competitors - a focus which may have been at the expense of developing a community and partnerships to actually use it. Outstanding prospect.

    ReplyDelete
  6. Cryptomedia - Crypto New Media
    bitcoin and blockchain news Visit for Blockchain, Bitcoin, Ethereum, Altcoin, ICO bitcoin blockchain crypto all in one #Cryptomedia

    ReplyDelete
  7. Earn Bitcoins while using Google Chrome. Add CryptoTab to your Chrome and start earning Bitcoins. Get CryptoTab - Easy way for Bitcoin Mining. Develop the network and get your rewards! Invite your friends, family and associates by your personal link and make many times more money! Get more than 1 BTC!

    ReplyDelete
  8. An online system that allows users to resell this system (Reselller Program) with a commission profit of 50% of the system price This system provides double profit to resellers with Reward & Incentive companies through this system project involves database, digital products and marketing.

    ReplyDelete
  9. You have shared a lot of information in this article about Sell bitcoin Canada. I would like to express my gratitude to everyone who contributed to this useful article. Keep posting.

    ReplyDelete
  10. The information in the post you posted here is useful because it contains some of the best information available. Thanks for sharing it. Keep up the good work linzhi phoenix.

    ReplyDelete