Discussions
»
Product and Service Development
»
Formula Assistance
»
Hoping this is a simple adjustment to existing OBV formula
Rank: Newbie
Groups: Registered, Registered Users Joined: 5/27/2012(UTC) Posts: 1
|
Hi, my apologizes if this is a simple fix but I'm new to MS so still learning the ropes. At the moment OBV formula is:
Cum(If( C is greater than Ref(C,-1), +V,
If( C is less than Ref(C,-1), -V, 0) ))
I just want to make a slight adjustment to this so that if Close = Previous Period Close, then rather leave cumulative value unchanged as in original OBV formula, I want to instead use the same output value as previous period, whether it is +V or -V.
For example if I was looking at a set of candles where the 2nd candle closed higher than the 1st candle then change to cumulative value will be +V. If subsequent 3rd, 4th and 5th candle closing prices remained unchanged, I want change to cumulative value to then be +V, +V, +V. If the 6th candle closed lower than the 5th candle then change to cumulative value will then be -V. If 7th candle closed lower or was equal to 6th candle then value will still be -V, otherwise +V.
Thanks!
|
|
|
|
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)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
Hoping this is a simple adjustment to existing OBV formula
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.