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

Notification

Icon
Error

Options
Go to last post Go to first unread
PROFIT306  
#1 Posted : Tuesday, February 14, 2023 5:00:02 AM(UTC)
PROFIT306

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.

MS Support  
#2 Posted : Tuesday, February 14, 2023 4:07:19 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,927

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
Originally Posted by: PROFIT306 Go to Quoted Post

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:

Code:
Sum(V > 100000,100)=100

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.

PROFIT306  
#3 Posted : Wednesday, February 15, 2023 3:31:30 AM(UTC)
PROFIT306

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 Go to Quoted Post
Originally Posted by: PROFIT306 Go to Quoted Post

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:

Code:
Sum(V > 100000,100)=100

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
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.