Multi dimensional value investing strategy

[siukingyiu]

I am trying to create a multidimensional value investing strategy on Excel.

For example:
For a one-dimensional factor like P/E, I rank all FTSE 100 stocks from the lowest P/E to the highest P/E, and then divide into 5 separate quintiles to get my portfolios - supposedly the most under-valued to the most over-valued. Assuming P/E ratio does work in identifying undervalued stocks.

Does anyhow know how I can produce a similar back-test, but with 2 factors instead, such as P/E ratio and dividend yield, on Excel?
i.e. Ranking the Ftse 100 stocks based on low(increasing) P/E ratios and high(decreasing) dividend yields.

Please bare with me as I get more ambitious.
What if this same strategy is implemented with 3 or more factors?
-P/E, P/Book value, Dividend yields, P/Cash flow, etc

Anyone has any idea?

 

[cr6196]

RANK function

 

[Retribution]

You should use a stock screener

The idea is good, but many of the proposed principes of value investing no longer hold. There is a multitude of stocks laying around, so you should screen thoroughly and have high standards.

For example you could construct a model that:
* Checks for 52wk change%
* 5yr Rev/Net growth
* P/E
* P/tangible book
Then look into recent news and annual reports.

There are many viable sets of fundamental buy/sell indicators.

 

[jamezz34]

Can I just say, PE ratio is meaningless when you compare companies in totally different sectors with each other. Its apples and oranges.

Compare like for like. You need look at a company's PE ratio in relation to its peers.

Utilities will generally have lower PE ratios in relation to Internet and Software companies but from that you cannot deduce that Utilities are undervalued, must look at the sector average in each

 

[jamezz34]

that also goes for dividend yield too. look at the historical for the company (if any) and look at peer comparison