Some API calls are available with CORS headers if you add a &cors=true paramter to the GET request. URL: cryptocoin365.de No Parameters. Returns a JSON object with the currency codes as keys. "15m" is the 15 minutes delayed market price, "last" is the most recent market price, "symbol" is the currency symbol. Mar 25, · You will need to generate a new query for each of your coins. Simply change the bitcoin part in the API link to whichever coin you're interested in. Replace bitcoin with your preferable coin's ID as shown in the ticker. Remember, use the ID, not the coin name. They are not always the same. For my examples, I would use the following API links. Connecting to Coinmarketcap API with Excel is a great way to ensure you have the latest pricing information for Bitcoin and your favorite cryptocurrencies. This article was brief to show you the steps involved in connecting to the API and getting the ticker and current information into Excel.
Btc markets api excelGitHub - BTCMarkets/API: API
Connecting to Coinmarketcap API with Excel is a great way to ensure you have the latest pricing information for Bitcoin and your favorite cryptocurrencies. This article was brief to show you the steps involved in connecting to the API and getting the ticker and current information into Excel.
To look further at the other API points listed in this article and to get some tips on the data transformations required, do check out this video. Do you want to start collecting rewards quickly for learning Excel? Then you should try:. Skip to content Using the Coinmarketcap API, you can quickly get live ticker information into your Excel spreadsheet for your favorite cryptocurrency.
This will open a From Web setup box. The data is returned in JSON format and we must now extract the data. Select the row for Data List and click on the word list This will expand the lists of data. Select To Table from the ribbon and select ok for the default settings in the To table option box. Next expand the records by clicking on the column header.
Select the columns you want to import and deselect Use original column name as prefix and press ok The new columns of data will expand. However, the quote field will still be a record that we must also expand Click on the expander in the column header for quote to expand the record. This opens another record which we much expand again. Click on the expander in the column header and select the columns you want to import This will import all the selected columns Carry out any required transformation steps, most notably ensuring all the data types are correct before you load to Excel.
From the home Ribbon select Close and Load to load the data as a table in Excel. Refresh the data from Coinmarketcap API in Excel Once all the tables have been loaded into Excel, we can keep these up to date with the latest information. Conclusion Connecting to Coinmarketcap API with Excel is a great way to ensure you have the latest pricing information for Bitcoin and your favorite cryptocurrencies.
Please note that the code samples below have been generously created by our users. Since these are not official samples please ensure you check and trust the code before using them. Skip to content. API stars 32 forks. Go back. Launching Xcode If nothing happens, download Xcode and try again. Latest commit. Git stats 52 commits. Failed to load latest commit information. Jun 26, View code. We encourage using our latest API for any new trading projects.