Jane Street TDO Excel and VBA Test: 23 Experiences (Part 8 of 10)
- Company
- Jane Street
- 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
- Part 1: overview, questions and what to practise, 165 reports
- Part 2: UK final round, 14 reports
- Part 3: UK coding round, 15 reports
- Part 4: UK phone screen, 15 reports
- Part 5: US final round, 11 reports
- Part 6: US phone screen, 20 reports
- Part 7: earlier US finals, 19 reports
- Part 8 (current): Excel and VBA test (earlier), 23 reports
- Part 9: phone math round (earlier), 26 reports
- Part 10: UK and Hong Kong (earlier), 22 reports
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
- From these reports: Currency Haircut (H26, H32, H35), Transaction Fees (H34), Price Deviation Alerts (H21), Heads in Fair Coin Flips (H30), Why Jane Street? and Most Recent Project (H21). Closest practice: Trade Blotter Summary (H26, H27, H31, H35, H36), Bond Haircut (H35), Bus Riders After Many Stops (H37).
- Jane Street banks (sign-in needed): Excel and data, coding, behavioral.
- Jane Street interview page and the Experience feed.
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.
Comments
0No comments yet — be the first to share what you know.