Company comparisons

[Bborub]

I am finding it difficult to download and format data for more than one company to perform financial comparisons. Is their a simple way to do this? Thank you.

[dgunning]

Are you referring to company Financial Data i.e. Do you need to compare balance sheets for two different companies? How do you want to do the comparison?

[Bborub]

Yes, company financials. Yes, comparing balance sheets, income statements, etc. , for 2 or more companies. Would like to compare ROE, ROI, and compare ratio analyses between 2 or more companies, as an example. Would like to be able to do this comparison over several consecutive reporting periods. Thank you.

[dgunning]

Describe what you need and it can be added as a feature.
Would it be something like diff(financials1, financials2) ?

Ratios haven't been added yet but it's on the radar

[Bborub]

Once the financials for more than one company have been downloaded and put into data frames, ratio analysis should be easy to perform on this downloaded data, such as 10Q's and 10K's. For example, Return on Equity (ROE)= Net Income/Shareholders' Equity. I can't get python to read this data from the downloaded financials. Say I wanted to download financials for several companies (10Q's, 10K's) and perform ROE analysis on each separate company then compare ROE results, perhaps also in a bar chart, etc...even do this for several different reporting periods for several different companies and do bar charts and other data visualization comparisons. Please note that ROE is just one type of financial analysis that can be performed, I just use it as an example. There are many other financial ratios and formulas that I'd like to apply.

Again, for example, I have downloaded 10Q's for AMD and INTC. The downloaded data provides financial results for Quarters Ending Sep 28, 2024 and Sep 30, 2023 for both companies. Say I would like to do financial analysis and compare AMD's 10Q financials against INTC's 10Q financials for these periods. Doing the financial analysis formulas in python is not difficult, but I can't get python to read, recognize or distinguish the financial data between the two companies, nor distinguish the respective dates. I have tried adding the suffix ".get_dataframe()" but it doesn't seem to work for me to perform the financial analysis I have mentioned.

I hope I have explained clearly. If not I can expand on this.

Thank you.

[dgunning]

That should be broken into two feature/enhancements.

1. Adding metrics like ROI to company financials
2. Comparing Finances and Metrics Across companies

#2. is possible right now, it should be made easier as an enhancement and the documentation needs to be improved.

Note that, once you have downloaded the data into DataFrames it is not at that point an issue with Egger tools. However, one could say that Egger Tools should provide additional features for comparisons.

I will start taking a look at this next week. Your ongoing feedback is requested. One more improvement I think I need in a tool is standard statements need to output more data. See here the comparison between Etsy and Pinterest.

[Bborub]

Thanks, I'll keep checking in here.

[david08-08]

Dwight,

I think this is a great idea and would be a excellent feature/enhancement to edgartools.

David

@dgunning

[virtualfunction]

I would also like to see ratios support for similar purposes. I would be tempted to try and calculate these, but looking into the field names some of them a little overwhelming (as in knowing which field to use as there are so many variants).

I did notice a blank ratios.py which seems to confirm this is on the radar. Look forward to seeing this. With the advent of vector databases and extensions like PG vector it'll great way to query similar companies ina large dataset.