How to get NY Fed SOFR and Reference Rates
Official New York Fed reference rates: SOFR, EFFR, OBFR, TGCR, BGCR with percentiles, volumes, and averages. A run saves one row per result.
One row per result
A row has Rate Type, Effective Date, Percent Rate, Volume In Billions. The columns are listed in the schema on this page.
The next run
Put the run on a schedule and the next file is the latest rows.
NY Fed SOFR and Reference Rates in Excel, Sheets, or Power BI
The rows are the same in each of those tools. The guide for the one you already use starts with a free Apify account and finishes with the file.
Schema
Examples come from the actor sample, not a live result.
| Name | Description | Example |
|---|---|---|
rateType | Rate Type | SOFR |
effectiveDate | Effective Date | 2026-09-10 |
percentRate | Percent Rate | 3.62 |
volumeInBillions | Volume In Billions | 2921 |
unit | Unit | percent |
sourceUrl | Source Url | https:/ |
scrapedAt | Scraped At | 2026-09-24T12:00:00.000Z |
rateTypeRate TypeSOFReffectiveDateEffective Date2026-09-10percentRatePercent Rate3.62volumeInBillionsVolume In Billions2921unitUnitpercentsourceUrlSource Urlhttps:// markets.newyorkfed.org/ api/ rates/ all/ latest.json scrapedAtScraped At2026-09-24T12:00:00.000Z