Income Statement Financial Research
Hi all,
This semester I'm taking a class that allows me to pick a topic and quantitatively analyze it using software like Stata. I've decided to research the relationship between monetary policy and banks' interest and trading earnings.
I'm currently in the data collection process, and collecting the data for the monetary policy side has been simple, but getting data for banks earnings over time has been extremely laborious.
My current method has been to look up the company, say JPMorgan Chase, on sec.gov and painstakingly grab their quarterly data and put it in an excel sheet. I'm asking the community if anyone knows of a resource that consolidates financial statements over time and makes it easy to work with. I know there are data resources out there that require a subscription, but I'd like to avoid these since I don't have a lot of money as a student.
I appreciate your help!
Database for financial statements of firms listed outside US? (Originally Posted: 07/06/2012)
What is the name of the database for financial statements of companies that are listed in the UK and Hong Kong like EDGAR for the US, if there is one?
I've been searching google for the name of this database but I'm not sure if it exists? If anyone can reply with the name of it, that would be great.
It does not. Closest comp to EDGAR is its ugly Canadian cousin, Sedar. Certain international exchanges will post filings for their listed companies, but there are so many different exchanges that it's not a very effective way to look. Easiest way is to go straight to the company's website. If they are public, they will have a filings section. Or if you have Factset, capiq, Thomson or Bloomberg, just check the links for where they're sourcing the data for the company's financials.
Try this one for the UK: http://www.companieshouse.gov.uk/
Company Valuation - Help needed regarding Databases that have company financial statements in Excel Form (Originally Posted: 08/19/2014)
Hi Guys,
Im currently working on an assignment where I am expected to do DCF valuation of a French Company, I wanted to know are there any databases where I can find the financial statements with historical data ( Balance Sheet, PnL, Cash Flow) for such companies. I know a database for Indian companies, Capitaline. Is their a similar database for European/American companies?
Hi Neelesh
If it's a public company, which I assume it is, then try and locate a Bloomberg Terminal. Failing that, attempt to locate its recent SEC filings (e.g. 10-k's, 10-q's, and 8-k's) on the company website.
I would look to the company's annual report on their website. You could look to sec.gov and search the ticker - they may file an F-1 or K/Q if they have ADRs
I do not have access to Bloomberg terminal. It is a french listed company and I was looking for Excel format balance sheets and PnL. I know that it is in the annual report, but would have to manually type the same into excel. Anyway, thanks for the help people.
Try CapitalIQ or FactSet, but they are also subscription-based. Not sure if they would have foreign firm financials though. You always have to be careful when pulling from databases though, as you need to understand the settings they use (e.g., are you using the most recent financials or original financials).
Sapiente eius veniam itaque est impedit. Et labore aut ipsum ut. Illum voluptates itaque corporis. Ut sint est omnis officia impedit. Et ut quis quaerat impedit exercitationem.
Autem quia eligendi sint et non rerum. Harum quae quis ducimus molestiae consequatur.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...