In this article, we will learn to import Coin metrics data to Google Sheets using the Amigo Data Add-on. Coin metrics is a company that aims to empower the public to make better financial decisions when trading in cryptocurrencies.
You can use the data available via Coin metrics to make informed decisions regarding your crypto investments and possibly end up making lucrative investments. You can import Coin metrics data to Google Sheets using the Amigo Data Add-on and facilitate calculations based on the data imported.
To import Coin metrics Data to Google Sheets, we will follow the steps mentioned below:
How to import Coin metrics data to Google Sheets
Follow the steps given below to learn how to import Coin metrics data to Google Sheets.
Step 1: Choose the API endpoint
Go to this website to find the API documentation. You will find a variety of API endpoints that can be used to import Coin metrics data to Google Sheets.
For the purpose of this tutorial, we will be using the API endpoint titled Available Asset Metrics.
To access the endpoint, click Catalog→ Available Asset Metrics. This endpoint will provide you with a list of metrics along with their description, categories and assets for which the metric will be available.
The query parameters list the queries that can be used to filter the data imported and its description.
Click on the arrow beside /catalog/asset-metrics in the top right corner.
You will see two links listed in the drop-down that appears. Click and copy the second link.
Coin metrics provides its users with two endpoint URLs: a paid URL that requires a key, and a community URL which is free and doesn’t require a key. The tradeoff with using the community URL is that this version comes with a limit of 1000 requests per IP address.
Step 2: Get Amigo Data Google Sheets extension
The Amigo Data Add-on is an extension in Google Sheets that allows you to import data from various sources without coding.
You can either install the extension directly from the Google Workspace Marketplace or follow the steps below:
- Open a new google sheet
- Click on Extension→ Add-ons→ Get Add-on
- Search for “Amigo Data” and install it.
Step 3: Import the data to Google Sheets
Go to the Google Sheet in which you want the data to be pasted. Click on Extennsions→Amigo Data→Connect
Select Custom API from the list of sources
Paste the API endpoint URL copied in step 1 and click on Preview.
In a few seconds, a cluttered dataset will appear on the screen. Flatten the dataset until it is separated into columns and then click on Import.
Upon cleaning the data and clicking on import, the data will appear on your sheets as shown below.
Other endpoint URLs
- Catalog→ Available market funding rates
This endpoint URL will allow you to access all data pertaining to markets and their funding rates along with the time ranges of available data.
https://community-api.coinmetrics.io/v4/catalog/market-funding-rates
- Timeseries→ Market metrics
This endpoint URL will allow you to fetch metrics for specified markets and order them by tuples. It takes two compulsory queries, which need to be added to the details section of the Amigo Data Add-on. The two compulsory queries are markets (list of markets whose metrics need to be imported), and metrics (Comma separated metrics to request time series data for).
https://community-api.coinmetrics.io/v4/timeseries/market-metrics
- Full catalog→ Supported institutions
This API endpoint URL returns a list of all support institutions along with information for them like metrics and time ranges of available data.
https://community-api.coinmetrics.io/v4/catalog-all/institutions
Amigo Data allows users to set a refresh schedule that automatically updates the data imported to ensure that the user is provided with the latest data without any manual input. To learn how to automatically update your data at regular intervals and receive alerts for the same on your email or Slack channel, click here.
In this article, we have successfully learned how to import Coin metrics data to Google Sheets. To learn more about related articles, check out our blog.
See Also
Below you will find some related articles on how to import data from a variety of sources.
Import Polygon.io data to Google Sheets