Excel recipe

SEC API for Excel Power Query

A self-serve Power Query recipe for analysts who want refreshed SEC filing watchlists in Excel using the live RapidAPI endpoint instead of a custom EDGAR ingest job.

Subscribe on RapidAPI Try demo JSON View code examples

GET /v1/sec/watchlist/changes?tickers=AAPL,MSFT&since=2026-07-01&limit=10

let
    Source = Json.Document(
        Web.Contents(
            "https://sec-event-intelligence.p.rapidapi.com",
            [
                RelativePath = "v1/sec/watchlist/changes",
                Query = [
                    tickers = "AAPL,MSFT",
                    since = "2026-07-01",
                    limit = "10"
                ],
                Headers = [
                    #"x-rapidapi-host" = "sec-event-intelligence.p.rapidapi.com",
                    #"x-rapidapi-key" = RapidAPIKey
                ]
            ]
        )
    ),
    Groups = Source[data],
    GroupTable = Table.FromRecords(Groups, null, MissingField.UseNull),
    ExpandedChanges = Table.ExpandListColumn(GroupTable, "changes"),
    ExpandedChange = Table.ExpandRecordColumn(
        ExpandedChanges,
        "changes",
        {"changeType", "observedAt", "filing"},
        {"changeType", "observedAt", "filing"}
    ),
    ExpandedFiling = Table.ExpandRecordColumn(
        ExpandedChange,
        "filing",
        {"companyName", "form", "filedAt", "accessionNo", "filingUrl"},
        {"companyName", "form", "filedAt", "accessionNo", "filingUrl"}
    )
in
    ExpandedFiling

Workflow Setup

This recipe validates whether buyers want SEC filing data inside automation tools before we build deeper app-specific support.

Subscribe on RapidAPI and copy the generated RapidAPI key.
Create a Power Query parameter named RapidAPIKey and store the key there.
Paste the query into Advanced Editor, then refresh the table on schedule or on demand.

Endpoints Used

The integration uses live SEC Event Intelligence endpoints available through RapidAPI subscriptions.

GET /v1/sec/watchlist/changes
GET /v1/sec/changes
GET /v1/sec/company/{ticker}/filings

Integration FAQ

Is this an Excel add-in?

No. It is a copy-ready Power Query M recipe for the live RapidAPI endpoint.

Should the RapidAPI key be hard-coded in the query?

No. Use a Power Query parameter or a protected workbook workflow instead of pasting the key into shared cells.

No investment advice. These recipes move public SEC filing metadata into automation tools. They do not provide recommendations, ratings, signals, or personalized financial guidance.