any FI/rv/mortgage traders?

Hey all, I was wondering what kind of projects/models do jr traders usually need to build? seems like automation is a big part, but wanted to get a better idea of what that actually looks like...I have never been a trading desk :( and am super curious and interested!

is vba enough or more advanced coding? Anything else worth learning or getting comfortable with?

Would love to hear anything about fi/rv/credit trading, more specifically mortgage/mbs desk. Thanks so much!

2 Comments
 

For someone interested in FI/RV/Mortgage trading, here’s what you need to know based on the most helpful WSO content:

Projects/Models Junior Traders Typically Build

  1. Automation of Manual Tasks:

    • Automating repetitive daily tasks is a key focus. For example, creating scripts to handle data organization, trade reconciliation, or report generation.
    • Examples include automating pricing sheets, building tools to track PnL, or creating dashboards for market data.
  2. Excel and VBA Mastery:

    • Excel is a cornerstone tool on trading desks. Junior traders often build models for pricing, risk management, and trade analysis.
    • VBA is commonly used for automating tasks within Excel, such as creating macros for data manipulation or building logic for risk calculations.
  3. Statistical and Regression Models:

    • Building regression models to analyze relationships between different financial instruments (e.g., yield curve spreads, RV trades).
    • Multi-variant linear regression models are often used to identify relative value opportunities, such as comparing 2s10s vs. 5s30s spreads.
  4. Trade Idea Generation:

    • Developing tools to identify mispricings or arbitrage opportunities in the market.
    • For example, using PCA (Principal Component Analysis) to analyze rate curves or spreads.
  5. Coding and Quantitative Tools:

    • While VBA is a great starting point, more advanced coding skills in Python, R, or SQL are increasingly valuable.
    • Python is particularly useful for data analysis, backtesting strategies, and building more sophisticated models.

Specific to Mortgage/MBS Desks

  1. Valuation Models:

    • Learning to value mortgage-backed securities (MBS) is critical. This often involves understanding prepayment models, interest rate sensitivity, and cash flow projections.
    • Coding skills can be applied to build valuation models or analyze raw loan data.
  2. Focus on Fixed Income Nuances:

    • Fixed income (FI) trading involves understanding yield curves, spreads, and carry trades. For MBS desks, this extends to analyzing collateral and prepayment risks.
  3. Esoteric ABS Desks:

    • Some desks focus on less liquid, esoteric asset-backed securities (ABS), which require a closer understanding of the underlying collateral.

Skills to Learn

  1. Excel and VBA:

    • Essential for day-to-day tasks. Start with mastering formulas, conditions, and VBA programming (not just recording macros).
  2. Python, R, and SQL:

    • Python is widely used for data analysis and automation. R is great for statistical modeling, and SQL is essential for working with large datasets.
  3. Statistics and Math:

    • A strong foundation in statistics and quantitative methods is crucial. Learn how to apply advanced concepts like PCA or regression analysis.
  4. Bloomberg Terminal:

    • Proficiency in Bloomberg is often expected. It’s a key tool for accessing market data and analytics.
  5. Order Management Systems (OMS):

    • Familiarity with OMS platforms can be a plus, as they are used for executing and managing trades.

Additional Tips

  • Start Small: Begin with Excel and VBA projects, then gradually move to Python or R for more complex tasks.
  • Learn by Doing: Build small projects like a “what’s priced into FOMC expectations” spreadsheet or a tool to analyze yield curve movements.
  • Focus on Fixed Income: FI trading is less automated compared to equities, offering more opportunities to develop hands-on skills.

By mastering these tools and concepts, you’ll be well-prepared to contribute to a trading desk, even without prior experience.

Sources: Preparing for a Jr. Trader/Desk Assistant Role, Q&A: Former BB Rates Trader - Now a prop trader, Insights on Fixed Income Trading, https://www.wallstreetoasis.com/forum/trading/what-are-the-top-volatility-trading-desks-at-jpm-gs-and-what-differentiates-them?customgpt=1, What kind of tools / apps do you wish existed in the industry?

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 
Most Helpful

Ut excepturi quisquam doloremque et saepe laborum nesciunt quibusdam. Ut id est voluptatem est molestiae et. Nisi molestiae impedit ipsum.

Et quo provident quas nemo facilis. Dolorem provident autem consequatur aliquam voluptas omnis. Laborum voluptas ut voluptatem praesentium autem odio ex. Rerum itaque porro optio iste repellat dolores dolores veniam. Doloribus ullam deserunt ut molestiae maxime.

Magnam in commodi est accusamus maxime rem. Sunt atque et quos numquam qui.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (65) $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
BankonBanking's picture
BankonBanking
99.0
3
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
DrApeman's picture
DrApeman
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
CompBanker's picture
CompBanker
98.9
8
dosk17's picture
dosk17
98.9
9
GameTheory's picture
GameTheory
98.9
10
Jamoldo's picture
Jamoldo
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...”