Rank: Newbie
Groups: Registered, Registered Users Joined: 7/10/2005(UTC) Posts: 5
|
ROC(OBV(),20,%)
This formula works in an Indicator but in The Explorer returns stranges values.
Why?
|
|
|
|
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)
|
... sort of the same question as, "Why couldn't Eric ride a bike"
Because he was a fish.
What do you mean by strange results?
Can you quantify strange?
Do you you have a screen capture showing the strange-ity?
Have you looked in the help section for a possible answer?
We need more info if you want an answer....
wabbit :D
|
|
|
|
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 cassianoqs,
Wabbit is right, we need more info but my guess would be your exploration load options. Make sure you do not have "load minimum records" selected ...
Patrick :mrgreen:
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users Joined: 7/10/2005(UTC) Posts: 5
|
an example (Load 500 Records is selected.):
indicator: 8.02246
explorer: 277.6089
I changed to load 5000 Records and now:
indicator: 8.02246
explorer: 8.0225
How many records should be loaded to run this formula in The Explorer?
ROC(OBV(),20,%)
|
|
|
|
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)
|
I know it does not make sense but please try the same tests with :
ROC(OBV(),20,$)
Are the results correct then?
Patrick :mrgreen:
PS: What version of Metastock ?
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users Joined: 7/10/2005(UTC) Posts: 5
|
Hi Patrick,
I use Metastock version 9.0
ROC(OBV(),20,$)
Results the same : 5772600.0000
(500 or 5000 records loaded)
What about % ?
ROC(OBV(),20,%)
shouldn't be equal
ROC(OBV(),20,$) * 100 / OBV() ?
ROC(OBV(),20,%) = 8.02246
ROC(OBV(),20,$) * 100 / OBV() = 7.4267
|
|
|
|
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)
|
I'm guesing the % function is messed up ...
I would make sure that ROC(OBV,1,$) give the right value and then once this is confirmed use your formula :
ROC(OBV(),20,$) * 100 / OBV()
You could also compare it to this :
((OBV()-Ref(OBV(),-20))*100)/OBV()
I will test it in 9.1 ...
Patrick :mrgreen:
|
|
|
|
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.