Bitcoin Forum

Other => Beginners & Help => Topic started by: marqric on September 20, 2017, 09:25:41 PM



Title: Excel CryptoManagerVBA
Post by: marqric on September 20, 2017, 09:25:41 PM
Hi folks,

If you want an Excel tool to manage your crypto currencies, i have created an Excel VBA macro that gets the information directly from coinmarketcap API, it is useful to monitor the status of your investments in a single view.

https://i.imgur.com/7j2lumJ.png

The application is open source so you can check the code first before running it on your computer.

Please note that i have only tested this against Office 2013 but it should work on Office 2007 onwards.

This is still a work in progress.

For any bugs or issues you may find, please let me know.

Download link:

https://github.com/marqric/CryptoManagerVBA



Title: Re: Excel CryptoManagerVBA
Post by: nwo99 on February 25, 2018, 10:15:22 AM
Thanks mate,
just a little issue is that it only updates the top 100 currencies, in order to get it to update everything. You should add "&limit=0" to the query string sent to coinmarketcap

Awesome effort