Hi,
I have a table of daily stock prices/indicies for which I am trying to create a volatility chart. So, I am calculating the daily differences in prices as Today's price - Yesterday's price. These values I have stored in an array for eg. {=A2:A100 - A1:A99} My question is, can I directly graph this array? I'm trying to avoid entering these value in the sheet to keep the sheet neat enough to read.
Any help would be greatly appreciated.
Thanks,
IronPalm
I have a table of daily stock prices/indicies for which I am trying to create a volatility chart. So, I am calculating the daily differences in prices as Today's price - Yesterday's price. These values I have stored in an array for eg. {=A2:A100 - A1:A99} My question is, can I directly graph this array? I'm trying to avoid entering these value in the sheet to keep the sheet neat enough to read.
Any help would be greatly appreciated.
Thanks,
IronPalm