Capital IQ, Excel Plug-In: Pulling 400k cells

Basically I need to populate 400k cells in excel for 2,200 companies. I just batched 20k cells and started pulling data. It's been 40 minutes and it's still loading. It was relatively quickly when I tried for just 100 cells but now I batched 20k cells and it seems to be more difficult. 

Does anyone have experience pulling this much data from Capital IQ Excel Plug-In and how long will it take can I speed it up.

TY.

1 Comments
 

Aut distinctio quis non molestiae assumenda. Sed aliquid et recusandae ea veritatis consectetur at.

Quaerat deserunt quo eligendi dolores voluptatibus neque. Ab rerum sunt neque ut at. Et qui voluptas placeat quibusdam reiciendis voluptatem aspernatur. Incidunt rerum dolores atque odit voluptas nulla est. Vero occaecati rerum enim temporibus beatae unde. Asperiores ea quia blanditiis voluptas dolore.

Consectetur quidem beatae corporis ut et. Doloremque dolores nisi officia tempore. Iure dolorem qui rerum incidunt rem et. Perspiciatis vitae sint soluta laudantium tenetur velit. Enim vero aut cupiditate voluptas molestiae sed.

Est officia voluptas facere similique. Rerum ut commodi illum quia beatae aut. Sequi odio aspernatur sit dolores quaerat tempora quidem.

I'm an AI bot trained on the most helpful WSO content across 17+ years.

Career Advancement Opportunities

November 2026 Hedge Fund

  • Point72 99.0%
  • D.E. Shaw 98.0%
  • AQR Capital Management 97.1%
  • Citadel Investment Group 96.1%
  • Magnetar Capital 95.1%

Overall Employee Satisfaction

November 2026 Hedge Fund

  • Magnetar Capital 99.0%
  • D.E. Shaw 98.0%
  • Blackstone Group 97.0%
  • Citadel Investment Group 96.0%
  • Two Sigma Investments 95.0%

Professional Growth Opportunities

November 2026 Hedge Fund

  • AQR Capital Management 99.0%
  • Point72 98.1%
  • D.E. Shaw 97.1%
  • Citadel Investment Group 96.1%
  • Magnetar Capital 95.1%

Total Avg Compensation

November 2026 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (27) $464
  • Director/MD (12) $355
  • NA (9) $320
  • Engineer/Quant (83) $287
  • 3rd+ Year Associate (26) $284
  • Manager (4) $282
  • 2nd Year Associate (32) $253
  • 1st Year Associate (77) $193
  • Analysts (235) $177
  • Intern/Summer Associate (29) $145
  • Junior Trader (5) $102
  • Intern/Summer Analyst (277) $95
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
DrApeman's picture
DrApeman
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”