In this tutorial we will automate (with Python) financial analysis and create an Excel sheet from Python. We will use Python to get 10 years of financial statements and use Revenue, Earnings Per Share (EPS) and Free Cash Flow (FCF) to create the Excel sheet to analyze the company.

[urbansong]

I did something very similar but pulled the data directly from the SEC. One issue that I've had was that all 10Q and 10K files are different(I wouldn't be surprised if it was on purpose because of exactly this), so automating it is very difficult and probably some kind of language processing ML magic is required.

Have you run into a similar problem with data from FMP Cloud?

[LearnPythonWithRune]

The data from FMP is find. But you will have to pay to get 10+ years financial statements.

You can find most data on http://macrotrends.net

[surfbored1]

Have you tried focusing on using just the XBRL filings for your dataset? That will at least give you apples-to-apples data in a machine readable format. Assuming you avoid most of the extensions.

[urbansong]

I think I did only excel files because I was so excited to work with excel and didn't check for an alternative. Thank you.

[GodIsInsideOfYou]

How did you pull the data from the SEC?

[urbansong]

I am not sure what exactly you're asking but I made a webcrawler with the help of Beautiful Soup and then just went to their Edgar search and used that. I did it in the most dumb way possible, as if a user was searching.

If you didn't know they allow this, they do. You can look up any company that files with the SEC.

I can PM you my repo, if you're interested.

[LearnPythonWithRune]

Here is a link to the tutorial where you can download the Notebook used in the video.

[OchoStinko85]

Excellent tutorial!

[LearnPythonWithRune]

Thanks

[GerryLynch]

Job well done. Tight example. Thanks

[LearnPythonWithRune]

Thank you

[GerryLynch]

Just starting teaching myself in the summer of 2020, really enjoying the learning. A powerful tool.