Rank: Member
Groups: Registered, Registered Users
Joined: 8/11/2013(UTC)
Posts: 24
Location: MUMBAI
Was thanked: 1 time(s) in 1 post(s)
|
Hello I want to have volume of last 100 bars to be more than 100000 on each bar. I do not wish to have average volume i.e mov(v,100,s)>100000 as this may create wrong picture as one day huge spike in volume may create average volume picture. I want to have each of the last 100 bars volume to be more than 100000 ... Request the forum to guide. Thanks in advance.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
Originally Posted by: PROFIT306  Hello I want to have volume of last 100 bars to be more than 100000 on each bar. I do not wish to have average volume i.e mov(v,100,s)>100000 as this may create wrong picture as one day huge spike in volume may create average volume picture. I want to have each of the last 100 bars volume to be more than 100000 ... Request the forum to guide. Thanks in advance.
Hello, I believe the Sum function would help with this. For example:
In this case, whenever Volume is greater than 100000 it returns a 1 value. We are summing this conditional value over 100 periods and stating that this value must equal 100, indicating the condition is true for all 100 periods.
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 8/11/2013(UTC)
Posts: 24
Location: MUMBAI
Was thanked: 1 time(s) in 1 post(s)
|
Hello Many thanks.
Originally Posted by: MS Support Originally Posted by: PROFIT306
Hello I want to have volume of last 100 bars to be more than 100000 on each bar. I do not wish to have average volume i.e mov(v,100,s)>100000 as this may create wrong picture as one day huge spike in volume may create average volume picture. I want to have each of the last 100 bars volume to be more than 100000 ... Request the forum to guide. Thanks in advance.
Hello, I believe the Sum function would help with this. For example:
In this case, whenever Volume is greater than 100000 it returns a 1 value. We are summing this conditional value over 100 periods and stating that this value must equal 100, indicating the condition is true for all 100 periods.
|
|
|
|
|
|
| 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.
