Stack Overflow
Stack Overflow

Questions tagged [edgar]

EDGAR is an information system of the U.S. Securities and Exchange Commission holding company data. Questions related to parsing and querying the data and public APIs should be tagged.

EDGAR stays for Electronic Data Gathering, Analysis, and Retrieval. This information system uses several data formats: classic SGML based, XML-based XBRL format for business reporting and many more.

120 questions
1
vote
1 answer

Read XML using VBA: List all occurrences of a tag including contextRef

I'm new to VBA and XML and would appreciate your help. I have the following code: Option Explicit Sub XMLfromPPTExample() Dim XDoc As MSXML2.DOMDocument Dim objxmlnodexbrl As MSXML2.IXMLDOMNode Dim objXMLNodeDIIRSP As MSXML2.IXMLDOMNode Set XDoc =…
PerseusSagittarius
  • 11
  • 1
1
vote
1 answer

Beautiful Soup table scraping only scrapes some of the time

I'm working to extract a specific table out of a couple documents, that holds the signatures of the directors, for a couple companies using BeautifulSoup4. My program finds a heading above the section that holds the tables, then counts two tables…
Retroflux
  • 57
  • 1
  • 1
  • 9
1
vote
3 answers

Parsing SEC Edgar fundamental data

I'm planning on downloading fundamental data (cash flow, income, balance sheet etc) from SEC EDGAR - am planning on downloading ALL the stocks in S&P 500 index . Does anyone know if there is an upper limit on the total amount of data/files that can…
Slayer
  • 101
  • 2
  • 12
1
vote
2 answers

xbrl dimensions linkbase parsing

I am trying to parse SEC edgar xml data and am confused by definition linkable. Below is an extract from the definition linkbase for apple for their 10-Q. Note: the roleURI column has been added from the roleRef elements in the definition…
pdoak
  • 721
  • 8
  • 21
0
votes
0 answers

SEC filings data using API in python with filter for specific strings

I'm trying to extract SEC filings in a certain date range with a certain key string, for several different companies. Basically I'm trying to replicate the search in this link: SEC Edgar (https://www.sec.gov/edgar/search/#) I installed the required…
Deep_S
  • 21
  • 3
0
votes
0 answers

Scrapping full Edgar into HTML fails due to condition has length > 1

I always get the following error message despite in my view I am doing everything as in the R documentary. > output <- getFilingsHTML(cik.no = 789019, 'ALL', 2018, quarter = c(1,2,3,4), useragent) Downloading fillings. Please wait... …
Fritz Müller
  • 3
  • 2
0
votes
1 answer

Finding string or empty column in pandas

This is to create a general use case of cleaning up tabular Data from the SEC EDGAR database. Considering this below table, I need to remove columns that may contain '[any_int]' Column A Column B Column C Column…
thzCU
  • 1
  • 1
0
votes
0 answers

Error in getFilingsHTML and searchFilings in edgar package of R

When I run the following two codes from edgar package in R, I got the following errors as seen in Output. CODE The code is here - word.list = c('derivative','hedging','currency forwards','currency futures') output2 <- searchFilings(cik.no =…
Sharif
  • 163
  • 1
  • 9
0
votes
1 answer

Why purrr:map () function is not working with load () to import Rda datasets

I have downloaded some Rdata files using getMasterIndex function from edgar package. Now I am trying to load all of these files into RStudio using the following code - paths <- list.files('Master Indexes', pattern = '[.]Rda$', full.names =…
Sharif
  • 163
  • 1
  • 9
0
votes
1 answer

EDGAR RESTful API dei taxonomy

I'm trying to write a Microsoft Excel UDF to pull information from the U.S. SEC's EDGAR database. The documentation I can find says that I can pull data (for example) this way, and I'll get a JSON…
jerry
  • 31
  • 5
0
votes
0 answers

Why is some of the text I extracted not properly decoded in Python?

I have written the following code to download the text of a financial report of Apple on the SEC: headers = {'User-Agent' : 'email'} response =…
larzz_010
  • 13
  • 3
0
votes
0 answers

R function getFilings() No filing information found error and user agent error

I am trying to get company filings from the SEC's EDGAR. I'm running the following code: library("edgar") useragent = "My Name MyEmail@gmail.com" companyFilings <- getFilings(cik.no = c(320193), c('10-K','10-Q'), 2017, quarter = c(1, 2, 3),…
SaltyHobo
  • 1
  • 2
0
votes
1 answer

Delete txt file based on keywords from multiple folders

I downloaded a bunch of 10-ks from edgar. I need to keep only 10-k reports with keywords "cryptocurrency" and "blockchain". Each company has one single folder. However, I was stuck on the reading txt file from multiple folders. Below are my…
Ciercy
  • 51
  • 5
0
votes
1 answer

Extract 10K filings url for a company using CIK number python

I am working on a project to find the latest 10K filings url for a company using CIK number. Please find the code below: import requests from bs4 import BeautifulSoup # CIK number for Apple is 0001166559 cik_number = "0001166559" url =…
Sushmitha Krishnan
  • 27
  • 5
0
votes
1 answer

SEC EDGAR API to Google Sheets integration

I want to connect US Securities and Exchange Commission (SEC) API to Google sheet. I want to be able to upload files in JSON from SEK server to Google Sheets directly. Buy could not make any of ImportJSON functions work. It gives me 403 code error.…
John Tiller
  • 1
1 2 3
4
5 6 7 8