Curious to know if anyone has been successful in using Python or another programming language to automate the monkey parts of Equity Research.
I'm in the process of learning Python myself and am wondering if its possible to write code that pulls line items from a 10-Q and inserts them into a valuation template into excel. I've found that I've spent too many hours hardcoding things into excel and want to know if its worth learning to code.
WSO Virtual BootcampsSee all
Career Advancement Opportunities
September 2022万博app网页版
Overall Employee Satisfaction
September 2022万博app网页版
Professional Growth Opportunities
September 2022万博app网页版
Total Avg Compensation
September 2022万博app网页版
LeaderboardSee all
| 1 |
|
99.2 |
| 2 |
|
99.1 |
| 3 |
|
99.1 |
| 4 |
|
99.0 |
| 5 |
|
99.0 |
| 6 |
|
99.0 |
| 7 |
|
99.0 |
| 8 |
|
99.0 |
| 9 |
|
99.0 |
| 10 |
|
98.9 |
Related EventsSee all
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.
Comments (7)
Can you write a program for the associates that automatically star-1 on each earnings call, and says "thanks for taking my question and congrats on a great quarter"?
Thanks.
Buy-side & Sell-side Research Career Coaching
Bump
For context I spent ~3 years as anERassociateand now work as a data analyst writing python/sql. I picked up python when I was in ER for the same reason and it's kind of hit or miss for making your life easier inER/IB. For filling in numbers from a press release or 10-Q you're better off using Bloomberg/CapIQ/SPGlobal/whatever else's excel add in because they'll do it better than you and it'll be a frustrating project as you start to learn python.
if you're really interested in learning python you should find some industry data that's published regularly and write a script that will scrape the data (or get it from an API like FRED, or use a data provider's API like Bloomberg if you have access) and create a report of it using python. If you're actually able to do this it'll be much faster than copy/pasting excel or refreshing 10 tabs of data in excel and everyone you work with will think you're a wizard since most finance people think coding is like magic. You can make other projects like dashboards with macro data, some easy natural language processing with earnings calls (EG how many times did the analyst say "nice quarter guys"), entry level stats stuff like regressions, or plotting time series/valuations over the longer term as projects that are somewhat useful inER/IBbut more to build your python skills up.
Following
My experience with Python, SQL, and light analytics stuff from undergrad was explicitly cited as helping me get anAMoffer with my firm. Like mentioned above, most fundamental financial analysts don't expect quant stuff if that's not your role, so any way you can use it to increase efficiency or streamline workflows will likely impress them. I've found SQL to be helpful for navigating data, particularly in screens etc., though it's not like you can do much with it that you couldn't do with a data provider's UI; more just a matter of preference and if you want to be a little different. Definitely more useful for combinational queries like "show me companies in the industrial sector wherePE>25x, revenue is between 1b and 3b, and most recent price is at least 25% less than 1y high" as opposed to just "show me companies with >25x PE" which would be easily run on any major screening software. Haven't really found much as much of a use for Python since statistical measures and algos etc. aren't always very useful to those in fundamental roles. With that being said, if you see an opportunity, take it since it could be a great way to stand out and earn some favor! If you're still recruiting, play around and try projects that you can talk about in interviews since it'll give you a more unique skill set. Hope that helps.
Are there any specific online python courses that might come in handy for ER? Anyone have any thoughts on theWSOcourse?
Delectus praesentium rerum voluptates vel expedita odio. Autem et blanditiis aut. Culpa libero distinctio ab deleniti. Blanditiis quasi consectetur aut cum cupiditate facilis et. Animi qui voluptatem autem facere sed qui tenetur. Ut corporis corporis nihil dolor maiores. Omnis voluptatem qui corrupti.
Sunt natus libero nihil aut saepe laborum. Natus ex ut maxime quis consequatur autem. Consequuntur aut nihil iure corporis placeat. Aut at et et. Et ut autem laborum ut facilis totam.
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)
orWant toUnlockby signing in with your social account?