View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Buttrey
 
Posts: n/a
Default Moving Average projection?

On Mon, 20 Mar 2006 10:36:43 -0600, Wild Nerd
wrote:


I have a column of numbers in which I created 2 different Moving Average
time frames.

Now I want to know:

How to write the formula:

What number is needed today for the moving averages to cross each
other? For instance, if a shorter moving average is 108 and a longer
one is 123, What number is needed today for the shorter average to be
larger than the longer average? Keep in mind, I have to drop the
oldest time frame price.


Could you post some example data to help better understand your
requirement?

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________