Use Polygon API To Enrich Your Sheet With Stock Market Data

The Polygon Stock API provides endpoints that let you query the latest stock market data and ticker information from US stock exchanges. You can also find data on company financials, stock market holidays, corporate actions, and more. This frictionless access to accurate historical and real-time data from Polygon API allows you to bring market awareness to your data in Gigasheet.

Don't have a Gigasheet account? Create one free, now.

Provider Website: https://polygon.io‍
‍Provider Enrichment Docs: https://polygon.io/docs/stocks/getting-started
‍Endpoint: https://polygon.io/docs/stocks/get_v2_aggs_grouped_locale_us_market_stocks__date
Token / Registration Required: Yes

How To Enrich A Spreadsheet With Polygon Stock API:

For this example, my data looks like this. We have a sheet with stock price and ticker symbol, and want to enrich the stock ticker with the company name. 

‍Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTP request from the Polygon documentation. Be sure your request starts with curl. Be sure to replace "MY_API_KEY" with your token from Polygon (https://polygon.io/docs/stocks/getting-started).

Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the prompt. In this case, we highlight the Ticker text in the input, and then select our Symbol column and click +Insert Column Reference. Then click Next.

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the Polygon response. At this point select the fields you want to be inserted into your sheet. I’ve selected the column name I’d like returned from the prompt, which in this case is company name.

Step 4. Finally, confirm the number of requests is to your liking, and when ready click Run to kickoff the custom enrichment process. It’s ok to leave or close the sheet; the custom enrichment will keep running and you’ll receive an email once the job has been completed. You can monitor the progress of your enrichment, or cancel the job at the top of the sheet. 

Here’s an example of the results:

As you can see, the ticker symbol in the “symbol” column now has been enriched with the symbol’s associated company name from Polygon API.