No-Code Enrichment with
How To Use Polygon Stock API To Enrich a Spreadsheet with Stock Market Data
Sign Up Free

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:
Provider Enrichment Docs:
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. 

Spreadsheet to enrich with polygon stock api data

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 (

cURL request to polygon stock API

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.

Customize request to polygon stock API
Customized polygon stock API request, ready for execution

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.

preview response from polygon stock API

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. 

confirm execution of polygon stock API on all rows

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.

Try it Out

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
Sign Up, Free Forever