I have developed GBP (Great Britain Pound) version. Please access link below.
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. It displays in GBP.
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