There are several other types of data that you can import into Google Sheets using Amigo Data such as Marketstack data, Coinmarketcap data, Nasdaq data, and many more. To learn how to set a refresh schedule, follow this link. By this you can automate importing financial market data to Google Sheets. To explore more endpoints go through the documentation of Polygon.io API.Īfter importing the data, you can also set a refresh schedule so that the data are updated automatically at regular intervals. You can import any kind of financial market data using this interface. Some endpoints may require a premium subscription. Similarly, you can also explore other endpoints.

The API returns a value to me and I use this value to determine if the product is in stock or not. In the parameter section enter the ticker symbol of the currency pair to fetch the data.įor example, for the EURUSD currency pair (EUR for base currency and USD for target currency), the URL link is as follows: Im trying to use an API from import.io for manage automatically the stock of products I reselling. This endpoint gives the exchange rate data at the time of close. How to automate importing financial market data to Google Sheets Install the Amigo Data add-on RSI helps one understand if a particular stock is overbought or oversold.īelow are the steps to import market data of stock into Google Sheets with Polygon.io API: In this tutorial, we will learn how to import the Relative Strength Index (RSI) of a stock. So let’s learn how to automatically import financial market data to Google Sheets using Polygon.io API. Amigo is a data integration and automation tool that you can use to automate data imports to Google Sheets.īelow is a snippet of dividends data imported into Google Sheets with Polygon API. in just a matter of a few seconds with an extension called Amigo Data. You can automate importing financial market data to Google Sheets using Polygon.io API. Im pulling down a bunch of tickers from the polygon.io: from polygon import. The key data include market data endpoints like aggregates, gainers/losers, technical indicators, etc. The Polygon.io Stocks API provides REST endpoints that let you query the.

Polygon.io is a platform that provides data about various financial markets like stock, forex, cryptocurrency, and options chains.

Import io stock