Reference · built on requestCommons signalEconomic & calendar reference

Bank of England Statistical Interactive Database

Bank Rate, sterling exchange rates, quoted and effective interest rates, and money and credit series from the Bank of England Database.

Request accessPricing ↗

About

The Bank of England Database, also called the Statistical Interactive Database, lets you browse, visualise, and export the data series the Bank publishes: Bank Rate, daily spot exchange rates against sterling, quoted household and effective interest rates, capital issuance, and the money and credit statistics behind the Bankstats tables. Each series has a code, usually seven characters: a three-letter prefix and a four-character code, sometimes with a suffix for a bank group or country. Any set of codes can be fetched as CSV, Excel, HTML, or XML by URL, with no key.

Through Fibric, an operator fetches the codes you name each morning after the update, compares them with the previous values, and proposes a change to a pricing or credit assumption for your approval. The series code and reporting date go on the record.

This is a reference listing. It documents what Fibric would read from Bank of England Statistical Interactive Database and what it could propose, based on the publisher's published interfaces. Fibric builds it under a managed deployment when you request it; selecting it here installs nothing.

Inputs

  • Bank Rate history, with the date of each change, exported from the Bank Rate page
  • Daily spot exchange rates against sterling in GBP, EUR, and USD views, published one to two working days after the date they relate to
  • Money and credit series such as LPMAUZI (monthly changes of M4) and LPMAVAA (notes and coin in circulation), in sterling millions
  • Quoted household interest rates, effective interest rates, and capital issuance series under the interest rates topic
  • CSV by URL from _iadb-fromshowcolumns.asp?csv.x=yes with Datefrom, Dateto, SeriesCodes, UsingCodes=Y, and CSVF set to TT, TN, CT, or CN
  • XML by URL with CodeVer=new&xml.x=yes, including VUD and VUDdate to pull only observations added or revised since a date
  • Provisional and final data selected through the VPD and VFD parameters

Proposed actions

Read-only. This feed informs operators; it changes nothing.

Proposed actions are target capabilities. Every action runs propose-first and needs a validated deployment and the appropriate permissions.

What you can build

  • Move sterling price lists on the morning rate

    After the 9:30am update the operator reads the sterling spot rates for the currencies you buy or sell in and proposes a price-list adjustment where the rate has moved past your threshold, with the rate date attached.

    With Price List Drift

  • Reset credit terms on a Bank Rate change

    When Bank Rate changes, the operator proposes a review of late-payment charges, credit holds, and dunning timing for sterling accounts, quoting the new rate and the date it took effect.

    With Credit Hold, Dunning Cadence

  • Reconcile sterling settlements against the published rate

    For sterling payouts booked in another currency, the operator fetches the spot rate for the settlement date and proposes reconciliation entries where the booked rate differs from the Bank's daily rate.

    With Bank Reconciliation, Payout Reconciliation

Requirements

  • The full series codes you need, found through the Database's advanced search or the Bankstats tables
  • Dates as DD/MON/YYYY, or now for Dateto, and one CSVF layout per request
  • Network reach to www.bankofengland.co.uk
  • Attribution to the Bank of England under the Open Government Licence v3.0, and the Bank's permission for the exchange rate series excluded from it
Authentication
None. Downloads are open URLs on www.bankofengland.co.uk; reproduction of Database data is under the UK Open Government Licence and the Bank's terms.

Limits

  • One request carries at most 300 series codes for CSV, HTML, and XML, and 250 for Excel
  • When more than five series including a daily series are requested together, the default date range shrinks to the last five years; XML with a daily series covers at most one year per request
  • Daily rates are updated at 9:30am no more than two working days after the date they relate to, and the Bank aims to update the Database by 10am
  • The exchange rates are not authoritative market rates, and selected exchange rate series are licensed from third parties and excluded from the Open Government Licence

Access and pricing

Reference listing. Public feed access is separate from Fibric integration. If you request this feed, your quote covers the build, usage, and support.

Request Bank of England Statistical Interactive Database ↗

Questions and answers

How do I pull several series in one call?
Build a URL on _iadb-fromshowcolumns.asp with csv.x=yes, Datefrom, Dateto, a comma-separated SeriesCodes list, UsingCodes=Y, and CSVF. Up to 300 codes fit in one CSV, HTML, or XML request and 250 in Excel. Tabular layouts put codes across the top and dates down the side.
When is the Database updated?
The Bank aims to update the Database by 10am. Daily rates are updated at 9:30am, no more than two working days after the date to which they relate. Provisional data is included when VPD=Y.
Can I fetch only what changed?
Yes, in XML. Use CodeVer=new&xml.x=yes with VUD set to A or B and VUDdate as DD/MON/YYYY or latest to retrieve new and revised observations applied since 3 June 2007. Set SeriesCodes to all to list metadata for every series added within a date range.
Ask about Bank of England Statistical Interactive Database

Ask about the capabilities and requirements in this listing.

For project-specific requirements, contact Fibric.

This Commons signal listing is developed, published, and supported by Fibric. It reads public data published by Bank of England, Statistical Interactive Database (www.bankofengland.co.uk/boeapps/database). Upstream agencies and projects are the property of their respective owners, who are not affiliated with Fibric and do not sponsor or endorse this listing. Trademark policy