![]() ![]() ![]() The parameters allow you to basically filter and define what you want returned. You can find full details on the parameters here The default price return is USD and you must use CONVERT to add other exchange rates. will allow you access to current market information for 1 or more coins. The API documentation lists the endpoints, but not all of them are available with the free API.įor our examples we will use the end point /cryptocurrency and for our endpoint paths we will look at /quotes/latest and /listings/latest We will add more to this URL so we can call call certain data. You will also find a quick link to the API documentation ( )Ĭreating a URL endpoint to connect to with Excel Once you have registered, you will be able to access your developer’s dashboard. However, it is limited in the coins and the function is not yet available to everyone. ![]() If you are using Excel 365 Beta channel and you have the STOCKHISTORY function you can use this to get historical data for the larger cap coins. However, you will not get access to historical data. You can register and sign up for an API key here With the free API that is available, in this article we will look at how you can connect to this API with Excel and keep your data up to date. Using the Coinmarketcap API, you can quickly get live ticker information into your Excel spreadsheet for your favorite cryptocurrency.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |