Usage of Excel in Rates Trading?
During the summer I'm going to be interning in S&T at a BB on their rates trading desk. I really enjoy VBA and have used it to a fairly advanced level in previous internships, and am just wondering how prevalent VBA is in rates trading nowadays? Are many tools that a rates trading team would use still Excel-based, or are they more sophisticated - e.g. Python, C++, etc? I have a rough understanding of how to interface C++ functions with Excel, but assume this is more on the quant side of things and not something I'd be touching at all over the summer.
I'm really curious about this sort of stuff, so any guidance would be much appreciated. Thanks!
I work in rates trading. I use python, c++, and excel/VBA (c++ for speed if necessary). These are all very advantageous, and honestly I would know all of them if you could. C++ probably being the least priority if your role is not very quantitative.
Super interesting, thanks. Are you able to provide any more granularity on what you actually use C++ for? Is it predominately when you need to write a function where speed is important, so you write it in C++ and then call the DLL from VBA and use the function as a UDF in Excel?
I'm very comfortable with VBA, and also have intermediate Python and C++ skills, so glad to hear they're advantageous on a rates desk.
I don’t really know what you are talking about in terms of interfacing via excel as I have never done that and have no use for that. For example I don’t like our system for pricing caps/floors, so I built a c++ application to do so and will price things there alongside our system. Another example would be building vol analytics tools via python because I think our vol surface/data source is shit so I made my own.
Thanks for the answer. For C++ apps that you build, is it mainly just CLI stuff - or do you sometimes get into making proper user interfaces / GUIs? Just curious about the complexity of programming that is used.
Mainly just CLI. Honestly I am the only one in my group that is technical and so I usability has never been a priority.
Could you elaborate more on what do you usually do with Python/Excel in the context of rates trading? Or for an intern, what are some more specific things I can learn to do in advance with Python/Excel and perhaps add some value to the desk? Appreciate the input.
Quibusdam quaerat illum quo maxime. Minus et labore aut quia voluptatem debitis. Incidunt quo et delectus error labore. Magni et eligendi quia voluptatem est cumque iusto. Qui officiis enim cum pariatur ducimus ut recusandae. Sed animi qui maxime omnis velit et. Voluptates autem quia sed.
Quasi corrupti natus animi accusantium soluta veniam. Provident neque delectus aut est. Quia sint voluptatibus in laboriosam quod impedit eos ad. Nobis dolor id ipsam.
Eius maxime sit voluptatem. Ullam iure mollitia iure in et. Sit non soluta ut sequi illum maiores quisquam. Architecto molestiae assumenda necessitatibus debitis ullam et molestiae. Sunt error voluptatibus occaecati beatae.
Et nihil earum et ducimus. Quia sunt rem nemo impedit rerum sint aspernatur voluptatem. Dolores impedit beatae maxime autem nisi praesentium tenetur. Ipsum eum dolorem esse unde consequatur iste ex. Non sint placeat quae quos debitis aliquam rerum quia.
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...