CapIQ or FactSet, if you could only have one...

which would you take? keep in mind with capiq you don't get dealmaven, although they have their own shortcuts and smart trace macros. but you don't get preslink, which is pretty useful too. my bank is a little small so to cut costs some of the analsts get capiq and some get factset. if you had to pick, which would you choose and why?

Comments (69)

Best Response
Oct 2, 2009 - 3:34am
dosk17, what's your opinion? Comment below:

Honestly I think the interface is a lot better and it's easier to find information / also find names and contact information if you're networking or need to help friends with that.

Admittedly I always used Capital IQ a lot more than Factset but that's because I tested both and found Capital IQ easier to use in terms of the program itself and also the Excel plug-in that makes it very quick to spread comps.

Your mileage may vary but I would take CapIQ unless Factset has some kind of functionality that you need to use a lot.

Oct 2, 2009 - 8:26am
NoLongerActiveHere, what's your opinion? Comment below:

errr ... FactSet WITHOUT a doubt .... you can automate so much sht in factset

I have automated spreading comps with my factset, shareholder runs etc

its so much better

Oct 6, 2009 - 12:20am
thecatch, what's your opinion? Comment below:

thanks for the insights guys. i ended up with factset, but i got the chance to work with capiq for a week and i must say i miss the auditing feature that comes with the excel plug-in. being able to see where the numbers are pulling was pretty useful to me. factset has it in some cases with the whole audit and no audit thing...but it's pretty damn clunky in comparison.

Oct 6, 2009 - 1:37am
BabyBeluga, what's your opinion? Comment below:

FactSet actually has a number of pitfalls, especially when it comes to financials for private companies. Where CapIQ has available stats on public debt, FactSet can't even list LTM revenue. At my bank at least, our focus is on smaller companies that are most usually private. In this capacity, CapIQ is the clear winner.

Oct 6, 2009 - 1:50am
dunston17, what's your opinion? Comment below:

I agree with Beluga - Factset's data is pretty dodgy, and on the whole I find it to be such an inefficiently programmed software compared to CapIQ. The best thing about Factset is undoubtedly Pres link though - that's the shittt.

Oct 6, 2009 - 10:48am
NoLongerActiveHere, what's your opinion? Comment below:

well ... i download data with factset and double check with T1 and Bloomberg

I'm all about automation. I don't have time to be looking sht up manually (I work in capital markets for the most part)

That said yes factset data is slightly dodgy

Oct 7, 2009 - 10:54am
ibanker2000, what's your opinion? Comment below:

I loved factset until my office got CIQ… The thing I missed the most was dealmaven until I found out CIQ has their own linking tool just like preslink AND the data and auditability is way better. I'd go for CIQ over factset any day

Oct 11, 2009 - 7:50pm
thecatch, what's your opinion? Comment below:
ibanker2000:
I loved factset until my office got CIQ… The thing I missed the most was dealmaven until I found out CIQ has their own linking tool just like preslink AND the data and auditability is way better. I'd go for CIQ over factset any day

damn really?? was the presentation linking tool installed by default? i did not realize this at all during the week i had capiq...preslink was one of the things i thought factset had over capiq. not that i can switch anymore, but damn, if capiq has a preslink-like tool then i'd have to say capiq is just better almost all around. ultimately, both have pretty unreliable numbers, but at least capiq is more easily audited.

Oct 7, 2009 - 2:07pm
Buck2210, what's your opinion? Comment below:

All of the people saying "FactSet is way easier to update in excel than CapIQ" are idiots.

CIQ codes are where it is at - learn how to use them fellas. CapIQ over FactSet and it's not even close. I must say CapIQ support is 10x better than FactSet support. The FactSet people in India (after hours) are horrific.

Oct 7, 2009 - 2:44pm
h.e.pennypacker, what's your opinion? Comment below:
Buck2210:
All of the people saying "FactSet is way easier to update in excel than CapIQ" are idiots.

CIQ codes are where it is at - learn how to use them fellas. CapIQ over FactSet and it's not even close. I must say CapIQ support is 10x better than FactSet support. The FactSet people in India (after hours) are horrific.

I only used CapIQ for a summer internship, and I was able to memorize enough CIQ codes to make a complete comps project by the end. I found it's automation to be very easy, with the only downside being the slow down while updating (which wasn't that bad).

May 9, 2011 - 7:35pm
Alpha123, what's your opinion? Comment below:

We currently use Factset and our contract is up for renewal but our base fees are in the Millions! Are your Base fees outragous?

Does anyone have a breakdown of costs for CapIQ vs. Factset? I may recommend we switch - enterprise wide.

May 9, 2011 - 10:26pm
feenans, what's your opinion? Comment below:

Factset FTW! The only issue I have is that ALT-S-F-A (updating) takes way too long sometimes, since I often huge spreadsheets. i.e. historical panel data for 100 companies with 100 financials variables for 36 quarters. Nothing makes me more furious than waiting for an hour to update that shit only to have excel crash ARGHHH!!!!! I swear to god if it was allowed, I would gladly punch through my monitors and pay for replacements the next day when that happens.

Jul 19, 2012 - 5:07pm
sharp_in1008, what's your opinion? Comment below:

Factset - Shortcomings? (Originally Posted: 06/21/2007)

Any views on this data stream provider? What are the shortcomings..

Jul 19, 2012 - 5:08pm
ONGMonkee, what's your opinion? Comment below:

It is a great resource, especially the new interation that they just put out (or at least my bank just got). Had training this morning on the new platform which actually is very relevant in creating buyers lists (I am in financial sponsors group). I will not abandon CapIQ, however, as I am more familiar with it, but will supplement the two going forward.

Factset is really good for public comps if you have the excel plugin and saves a lot of time in terms of raw data.

Jul 19, 2012 - 5:12pm
aachimp, what's your opinion? Comment below:

factset is awesome for defining stock selection criteria. capiq is more of a google of company info. don't see how you could compare the two. bbg is alright, but it's more for traders.

way i see it.

factset -> investing bbg -> tradingcapiq -> banking

Jul 19, 2012 - 5:15pm
willski21, what's your opinion? Comment below:

I've always used CapIQ, but we are considering switching to FactSet. From only a quick glance, it seems like FactSet lacks depth in transaction screening criteria, but definitely has better info on fixed income.

Are these fair statements?

Jul 19, 2012 - 5:16pm
Alpha123, what's your opinion? Comment below:

We currently use Factset and our contract is up for renewal but our base fees are in the Millions! Are your Base fees outragous?

Does anyone have a breakdown of costs for CapIQ vs. Factset? I may recommend we switch - enterprise wide.

Jul 19, 2012 - 5:17pm
vikram_eda, what's your opinion? Comment below:

FactSet Vs CapitalIQ (Originally Posted: 05/23/2009)

Friends,

I have used FactSet a little bit. Actually MergerStat. Do not know much about CapIQ.

I will be using CapIQ during my summer internship.

Does anyone know what the major differences are between the two ?

V

Jul 19, 2012 - 5:18pm
MoneyKingdom, what's your opinion? Comment below:

CapIQ is the shit. I use bloomberg more often, but most of the analysts use CapIQ for everything. FactSet is good too, but the excel plug-in on CapIQ is simply amazing.

Jul 19, 2012 - 5:19pm
research_grunt, what's your opinion? Comment below:

