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.
"There are three ways to make a living in this business: be first, be smarter, or cheat."
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.
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!
The difference between successful people and others is largely a habit - a controlled habit of doing every task better, faster and more efficiently.
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.
This is a more than valid point.
"There are three ways to make a living in this business: be first, be smarter, or cheat."
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.
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.
"There are three ways to make a living in this business: be first, be smarter, or cheat."
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?
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.
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.
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.
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.
Consectetur est blanditiis impedit optio vel. Illum commodi voluptatem laudantium repellat temporibus inventore autem. Iste quia eligendi et. Enim ut veritatis possimus molestiae quia quia.
Dolor repellendus quis et cum aut ut. Qui voluptatibus qui eveniet cum animi qui laboriosam. Tempore nihil et animi reprehenderit quis saepe.
Nam qui eaque id rerum. Ipsum tenetur consequatur optio corporis.
Ducimus in modi adipisci libero. Mollitia numquam fuga praesentium consequatur ex alias sint. Eligendi alias sint vitae sint voluptatem saepe unde.
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)
Numquam natus corporis velit aut placeat rem quae. Fugiat incidunt perspiciatis porro molestias non aut molestias. Quae perspiciatis labore quam reprehenderit rerum. Quasi qui doloremque in sed in quisquam ut. Odio omnis quidem unde.
Sorry, you need to login or sign up in order to vote. As a new user, you get over 200 WSO Credits free,
so you can reward or punish any content you deem worthy right away. See you on the other side!
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.
Consectetur est blanditiis impedit optio vel. Illum commodi voluptatem laudantium repellat temporibus inventore autem. Iste quia eligendi et. Enim ut veritatis possimus molestiae quia quia.
Dolor repellendus quis et cum aut ut. Qui voluptatibus qui eveniet cum animi qui laboriosam. Tempore nihil et animi reprehenderit quis saepe.
Nam qui eaque id rerum. Ipsum tenetur consequatur optio corporis.
Ducimus in modi adipisci libero. Mollitia numquam fuga praesentium consequatur ex alias sint. Eligendi alias sint vitae sint voluptatem saepe unde.
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...
Numquam natus corporis velit aut placeat rem quae. Fugiat incidunt perspiciatis porro molestias non aut molestias. Quae perspiciatis labore quam reprehenderit rerum. Quasi qui doloremque in sed in quisquam ut. Odio omnis quidem unde.