![]() From the data ribbon, select From Web which can be found in the Get and Transform group of commands. ![]() Connecting Excel to the Coinmarketcap API. Once we have created our API endpoints, we can then use these to connect Excel to Coinmarketcap data.Import CoinmarketCap API cryptocurrency prices in Excel using a Web Query and have them refresh automatically at an interval of your choosing!-The CoinMar.Paste the ticker API link ( ) that they provide in the link above and hit. In Excel, under the Data tab, click on New Query, then From Other Sources, then From Web. To import ticker into excel follow the steps as described below: 1.1.Home Coinmarketcap Excel import How to import coinmarketcap data into Excel and have it
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |