Excel Import CoinMarketCap API Data with Query
Import CoinmarketCap API cryptocurrency prices in Excel using a Web Query and have them refresh automatically at an interval of your choosing!
----
The CoinMarketCap Pro API is a great source for cryptocurrency data on current and historical prices, exchange information and more. If it is your wish to use Excel to import CoinMarketCap API data, and have it updated live, look no further. In this video, I will show you how to use a query to import current prices into Excel and have them updated regularly using the methods shown in the Import JSON Data in Excel article. Be aware that this works best with Excel 2016 or greater, and doesn't work with Excel for Mac. If you are using Excel 2013 or prior, you will need to install Power Query before attempting these steps.
----
Written tutorial: https://syntaxbytetutorials.com/excel...
На этой странице сайта вы можете посмотреть видео онлайн Excel Import CoinMarketCap API Data with Query длительностью online в хорошем качестве, которое загрузил пользователь SyntaxByte 15 Май 2020, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 74,091 раз и оно понравилось 889 зрителям. Приятного просмотра!
