⚡ FPRates — Download Historical Rates

CSV columns

slot_time_utc — Half-hourly slot in UTC
local_time — Half-hourly slot in UK local time (BST/GMT)
fp_rate — EDF FreePhase rate in p/kWh
period_class — green / amber / red band

Power Query (Excel)

Use this in Excel Power Query to pull data automatically:

let
    StartDate = "2025-10-29",
    EndDate = Date.ToText(Date.AddDays(DateTime.Date(DateTime.LocalNow()), 1), "yyyy-MM-dd"),
    Source = Json.Document(Web.Contents("https://fprates.online/api/rates/G/history?start=" & StartDate & "&end=" & EndDate)),
    ToTable = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Expanded = Table.ExpandRecordColumn(ToTable, "Column1", {"slot_time_utc", "local_time", "fp_rate", "period_class"}),
    ChangeType = Table.TransformColumnTypes(Expanded, {{"local_time", type datetime}, {"fp_rate", type number}})
in
    ChangeType

Replace G with your region code.