Answer · Excel · Power Query

Pinnacle odds in Excel with Power Query

Updated 10 November 2026 · PinnFeed · 1 min read

Answer: use Power Query Web.Contents with Headers=[#"x-api-key"=YourKey], then expand events → markets → outcomes. Free REST (30 s delay) works for a refreshed board; live push still needs the WebSocket on Builder (not inside Excel).

Power Query sketch#

let
  Key = Excel.CurrentWorkbook(){[Name="ApiKey"]}[Content]{0}[Column1],
  Raw = Json.Document(Web.Contents("https://pinnfeed.io/v1/odds?sport=soccer&main=true&limit=50",
    [Headers=[#"x-api-key"=Key]])),
  Events = Raw[events]
in
  Events

Keep the key in a named cell on a hidden sheet or better in a local parameter — never commit it to a shared OneDrive file. Related: Sheets+Excel answer.

Trial CTA#

Builder (€99/mo) for WebSocket and closing history. 3-day trial; card required, charged after day 3 unless cancelled. Free REST: signup. Related: answers hub, docs.

Related: Power BI REST.

Questions people ask#

Is there an official Excel add-in?#

No — REST JSON via Power Query / Python is the integration surface.

Can Excel open the WebSocket?#

Not practically — use REST refresh in Excel; run a Python/Node WS client alongside for live.

Is this educational content for adults?#

Yes (18+).