For Recruiters
When you want to put a rocket behind your spreadsheet.

How to harness Python as a programming language when you mostly know Excel

Most of the new juniors who get jobs in investment banks now know how to code a bit in Python. However, this doesn't mean they're Python natives, and typically they still spend a lot of time in Excel.  One former product manager at UBS asset management has developed an open-source product to make their lives easier. 

"The idea is to automate Excel with Python," says Felix Zumstein, an ex-UBS director and the man behind XLWings, a Python library that can be called from Excel using a syntax not dissimilar to VBA. "It's not for professional developers," says Zumstein of his creation. "It's for citizen developers, for people who spend an hour or so every day tinkering about in code and who know how to code a bit, but who mostly write a little bit of code as a means to an end."

Best comment picked by the author
What is the benefit of adding Python to Excel? If VBA already natively has access to the entire Excel object, as well as the remaining Office object models, what is gained by extending it through Python?

Given that XLWings operates at the intersection of Python and Excel and that its protagonist came from a Swiss bank, it's unsurprising that most of its users are working in finance. "People using XLWings can be financial modelers, economists, anything in banking," says Zumstein. "It speeds up workflows. - If you just want to format a spreadsheet to look nice, it's not the ideal use case. But if you want to do scientific computations in Excel or calculations with a lot of data, it will make your life a lot easier."

Zumstein says users come from both ends of the age spectrum. On one hand, they're the "Excel guys aged 40+ who only really know VBA"; on the other, they're new analysts who can potentially do everything in Python but who use Excel when they need to send data to senior staff. "Excel will always be used in banks somewhere," says Zumstein. XLWings makes using it easier. 

XLWings piggybacks on PyWin32. Zumstein began working on it in 2014. Today, there's a paid version that he sells to "major banks, hedge funds and S&P 500 companies" and an unpaid open-source version that's been downloaded nearly 650,000 times in the last 30 days alone.

Not all banks allow juniors to plug-in open-source packages, but Zumstein says smaller boutiques in particular are ahead of the curve and that some analysts use XLWings anyway: "It's become much more common to use open-source software packages than it used to be."

Have a confidential story, tip, or comment you’d like to share? Contact: sbutcher@efinancialcareers.com in the first instance. Whatsapp/Signal/Telegram also available.

Bear with us if you leave a comment at the bottom of this article: all our comments are moderated by human beings. Sometimes these humans might be asleep, or away from their desks, so it may take a while for your comment to appear. Eventually it will – unless it’s offensive or libelous (in which case it won’t.)

Photo by NASA on Unsplash

 

 

 

author-card-avatar
AUTHORSarah Butcher Global Editor
Cancel
  • xl
    xlwings fan
    19 November 2021

    For an quickstart guide and some more information on xlwings, check out this article:
    https://towardsdatascience....

  • qu
    quadrature
    18 November 2021

    I have used XLWings and it's absolutely brilliant. Using Xlwings opens up the large number of packages available in python (numpy, scipy, statsmodels etc) to excel users. You then basically used Excel as a glorified data entry and all your grunt work is done in the background. This is quite similar to use Excel-Dna for C# or the MS Excel SDK for hardcore C/C++ coders with the added advantage of the richness of the python package landscape.

  • Se
    Sean
    17 November 2021

    What is the benefit of adding Python to Excel? If VBA already natively has access to the entire Excel object, as well as the remaining Office object models, what is gained by extending it through Python?

Apply for jobs

Find thousands of jobs in financial services and technology by signing up to eFinancialCareers today.

Boost your career

Find thousands of job opportunities by signing up to eFinancialCareers today.
Latest Jobs
FNZ
Migration Analyst Tester
FNZ
Toronto, Canada
Selby Jennings
Data Scientist
Selby Jennings
Mont-Royal, Canada
Caisse de Dépôt et placement du Québec (CDPQ)
Analyste, Administration et soutien à l'investissement - Marchés boursiers
Caisse de Dépôt et placement du Québec (CDPQ)
Montreal, Canada
Caisse de Dépôt et placement du Québec (CDPQ)
Analyste fonctionnel(le) D365 Finance & Opérations
Caisse de Dépôt et placement du Québec (CDPQ)
Montreal, Canada
Caisse de Dépôt et placement du Québec (CDPQ)
Analyste, Encaisse
Caisse de Dépôt et placement du Québec (CDPQ)
Montreal, Canada
Caisse de Dépôt et placement du Québec (CDPQ)
Premier(ière) analyste, Placements privés - Équité 25³ (fonds diversité)
Caisse de Dépôt et placement du Québec (CDPQ)
Montreal, Canada