Having trouble with my formula ideas today
Next of my questions while I work through some brainstorming today
is this:
I have (for stocks' daily historical data) a column of highs and a
column of lows. I want to know the standard deviation of the day's
range.
I know I can create a new column, e.g., "X", that contains each
day's range (high minus low). Then I could just do STDEV(X:X).
But I'd rather not create the column if I don't need to. Is there
an easy way to do this?
Thanks for more good insight from a great group.
--
dman
|