Excel tool KWR (SOUTH KOREAN WON) version for cryptocurrency price and market cap -Using Excel VBA

I am happy to announce the release of Excel tool for cryptocurrency price and market cap.
I have developed KRW (SOUTH KOREAN WON) version. Please access link below.

Download : My_CryptocurrencyMarketCap_Data_List_KRW1.xlsm (in Google drive)

I have updated this Excel macro tool. Please access link below.
Excel macro tool to get cryptocurrency market cap price data -Using Excel VBA


This tool can fetch cryptocurrency details once you click on the command button in the Sheet.
By using the API, it display the data read from Cryptocurrency Market Capitalizations. Currency unit is displayed in KRW (SOUTH KOREAN WON) .

Remember to enable macros to Excel. Otherwise this Excel tool will not work.



・Operation procedure
Enter arbitrary cryptocurrency symble in the cell after the third row of column A as shown below, and click GO button. It is displayed in a few seconds to tens of seconds

When you press the All Symbol button, you will see the symbols of all the coins with more than 1000 in Cryptocurrency Market Capitalizations.

Each data is displayed as shown below.

Pressing the Clear button erases the values and formatting of all cells below the third row. The symbol also disappears.

Notice: If the Excel tool freezes, please open task manager by pressing Ctrl + Shift + Esc and Forcibly terminate it.

In personal experience, macro stopped in Http.send of program. One day, It was fixed unexpectedly. I am not sure the reason, although I tried to repair it a lot.

Donate BTC: 1LcULwCQPjxLGXdpEJkhNkPpqCwG5csasU

Donate LTC: LSXEG7tjeCCGWuzvf5eFvJUZM6Xpvsdc4f