Stunt
Diamond Member
- Jul 17, 2002
- 9,717
- 2
- 0
I want to keep this as brief as possible as this shouldn't be a difficult problem to solve, but I'm having a difficult time wrapping my head around it.
What I have done is used stock screeners to determine key valuation data for 500 of Canada's largest publicly traded companies. The following metrics have been ranked in 6 separate worksheets: price/earnings, price/sales, price/book, operating margin, profit margin, return on equity, and return on assets.
The companies with the lowest [price/earnings, price/sales, price/book] and highest [operating margin, profit margin, return on equity, and return on assets] are at the top of the list and continue down for all 500 companies.
Because this was a stock screener, the companies names are all identical, so if you search for company "Anandtech", the string will be consistent across all worksheets.
What I want to do is average, maybe even a weighted average for these rankings as usually companies with high return on capital have a high stock price. The goal will be to find the stocks with the lowest price for the highest profitability. I will then use this list, take the best names from each sector, do a little research/due diligence and hopefully make some money off them.
So how can I correlate these worksheets by company name.
Cheers and I look forward to your help, I know there are a lot of smart people on these forums!!
What I have done is used stock screeners to determine key valuation data for 500 of Canada's largest publicly traded companies. The following metrics have been ranked in 6 separate worksheets: price/earnings, price/sales, price/book, operating margin, profit margin, return on equity, and return on assets.
The companies with the lowest [price/earnings, price/sales, price/book] and highest [operating margin, profit margin, return on equity, and return on assets] are at the top of the list and continue down for all 500 companies.
Because this was a stock screener, the companies names are all identical, so if you search for company "Anandtech", the string will be consistent across all worksheets.
What I want to do is average, maybe even a weighted average for these rankings as usually companies with high return on capital have a high stock price. The goal will be to find the stocks with the lowest price for the highest profitability. I will then use this list, take the best names from each sector, do a little research/due diligence and hopefully make some money off them.
So how can I correlate these worksheets by company name.
Cheers and I look forward to your help, I know there are a lot of smart people on these forums!!
Facebook
Twitter