Error

 Previous Topic Next Topic
 PROFIT306 #1 Posted : Tuesday, February 14, 2023 5:00:02 AM(UTC) Rank: MemberGroups: Registered, Registered UsersJoined: 8/11/2013(UTC)Posts: 22Location: MUMBAIWas thanked: 1 time(s) in 1 post(s) HelloI 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.
 Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
 MS Support #2 Posted : Tuesday, February 14, 2023 4:07:19 PM(UTC) Rank: Advanced MemberGroups: Moderators, Registered, Registered Users, SubscribersJoined: 10/8/2010(UTC)Posts: 1,918Thanks: 84 timesWas thanked: 152 time(s) in 148 post(s) Originally Posted by: PROFIT306 HelloI 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) Rank: MemberGroups: Registered, Registered UsersJoined: 8/11/2013(UTC)Posts: 22Location: MUMBAIWas thanked: 1 time(s) in 1 post(s) HelloMany thanks. Originally Posted by: MS Support Originally Posted by: PROFIT306 HelloI 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.