Foreign exchange
Month-end foreign exchange
=SF("FX","EUR","USD","2026-10-09","ECB")1.1206
European Central Bank euro reference rate for Oct 9, 2026. Units of USD per 1 EUR.
Official figures
SourcedFigures places European Central Bank and Federal Reserve exchange rates, U.S. Treasury yields, and the consumer price index (CPI) into a close workbook as live =SF formulas. Each number keeps the official source and the as-of date. The Federal Reserve Economic Data (FRED) add-in pastes a whole series as static values and has to be pulled again by hand.
A close workbook, a lease schedule, or a CPI escalator is built once. The same formulas take a new date when the next official print is published.
In development. Reservations open soon.
Proof
Foreign exchange
=SF("FX","EUR","USD","2026-10-09","ECB")1.1206
European Central Bank euro reference rate for Oct 9, 2026. Units of USD per 1 EUR.
Treasury
=SF("UST","5Y","2026-10-09")5.02%
The 5-year Treasury par yield on Oct 9, 2026, the tenor a lease schedule uses when the Accounting Standards Codification (ASC) 842 risk-free rate follows a five-year term. The function returns a decimal. This print is cited as 5.02%.
Price index
=SF("CPI","CPI-U","2025-08")323.976
Aug 2025
=SF("CPI","CPI-U","2026-08")334.98
Aug 2026
Bureau of Labor Statistics CPI-U, U.S. city average, not seasonally adjusted. Index, 1982–84 = 100. A date-range form is planned, using the series id: =SF("CPI","CUUR0000SA0","2026-01:2026-09"). No value is printed for that span. The monthly series for that span is not published on this page.
These figures are official prints for the stated dates. Past performance is not indicative of future results.
Template
The September close uses the Sep 30, 2026 official prints. The later rows use the Oct 9, 2026 prints. Oct 9 is not an October month-end. The CPI row stays on August 2026, the latest CPI month recorded here.
| As of | Figure | Formula | Value |
|---|---|---|---|
| Sep 30, 2026 | EUR to USD, European Central Bank | =SF("FX","EUR","USD","2026-09-30","ECB") | 1.1355 |
| Sep 30, 2026 | 5-year Treasury par yield | =SF("UST","5Y","2026-09-30") | 0.0509 |
| Aug 2026 | CPI-U, not seasonally adjusted | =SF("CPI","CPI-U","2026-08") | 334.98 |
| Oct 9, 2026 | EUR to USD, European Central Bank | =SF("FX","EUR","USD","2026-10-09","ECB") | 1.1206 |
| Oct 9, 2026 | 5-year Treasury par yield | =SF("UST","5Y","2026-10-09") | 5.02% |
September Treasury values are the decimal the function returns. The Oct 9 Treasury value is the cited percent, 5.02%. It is not restated as a decimal.
Planned
The planned host is Windows desktop Excel (Microsoft 365, 2019, or later). Mac and Excel on the web are not in the current plan. The add-in is not yet available to install.
Evidence
The planned Evidence tab lists every sourced figure in the workbook with its link, publication date, and retrieval time, ready for the audit prepared-by-client list. The rows below are the September close sample. Retrieval time is shown only where one was recorded.
Planned
| Formula | Value | Source | As of | Retrieved |
|---|---|---|---|---|
=SF("FX","EUR","USD","2026-09-30","ECB") | 1.1355 | European Central Bank euro reference rates | Sep 30, 2026 | |
=SF("FX","EUR","GBP","2026-09-30","ECB") | 0.85463 | European Central Bank euro reference rates | Sep 30, 2026 | |
=SF("FX","EUR","JPY","2026-09-30","ECB") | 178.27 | European Central Bank euro reference rates | Sep 30, 2026 | |
=SF("FX","EUR","USD","2026-09-30","H10") | 1.1345 | Federal Reserve Board H.10 | Sep 30, 2026 | |
=SF("FX","GBP","USD","2026-09-30","H10") | 1.3267 | Federal Reserve Board H.10 | Sep 30, 2026 | |
=SF("FX","USD","JPY","2026-09-30","H10") | 157.25 | Federal Reserve Board H.10 | Sep 30, 2026 | |
=SF("FX","USD","CAD","2026-09-30","H10") | 1.421 | Federal Reserve Board H.10 | Sep 30, 2026 | |
=SF("FX","USD","EUR","2026-09-30","TREASURY") | 0.881 | U.S. Treasury Reporting Rates of Exchange | Sep 30, 2026 | |
=SF("FX","USD","GBP","2026-09-30","TREASURY") | 0.752 | U.S. Treasury Reporting Rates of Exchange | Sep 30, 2026 | |
=SF("UST","1Y","2026-09-30") | 0.0454 | U.S. Treasury daily par yield curve | Sep 30, 2026 | |
=SF("UST","3Y","2026-09-30") | 0.05 | U.S. Treasury daily par yield curve | Sep 30, 2026 | |
=SF("UST","5Y","2026-09-30") | 0.0509 | U.S. Treasury daily par yield curve | Sep 30, 2026 | |
=SF("UST","7Y","2026-09-30") | 0.0519 | U.S. Treasury daily par yield curve | Sep 30, 2026 | |
=SF("UST","10Y","2026-09-30") | 0.0529 | U.S. Treasury daily par yield curve | Sep 30, 2026 | |
=SF("CPI","CPI-U","2026-08") | 334.98 | Bureau of Labor Statistics CPI-U, series CUUR0000SA0 | Aug 2026 | |
=SF("CPI","CPI-U","2025-08") | 323.976 | Bureau of Labor Statistics CPI-U, series CUUR0000SA0 | Aug 2025 | |
=SF("CPI","CPI-W","2026-08") | 328.481 | Bureau of Labor Statistics CPI-W, series CWUR0000SA0 | Aug 2026 | |
=SF("FX","EUR","USD","2026-09-30","ECB","all") | 1.1355 | European Central Bank euro reference rates | Sep 30, 2026 | 2026-10-12 13:25 ET |
Pricing
Single seat
$79 per seat per month
$79 per seat per month after a 30-day trial. You pay $0 today and can cancel anytime.
Sample
September close sample. The file is .xlsx, with no macros and no live formulas. Each row is an official print with its source page, so the number can be checked.
Questions
No. SourcedFigures returns figures published by official sources, with a link to each. Informational only; not investment, legal, tax, or accounting advice.
Only official publishers: the European Central Bank, the Federal Reserve Board (H.10 and H.15), the U.S. Treasury (par yield curve, Reporting Rates of Exchange, and FiscalData), the Internal Revenue Service, and the Bureau of Labor Statistics. No scraped or third-party aggregates.
The European Central Bank publishes its reference rates for information purposes only and discourages using them for transactions. It also notes that the rates are often used for annual financial statements and tax returns. The accounting policy decides. SourcedFigures shows the source.
European Central Bank euro reference rates. European Central Bank, role of exchange rates
SourcedFigures cannot promise that. The Internal Revenue Service, for example, has no official exchange rate and accepts any posted rate used consistently. The source, the date, and the method are visible and identical every month.
Internal Revenue Service, yearly average currency exchange rates
U.S. federal data is public domain. European Central Bank data is used with the Bank’s attribution. SourcedFigures licenses the software and the evidence formatting, not the underlying figures.
Not in the current plan. The planned host is Windows desktop Excel (Microsoft 365, 2019, or later).
The planned install note covers the publisher name, file hashes, install location, and the network calls the add-in makes. Those calls are query parameters only. Workbook contents stay on the machine. The install note is not published on this site. The address is support@sourcedfigures.com.
Support mail goes to support@sourcedfigures.com.
Our payment processor collects the card, not this site. Billing starts after the 30-day trial, and nobody is billed if the add-in hasn't shipped.
The FRED add-in pastes a whole series as static values, and the paste has to be repeated by hand. A SourcedFigures cell is a live =SF formula for the value requested. A template built once updates when the official print is published.