Jane Street TDO Excel and VBA Test: 23 Experiences (Part 8 of 10)

Shared by janebeingjane ·
Level
Unknown
Stages
OA → Phone screen

Jane Street TDO Excel and VBA tests, US and Montreal reports from 2015 to early 2023: most report only the first Excel take-home, usually a haircut sheet.

At a glance

  • Process (these earlier reports): Excel take-home, often due in two or three days → phone brainteaser call → VBA take-home → coding or interviews. Eleven were turned down after the first Excel take-home; four more describe only it.
  • Asked: haircut sums in 14 of 23, latest Jan 2023 (H20, H21). Named in a few: currency haircuts (H26, H32, H35), a securities haircut (H35), an Excel-functions sheet beside the haircuts (H26, H27, H31, H35, H36), transaction fees (H34) and a VBA price alert (H21).
  • Difficulty: the formulas felt basic but the finance reading tedious or confusing (H29, H33, H36, H42). VBA felt difficult in H24, harder in H25 and easy in H30.
  • Practise first: Currency Haircut with FX Forwards (H26, H32, H35), Price Deviation Alerts (H21) and Transaction Fees by Instrument (H34).

Coverage: 23 reports from before Nov 2023: 22 US (7 New York, 1 Chicago, 14 with no city) and 1 Montreal. Titles: TDO, Trade Desk Operations, Trading Desk Operation(s), Trading Desk Operations Analyst (H34) and Operations Specialist (H21, same pipeline). None states a hiring level. Apr 2015 (report date) to Jan 2023. Furthest stage described: the first Excel take-home (15), a timed test (H23), a second Excel test (H37), the VBA test (H22, H24, H25, H28, H30) and video coding (H21).

In this series

What came up

Nearly everyone here started with an Excel take-home, and most reports stop there. Haircuts run through it from 2017 to 2023.

Topic Reports Last seen
Excel take-home or test 22 of 23 Jan 2023
Haircut calculations 14 of 23 Jan 2023
Maths or brainteaser phone call 7 of 23 Jan 2023
VBA take-home 6 of 23 Jan 2023
Excel-functions sheet beside the haircuts 5 of 23 Feb 2020

Questions in these earlier reports

Counted only within these 23 reports.

Excel, VBA and data tasks

Question Reports Last seen
Haircut sheet, rules not given (not on FastPrep: topic only) 11 Jan 2023
Excel take-home, contents not given (not on FastPrep: topic only) 7 Jul 2021
VBA take-home, task not given (not on FastPrep: topic only) 5 Oct 2022 (report date)
Excel-functions sheet, e.g. share counts (closest practice) 5 Feb 2020
Currency haircut 3 Feb 2020
Transaction fees by instrument 1 Mar 2018
Securities haircut (closest practice) 1 Feb 2018

Coding

Question Reports Last seen
VBA price-deviation alert 1 Jan 2023
Python coding on video, no prompt given (not on FastPrep: topic only) 1 Jan 2023

Maths, probability and brainteasers

Question Reports Last seen
Brainteasers or maths, not described (not on FastPrep: topic only) 5 Jan 2023
At least 2 heads in three coin flips 1 Oct 2018
People getting on and off a bus (closest practice) 1 Feb 2018

Behavioral (BQ)

Question Reports Last seen
Why Jane Street? 1 Jan 2023
Most recent project and what you learned 1 Jan 2023

History (before Nov 2023)

H20: Haircut test, then silence

Interview date: Jan 2023 · Location: New York · Result: Rejected after the Excel test

Emailed after an online application: an Excel test, due within three days, to work out haircuts with formulas. A haircut is the cut taken off a position's value to allow for risk. No update came until the candidate asked; then a no, though they believed their answers were right.

H21: Haircuts, a VBA price alert and Python

Interview date: Jan 2023 · Role: Operations Specialist · Location: United States · Result: Not stated

(1) Excel take-home on haircuts, where detail matters. (2) Phone: some maths brainteasers (not given). (3) VBA (Excel's macro language) take-home: a macro that reports how far, in percent, a stock trades from its reference price (Price Deviation Alerts). (4) Python coding on video (prompt not given). Also asked, round not given: why Jane Street? and your most recent project and what you learned.

H22: Excel, brainteasers, then a VBA macro

Report date: Oct 2022 · Location: United States · Result: Did not reach the fourth round

Excel haircut take-home; phone brainteasers (not given); a VBA take-home to build a macro (task not given). The process ended there.

H23: One timed take-home, process only

Report date: Sep 2022 · Location: United States · Result: Not stated

A timed take-home of one to two hours, submitted through a link. Medium-easy, the candidate says; an economics background helps.

H24: Finance questions and a tough VBA test

Interview date: Jul 2021 · Location: United States · Result: Not stated

Excel take-home of basic formulas and finance questions; a phone call with three critical-thinking or maths questions (not given); a VBA coding test the candidate found difficult for a role that needs no coding. An interview came after these three, not described.

H25: VBA learned in five hours

Interview date: Oct 2020 · Location: New York · Result: No offer (rejected after the VBA test)

Fairly easy Excel test; a 15 to 20 minute call with a couple of brainteasers; a harder Excel VBA test. The candidate taught themselves VBA in about five hours for it.

H26: Montreal currency exposure sheet

Interview date: Feb 2020 · Location: Montreal · Result: Not stated

Three Excel exercises: haircuts, currency questions and basic Excel operations; no finance training needed. One task: for a given currency, add up the total exposure, then apply the haircut to its absolute value (Currency Haircut with FX Forwards; the practice version sums every currency into one total). For the basic Excel part, Trade Blotter Summary by Ticker is the closest practice.

H27: Haircuts and share counts

Report date: Feb 2019 · Location: United States · Result: Rejected after the Excel assignment

Found on a school job portal. Online Excel assignment on haircuts and Excel functions, including number of shares (Trade Blotter Summary by Ticker is the closest practice). Answers went back by email; a rejection followed.

H28: VBA test not finished in time

Interview date: Feb 2019 · Location: New York · Result: No offer

A short Excel skills test and a call with two brainteasers, both passed. The VBA skills test allowed two to three days; the candidate did not finish it in time, which ended the process.

H29: Easy formulas, hard finance

Interview date: Jan 2019 · Location: United States · Result: Did not pass the Excel round

Short Excel exercises: decide haircuts in made-up situations. The Excel steps were basic; the economics-heavy content was the confusing part.

H30: Coin odds, then an easy VBA question

Interview date: Oct 2018 · Location: New York · Result: Rejected at the VBA round

Excel round on handling data with formulas. Phone: mental maths, such as the chance that at least 2 of 3 fair coins land heads. Then an easy VBA question (not given), where the process ended.

H31: Haircuts with explainer PDFs

Interview date: Jun 2018 · Location: United States · Result: Not moving on after the exercises

Excel exercises due in two to three days, with documents and PDFs explaining each problem: several haircut questions and a few on Excel formulas (Trade Blotter Summary by Ticker is the closest practice for those).

H32: Failed on a currency haircut

Interview date: Apr 2018 · Location: New York · Result: No offer (failed the Excel test)

An Excel test on working out a currency haircut. Inputs not given.

H33: Three PDFs and lookups

Report date: Mar 2018 · Location: United States · Result: Not stated

Applied through university. Excel files plus three PDF explanations; the haircut follows the logic in the PDFs. The sums are light, VLOOKUP level (the function that finds a row by its key); understanding the questions is the hard part.

H34: Fees on a set of instruments

Interview date: Mar 2018 · Role: Trading Desk Operations Analyst · Location: New York · Result: Not stated

An Excel test of both Excel skill and a finance idea explained in the test: work out the transaction fees for a set of financial instruments. Fee rules not described.

H35: FX and securities haircuts, rejected next day

Interview date: Feb 2018 · Location: United States · Result: Rejected the day after submitting

Approached for TDO after applying to other roles. An emailed problem set, due in a few days: a foreign-currency haircut (Currency Haircut with FX Forwards), a securities haircut (Bond Haircut by Ratings and Maturity is the closest practice) and questions on Excel functions (Trade Blotter Summary by Ticker is the closest practice).

H36: Tedious haircut files and a lookup sheet

Report date: Feb 2018 · Location: United States · Result: Rejected soon after submitting

Applied online. Excel exercises due in two to three days: files on haircuts, with the finance context in PDFs, plus one sheet on Excel functions such as lookups (Trade Blotter Summary by Ticker is the closest practice). Not hard, but tedious and finance-heavy.

H37: Bus riders, then a second Excel test

Interview date: Feb 2018 · Location: United States · Result: No feedback after the second test

Simple Excel test; a call with a couple of maths questions, one on people getting on and off a bus (details not recalled; Bus Riders After Many Stops is the closest practice); then a longer second Excel test, not described. The candidate thought it was right but heard nothing.

H38: Haircut test over two to three days

Interview date: Nov 2017 · Location: United States · Result: Rejected after the Excel test

An Excel skills test on haircuts with two to three days to finish. The rejection came a few days after submitting.

H39: Haircuts after an info session

Interview date: Sep 2017 · Location: United States · Result: Rejected after the Excel assignment

Applied after an online information session. Several Excel assignments, two to three days to finish: work out haircuts from the information given.

H40: A list of Excel tasks

Interview date: Jun 2017 · Location: New York · Result: Not invited to another interview

A list of tasks to complete in Excel, including the haircut for given positions (inputs not given).

H41: Chicago take-home, quick no

Interview date: Feb 2017 · Location: Chicago · Result: Rejected after the take-home

A few short Excel exercises on basic calculations. Returned on a Saturday; the rejection email came on Monday.

H42: Simple Excel, heavy reading

Report date: Apr 2015 · Location: United States · Result: Not stated

A pre-interview assignment: simple Excel commands and simple maths, with technical reading material to learn first.

Keep practicing

In this series: Part 1 · Part 2 · Part 3 · Part 4 · Part 5 · Part 6 · Part 7 · Part 8 · Part 9 · Part 10

Sources: Anywhere useful interview info can be found.

Next in this seriesJane Street TDO Phone Math Round: 26 Experiences (Part 9 of 10)
0 total reactions. Your reactions: none.

Comments

0

No comments yet — be the first to share what you know.