Import this formula to enter a list of dates and stock tickers to get back all pairs of prices for each pair of tickers and dates entered.
⚙️ Polygon.io Stock Market Historical Prices - Multiple Stocks & Dates Workflow Formula By steve
⚙️ Polygon.io Stock Market Historical Prices - Multiple Stocks & Dates
Endpoint
-
Date
Date for the open and closing prices in
YYYY-MM-DDformat. See here: https://catonmat.net/tools/generate-calendar-dates if you need to generate a list of dates in this format, see below image for an example of the settings to use:
-
Ticker
Ticker to get the company details for.
-
API Key
Your Polygon.io API Key Available here: https://polygon.io/dashboard/api-keys
Unadjusted
Whether or not the results are adjusted for splits. Set this to true to get results that are NOT adjusted for splits.
Extractors
-
Stock Prices
.