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
Topic: Excel CryptoManagerVBA (Read 228 times)
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
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
Jump to: