Creating an Excel sheet that automatically does a Fundamental Analysis, NEED YOUR ADVICE

by StonksArthur. Posted on Sep 14, 2020    2    1


As the title says.

This is the current version (still updating massively): https://imgur.com/a/YyN99vx

But before I continue i would like some advice, what would you like to see? What do you consider important. All the terms and ratios currently selected is what i consider important. the cells will ColorCode red/green/blue/orange when excel autmaticallt detects an interesting value.

You have to manually edit the income statement, balance sheet and cash flow. All the other numbers are generated automatically.

The company that is currently being used is Lennox International.


Comments

  StonksArthur 1

When finished I will post the file for free! it's gonna be a couple weeks however because i want to make it absolutely perfect