How do I pull historical financials from CapIQ or PitchBook?
Recently started in PE from more of an operations consulting background so am not super familiar with CapIQ and PitchBook. My firm has both and just wondering if there's a way to autmoatically pull the 3 financial statements into excel quarterly for the past few years?
Can anyone give a brief explanation on how to do this - I think it's possible, but not 100% sure.
Bump
Call the capIQ helpline, they are super helpful and will explain it to you
Unnecessary
Why?
Super easy- pull up the company page > go to financials / valuation on the left side panel > click on income statement > select the time range you'd like > select the "quarterly" function on the period type > close to the top of the page should be a "download financials" button, click on that. I'll say this- I never trust CIQ for my financials, especially income statement items. There's a lot of adjustments / reclassifications that are made in their financial statements. I always hard code my financials from 10ks and 10qs. It takes more time, but at least you know you're getting the correct information rather than some adjustment made by CIQ that you can't explain.
Don't rely too much on these.
I download the CapIQ and audit by checking with the 10Q and 10K. Sometimes you need to make minor adjustments, sometimes you need a complete overhaul then you might as well directly hard code from financials. It depends. You can decide after comparing the CapIQ and 10k initially since sometimes it’s not necessary.
Another tip for OP is that you can expand the line items with the + icon on the name. For example, CapIQ will reclassify OpEx and consolidate SG&A, you can expand to see the breakdown of S, G&A. The expansion/drop down will appear in the downloaded.xls file as well.
It will always depend on the circumstance - line items specific to the industry you might want to look out for and don’t want them to be reclassified by CapIQ.
Mollitia mollitia adipisci aliquid voluptatum suscipit ipsa cupiditate. Alias incidunt quia explicabo quo beatae. Aut modi et occaecati est. Ex quia modi facilis velit quae.
Placeat vel nihil itaque autem rem architecto minima. Assumenda vel odio non consequatur. Accusantium eum sit perferendis reiciendis quia et rem. Voluptatem dolor maxime voluptatem temporibus.
Asperiores aut ut autem. Eos quia omnis sapiente nam sit veritatis et eveniet.
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...