Inputting raw sec filings - any tips?

Have a model round coming up at an SM and part of test is to build model from scratch by using SEC filings. That is what I do for my current job anyways but I’m a relatively slow typer so struggle to input historicals quickly. Any tips to make it faster instead of going Q by Q? Any tricks and tips that people have that saves them time? Using the excel filing instead of pdf (I’ve never figured out how to do that because of the weird formatting)? Note that I absolutely cannot use bberg/any other source as part of this.

4 Comments
 

Omnis rerum sunt laudantium omnis saepe quibusdam. Nesciunt sunt quaerat eum dolorem occaecati. Quia ut aut magni enim assumenda expedita. Nesciunt fuga inventore dolores minus et impedit et.

Career Advancement Opportunities

July 2025 Hedge Fund

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

Overall Employee Satisfaction

July 2025 Hedge Fund

  • Magnetar Capital 99.0%
  • Millennium Partners 98.0%
  • D.E. Shaw 97.0%
  • Blackstone Group 96.0%
  • Citadel Investment Group 95.0%

Professional Growth Opportunities

July 2025 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

July 2025 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (26) $463
  • Director/MD (12) $423
  • NA (8) $337
  • Engineer/Quant (84) $285
  • 3rd+ Year Associate (26) $284
  • Manager (4) $282
  • 2nd Year Associate (31) $257
  • 1st Year Associate (76) $192
  • Analysts (237) $182
  • Intern/Summer Associate (27) $144
  • Junior Trader (5) $102
  • Intern/Summer Analyst (270) $92
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

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...”