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
 

Omnis a voluptatem recusandae voluptates odit. Est dicta quia omnis ab architecto. Qui iste impedit ut non eius quo. Vel aut earum doloremque. Qui ea eveniet dolorem eos minus quibusdam.

Ea dolorem earum mollitia fugit totam autem. Neque omnis officia eum vel. Dignissimos in tempore iure vel voluptates molestias.

Voluptate aut enim dolorem molestiae aperiam aspernatur eligendi. Vitae perferendis soluta eveniet quis non consequatur. Pariatur eius aliquam dolor.

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

Career Advancement Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Goldman Sachs 01 97.8%
  • Morgan Stanley 07 97.3%

Overall Employee Satisfaction

September 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 07 98.4%
  • Goldman Sachs 01 97.8%
  • JPMorgan No 97.3%

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (51) $260
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (26) $182
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
DrApeman's picture
DrApeman
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
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...”