I need to calculate 20-day and 60-day relative strength figures for several columns of stock prices. They would be measured against a benchmark in first column.

Before I waste six months time recreating a mouse trap ... Is there anyone who can give me a few tips.

I assume you first have to calculate 20-day moving average for each column then calulate relative strength for each stock's moving average. Results should range from 1 to 99.

Thanks,

Harmony