Hey guys, I'm in my 2nd week as an S&T SA and was just given a task to create a dollar roll calculator in excel. I understand the basics of TBAs and how they trade (negative convexity) but how would I go about even starting this? I'm excited at the challenge of it but would just like some advice about where to start. Also, can it be done using normal excel functions or is VBA required? Thanks.
| +32 | Help: GS SF S&T vs JPM NY S&T | 22 | 1d | |
| +15 | Full Time Timeline | 1 | 4d | |
| +13 | Iron Ore Trading? | 12 | 2d | |
| +12 | Tips for a beginning commodities trader? | 1 | 5d | |
| +12 | Job roles with more client experience | 1 | 6d | |
| +9 | Question on SA 2025 SnT timings | 1 | 1d | |
| +9 | Best programming languages to learn for energy trading | 1 | 6d | |
| +9 | I had my superday friday afternoon, when do you think I will hear back? | 1 | 6d | |
| +7 | Questions as a college freshman | 2 | 5d | |
| +3 | Understanding the Yield Curve | 1 | 14h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Bump
it's likely you got tasked with something this difficult because you already claim to "know the basics" in your second week
Similique rerum doloribus quia eveniet hic. Pariatur enim et quia esse. Suscipit optio totam fugit voluptatem.
Et eos excepturi quae qui impedit aut. Deleniti totam tempore et soluta magnam error. Nobis repudiandae consectetur iste et.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...