Hello,

I'm looking to create my own custom stock index with a few different securities. I have downloaded the daily Open, High, Low, Close and Volume for each of the stocks and have them in separate workbooks in the same spreadsheet.

I sum the total for each value across the workbooks in a summary workbook which I then use to draw a stock chart. I was wondering:

What would be the best way to normalize the data? In the current set up a $100 stock impacts the chart 4 times as much as the $25 stock and the results are skewed towards the activity of the larger issues.

If I eventually did want to weigh the components individually how would I go about it?

Any guidance is appreciated.

Thanks
-Bill