How do I use Power Query to get data from SEC EDGAR with API and/or M?

Elliot, Jonathan 1 Reputation point
2022-09-29T21:38:19.59+00:00

I've just about exhausted Google and Bing searches here.

WHAT I'M TRYING TO DO
I'm trying to find out how to use Power Query to connect to web data source (www.sec.gov) so that I can extract company filings and financial data directly into Power Query, then excel

I do not have the ability to use Python to assist (Tech department has controls on this) so I need to know how to use Power Query and/or M Code

I've read through the below link a lot of times and have not had success. There is a way to do it but I'm just not smart enough

https://www.sec.gov/edgar/sec-api-documentation

I can get 'see' the filings i need in Power Query but can't find a way to extract the content
246206-m-code-attempt.txt

IF SOMEONE CAN ASSIST
I would have the following data as an 'input' somewhere on 'Sheet1':

  1. Ticker Symbol of company (i.e MSFT)
  2. CIK (per API documentation)

246244-msft-filings.png246215-msft-8k.png246235-msft10q.png

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,566 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dave Patrick 426.2K Reputation points MVP
    2022-09-29T21:43:49.2+00:00

    Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
    https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments No comments