B
- Bobb -
I'm a tinkerer in Excel - I use it, as well as Money, to track my finances. I'm trying to use a trendline as they do on CNBC when
they review a stock chart and "buy" "sell" signals. If someone else has done this - a simple question: how to have the moving avg
trendline " current - up to today". ?
I have a weekly chart in my worksheet which shows 52 weekly columns (from another sheets info) with 3 trendlines - 2wk, 4wk and 7
week moving average of the data and it works ok except that since they all start on Jan 1, of course the 7 week is "7 weeks behind
the current data" as is the 4 and 2. Yet I see on financial shows when they show moving averages, they are "up to date", not
trailing - that defeats the whole purpose, so: Now that I have a 52 week history, how to have the trendlines "apply to the PAST 2 ,
4 and 7 weeks rather than always trailing by that amount ?" Is it as simple as reversing the order for the series ( $BE$1: $i$1
etc)? mathematically , is that right in Excel ? I thought that I would, but I couldn't find a box to check to choose the order of
the moving average.
The formula I currently have for the series is:
=SERIES("Weekly Moving Average",'Portfolio'!$I$1:$BE$1,'Portfolio'!$I$26:$BE$26,1)
and for the averages I have 3 trendlines:
Type = moving average , period = 2 , 4 and 7 week . order = 2 (that's greyed out)
Thanks very much.
Bobb
they review a stock chart and "buy" "sell" signals. If someone else has done this - a simple question: how to have the moving avg
trendline " current - up to today". ?
I have a weekly chart in my worksheet which shows 52 weekly columns (from another sheets info) with 3 trendlines - 2wk, 4wk and 7
week moving average of the data and it works ok except that since they all start on Jan 1, of course the 7 week is "7 weeks behind
the current data" as is the 4 and 2. Yet I see on financial shows when they show moving averages, they are "up to date", not
trailing - that defeats the whole purpose, so: Now that I have a 52 week history, how to have the trendlines "apply to the PAST 2 ,
4 and 7 weeks rather than always trailing by that amount ?" Is it as simple as reversing the order for the series ( $BE$1: $i$1
etc)? mathematically , is that right in Excel ? I thought that I would, but I couldn't find a box to check to choose the order of
the moving average.
The formula I currently have for the series is:
=SERIES("Weekly Moving Average",'Portfolio'!$I$1:$BE$1,'Portfolio'!$I$26:$BE$26,1)
and for the averages I have 3 trendlines:
Type = moving average , period = 2 , 4 and 7 week . order = 2 (that's greyed out)
Thanks very much.
Bobb