How to chart security indices?

  • Thread starter Thread starter Marcus Leon
  • Start date Start date
M

Marcus Leon

Hi, I have four columns each containing values for different stock
securities. I would like to chart these columns in a line chart with a
line for each column. But I would like to chart the index value as
opposed to the actual value. Does anyone know how to do this?

By index value I mean (1 + ((CurrVal - StartVal) / StartVal) * 1000)
where 1000 is the base index value.

Or if anyone knows of a more clever approach to measuring percent price
changes please let me know.

Thanks!
 
Marcus -

Assuming your dates are in column A and your stock prices in B:E, you would put
formulas in columns F:I to compute the indexes for these stocks. Now select the data
in columns A and F:I (hold CTRL to add another area to the first), and run the chart
wizard.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top