Is there an easy way to download 5, 10K statements (most recent) to excel?
Title. Or do I have to transcribe them, myself?
Title. Or do I have to transcribe them, myself?
+141 | How to stop feeling like shit for not making it in IB? | 55 | 57m | |
+106 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 52 | 10m | |
+66 | Updated LA Banking Scene (2024) | 49 | 11h | |
+57 | Why Is It Called Investment Banking? | 20 | 32m | |
+38 | Ranking banks that went under | 19 | 15h | |
+32 | A strategy for SA applicants late to the game like myself | 15 | 3h | |
+32 | Burnt Out M&A ASO | 17 | 1h | |
+31 | UBS Actual Buyside Exits 2024 Post-Integration | 9 | 3d | |
+29 | Relevance of A-Levels for U.K. London recruiting | 21 | 9h | |
+26 | Series 79 Help / Tips to Pass The First Attempt | 11 | 1d |
Career Resources
if you don't have factset/cap iq/thomson/etc., then try Edgar. Specifically, if you select "interactive data," there should be an option to "view excel document."
The formatting isn't super ideal (there's a tab for every single header), and it's only available for 10-K & 10-Q filings, but yeah it's definitely better than transcribing yourself.
I always transcribe myself because I don't trust Thomson to do it correctly for me... they always end up lumping some line items into the wrong places that (to me) are actually very important. I've gotten pretty damn quick at it but it's definitely a pain in the ass. Never done the Edgar 'view in Excel' option though so I'll have to look into it. But at the end of the day if it takes me an extra 30 minutes to transcribe it the way I want, I'll keep doing that. Getting the financials wrong is way worse than getting anything else wrong. Affects everything.
I will just transcribe them, or use bloomberg... I will see if I like the format. Thanks, guys!
This is a more than valid point.
Are you in school? If so, see if your school has a subscription or access to Mergent. It gives you the option to download financial information in excel, in a number of different formats.
Can't you go into investor relations for each company (assuming they're public) and download the statements?
Bloomberg terminal will do that. If you are in school you guys should have a couple bloombergs.
Wtf is a 5k?
Haha, wondered that myself. Think OP means; five 10k statements
Hand spread them. Don't be a bitch.
it says in the title, FIVE 10K statements? Thanks for all the help, guys!
Not to quibble, but that's not what you said. You said "5, 10K statements," which could also be construed as a shorthand for "5K and 10K." Which is clearly what people took it to mean.
Moreover, what difference does it make to your question whether it is one 10k or 20 10ks?
Automated extraction of reporting data (i.e. 10q & 10k) (Originally Posted: 06/07/2011)
I'm starting as an associate analyst on an equity research team in a couple weeks. My MD has me updating some models before I officially start. I'm sitting here digging through 10Q's wondering why this can't be automated. Anyone have experience with this or know of any existing tools automate the extraction of data from 10Ks and 10Qs?
Cap IQ has a plugin to do this.
Same with FactSet - you should have one or the other I would hope. You'll still want to double check those numbers with the Q's and K's.
Thanks. I'll try it out.
Bloomberg too.
Seriously?
You put the numbers in by hand to understand wtf is going on. Good luck answering questions about the financials. What was the $5M in nonrecurring? IDK, let me log into Bloomberg.
If it were acceptable to do, ER people would all be doing it. Or maybe they are? We sure didn't in O&G.
Also, get fast at doing it by hand now and learning how your models work while you have a few days to update. When a release hits in the a.m. and you have an hour, good luck getting it from Bloomberg.
In my experience, those systems are more of a pain then you expect to maintain as well. I spent some time setting up auto things, and they were always a cluster-fuck when it came time to pull the data.
^^ This
BB and others will condense a number of line items, particularly on BS and CF, into just one line. If you're going to actually cover the company, build it from scratch by looking at the Qs and Ks.
If you're just fucking around, pull the data from BB, Thomson, CapIQ, etc.
Dont be lazy. Your analyst asked you to put the numbers in by hand so you would learn about the company.
Depends on what you're doing--if you're doing screening for a number of stocks, you can use the ready-made templates that FactSet, Thompson Reuters or Bloomberg have. If you're building an actual honest-to-god model, plug in the damn numbers. Yeah, it's tedious--that's why you're the one doing it.
Agree with all the above. Also in ER currently.
First of all, it builds character. That is very important in life.
You also want to tailor your model's line items to the forecasting drivers. Sometimes you wish to consolidate stuff on the 10k/Q, because it is immaterial/is not a key value driver. Other times, you browse through the notes and want to have intricate details on debt schedules and operating leases. It depends on how your analyst wants them.
When I first did this tedious work, I was also complaining and went to BB/factset to pull in reported info. Problem is, you spend too much time rearranging cells because companies change their operating segments, reported line items and other stuff over time. Especially during the 2008-2009 fin crisis. It is just better to get good at looking at 10k/Q for the info, so that you really OWN the model. After a week of building out historicals, you get to really savor the intricacies.
Go check out those Q's and K's. I like using msn.money to get those as its easy to navigate by sorting in regards to the type of report you are looking for and the reported date.
I recommend when starting coverage on a company for real, start from scratch, or use a template at least.
Ive been interning in ER for a few weeks now. The first day I was asked to build a historical model and I used CapIq. I ended up having to make so many adjustments that it just wasn't worth it.
I've built a few more from scratch since and although it takes forever, you go way more in depth intellectually with the company and really gain an understanding of how the model functions inside and out.
Totam necessitatibus quisquam provident a explicabo unde. Autem et voluptatum aliquam voluptates facilis dolores laudantium quisquam.
Excepturi autem architecto aspernatur quibusdam. Fugit asperiores magnam repellat ducimus tempore est a. Mollitia distinctio minus nesciunt consequatur est porro voluptate.
Iusto maiores hic sint. Fugit doloremque illum libero. Libero deserunt expedita qui ab optio harum. Laboriosam dicta temporibus velit quae sit delectus eum. Minima deleniti ex aspernatur rem mollitia debitis. Explicabo sapiente ab distinctio qui. Harum consequatur eveniet accusantium aut.
Adipisci dignissimos voluptatem doloribus molestiae. Fugit aperiam doloribus voluptas necessitatibus dolor. Velit laudantium vitae fuga aut itaque maiores.
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...
Ipsum in dolore voluptas et omnis illum voluptatem. Dicta ut ut sint veniam. Labore ipsa voluptatum aut esse enim aut.
Et ut dolor quia voluptas ab. Ratione eum suscipit doloremque voluptas. Similique corrupti ut in vel ut. Laboriosam ab necessitatibus temporibus. Commodi quod nihil voluptas omnis non et optio doloribus. Non vel laudantium labore pariatur labore quia dolore.
Explicabo ut ad error quia praesentium. Perspiciatis adipisci iste rerum magni ad voluptatem consequatur dolor.
Quos occaecati aliquid tenetur ipsum. Facere architecto nihil culpa fuga. Assumenda ut sunt laborum repellat consectetur sed nihil. Animi ab magnam et earum aut. Omnis nostrum iure optio dolorum quasi tempora ea voluptatem.