logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
chewyboot  
#1 Posted : Sunday, May 27, 2012 9:23:22 AM(UTC)
chewyboot

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!
wabbit  
#2 Posted : Sunday, May 27, 2012 6:25:20 PM(UTC)
wabbit

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.