View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dallman Ross Dallman Ross is offline
external usenet poster
 
Posts: 390
Default 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