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':
- Ticker Symbol of company (i.e MSFT)
- CIK (per API documentation)
![246244-msft-filings.png](https://learn-attachment.microsoft.com/api/attachments/246244-msft-filings.png?platform=QnA)
![246215-msft-8k.png](https://learn-attachment.microsoft.com/api/attachments/246215-msft-8k.png?platform=QnA)