# Excel RANK a row of todays stock prices from last week's

January 14, 2012 at 17:33:27
Specs: Windows XP
 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

See More: Excel RANK a row of todays stock prices from last weeks

#1
January 14, 2012 at 19:41:44
 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/214078Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions