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+1 576.25
=+AD42+1 584.25
=+AD43+1 587.75
=+AD44+1 584.5
=+AD45+1 589.25
=+AD46+1 587.75
=+AD47+1 584
=+AD48+1 590
=+AD49+1 600.5
=+AD50+1 606
=+AD51+1 604
=+AD52+1 591
=+AD53+1 594
=+AD54+1 593
=+AD55+1 590.25
=+AD56+1 584.75
=+AD57+1 586.5
=+AD58+1 601
=+AD59+1 614.5
=+AD60+1 604.25
=+AD61+1 599
=+AD62+1 596
=+AD63+1 597.75
=+AD64+1 596
=+AD65+1 601.75
=+AD66+1 591.25
=+AD67+1 588
=+AD68+1 607.5
=+AD69+1 596.75
=+AD70+1 592.25
=+AD71+1 606.75
=+AD72+1 609.5
=+AD73+1 599.75
=+AD74+1 584.5
=+AD75+1 578
=+AD76+1 581
=+AD77+1 585
=+AD78+1 577.75
=+AD79+1 574.75
=+AD80+1 574.75
=+AD81+1 580.75


--
Wild Nerd
------------------------------------------------------------------------
Wild Nerd's Profile: http://www.excelforum.com/member.php...o&userid=32633
View this thread: http://www.excelforum.com/showthread...hreadid=524434