Sparkasse Mainfranken Würzburg Exchange Rate API: EUR Buy and Sell Rates as JSON

Sparkasse Mainfranken Würzburg is the savings bank for the city and district of Würzburg and the surrounding Lower Franconia districts. Its Devisenkursblatt lists the daily Geld and Brief rates per euro for about 30 currencies. This guide shows how to read that board as JSON: what the rates mean, how they compare with the European Central Bank official rate and with other banks in Germany, and the calls that return them.

What the Sparkasse Mainfranken board shows

• 29 currencies against the euro: AED, AUD, CAD, CHF, CNY, CZK, DKK, GBP, HKD, HUF, IDR, ILS, INR, JPY, KWD, MXN, NOK, NZD, PLN, QAR, RON, SAR, SEK, SGD, THB, TND, TRY, USD and ZAR. Every value is EUR per 1 unit of the foreign currency.
• The devisenkursblatt (non-cash) geld / brief pair. German banks quote how much foreign currency 1 euro buys, as a Geld (bid) and Brief (ask) pair fixed once or twice a day. The rates here are turned round to euros per 1 unit; the European Central Bank publishes one euro reference rate per business day. The European Central Bank official rate is shown next to each row.
• USD on 15 November 2026: Sparkasse Mainfranken bought at 0.9014 and sold at 0.9079 EUR, a spread of 0.72%. The European Central Bank official rate was 0.9048, so the bank's mid sat -0.02% from it.
• The bank's own timestamp. The page prints a last-updated stamp (13.11.2026 on the board above), returned as bank_updated_at next to our captured_at.
• Every day's board is kept permanently, from 13 November 2026. Read one past day with ?date=, or a range for one currency with the /history endpoint (paid plans).

Spreads across the board

On the 15 November 2026 board the tightest spreads were TRY (0.18%), IDR (0.40%), JPY (0.57%) and the widest ILS (4.51%), THB (4.00%), SAR (3.38%). Spread is (sell − buy) ÷ mid: what a round trip through the bank costs, before any fees. The API returns it on every row as spread_pct, so you can rank currencies or alert when a bank widens its board.

USD at Sparkasse Mainfranken and other banks in Germany

USD on the 48 boards AllRatesToday reads in Germany, all captured on 15 November 2026 (the European Central Bank official rate was 0.9048):

Sparkasse Mainfranken had the 15th narrowest USD spread of the 48. One call to /api/v1/bank-rates/de returns every board in the table at once.

Get the board (REST)

You need an API key; the free key works. The full board:

curl "https://allratestoday.com/api/v1/bank-rates/de/sparkassemainfranken" \
  -H "Authorization: Bearer art_live_your_key"

What comes back (the 15 November 2026 board, first three rows):

{
  "bank": "sparkassemainfranken",
  "name": "Sparkasse Mainfranken Würzburg",
  "country": "de",
  "quote_ccy": "EUR",
  "bank_updated_at": "13.11.2026",
  "basis": "Devisenkursblatt (non-cash) Geld / Brief",
  "captured_at": "2026-11-15T11:22:54.617Z",
  "rates": [
    {"ccy":"AED","buy":0.24448981,"sell":0.24812972,"mid":0.24630977,"spread_pct":1.478,"official":null,"vs_official_pct":null},
    {"ccy":"AUD","buy":0.61106392,"sell":0.6186243,"mid":0.61484411,"spread_pct":1.23,"official":0.6139489194499017,"vs_official_pct":0.146},
    {"ccy":"CAD","buy":0.6304574,"sell":0.63850844,"mid":0.63448292,"spread_pct":1.269,"official":0.6345982992765579,"vs_official_pct":-0.018},
    … 26 more currencies
  ],
  "disclaimer": "…",
  "attribution": { … }
}

One currency, with the row fields at the top level:

curl "https://allratestoday.com/api/v1/bank-rates/de/sparkassemainfranken?ccy=USD" \
  -H "Authorization: Bearer art_live_your_key"

