Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking at the list of companies in the S&P 500 Pure Value Index. For each firm, I want to obtain the dividend yield industry percentile rank and the PEG ratio industry percentile rank.

I've tried Google Finance and Morningstar. The process involves adding by hand specific industry stocks to a portfolio, exporting the data to excel, using percentrank.exc() and vlookup()... Doing this for 100+ stocks in 100+ industries is error prone and can take days.

Is there a faster, more accurate way of obtaining industry rank based on financial data? Does Bloomberg have this functionality?

share|improve this question
up vote 1 down vote accepted

You may get the S&P500 tickers and download the corresponding fields PEG, DivYield, Industry from Bloomberg into Excel.

Then you can just sort the values in excel once by industry and then by PEG to directly see the ranks. You may use two sheets for PEG and DivYield.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.