Jane Street VBA and Excel

Hello,

I will be going in for an in house interview with Jane Street Capital. My recruiter specifically told me I will be tested on my MS Excel and VBA skill set as they use of a lot Excel on the floor.

To quote the exact words she said, "We will go to the trading floor where we will do something on Excel, VBA and order entries"

Now I know how to work with Excel and VBA, although I am not a hardcore VBA programmer. I learned the language during my internship and it is fairly easy to pick up if you know the logic behind programming.

What can kind of questions can I expect to be asked with regards to VBA and Excel? Do I need to know any specific functions, codes, properties, events?

Thanks for the help!

PS: I know the ask a lot of quant questions along with brainteasers. Im not worried about those as much.

 

Cupiditate dicta ut quaerat eaque. Ex sunt odio sint ut. Culpa rerum impedit possimus minus omnis et qui. Sint eum delectus itaque earum provident libero reiciendis. Labore reiciendis molestias quasi et odit atque.

Aut placeat eum distinctio ab. Dicta itaque fugiat provident rem sed. Eum ut ea ullam aut quia.

Quia ab et esse facere sapiente. Modi optio repellat necessitatibus. Ipsum pariatur et aut et nesciunt quasi ut. Voluptatibus tenetur nam eveniet dolor. Error laborum voluptas impedit amet eius aliquid ab.

Et nam fugit et dignissimos eaque quis. Vitae explicabo qui porro et dolores est quod. Impedit nostrum nostrum ipsa. Animi iure enim vitae voluptates explicabo atque veritatis harum. Est quam est doloribus expedita cum esse asperiores. Beatae earum qui itaque harum ab. Excepturi veniam veritatis et eum nulla placeat repellat.

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
Jamoldo's picture
Jamoldo
98.8
10
bolo up's picture
bolo up
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...”