UK Energy Price Cap Scraper: Ofgem Rates by Region + Forecast

Get the official Ofgem energy price cap unit rates and standing charges for every GB region and payment method, plus Cornwall Insight forecasts, in one run.

Who it's for

• Energy-bill comparison sites, newsletters and journalists
• Landlords, letting agents and businesses budgeting energy costs
• Analysts tracking cap changes quarter by quarter

Sample output

capPeriod	region	paymentMethodLabel	electricityUnitRatePencePerKwh	gasUnitRatePencePerKwh
October 2026 – December 2026	GB average	Direct Debit	26.32	7.97
October 2026 – December 2026	East Midlands	Direct Debit	25.36	7.82
October 2026 – December 2026	Eastern England	Direct Debit	26.61	7.91

Real rows from a test run (shortened; the full output has more fields).

Price per 1,000 results

This actor charges $0.03 per price-check (one price check returns every region and payment method). Example: 1,000 checks = $30.00; a weekly check for a year = 52 checks = $1.56. Plus $5e-05 per run start. See the Pricing tab for the current prices.

Input example

{
  "includeGbAverage": true,
  "includeForecasts": true
}

What does UK Ofgem Energy Price Cap do?

Pull a clean, sourced snapshot of the UK energy price cap — official Ofgem unit rates and standing charges for every GB region and payment method (Direct Debit, standard credit, prepayment), with optional Cornwall Insight forward forecasts for the next cap period. Built for energy-bills newsletters, bill-trackers and anyone who needs “what’s the cap this quarter?” without wrestling Annex 9 spreadsheets.

Data comes from Ofgem’s published Final levelised cap rates model (Annex 9) XLSX (Open Government Licence), not from MoneySavingExpert HTML.

Why use this Actor?

Ofgem only changes the cap about four times a year, but bills content still needs a repeatable check: schedule weekly, compare to last run, and ship the newsletter when something moves — or when Cornwall Insight’s forecast shifts.

• Full matrix — 14 charge-restriction regions × 3 payment methods × electricity + gas
• Headline-ready — GB average dual-fuel £/year, unit rates (p/kWh) and standing charges (p/day)
• Forward look — optional Cornwall Insight public predictions for the next quarter
• Sourced — every row carries sourceUrl and scrapedAt
• Pay per check — priced for monitoring runs, not for flooding you with per-region micro-charges

Ideal for @ImRawTrader-style energy-bills roundups, household budget tools, and regional bill comparisons.

What data can you extract?

Field	Description
capPeriod / start / end	Current official Ofgem charge restriction period
region + paymentMethod	Where you live × how you pay
electricityUnitRatePencePerKwh	Single-rate elec unit rate (p/kWh)
electricityStandingChargePencePerDay	Elec standing charge (p/day)
gasUnitRatePencePerKwh	Gas unit rate (p/kWh, 5% VAT)
gasStandingChargePencePerDay	Gas standing charge (p/day)
dualFuelAnnualBenchmarkGbp	Typical dual-fuel annual £ (Ofgem TDCV)
Forecast rows	Cornwall Insight next-period £ and p/kWh (optional)

You can download the dataset as JSON, CSV, Excel or HTML.

How to get the Ofgem price cap data

1. Open this Actor on Apify Store (or run it locally with apify run).
2. Leave filters empty for the full matrix, or narrow by region / payment method.
3. Keep Include Cornwall Insight forecasts on if you want the forward-looking row for newsletter “what’s next” copy.
4. Run. Schedule it weekly for bills monitoring — you pay for a price check, not for every region cell.

Example: full official matrix + forecast (newsletter default)

{
  "includeGbAverage": true,
  "includeForecasts": true
}

Example: London Direct Debit only

{
  "regions": ["London"],
  "paymentMethods": ["directDebit"],
  "includeForecasts": false
}

How much will it cost?

Pay per event (PPE). Primary event:

Event	Suggested price	When charged
price-check	$0.03 per successful run	Once, after a full successful snapshot (cap matrix ± forecast) is written

Configure the event price in Actor → Monetization (Console). Remove or zero the synthetic apify-default-dataset-item event so you are not double-charged per region row — this Actor is designed around checks, because the official cap barely moves between quarters.

A weekly schedule for a bills newsletter is typically well under $2/month at $0.03/check.

Input

See the Input tab for the full form. Main toggles: payment methods, region filter, GB average rows, Cornwall Insight forecasts.

Output

{
  "recordType": "capRate",
  "capPeriod": "October 2026 – December 2026",
  "capPeriodStart": "2026-10-01",
  "capPeriodEnd": "2026-12-31",
  "region": "London",
  "paymentMethod": "directDebit",
  "paymentMethodLabel": "Direct Debit",
  "electricityUnitRatePencePerKwh": 26.6,
  "electricityStandingChargePencePerDay": 42.92,
  "gasUnitRatePencePerKwh": 7.97,
  "gasStandingChargePencePerDay": 28.76,
  "dualFuelAnnualBenchmarkGbp": 1663.55,
  "typicalElecKwh": 2500,
  "typicalGasKwh": 9500,
  "source": "Ofgem Annex 9 Final levelised cap rates model",
  "sourceUrl": "https://www.ofgem.gov.uk/sites/default/files/.../Annex-9-....xlsx",
  "licence": "Open Government Licence v3.0",
  "scrapedAt": "2026-10-23T08:15:00Z"
}

RUN_SUMMARY in the default key-value store has the period, Annex 9 URL, row counts and charged events.

Tips for energy-bills content

• Schedule after Ofgem announcement days (usually late February / May / August / November) and again when Cornwall Insight updates their predictions page.
• Use the GB average Direct Debit row for the headline “typical dual-fuel bill”, then a regional table for “what you actually pay where you live”.
• Pair with a previous-run dataset diff to power “cap unchanged” vs “cap rising” newsletter variants.

FAQ

Where does the official data come from?
Ofgem’s Energy price cap (default tariff) levels page — specifically the Final levelised cap rates model (Annex 9) workbook. Unit rates are derived from nil vs typical-consumption levels using Ofgem TDCVs, with VAT applied to match consumer-facing figures.

Is Direct Debit the same as “Other Payment Method” in Annex 9?
Yes. In the levelised model, Ofgem’s “Other Payment Method” is the Direct Debit path used for consumer tables.

What about Cornwall Insight copyright?
Forecast rows are parsed from their public predictions page, with full attribution and a licence note on each record. Cornwall Insight states that commercial redistribution may need consent; media/news use of published figures is commonly how the forecasts appear in the press. Check their page notice before republishing commercially beyond fair reporting.

Northern Ireland?
Not covered — NI has a separate market. This Actor is Great Britain only.

Contains public sector information published by Ofgem / UK government, licensed under the Open Government Licence v3.0. Not financial advice. Energy bills still depend on your usage.

Related UK data actors

• UK Google Trends Scraper: Interest, Regions & Related Queries
• UK Product Recalls Scraper: OPSS, FSA & MHRA Safety Alerts
• UK Companies House Scraper: New Companies & Insolvency Alerts

About RawTrader | UK Industry & Bills

RawTrader | UK Industry & Bills is a UK newsletter and open data project tracking energy bills, fuel prices, public tenders, company closures and FCA short positions, using official data from Ofgem, DESNZ, ONS, Companies House, Find a Tender and the FCA.

• RawTrader Data: every UK data tool in one place
• UK Industry & Bills newsletter
• Follow @ImRawTrader on X