This macro lets you import the current price of any cryptocurreny/token into Excel. Copy and paste the VBA macro in the very first comment below into Excel as shown in the video. The code looks different now than in the clip. I have streamlined it a little. A more powerful macro can be found in the response to Andy Shin’s comment below. There you can also choose from which crypto exchange to withdraw the price. Thanks to CryptoCompare (https://www.cryptocompare.com/) for their API. If you have ideas on how to simplify the code further please tell me in the description below.
Also check out my open-source web app to manage your portfolio: http://my-cryptoportfolio.renek.cc
If you like the code and want to donate me some Satoshis, I’d be grateful: bc1qj9zy9x6ntrup7zujyx3atfhyk0zq0gu5r2kdfx
source