用於加密貨幣的Excel宏TWD版本 Excel tool TWD version for cryptocurrency price and market cap

我很高興地宣布發行用於加密貨幣價格和市值的Excel。

我開發了TWD（新台幣）版本。 請訪問下面的鏈接。

Download : My_CryptocurrencyMarketCap_Data_List_TWD1.xlsm (in Google drive)

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 TWD.

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

・New Version

Updated free Excel tool for cryptocurrency price and market cap -Using Excel VBA