Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
0 votes
0 answers
51 views

more than one 10-q?

Sorry if this is a stupid question, I am new to using python in data extraction. When I extract data from EDGAR, there is something that troubles me. When I fetch 10-Q reports, several similar but not ...
faipince's user avatar
2 votes
3 answers
650 views

Syncing another company's financial year to another company using EDGAR database

I'm working on a school project that was built by a previous group, and one of my tasks is to synchronize the fiscal year's start date according to the start date of the company of focus. This is the ...
MG0310's user avatar
  • 21
0 votes
1 answer
226 views

How to use dictionary imported from EDGAR using their API

I am very new to python so this is likely a stupid simple question. I have imported financial statements from EDGAR-Online using their API and it imports as a dictionary. I have read all I could find ...
Dwilkin5's user avatar
0 votes
2 answers
479 views

Cant retrieve company record from EDGAR platform

Im trying to retrieve company information from EDGAR platform with following code: library(edgar) library(tidyverse) library(kableExtra) tesla <- getFilingsHTML( cik.no = 0001318605, form....
Andres Mora's user avatar
  • 1,068
1 vote
2 answers
328 views

REGEX extract information from EDGAR SC-13 form

I am trying to extract information from the latest SEC EDGAR Schedule 13 forms filings. Link of the filing as an example: 1) Saba Capital_27-Dec-2019_SC13 The information I am trying to extract (...
Lko's user avatar
  • 252
0 votes
1 answer
173 views

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 ...
JEK's user avatar
  • 33
1 vote
1 answer
1k views

Use Arelle to export XLSX file

I'm trying to use Arelle to export a XLSX file from a zip of XBRL files. It works just fine when I use the EdgarRenderer plugin. ./arelleCmdLine -f data/goog-20151231.xml.zip --plugins ...
AppTest's user avatar
  • 501
0 votes
1 answer
380 views

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 ...
Derek_P's user avatar
  • 666
-1 votes
1 answer
111 views

SAS Regex code to capture Business Address from 10-K company filings

Consider the following EDGAR 10-K SEC Company Filing https://www.sec.gov/Archives/edgar/data/912382/000136231009004179/0001362310-09-004179.txt BUSINESS ADDRESS: STREET 1: 107 N ...
Martin D.'s user avatar
3 votes
2 answers
3k views

Arelle Webserver - How to extract the income statement from an XBRL filing?

I am trying to extract financial statement information based on type of the statement. Let me explain to you in a little more details. I want to extract the income statement, balance sheet and cash ...
rbr's user avatar
  • 51
5 votes
2 answers
3k views

From 10-K -- extract SIC, CIK, create metadata table

I am working with 10-Ks from Edgar. To assist in file management and data analysis, I would like to create a table containing the path to each file, the CIK number for the company filed (this is a ...
user avatar
2 votes
0 answers
728 views

Download 10-k for each corporation, group by SIC code

I am using the EDGAR library in R to download all 2005 10-Ks. The below code will prompt "yes" download the 10-K for each CIK in my loop. (h/t to Weihuang Wong to assisting me with this.) install....
user avatar
0 votes
0 answers
220 views

Download .txt from URL string in R

I am working with the EDGAR package in R to download Apple's 2005 Annual Report. This is my code to get that far: library(edgar) getMasterIndex(2005) aapl<-getFilings(2005,320193, '10-K') This ...
user avatar