Have you tried using Gridstone Research? (http://grid.gridstoneresearch.com/grid/site/usersignup.aspx)

I used it once and have not gone back to the others ever. (My job is US company focused.)

Jul 19, 2012 - 5:20pm
SanityCheck, what's your opinion? Comment below:

Which data/research provider do you prefer (CapIQ, Thomson, Factset) (Originally Posted: 11/06/2012)

Just wondering what my fellow private equity colleagues prefer their firm uses. For once I have the ability to decide which provider our firm uses going forward and am wondering what others are using and how they like it.

From talking to account reps, it seems like Thomson definitely has the most research reports and information (content) but lacks in add-ins, macros, excel-related modeling plugins, etc. However they are working to build this in the past six months.

Factset seems to have all the cool gadgets and better technology/software/application but is a bit on the low end with respect to the research reports and content.

and Cap IQ I just don't like but that's my personal opinion.

What do you guys like/prefer?

Jul 19, 2012 - 5:22pm
shark-monkey, what's your opinion? Comment below:

Axial Markets I've heard, Haven't used tho

Fear is the greatest motivator. Motivation is what it takes to find profit.
  • 1
Jul 19, 2012 - 5:24pm
idragmazda, what's your opinion? Comment below:

I like Cap IQ and SNL. Have not used the others much.

Super Nintendo, Sega Genesis - when I was dead broke man I couldn't picture this
Jul 19, 2012 - 5:25pm
collector, what's your opinion? Comment below:

capiq , although for reports i prefer reuters knowledge

Jul 19, 2012 - 5:26pm
Laissez_faire, what's your opinion? Comment below:

I'm biased but if you are a PE or VC shop modeling financials and investment metrics for private companies you should explore ClearMomentum. They allow the report building and modeling you might expect with public companies via FDS or CapIQ but using your proprietary portfolio company financial data...

Jul 19, 2012 - 5:32pm
anybankeratall, what's your opinion? Comment below:

FactSet vs. Capital IQ vs. SNL Financial (Originally Posted: 11/18/2013)

What do you guys use and which one is better? Do you use it for different things?

Those FactSet reps came over to our bank and told us how much better they were. We currently have all our Excel models embedded with Capital IQ CIQ formulas but Cap IQ interface really does seem a bit dated.

Is FactSet better?

I know SNL is for FIG only but how good is it? My bank does a ton of BDCs and REITs - what does SNL do that Cap IQ or FactSet cannot for FIG?

Jul 19, 2012 - 5:36pm
Bullet-Tooth Tony, what's your opinion? Comment below:

Only SNL if you are working in FIG. Doesn't cover BDCs and REITs to the same level as it does banks and insurers.

CapIQ pricing depends on the number of licenses. Ours runs around $15-20K. Heard mixed things about Factset. CapIQ has been crashing too often the past year and there is plenty of inaccurate data on it as well.

Jul 19, 2012 - 5:37pm
td12, what's your opinion? Comment below:

The layout of SNL is nice IMO, but I sometimes see minor discrepancies in the numbers. They have a deal that pays out $50/error if you send them a shot of it.

Jul 19, 2012 - 5:39pm
duffmt6, what's your opinion? Comment below:

CapIQ is easier to use and faster than FactSet.

"For I am a sinner in the hands of an angry God. Bloody Mary full of vodka, blessed are you among cocktails. Pray for me now and at the hour of my death, which I hope is soon. Amen."
Jul 19, 2012 - 5:41pm
B_T Analyst, what's your opinion? Comment below:

I'm fairly late to comment here, but for anyone else that reads this. I've used snl for some time and it's a good product; however, be prepared to get jammed at renewal time. They give the song and dance about unlimited users, but then hit you with 15 - 20% increase on price (year over year).

I've also used CapIQ and it's fairly slick. A better interface than SNL and worlds better than FactSet

Jul 19, 2012 - 5:43pm
OGBanker, what's your opinion? Comment below:

I like CapIQ much better than Factset. At first I thought the user interface of Factset looked cooler and I was hopeful. But I soon found myself missing CapIQ. The only thing I like about Factset is they give you a bunch of foam footballs you can toss around the office. And then in a month they've all disappeared somehow and then the sadness returns.

  • 1
Jul 19, 2012 - 5:44pm
eerie33, what's your opinion? Comment below:

factset is too heavy, and crashes all the time. I am in FIG and we use SNL for almost everything, it costs 650 per month if I remember correctly.

Jul 19, 2012 - 5:45pm
dhcdr, what's your opinion? Comment below:

FACTSET THOMSON ONE OR CAPIQ (Originally Posted: 05/02/2014)

our firm is looking for a new system and I wanted to know if anyone had any experience in working with these systems. So far the consensus I get is capiq is better than thomson one, however I have not heard anything on factset.

Jul 19, 2012 - 5:46pm
above_and_beyond, what's your opinion? Comment below:

Well, we generally use CapIQ for historical financials and FactSet for estimated financials in models. I really like that combination because I feel like CapIQ is more accurate in terms of historical financials, but I could be wrong. All in all, I mostly use FactSet for all types of tasks, CapitalIQ for broker reports, call transcripts, and screenings, ThomsonOne for broker reports and Bloomberg for broker reports and market data. If I had to choose, I would probably opt for FactSet or CapitalIQ (or even better, both). ThomsonOne is nice to have, but no must have imho. And it's super slow which is quite annyoing.

Jul 14, 2017 - 12:24pm
sloopjohnd, what's your opinion? Comment below:

Late to the party, but you should check out Sentieo. It comes in a lot cheaper than either Factset or CapIQ, and can be useful for M&A when looking up precedent transactions. In particular, it takes about ten seconds to find the fairness opinion of any merger ranging back at least a decade using its document search.

To be fair, it doesn't have quite the breadth of data that either Factset or CapIQ does, but its equity data is on par, both domestic and internationally. I am a former employee of Sentieo, so I am a little biased of course, but for equity analysis and M&A work, I've yet to find a better value proposition.

Jul 14, 2017 - 12:25pm
dsciola, what's your opinion? Comment below:

Capital IQ and Others for Corporate Development (Originally Posted: 04/28/2014)

All,

I recently got a job in Corporate Development. One of my first to-do's is to get our team/the firm a thorough market research, data analytics, and overall M&A tool. M&A especially important here since the firm wants to be more acquisitive. For example, Capital IQ.

Wanted to ask the smarter than me folks on this website...what other alternatives are there to Capital IQ? What are some other comparable services? So far, I've been able to dig up as alternatives services...

FactSet VM Index Hoovers/ Dun & Bradstreet

Any other ones out there?

Thanks, Dominick

Jul 14, 2017 - 12:26pm
Nouveau Richie, what's your opinion? Comment below:

I mean, there's the obvious category leader, which you didn't mention: Bloomberg.

“Millionaires don't use astrology, billionaires do”
Jul 14, 2017 - 12:27pm
dsciola, what's your opinion? Comment below:

Laboriosam quasi consequuntur ea. Exercitationem officiis in rerum odio ab ad quia. Sequi et odit dolor consectetur adipisci. Sunt quia ex non est eaque.

Nulla saepe delectus eos. Quae reprehenderit cupiditate repellat velit. Quia ut dolor deleniti itaque. Ipsum nesciunt labore ut cumque in non.

Jul 14, 2017 - 12:28pm
roberto, what's your opinion? Comment below:

Rem odio sed ut. Ullam soluta omnis ut. Quia et autem natus omnis quisquam. Ea vitae quisquam perferendis temporibus. Quasi cumque aut voluptatem.

Facere beatae sequi et sapiente. Laboriosam earum amet deserunt sint.

Voluptas non maiores sint consequatur inventore. Non dicta dolores non qui. Voluptas vel sed sit illo doloremque eos. Voluptatum iusto facere et odio est qui dolorem. Voluptates rem debitis ipsam et dolor officia. Incidunt unde modi eum quis.

Dolor dolorem quod molestiae magni ipsa provident soluta magnam. A similique voluptates corrupti velit. Debitis optio dolores autem commodi cupiditate possimus dolor. Fuga et architecto laudantium a in.

Jul 14, 2017 - 12:30pm
Oil Frog, what's your opinion? Comment below:

Enim ratione eum sint temporibus. Qui quasi nam est laborum accusantium. Corporis exercitationem voluptatem quas numquam qui dolorem. Corrupti quia iusto similique est cum non suscipit. Quia unde eos non recusandae quo.

Corrupti voluptatum ut cumque hic quisquam quia similique dolores. Aperiam excepturi quis quibusdam odit est in. Est molestiae accusamus excepturi ad iusto voluptas. Et nobis ut officiis qui. Est et voluptatum magni qui architecto qui numquam.

Start Discussion

Career Advancement Opportunities

July 2022 Investment Banking

  • Jefferies & Company (▲03) 99.6%
  • Lincoln International (= =) 99.2%
  • RBC Capital Markets (▲07) 98.8%
  • Bank of America Merrill Lynch (▲01) 98.4%
  • Houlihan Lokey (▲06) 98.0%

Overall Employee Satisfaction

July 2022 Investment Banking

  • Lincoln International (▲06) 99.6%
  • Jefferies & Company (▲11) 99.2%
  • Greenhill (▲07) 98.8%
  • Rothschild (▲01) 98.4%
  • Evercore (▽01) 98.0%

Professional Growth Opportunities

July 2022 Investment Banking

  • Jefferies & Company (▲04) 99.6%
  • Lincoln International (▲04) 99.2%
  • RBC Capital Markets (▲09) 98.8%
  • Houlihan Lokey (▲07) 98.4%
  • Bank of America Merrill Lynch (▲04) 98.0%

Total Avg Compensation

July 2022 Investment Banking

  • Director/MD (9) $661
  • Vice President (37) $394
  • Associates (192) $256
  • 2nd Year Analyst (117) $162
  • 3rd+ Year Analyst (17) $156
  • 1st Year Analyst (369) $150
  • Intern/Summer Associate (79) $147
  • Intern/Summer Analyst (292) $92