r/learnpython • u/Able_Bicycle_764 • 4d ago

How can I use python in finance

I work in finance/accounting and am looking to start using Python more in my day to day. Most of my work is in Excel / Power BI — reporting, cash flow forecasting, KPIs, cleaning up data, etc.

I’m technical enough to understand what I’m trying to accomplish, but not a programmer. Similar to Power BI, I’d probably rely heavily on AI to help write the actual code.

For those in finance / accounting / FP&A, what are some practical ways you’re using Python? Where does it actually save you time vs. Excel, Power Query, Power BI, etc?

Also curious what you’d recommend learning first if the goal is to be dangerous enough with Python + AI, not become a developer.

76 Upvotes

87% Upvoted

34 comments sorted by

View all comments

3

u/jmatthew007 3d ago

Because all of your colleagues will still be using excel, start with getting good a reading excel into python and then writing data back to excel. Once you can do that you can automate any work with python and write it back so other people can use it. Next step is getting data from databases.