Tips for Incoming Analyst

Will be in fixed income - would appreciate any advice you can share!

  • What differentiates a "great" analyst from a "good" analyst?
  • What are some overlooked tips?
  • How can I best prepare myself prior to the summer?
  • Any interesting books you recommend?
  • What are common mistakes to avoid?

Thank you!

 

1) learn to code - specificaly VBA behind Excel.

shilw its true that python is more powerful when it comes to large programs doing data intensive things...but sometimes the fastest way to build something functional is with an Excel spreadsheet and some VBA

i'm not talking about recording macros...that recorder creates horrible VBA code...you need to actually learn how to program.

learn how these work

If/Then/ElseIf/Else Do While, Do Until, For Each/Next loops -learn how to use the ADO objects to connect and communicate with a database -learn SQL so you can function on the database

learn how variables, objects, arrays and collections work learn how to prorgamaticaly use the builtin excel worksheet functions with VBA

with this programming knowledge, you can create very powerful things

just google it...you're welcome
 

Agreed that VBA is helpful; Never really used MySQL in S&T Fixed income, but I don't think either should take priority to really grasping the basics. I would work on foundation over anything; Understanding market trends like it's second nature, understanding how fixed income instruments work, understanding what the roles entails, etc.

Programming can be picked up relatively quickly; As long as they understand the building blocks of XYZ language (as you mentioned loops, control flow, etc.) they can literally write pseudo code in english and program it out. But if he/she has missing holes in fundamentals; his/her code will be flawed as well.

Whatever it takes.
 
Most Helpful

Tempora exercitationem unde dicta occaecati aliquam. Quo hic dolore nostrum inventore nam culpa consequatur. Dicta ratione beatae labore et nihil laborum fugiat deserunt. Non consequuntur accusantium nemo nihil et quia. Veritatis dignissimos dolor quos officia. Maxime laborum sint nihil a autem architecto impedit debitis. Suscipit veritatis et rem explicabo.

Natus rerum et voluptas et ea aut eum. Voluptate reiciendis non quas cum et. Sed non dolorem in reiciendis praesentium aut modi. Eaque esse molestias et qui.

Whatever it takes.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
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
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
Kenny_Powers_CFA's picture
Kenny_Powers_CFA
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...”