{
  "bank": "sparkassemainfranken",
  "name": "Sparkasse Mainfranken Würzburg",
  "country": "de",
  "quote_ccy": "EUR",
  "bank_updated_at": "13.11.2026",
  "basis": "Devisenkursblatt (non-cash) Geld / Brief",
  "captured_at": "2026-11-15T11:22:54.617Z",
  "ccy": "USD",
  "buy": 0.90138814,
  "sell": 0.90793536,
  "mid": 0.90466175,
  "spread_pct": 0.724,
  "official": 0.9048136083966704,
  "vs_official_pct": -0.017,
  "disclaimer": "Retail buy/sell rates as displayed on each bank’s own website at capture time, quoted as home currency per 1 unit of foreign currency. Indicative only: banks change these through the day, apply them at the counter or in-app, and they are not official or reference rates. For the rate a regulation names, use the central-bank endpoints.",
  "attribution": {
    "source": "Board rates published by Sparkasse Mainfranken Würzburg on its own website, collected by AllRatesToday",
    "bank_url": "https://www.sparkasse-mainfranken.de/fi/home/produkte/internationales-geschaeft/devisenkursblatt.html",
    "url": "https://allratestoday.com/bank-exchange-rate-api/de/sparkassemainfranken/",
    "terms": "Public pages that show the rates need a visible link to allratestoday.com"
  }
}

The board as it stood on a past day:

curl "https://allratestoday.com/api/v1/bank-rates/de/sparkassemainfranken?date=2026-11-13" \
  -H "Authorization: Bearer art_live_your_key"

One currency over a date range, one row per day (paid plans; add &format=csv, xml or xlsx for a file):

curl "https://allratestoday.com/api/v1/bank-rates/de/sparkassemainfranken/history?ccy=USD&from=2026-11-13&to=2026-11-15" \
  -H "Authorization: Bearer art_live_your_key"

JavaScript

npm install @allratestoday/sdk

import { AllRatesToday } from '@allratestoday/sdk';

const client = new AllRatesToday({ apiKey: 'art_live_your_key' });

// Sparkasse Mainfranken Würzburg's USD row
const r = await client.bankRates('de', { bank: 'sparkassemainfranken', ccy: 'USD' });
console.log(`Sparkasse Mainfranken buys USD at ${r.buy}, sells at ${r.sell} EUR`);

// The board as it stood on a past day
const past = await client.bankRates('de', { bank: 'sparkassemainfranken', date: '2026-11-13' });
console.log(past.snapshot_date, past.rates.length);

Python

import requests

r = requests.get(
    "https://allratestoday.com/api/v1/bank-rates/de/sparkassemainfranken",
    headers={"Authorization": "Bearer art_live_your_key"},
    timeout=10,
)
r.raise_for_status()
for row in r.json()["rates"]:
    print(row["ccy"], row["buy"], row["sell"], row["spread_pct"])

Board rate or official rate?

The European Central Bank rate is the one tax, accounting and customs rules in Germany name; nobody transacts at it. Sparkasse Mainfranken's board is the price a customer actually gets. The API puts both on every row: official is the central bank's rate for the same currency and vs_official_pct is how far the bank's mid sits from it. Use the board to show customers a real price, compare banks for a remittance, or keep a dated record of what the bank quoted; use the European Central Bank endpoint when a rule asks for the official rate.

FAQ

Where do the Sparkasse Mainfranken Würzburg rates come from?

From the bank's own public rates page (https://www.sparkasse-mainfranken.de/fi/home/produkte/internationales-geschaeft/devisenkursblatt.html), read hourly. AllRatesToday does not change the numbers: each row is the buy and sell price Sparkasse Mainfranken shows, with the mid, the spread and the European Central Bank rate added.

Are these the official EUR exchange rates?

No. They are Sparkasse Mainfranken's retail prices for customers. The official rate in Germany is the European Central Bank rate, which the API returns as official on each row where the central bank has one, and in full from the central-bank endpoint.

How often is the Sparkasse Mainfranken board updated?

AllRatesToday reads the page every hour. The bank's own last-updated stamp is returned as bank_updated_at, so you can tell a fresh read of an unchanged board from a new board.

Can I get Sparkasse Mainfranken rates for a past date?

Yes, from 13 November 2026 onward; every day's board is kept permanently. Add ?date=YYYY-MM-DD for one day: the response is the board captured that day, or the nearest earlier day within five days, with date_requested and snapshot_date added. For a range, /history?ccy=USD&from=…&to=… returns one row per day as JSON, CSV, XML or XLSX on paid plans.

Do I need an API key?

Yes. Commercial bank boards need an API key; any plan works, the free key included, and each call counts against the plan. Public pages or widgets that show the rates need a visible link to allratestoday.com.