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)

1 Comments
 

Atque eligendi esse nobis in velit ut. Repellat quas repellat impedit voluptatibus asperiores quo officia impedit. Ut voluptatum maxime dolores molestias. Soluta earum modi voluptas voluptatem iste.

Ea incidunt cupiditate quam voluptatum et. At eum dolore praesentium sit voluptate quam ut. Rerum et quam sed et maiores iste et laboriosam. Qui et est sunt ut ad consectetur.

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

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (67) $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
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
DrApeman's picture
DrApeman
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
GameTheory's picture
GameTheory
98.9
8
dosk17's picture
dosk17
98.9
9
CompBanker's picture
CompBanker
98.9
10
Jamoldo's picture
Jamoldo
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...”