software

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.--
Wild Nerd
------------------------------------------------------------------------
Wild Nerd's Profile: www.excelforum.com/member.php...oamp;userid=32633
View this thread: www.excelforum.com/showthread...hreadid=524434On Mon, 20 Mar 2006 10:36:43 -0600, Wild Nerd
gt; wrote:

gt;
gt;I have a column of numbers in which I created 2 different Moving Average
gt;time frames.
gt;
gt;Now I want to know:
gt;
gt;How to write the formula:
gt;
gt;What number is needed today for the moving averages to cross each
gt;other? For instance, if a shorter moving average is 108 and a longer
gt;one is 123, What number is needed today for the shorter average to be
gt;larger than the longer average? Keep in mind, I have to drop the
gt;oldest time frame price.

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

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________


576.50576.3750 2-Day M Avg.Less Than
576.38579.0000 3-Day M Avg.Less Than
581.19581.8500 5-Day M Avg.Less Than
583.08583.7500 7-Day M Avg.Less Than
587.89589.2292 12-Day M Avg.Greater Than
589.63589.4583 18-Day M Avg.Greater Than
593.35593.4667 30-Day M Avg.Greater Than
592.78592.3313 40-Day M Avg.Greater Than1576.50
2576.25
3584.25
4587.75
5584.50
6589.25
7587.75
8584.00
9590.00
10600.50
11606.00
12604.00
13591.00
14594.00
15593.00
16590.25
17584.75
18586.50
19601.00
20614.50
21604.25
22599.00
23596.00
24597.75
25596.00
26601.75
27591.25
28588.00
29607.50
30596.75
31592.25
32606.75
33609.50
34599.75
35584.50
36578.00
37581.00
38585.00
39577.75
40574.75--
Wild Nerd
------------------------------------------------------------------------
Wild Nerd's Profile: www.excelforum.com/member.php...oamp;userid=32633
View this thread: www.excelforum.com/showthread...hreadid=524434I assume A1:A40 is your data. How do the numbers at the top relate to
the data? i.e. what are the 8 rows and how do they relate to the data
rows?

What for instance do the two summary columns of numbers mean and what
are you trying to achieve in columns C amp; D

RgdsOn Mon, 20 Mar 2006 12:23:28 -0600, Wild Nerd
gt; wrote:

gt;
gt;576.50576.3750 2-Day M Avg.Less Than
gt;576.38579.0000 3-Day M Avg.Less Than
gt;581.19581.8500 5-Day M Avg.Less Than
gt;583.08583.7500 7-Day M Avg.Less Than
gt;587.89589.2292 12-Day M Avg.Greater Than
gt;589.63589.4583 18-Day M Avg.Greater Than
gt;593.35593.4667 30-Day M Avg.Greater Than
gt;592.78592.3313 40-Day M Avg.Greater Than
gt;
gt;
gt;1576.50
gt;2576.25
gt;3584.25
gt;4587.75
gt;5584.50
gt;6589.25
gt;7587.75
gt;8584.00
gt;9590.00
gt;10600.50
gt;11606.00
gt;12604.00
gt;13591.00
gt;14594.00
gt;15593.00
gt;16590.25
gt;17584.75
gt;18586.50
gt;19601.00
gt;20614.50
gt;21604.25
gt;22599.00
gt;23596.00
gt;24597.75
gt;25596.00
gt;26601.75
gt;27591.25
gt;28588.00
gt;29607.50
gt;30596.75
gt;31592.25
gt;32606.75
gt;33609.50
gt;34599.75
gt;35584.50
gt;36578.00
gt;37581.00
gt;38585.00
gt;39577.75
gt;40574.75

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________


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.--
Wild Nerd
------------------------------------------------------------------------
Wild Nerd's Profile: www.excelforum.com/member.php...oamp;userid=32633
View this thread: www.excelforum.com/showthread...hreadid=524434On Mon, 20 Mar 2006 13:31:26 -0600, Wild Nerd
gt; wrote:

gt;
gt;Thanks Richard for taking the time to address my problem.
gt;
gt;If A1:A40 are my dates. A1 is yesterday and A40 is 40 business days
gt;ago.
gt;and B1:B40 are the closing prices for those dates.
gt;
gt;A 2-day Average is simply =average(B1:B2), a 5-day is =Average(B1:B5)
gt;
gt;I am a trader who wants to be long if the shorter average is above the
gt;longer average and short if the shorter average is below the longer
gt;average. Let's say I currently own a stock. I want my Excel worksheet
gt;to tell me during the current day, what price needs to trade today to
gt;put the short avg below the long avg? Eventually, that day's data
gt;will be placed into cell B1 after B1-B40 is Ctrl C, arrow down, CTRL
gt;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
__________________________


Richard,
In the OP, the price 576.5 is the closing price for Soybeans at the
Chicago Board of Trade. I currently plug in these prices(column AE)
daily.

These are the actual formulas in the spreadsheet. Does this make
better sense?

=AVERAGE(AE41:AE42)-- (Shorter Avg(2-Day))
=AVERAGE(AE41:AE43)-- (Shorter Avg(3-Day))
=AVERAGE(AE41:AE45)-- (Shorter Avg(5-Day))
=AVERAGE(AE41:AE47)-- (Shorter Avg(7-Day))
=AVERAGE(AE41:AE52)-- (Longer Avg(12-Day))
=AVERAGE(AE41:AE58)-- (Longer Avg(18-Day))
=AVERAGE(AE41:AE70)-- (Longer Avg(30-Day))
=AVERAGE(AE41:AE80)-- (Longer Avg(40-Day))

AD AE
1 576.5
= AD41 1576.25
= AD42 1584.25
= AD43 1587.75
= AD44 1584.5
= AD45 1589.25
= AD46 1587.75
= AD47 1584
= AD48 1590
= AD49 1600.5
= AD50 1606
= AD51 1604
= AD52 1591
= AD53 1594
= AD54 1593
= AD55 1590.25
= AD56 1584.75
= AD57 1586.5
= AD58 1601
= AD59 1614.5
= AD60 1604.25
= AD61 1599
= AD62 1596
= AD63 1597.75
= AD64 1596
= AD65 1601.75
= AD66 1591.25
= AD67 1588
= AD68 1607.5
= AD69 1596.75
= AD70 1592.25
= AD71 1606.75
= AD72 1609.5
= AD73 1599.75
= AD74 1584.5
= AD75 1578
= AD76 1581
= AD77 1585
= AD78 1577.75
= AD79 1574.75
= AD80 1574.75
= AD81 1580.75--
Wild Nerd
------------------------------------------------------------------------
Wild Nerd's Profile: www.excelforum.com/member.php...oamp;userid=32633
View this thread: www.excelforum.com/showthread...hreadid=524434