Official figures

Build the template once; it updates itself.

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

Three Proof Points

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.

European Central Bank euro reference rates

Treasury

Five-year par yield

=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%.

U.S. Treasury daily par yield curve

Price index

CPI-U, one year apart

=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.

Bureau of Labor Statistics CPI-U, series CUUR0000SA0

These figures are official prints for the stated dates. Past performance is not indicative of future results.

Template

The Same Formulas, A Later Date

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 ofFigureFormulaValue
Sep 30, 2026EUR to USD, European Central Bank=SF("FX","EUR","USD","2026-09-30","ECB")1.1355
Sep 30, 20265-year Treasury par yield=SF("UST","5Y","2026-09-30")0.0509
Aug 2026CPI-U, not seasonally adjusted=SF("CPI","CPI-U","2026-08")334.98
Oct 9, 2026EUR to USD, European Central Bank=SF("FX","EUR","USD","2026-10-09","ECB")1.1206
Oct 9, 20265-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

How a close uses the add-in

  1. The plan is a signed add-in for Windows desktop Excel, installed without administrator rights.
  2. One function, =SF(...), returns the value with its source.
  3. The Evidence tab lists every sourced figure for the audit file.

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

Evidence Tab

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

FormulaValueSourceAs ofRetrieved
=SF("FX","EUR","USD","2026-09-30","ECB")1.1355European Central Bank euro reference ratesSep 30, 2026
=SF("FX","EUR","GBP","2026-09-30","ECB")0.85463European Central Bank euro reference ratesSep 30, 2026
=SF("FX","EUR","JPY","2026-09-30","ECB")178.27European Central Bank euro reference ratesSep 30, 2026
=SF("FX","EUR","USD","2026-09-30","H10")1.1345Federal Reserve Board H.10Sep 30, 2026
=SF("FX","GBP","USD","2026-09-30","H10")1.3267Federal Reserve Board H.10Sep 30, 2026
=SF("FX","USD","JPY","2026-09-30","H10")157.25Federal Reserve Board H.10Sep 30, 2026
=SF("FX","USD","CAD","2026-09-30","H10")1.421Federal Reserve Board H.10Sep 30, 2026
=SF("FX","USD","EUR","2026-09-30","TREASURY")0.881U.S. Treasury Reporting Rates of ExchangeSep 30, 2026
=SF("FX","USD","GBP","2026-09-30","TREASURY")0.752U.S. Treasury Reporting Rates of ExchangeSep 30, 2026
=SF("UST","1Y","2026-09-30")0.0454U.S. Treasury daily par yield curveSep 30, 2026
=SF("UST","3Y","2026-09-30")0.05U.S. Treasury daily par yield curveSep 30, 2026
=SF("UST","5Y","2026-09-30")0.0509U.S. Treasury daily par yield curveSep 30, 2026
=SF("UST","7Y","2026-09-30")0.0519U.S. Treasury daily par yield curveSep 30, 2026
=SF("UST","10Y","2026-09-30")0.0529U.S. Treasury daily par yield curveSep 30, 2026
=SF("CPI","CPI-U","2026-08")334.98Bureau of Labor Statistics CPI-U, series CUUR0000SA0Aug 2026
=SF("CPI","CPI-U","2025-08")323.976Bureau of Labor Statistics CPI-U, series CUUR0000SA0Aug 2025
=SF("CPI","CPI-W","2026-08")328.481Bureau of Labor Statistics CPI-W, series CWUR0000SA0Aug 2026
=SF("FX","EUR","USD","2026-09-30","ECB","all")1.1355European Central Bank euro reference ratesSep 30, 20262026-10-12 13:25 ET

Pricing

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

Sample Workbook

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

Questions

Is this investment advice?

No. SourcedFigures returns figures published by official sources, with a link to each. Informational only; not investment, legal, tax, or accounting advice.

Where do the numbers come from?

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.

Can European Central Bank rates be used in financial statements?

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

Will an auditor accept it?

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

Licensing

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.

Mac or Excel on the web?

Not in the current plan. The planned host is Windows desktop Excel (Microsoft 365, 2019, or later).

What if information technology manages add-ins?

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.

When does it ship?

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.

How is this different from the FRED add-in?

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.