Bitcoin Forum
June 24, 2024, 04:24:16 AM *
News: Voting for pizza day contest
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Excel CryptoManagerVBA  (Read 228 times)
marqric (OP)
Newbie
*
Offline Offline

Activity: 34
Merit: 0


View Profile
September 20, 2017, 09:25:41 PM
 #1

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

nwo99
Jr. Member
*
Offline Offline

Activity: 150
Merit: 2

Looking for a good project


View Profile
February 25, 2018, 10:15:22 AM
 #2

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

Looking for a good project to work on
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!