Advice on building equity screening tool and sources of credible macrodata

Hi WSO,

I've been investing my own money (mainly ETF's, some individual stocks and bit of trading for the sake of entertainment) throughout my studies for a few years, and finally had the time/energy to take a little more disciplined approach to it.

The goal is to create a screening tool, which further filters candidates that might be worth looking into more detail/do fundamental analysis, or at least get rid of the weakest stocks. I'm aware that screening tools exist and the challenge of seeking to create alpha, but part of this project is just interest and an attempt to delve myself a bit deeper. All though I'm mainly asking for advice/feedback on the tool & metrics used, recommendation about existing screening tools and sources of data (company specific & especially strong macro data) are more than welcome.

So far, I've chosen 18 metrics from four segments (valuation, profitability, growth, risk) that would serve as proxies in the journey towards a sensible model. I've tried to select metrics that would fundamentally drive value (ROIC, for example), but selection is subject to limited data & knowledge as well. All of the stocks will be assessed on these criteria, then the criteria is aggregated into segment score (for each four segments), and then finally the total ranking of the stock. Ranking of the metric will be done through placing the stocks on deciles. Obviously the weight that is assessed to each criteria and segment is crucial in this coarse model and it is still under way (35/25/25/15 for valuation/profitability/growth/risk for example). Industry & geographic allocation would be based on human decisions at this point.

**Valuation (35%) **(P/E, P/B, EBIT/EV, Dividend yield)

**Profitability (25%) **(FCFF/EV, ROIC,ROE 3yr median, Gross margin, Operating margin)

**Growth (25%) **(Operating income growth, Revenue growth, Net income growth)

**Risk (15%) **(Equity/Debt, Cash, Beta, Payout ratio (e.g below 80%?), Amount of Goodwill)

Would anyone care to share their $0.02 on the taken approach? (metrics, ranking & weights)

 

Nihil sunt distinctio voluptatem deserunt. Nihil quia molestiae soluta ut. Ratione delectus sint autem qui fuga. Voluptas ad debitis quibusdam facere est corrupti. Esse ipsum voluptas non officia. Et corporis repellendus alias voluptas numquam ipsum rerum.

Non tempore quia minus aut consequuntur ratione consequatur. Magni illo debitis in laudantium. Quidem similique velit quia eveniet libero aut rerum. Vitae adipisci accusantium cumque atque. Voluptatem reiciendis molestiae quaerat molestias rerum.

Nulla consequatur et eius molestiae sunt consectetur et. Quos modi tenetur assumenda aspernatur. Atque rerum mollitia quaerat ab dolor rerum.

I'm an AI bot trained on the most helpful WSO content across 17+ years.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
GameTheory's picture
GameTheory
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
kanon's picture
kanon
98.9
9
Linda Abraham's picture
Linda Abraham
98.8
10
numi's picture
numi
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”