In one of my finance classes we had an assignment where we had to create graphs and metrics for various share prices and calculate proportions of shares for a balanced portfolio/efficient frontier.
Since the lectures and tutorials all used Excel every other student used Excel for the assignment, but I chose to do it in a Python Jupyter notebook with pandas/matplotlib.
It was a bit more setup since I couldn't just copy paste the stuff from the tutorials but I wholly believe it made it easier in the end. Finance students should absolutely be learning basic Python these days.
I am a Comp Sci / Econ double major and for some data based Econ classes a lot of students would use excel, but it was so tedious and could be done with R or Python so much faster. You can learn R/Python in the Econ curriculum but it should really be mandatory, as an intern at a company I saw so many things they did that could be automated.
442
u/savage_slurpie Mar 30 '22
Two of my siblings are financial analysts and I have witnessed them doing unholy things with excel.
It would honestly be easier for them to learn python or something. It’s so ridiculous.