Error

 Previous Topic Next Topic
 flavio_meta #1 Posted : Friday, October 27, 2023 12:22:00 PM(UTC) Rank: NewbieGroups: Registered, Registered Users, SubscribersJoined: 10/4/2023(UTC)Posts: 6 Hello, I need to ‘freeze’ a higher low LLV1 (see screen shot attached) for example 40 periods ago and then compare it to a lower low LLV3 today. What happens is that LLV1 moves down to LLV3 and they are equal at point (3) so I cannot calculate the difference. Any idea how to ‘freeze’ LLV1? Edited by user Friday, October 27, 2023 12:28:59 PM(UTC)  | Reason: Not specified
 Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
 MS Support #2 Posted : Monday, October 30, 2023 3:01:57 PM(UTC) Rank: Advanced MemberGroups: Moderators, Registered, Registered Users, SubscribersJoined: 10/8/2010(UTC)Posts: 1,943Thanks: 86 timesWas thanked: 155 time(s) in 150 post(s) Originally Posted by: flavio_meta Hello, I need to ‘freeze’ a higher low LLV1 (see screen shot attached) for example 40 periods ago and then compare it to a lower low LLV3 today. What happens is that LLV1 moves down to LLV3 and they are equal at point (3) so I cannot calculate the difference. Any idea how to ‘freeze’ LLV1? Generally speaking the indicators will change as new data comes in. There are ways you can combine functions to identify more specific data points, such as ValueWhen and REF, but it would probably be helpful to see the formula you are attempting to use to make your comparison in order to give a suggestion that would make the most sense for your situation.
 flavio_meta #3 Posted : Monday, October 30, 2023 5:28:47 PM(UTC) Rank: NewbieGroups: Registered, Registered Users, SubscribersJoined: 10/4/2023(UTC)Posts: 6 The formula is pretty simple VVL(...,40), and '...' could be anything e.g. CLOSE. I have uploaded a chart for better illustration. The chart is attached but when I'll post it, it disappears. Where can I email that chart to? With 'Ref' one data point is possible only. Right? With 'ValueWhen' one data point in the past is possible only. Right? >>> What I need though is a range from e.g. -40 periods in the past with VVL and keeps going until today, even if there is a lower low. Thanks for your answer.
 MS Support #4 Posted : Tuesday, October 31, 2023 3:21:36 PM(UTC) Rank: Advanced MemberGroups: Moderators, Registered, Registered Users, SubscribersJoined: 10/8/2010(UTC)Posts: 1,943Thanks: 86 timesWas thanked: 155 time(s) in 150 post(s) Originally Posted by: flavio_meta The formula is pretty simple VVL(...,40), and '...' could be anything e.g. CLOSE. I have uploaded a chart for better illustration. The chart is attached but when I'll post it, it disappears. Where can I email that chart to? With 'Ref' one data point is possible only. Right? With 'ValueWhen' one data point in the past is possible only. Right? >>> What I need though is a range from e.g. -40 periods in the past with VVL and keeps going until today, even if there is a lower low. Thanks for your answer. Thank you, I have a better idea of what you are asking. Unfortunately the point to 'freeze' is somewhat arbitrary without some other qualifying criteria, i.e. the lowest low since a specific date. So the relevant question would be, "How do I decide (via a formula) which lowest low to keep and which to ignore?"You can use ValueWhen to look for a Lowest Low from a specific date using the DayOfMonth, Month, and Year functions but that obviously makes that part of the formula very specific and it would not work for other dates. For example: Code:``ValueWhen(1,Month()=6 AND DayOfMonth()=15,LLV(L,40))``
 flavio_meta #5 Posted : Tuesday, October 31, 2023 6:30:47 PM(UTC) Rank: NewbieGroups: Registered, Registered Users, SubscribersJoined: 10/4/2023(UTC)Posts: 6 Thanks a lot for your answer. :-)   It is a nice workaround, and it does the job, by moving the original function into the future. 'ValueWhen' is not just for a specific day and rigid, but can also be used on a rolling basis, if used in this way: ValueWhen(20 , Month() , LLV(L,40)); 20 in this example shifts the function 19 periods into the future. Edited by user Tuesday, October 31, 2023 6:31:34 PM(UTC)  | Reason: Not specified
 kkrishna79 #6 Posted : Saturday, April 6, 2024 3:02:55 AM(UTC) Rank: MemberGroups: Registered, Registered Users, Unverified UsersJoined: 1/31/2009(UTC)Posts: 18Location: MumbaiThanks: 2 times Originally Posted by: flavio_meta Thanks a lot for your answer. :-)   It is a nice workaround, and it does the job, by moving the original function into the future. 'ValueWhen' is not just for a specific day and rigid, but can also be used on a rolling basis, if used in this way: ValueWhen(20 , Month() , LLV(L,40)); 20 in this example shifts the function 19 periods into the future. Sir,How can i get the highest high of  monday, tuesday & wednesday (of all weeek)lowest low of monday, tuesday & wednesday (of all week)Please helpThank youKrisna
 kkrishna79 #7 Posted : Saturday, April 6, 2024 3:04:16 AM(UTC) Rank: MemberGroups: Registered, Registered Users, Unverified UsersJoined: 1/31/2009(UTC)Posts: 18Location: MumbaiThanks: 2 times Originally Posted by: MS Support Originally Posted by: flavio_meta The formula is pretty simple VVL(...,40), and '...' could be anything e.g. CLOSE. I have uploaded a chart for better illustration. The chart is attached but when I'll post it, it disappears. Where can I email that chart to? With 'Ref' one data point is possible only. Right? With 'ValueWhen' one data point in the past is possible only. Right? >>> What I need though is a range from e.g. -40 periods in the past with VVL and keeps going until today, even if there is a lower low. Thanks for your answer. Thank you, I have a better idea of what you are asking. Unfortunately the point to 'freeze' is somewhat arbitrary without some other qualifying criteria, i.e. the lowest low since a specific date. So the relevant question would be, "How do I decide (via a formula) which lowest low to keep and which to ignore?"You can use ValueWhen to look for a Lowest Low from a specific date using the DayOfMonth, Month, and Year functions but that obviously makes that part of the formula very specific and it would not work for other dates. For example: Code:``ValueWhen(1,Month()=6 AND DayOfMonth()=15,LLV(L,40))`` Sir,How can i get thehighest high of  monday, tuesday & wednesday (of all weeek)lowest low of monday, tuesday & wednesday (of all week)Please helpThank youKrisna
 MS Support #8 Posted : Monday, April 8, 2024 4:01:15 PM(UTC) Rank: Advanced MemberGroups: Moderators, Registered, Registered Users, SubscribersJoined: 10/8/2010(UTC)Posts: 1,943Thanks: 86 timesWas thanked: 155 time(s) in 150 post(s) Originally Posted by: kkrishna79 Originally Posted by: MS Support Originally Posted by: flavio_meta The formula is pretty simple VVL(...,40), and '...' could be anything e.g. CLOSE. I have uploaded a chart for better illustration. The chart is attached but when I'll post it, it disappears. Where can I email that chart to? With 'Ref' one data point is possible only. Right? With 'ValueWhen' one data point in the past is possible only. Right? >>> What I need though is a range from e.g. -40 periods in the past with VVL and keeps going until today, even if there is a lower low. Thanks for your answer. Thank you, I have a better idea of what you are asking. Unfortunately the point to 'freeze' is somewhat arbitrary without some other qualifying criteria, i.e. the lowest low since a specific date. So the relevant question would be, "How do I decide (via a formula) which lowest low to keep and which to ignore?"You can use ValueWhen to look for a Lowest Low from a specific date using the DayOfMonth, Month, and Year functions but that obviously makes that part of the formula very specific and it would not work for other dates. For example: Code:``ValueWhen(1,Month()=6 AND DayOfMonth()=15,LLV(L,40))`` Sir,How can i get thehighest high of  monday, tuesday & wednesday (of all weeek)lowest low of monday, tuesday & wednesday (of all week)Please helpThank youKrisna Hello,Are you looking to identify the Highest value of a particular day of the week? You could try the following formula and see if it accomplishes what you are looking to do. You can of course modify the DayOfWeek() function for each day you want to do this for (1=Monday, 2=Tuesday, etc).Code:``Highest(ValueWhen(1,DayOfWeek()=1,H))``
 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.