Row B = 30 Stock price's from 1-6-2012 (B1:B30)

Row C = 30 Stock prices from 1-13-2012 (the same row of issues/names) (C1:C30)

I think I have to subtract Row B from Row C's prices (to find the difference)

Problem: some stocks are $5 and others are $80. Do I make the weekly change a % change then rank the % change?

Then RANK the difference in % of weekly price change.

I'm trying to find the strongest stocks (list of 30) on a weekly % change basis.

Having trouble with the Excel formula.

Thanks! mrfracture

I'm not sure if it will help you get the results you want, but you might want to look up the PERCENTRANK formula in the Excel Help files. In any event, to see the formula used to determine the percent change between two numbers, read the information at this site:

http://support.microsoft.com/kb/214078

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History