Questions tagged [sec]
39 questions
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
How can I parse HTML tabular data from an SEC 10K document and write it in a text format?
I am trying to create a program that analyzes SEC 10K reports and puts them in a readable text file. So far, I've been successful getting the HTML from their API (sec-api) and downloading that locally (let me know if there's a better way to get the…
0
votes
0 answers
Combining or selecting duplicate columns by rules into one column / new dataframe in Pandas DataFrame
I have pandas dataframe with loosely formatted data which I have managed to clean quite well. Dataframe has some duplicate columns which dont all have the same values. Columns can be identified by looking at the three first rows which contain the…
EricS
- 11
- 2
0
votes
0 answers
Reading loosely formatted HTML data tables from SEC filings into pandas dataframe in Python
I am trying to read tables from SEC Edgar filings into pandas dataframe. I initially tried the standard read_html solution from pandas with rather poor results. I Would appreciate on what would be best approaches on reading loosely formatted HTML…
EricS
- 11
- 2
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
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.…
0
votes
0 answers
Can ExtractorApi in sec-api module be used for scraping all the texts?
I am trying to collect all the texts from the 10-K
without considering the section of the 10-K. Is there any way to do so?
Plus, I see some old 10-Ks in below…
kyung sub Song
- 29
- 2
- 6
0
votes
1 answer
SEC's API: Search for US GAAP Taxonomy Frames
Using the SEC's website, I'm looking for the XBRL frames for the WeightedAverageNumberOfDilutedSharesOutstanding concept from the U.S. GAAP taxonomy.
Using this URL results in an…
Catalyx
- 435
- 2
- 7
- 17
0
votes
0 answers
Save (pre-2012) 13-F filings to Pandas Dataframe using python
I saw the question on pre-2013 13-F filings, but noticed they used an even different format pre 2012. This is the original question: Extracting table of holdings from (Edgar 13-F filings) TXT (pre-2013) with python
Pre 2013 but post 2012…
Not_a_Robot
- 43
- 8
0
votes
1 answer
Extract entire textual data from Edgar 10-K using python
I am trying to extract entire textual data from the given URL below as an example. I have many URLs so automating. I tried every code posted here - they are giving error, eg AttributeError: 'NoneType' object has no attribute 'find_next'.
Perhaps the…
silicon23
- 68
- 1
- 9
0
votes
1 answer
Having issue with XBRL API OAuth2
Has anyone worked with the XBRL API for financial data (https://xbrlus.github.io/xbrl-api/)? I am able to use the interactive demo but not able to recreate it on my own and successfully access the API using the python requests library when accessing…
nodeMASTER
- 3
- 2
0
votes
2 answers
TIME_TO_SEC is not working Correctly in mysql
" select
SEC_TO_TIME(SUM(TIME_TO_SEC(m.totalTime))) as totalDuration
from m
inner join pd on pd.candidateId = m.candidateId
where m.s_id is not null
and pd.s = 1"
OUTPUT :totalDuration: 838:59:59
"select
…
Narayan Pandey
- 21
- 3
0
votes
1 answer
How to build up edgar filing calculations when a fact is summed up multiple ways?
The Edgar documentation has some limited information on how to handle facts with different dimension break-downs. Take as an example the AAPL annual report:
On page 29 the total Net Sales (365,817) is split for products and services
On page 37 the…
jollytall
- 117
- 8
0
votes
1 answer
SEC Edgar filings extraction master.idx question
I encountered an issue while using the code from https://codingandfun.com/scraping-sec-edgar-python/
I tried to contact the authors of the website, but didn't work out. I am hoping to get some help here, and thank you in advance.
It seems that when…
user12167490
- 27
- 2
0
votes
1 answer
Access link href using BeautifulSoup in Python
I am looking for help webscraping the SEC's EDGAR database using BeautifulSoup. I have a list of investment firm names that I am trying to iterate through, and ultimately access their 13F filings.
So far, using BeautifulSoup, I am able to specify an…
therdawg
- 69
- 6