Start Here: Download NGI Excel Add-in
The Excel Add-in requires the following:
- Windows 7 or greater
- Excel 2013 or Office 365
- Ability to install Excel Add-ins in Excel (some users may be restricted due to their company’s IT policies)
- An NGI Excel access token (if you don’t have an access token and would like one, please reach out to firstname.lastname@example.org or your account representative)
To begin using the Excel Add-in, follow our step-by-step directions to pull your first Datafeed. If you encounter a ‘Microsoft Excel Security Notice’, please click “Enable”. Place your Excel access token in a cell somewhere in the workbook you’re building (our examples below use cell A1) and reference it when using the below formulas.
Historical Data (everything except forwards)
To retrieve time-series historical data for all non-forward price series, use the NGIHistory function. If you don’t know the pointcode for a location, you can get a list of locations and their corresponding pointcodes using the NGILocations function described below.
=NGIHistory(excel_access_token, series, start_date, end_date, pointcode)
Example: =NGIHistory(A1, “daily”, “2021-03-15”, “2022-03-30”, “WTXWAHA”)
Historical Forward Data
To retrieve time-series historical data for forward series, use the NGIForwardHistory function. The forward series historical data is not available under the NGIHistory function because requesting these data requires an additional parameter, contract, which is not applicable for other, non-forward series.
If you don’t know the pointcode for a location, you can get a list of locations and their corresponding pointcodes using the NGILocations function described below.
=NGIForwardHistory(excel_access_token, series, start_date, end_date, pointcode, contract)
Example: =NGIForwardHistory(A1, “forward”, “2022-03-15”, “2022-03-30”, “WTXWAHA”, “2022-04-01”)
Datafeeds (All locations/prices for a single day/week/month)
To retrieve the full contents of a datafeed, use the NGIDatafeed function. Issue date is the day that a datafeed was published; not the day the data were traded. Data must be referenced by issue date because not all series have a single trade date (ex. Weekly).
=NGIDatafeed(excel_access_token, series, issue_date)
Example: =NGIDatafeed(A1, “daily”, “2022-03-21”)
Lists of Locations/Pointcodes
To retrieve a list of locations and their corresponding pointcodes, use the NGILocations function.
Example: =NGILocations(A1, “daily”)