I am a Pure Maths PhD student who will graduate in 2 years time. My aim is to land a quant job after gradauation.

When collecting more information so that I can have some edges over others, I heard from my friend (he is working as a treasury trader in barclay) that VBA and bloomberg terminal are MUST to know and they will pop up during interview.

However, when I go through online quant jobs required skills, it seems that bloomberg is not even mentioned once (except jobs at Bloomberg) and only a little of them mention VBA.

So my question is

Do quants need to know bloomberg terminal and VBA?

I personally think that Python is used more frequently for quants. It would be good if someone is working as quants or with quant experience can give some pointers.


1 Answer 1


(these are just my random opinions. Sorry, I expect many people to disagree with some of them.)

Bloomberg makes no effort to make its terminals available to students - quite the opposite. Hence lots of recent graduates don't know the terminal, but do know how to get things done without the terminal, and don't think they need the terminal. It's a problem for Bloomberg, not for you. If you've never worked in the industry, it's unrealistic to expect you to know Bloomberg terminal right away. A math PhD student should have no trouble at all learning within a few days 1) how to retrieve the data you want from Bloomberg terminal into your program / database, unless your firm already got someone else to set this up so you don't need to reinvent the wheel 2) how to use a few dozen terminal functions that you will need for your area (like YAS and SWPM and CSHF if you're doing any fixed income), should you need this. Hopefully someone on the desk already made a list of useful terminal functions that everyone needs to know. If not yet, then you should be the first person to write them down. If you move to another area, then there will probably be a few more dozen terminal functions that you will need to learn for that. It's much easier than learning, for example, LaTeX or Python or R.

I don't think that another candidate who perhaps had a summer internship may already learned a few things about Bloomberg terminal, and "can hit the ground running" would be any better than someone who can learn these skills in days. Some HR people (who would probably find learning terminal functions very challenging if they needed to) may disagree. If you have the time to spare and can find access to a Bloomberg terminal (e.g. at a public library) and want to build up your confidence by learning a few functions, it can hardly hurt.

VBA is useful for writing macros in Microsoft Excel and Word. Almost everyone is forced to use these tools sometimes, even if they'd rather use Jupyter Notebook and LaTeX (or whatever). Being able to write simple macros saves you time and makes you a "power user". You can find some examples of useful macros on stackexchange. But writing anything more complicated in VBA is a bad idea. Being asked to reverse-engineer someone else's abandoned legacy spreadsheet because you "know VBA" is a bad position.

  • $\begingroup$ Hi Dimitri Vulis. Thanks for posting an answer. I am just curious. Other than data retrieving, where would bloomberg terminal be used for quants? $\endgroup$
    – Idonknow
    Commented Aug 5, 2019 at 7:22
  • 1
    $\begingroup$ "where would bloomberg terminal be used for quants?" For example, Communications - many people use Bloomberg Chat (IB) and mail (MSG). Benchmarking: you write a complicated model (because it has more features than Bloomberg model), but you want to ensure that for simple cases it matches Bloomberg's model. $\endgroup$ Commented Aug 5, 2019 at 7:26

Not the answer you're looking for? Browse other questions tagged or ask your own question.