Rank: Newbie
Groups: Registered, Registered Users
Joined: 7/25/2005(UTC)
Posts: 1
|
I have an unexpected error in my Explorer Report ... <<Filter reference to N/A value in Colum E>>. This makes little sense since Column E is DPO(30) ... and is viewable when I add the indicator to a chart.
I have MS version 8.01. Your help is appreciated.
-brian
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Hi,
Can you post the formula that is in your filter?
Patrick :mrgreen:
|
|
|
|
|
|
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)
|
When you plot the DPO on a chart, does the line show in the last 16 bars of your chart?
The answer should be no, because it states in the manual:
the Bible wrote:The calculation is quite simple; you simply center an x-period moving average by shifting it back x/2 + 1 periods. This centered moving average is then subtracted from the close. The result is an oscillator that crosses above and below zero.
Since the DPO is shifted back "x/2 + 1" periods, the last "x/2 + 1" periods will have no values..
... so always returns N/A in an exploration.
wabbit :D
[edited: cut and paste error]
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
| 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.
