On Mon, 20 Mar 2006 13:31:26 -0600, Wild Nerd
wrote:


Thanks Richard for taking the time to address my problem.

If A1:A40 are my dates. A1 is yesterday and A40 is 40 business days
ago.
and B1:B40 are the closing prices for those dates.

A 2-day Average is simply =average(B1:B2), a 5-day is =Average(B1:B5)

I am a trader who wants to be long if the shorter average is above the
longer average and short if the shorter average is below the longer
average. Let's say I currently own a stock. I want my Excel worksheet
to tell me during the current day, what price needs to trade today to
put the short avg below the long avg? Eventually, that day's data
will be placed into cell B1 after B1-B40 is Ctrl C, arrow down, CTRL
V'd.

OK, Thanks,

I just need to understand what you mean by shorter average and longer
average - in terms of the data in your original post. I'm also not
quite clear how your data results in the Less Than and Greater Than
results your OP suggests.

e.g. in the first column for the 2 day moving average (row 1 576.5 -
what are these values incidentally, how are they calculated?), the
moving avg of 576.375 is less than the number in the first column,
however on the second row, the 579 3 day moving avg is more than the
576.38 in the first column. Yet your OP marks these both as 'Less
Than'.

Your OP talked about the moving averages 'crossing each other. Could
you just expand on that please, again with ref to your original data.

I think the Solver Add-in is probably needed for a solution here, but
I just need to fully understand your data first.

Sorry for being a bit wooden about this.

Rgds


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________