Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 10/28/2004(UTC)
Posts: 3
Location: Minnesota USA
|
I did search the forum for answers with no success. That includes searching the formulas.
I have MS 8.01 under Windows XP Professional. I have a programming background, but I'm very inexperienced in MS programming. I have also sought answers in the reference manual.
I believe that what I wish to do would be very easy for an experienced MS explorer user. I'd like to determine the average close for a stock for the period from 52 bars ago to 78 bars ago.
I expect that the answer to my simple problem will help me to accomplish other tasks with the explorer. So thanks in advance for w[censored]ver comes up with an answer or answers for me.
Rich in Minnesota USA
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Rich,
So what you are really looking for is a 78-52=26 bar simple moving average from 52 bars ago?
Ref(Mov(C,26,S),-52)
Hope this helps.
wabbit :D
49 days to go!
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 10/28/2004(UTC)
Posts: 3
Location: Minnesota USA
|
Ref(Mov(C,26,S),-52)
Great. Thanks a bunch. As an old programmer, I figured it might be elegantly simple, and you showed that indeed it is. I'll sure have to remember the simple power of REF. <G>
Rich in Minnesota USA
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
