Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 64
Location: India
|
hi
pls help me write this formula.
i want
maximum of highs in last 30 days.
and same way
minimum of lows in last 30 days.
also it will be better if the no. of days i can use can be input function.
actually i want the values for pivot so looking for all this.
also can i have that formula with input function in explorer, i know input is not supported in explorer but first create in indicator and then thru fml function with default value 30. what u say. i am waiting pls get me answer fast.
thanks
Navneet singhal
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
if it is the max. price over the last 30 days use
HHV(,H,30)
and for low
LLV(L,30)
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 64
Location: India
|
its not what i wanted. pls see this and check on u r version.
hhv(h,30)
and
llv(l,30)
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
I am sure I misunderstood the question.
hhv(h,30) gives you the highest high over the previous 30 days.
can you restate the question
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Please repost your question I did notunderstand it either :eek:
Maybe this?
Sum(H>ref(H,-1),30)
Patrick :mrgreen:
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 64
Location: India
|
hi patrick sir,
the question is like this.
for pivot of monthly i want high value of the month. that's it
simplify it , highest value of a stock in last one month.
thanks in advance
Navneet singhal
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
What a bout something simple like :
ValueWhen(1,Roc(Month(),1,$)<>0,HighestSince(2,Roc(Month(),1,$)<>0,H))
Patrick :mrgreen:
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Sorry did you want last month's high or thecurrent month highest high?
Anyways also try:
HighestSince(1,Roc(Month(),1,$)<>0,H)
Patrick :mrgreen:
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Maybe wait for this month's programming contest to be over and get the results...
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
plot this... is this what you want?
{previous months high low}
mth1:=If((Month()=Ref(Month(),-1)+1) OR
(Ref(Month(),-1)-Month()=11),1,0);
H1:=HighestSince(1,mth1=1,H);
H2 := If((Ref(Month(),-1)<Month()) OR
(Ref(Month(),-1)-Month()=11),Ref(H1,-1),0);
H3 := HighestSince(1,(H2<>0),H2);
H3;
L1:=LowestSince(1,mth1=1,L);
L2 := If((Ref(Month(),-1)<Month()) OR
(Ref(Month(),-1)-Month()=11),Ref(L1,-1),0);
L3 := HighestSince(1,(L2<>0),L2);
L3
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 64
Location: India
|
Hi patrick sir
u said this one will work. yes it works but the same answer is much easy by following these steps
go to explorer and choose col a as high and then filter anything like c>1 to cover entire markets adn then in options select month as exploration periodicity.
HighestSince(1,Roc(Month(),1,$)<>0,H)
i am also getting the same values that u got by this formula.
but the problem is that this month is december and just 14 days have passsed so it is taking into consideration this month as month that is only 14 days data, but i am looking for 30 days data. that is 30 days including todays date. and see the high of these 30 days and low of these 30 days. i hope u understood my question now well. i am waiitng for answer, which i know u have as i have learn whatever i know from u and u r videos and formnmula primer only but still i am way behind from being and expert. so pls guide me.
thanks
Navneet singhal
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
happysingh wrote: but i am looking for 30 days data. that is 30 days including todays date.
Well then JohnL's answer was correct : hhV(h,30) ...
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 64
Location: India
|
hi
the problem i feel is hhv(h,30) is taking data of last 30 periods of trading days ignoring saturdays and sundays.
and i am looking for high between 15th nov 2005 to 14th dec 2005.
now any answers to solve this please
Thanks for such quick reply and consideration of my problem.
Navneet singhal
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
You will have to program it manually each time ... The date range function in the ForumDll might help speed it up but you have to write something like:
Date:=Month()=11 and dayofmonth()=15 and year()=2005;
HighestSince(1,Date,H)
Patrick :mrgreen:
|
|
|
|
|
|
| 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.
