• Bitcoin Price Ticker in Excel

    This is really a fine code that I have come up with accidentally. I was only searching for how to add Cryptocurrency market chart in my website. Then during the Internet research/search, I came across this query.

    Then, why not build something for Excel on my own. Then I got a source that gives this info in the form of JSON.

    Cryptocurrency Price – Ticker in Excel

    Bingo. I already have code to convert JSON to Excel. Just integrated both & presenting the full code here. Copy paste this code in your Excel VBA, then you can just see bitcoin & other 100 such cryptocurrency tickers in your Excel worksheet.

    In case you are not familiar with VBA Macro , then just download the Excel Ticker App by Officetricks. This tool can just fetch the Price details once you click on the command button in the Sheet named “Settings”.

    Download 100 Cryptocurrency Price List in Excel – Downloaded 65 Times

    Note: Remember to include the steps mentioned in this JSON to Excel article. Otherwise this code will not work.

    Just run the code by pressing F5. you might get a reference missing for the datatype “Dictionary”. In the Excel VBA project, go to menu, Tools -> References -> Add “Microsoft Scripting Runtime”. Then this error will go off. Run again, you will see that it fetch all the Cryptocurrency market details.

    Where is the Tick Tock – Ticker?

    In case if you like to execute this code in repeat mode after every minute or some interval, then follow this code. IT explains how to execute this module at a predefined time interval.

    Previous Post:
    Next Post: