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
0
votes
0 answers

R for loop is numeric

I have a "test" dataframe with 3 companies (ciknum variable) and years in which each company filed annual reports (fileyear): ciknum fileyear 1 1408356 2013 2 1557255 2013 3 1557255 2014 4 1557255 2015 5 1557255 2016 6 1557255 2017 7…
martins
  • 441
  • 1
  • 5
  • 19
0
votes
1 answer

Why do I encounter errors when extracting business descriptions from 10-K reports using the R package edgar?

I am trying to extract business descriptions of multiple firms from their 10-K reports using the R package, edgar. I am using getBusinDescr function to do so. As I want business descriptions of many firms (1000+), I created a vector of firms' cik…
Rouje
  • 3
  • 3
0
votes
2 answers

r edgar Error: Input year(s) is not numeric

I have a "test" dataframe with 3 companies (ciknum variable) and years in which each company filed annual reports (fyearq): ciknum fyearq 1 1408356 2012 2 1557255 2012 3 1557255 2013 4 1557255 2014 5 1557255 2015 6 1557255 2016 7 …
martins
  • 441
  • 1
  • 5
  • 19
0
votes
0 answers

R edgar package - issue with geBusinDescr

I want to retrieve the business description section of 74 companies using R edgar package and function getBusinDescr(). When I run my line of code, all the filings were downloaded via getFilings(). But then, the following error results: "Error in…
BeV
  • 1
  • 2
0
votes
1 answer

Download SEC filings using Excel VBA - Inline XBRL viewer issue

I am trying to download SEC filings (10-K, 8-K etc) from SEC website using Excel vba. I am using getelementsbytagname to identify the url for the filing. However when i use "URLDownloadToFile" private function, I am not able to get the file…
msksantosh
  • 379
  • 4
  • 19
0
votes
1 answer

How to search for a combination of keywords in a text-file, extract lines above and below, and then export to Excel using pandas

I am trying to extract 5 lines before and after a specific combination of keywords from several SEC 10-K filings and then export that data into Excel so that I can then further process it manually. Unfortunately I have to rely on the .txt format…
lnrd
  • 13
  • 2
0
votes
0 answers

How to capture the index number of a specific node in an absolute xpath

It's a little complicated - but necessary - to explain the backstory, so some patience is requested. I'm trying to parse an SEC Edgar filing (this Form 10-K, as a random example), not for its financial data, but for the list of Exhibits contained…
Jack Fleeting
  • 24,385
  • 6
  • 23
  • 45
0
votes
1 answer

SEC Edgar - Can someone help me identify what this text represents?

https://www.sec.gov/Archives/edgar/data/1383094/000119312518268345/0001193125-18-268345.txt The part I'm unsure how to read can be found by using ctrl+f on the following characters: M_]C_X0QQ17AI9@ This is the start of a section I am not familiar…
J Doe
  • 9
  • 2
0
votes
1 answer

Extract the product description from 10-k

I want to extract the product description from a 10-k report for my master thesis (new at programming, finance background). This product description is between "ITEM 1" and "ITEM 2" from the reports. What I did until now is to download all the 10-ks…
Adrian
  • 774
  • 7
  • 26
0
votes
1 answer

SSL error with Python but server test gives all A+ ratings

Last year I wrote a Python script to query the SEC's EDGAR database to retrieve their index of company filings for various years and quarters. At the time, the script worked fine but I recently picked it back up only to find that now I receive SSL:…
JEK
  • 33
  • 4
0
votes
1 answer

Pythonic counting and scraping to skip first table if two tables exist

I'm trying to get .xml data from SEC filings. It's in the second table. But, if I get to a page that doesn't have the .xml, I want the html vers, first & only table. Could someone please help me understand how to iterate or skip a the first table if…
Derek_P
  • 658
  • 8
  • 29
0
votes
2 answers

Edgar Package | Issue with .txt files

Thank you already in advance for your input. My issue is the getSentimentCount(word.frq, words.list) function of the edgar package. The function is supposed to read the word.list which is a .txt file and compare the content of another existing list…
Kim Sa
  • 1
  • 2
0
votes
1 answer

Partial extraction of unstructured data on 2nd instance

I have a huge text file from Edgar. I want to extract only a portion of text from business risk section. For example if the text is like : Bshehebvegegeveghdhebejejrjbfbfk And I want to extract the start position as he(2nd instance) end position…
user35655
  • 13
  • 5
0
votes
1 answer

Prompt 'Yes' every time to getFilings

I am going to download the 2005 10-Ks for several corporations in R using the EDGAR package. I have a mini loop to test which is working: for (CIK in c(789019, 777676, 849399)){ getFilings(2005,CIK,'10-K') } However each time this runs I get a…
user7317101
1 2 3 4 5 6
7
8