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
 

Consequatur dolor voluptates est autem. Quasi libero est provident totam qui consequatur sapiente. Dolor consequatur et quia. Id dolor est sed aut perspiciatis. Distinctio iusto laboriosam ea nobis eveniet. Autem qui molestiae distinctio.

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

Career Advancement Opportunities

July 2026 Investment Banking

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

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 01 98.3%
  • BMO Capital Markets 13 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $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
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
10
Mimbs's picture
Mimbs
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...”