[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Metastockusers] Re: Calculations between two specific dates. How ???



PureBytes Links

Trading Reference Links

Alex,
The reason of identifying the two highs and two lows is for you to 
give an "if" condition, and plot only what two lines you want.
For example, if the high of the first date is lower than the high of 
the second date, or vice versa.
To terminate the line, you would have to use the syntax 
Bp:=LastValue(<date condition>);
Line:= <condition>
Line:=Ref(Ref(Line,-Bp),Bp); {blank end of line}

Try it yourself.

Dusant
--- In Metastockusers@xxxxxxxxxxxxxxx, "alui_98" <alui_98@xxxx> wrote:
> Sorry, I don't think I was very clear in my original description. 
So, 
> let me clarify a bit.  What I really want is to identify the 
> highest/lowest prices that occurred in between the start and end 
> dates, not necessarily the highs/lows of those 2 dates.  Then, I'd 
> like to draw 2 horizontal lines (at the highest/lowest prices) that 
> extends only from the start date to the end date (i.e. not across 
the 
> entire chart).   Not sure if this is doable in Metastock ...
> 
> Thanks again,
> -Alex
> 
> 
> --- In Metastockusers@xxxxxxxxxxxxxxx, "Dusant" <cooldush@xxxx> 
wrote:
> > Apart from what I had given earlier, you could just add this:
> > min(Lo1,Lo2);
> > max(Hi1,Hi2);
> > That would give you the lowest and highest values plotted as a 
> > horizontal line
> > Dusant
> > --- In Metastockusers@xxxxxxxxxxxxxxx, "alui_98" <alui_98@xxxx> 
> wrote:
> > > Dusant,
> > > 
> > > As a slight extension of this thread, I was wondering if you 
know 
> of 
> > > a way to automatically draw a horizontal line in Metastock.  
> > > Basically, I would input a start date and end date, and then 
have 
> > the 
> > > indicator draw 2 horizontal lines using the highest/lowest 
prices 
> > > between these 2 dates, respectively.
> > > 
> > > Thanks,
> > > -Alex
> > > 
> > > --- In Metastockusers@xxxxxxxxxxxxxxx, "Dusant" <cooldush@xxxx> 
> > wrote:
> > > > John,
> > > > 
> > > > {First Date}
> > > > D1:=Input("1 Date",010100,123199,010101);
> > > > {Second Date}
> > > > D2:=Input("2 Date",010100,123199,010101);
> > > > {Reducing Dates to day of year}
> > > > Dt1:= If(Month()=(Int(D1/10000)) AND DayOfMonth()=(Int(D1/100)
> > > > -((Int(D1/10000))*100)) AND Year()=(If(Mod(D1,100)>30,1900+Mod
> > > (D1,100)
> > > > ,2000+Mod(D1,100))),1,0);
> > > > Dt2:= If(Month()=(Int(D2/10000)) AND DayOfMonth()=(Int(D2/100)
> > > > -((Int(D2/10000))*100)) AND Year()=(If(Mod(D2,100)>30,1900+Mod
> > > (D2,100)
> > > > ,2000+Mod(D2,100))),1,0);
> > > > {Assigning values}
> > > > Hi1:= ValueWhen(1,Dt1=1,H);
> > > > Lo1:= ValueWhen(1,Dt1=1,L);
> > > > Hi2:= ValueWhen(1,Dt2=1,H);
> > > > Lo2:= ValueWhen(1,Dt2=1,L);
> > > > {Plotting Values}
> > > > Hi1; Lo1; Hi2; Lo2;
> > > > 
> > > > I have ver 6.52 and it is not capable of realtime. Therefore, 
I 
> > > cannot 
> > > > help you on that score. However, the logic will be the same. 
> There 
> > > are 
> > > > several posts earlier to pinpoint a particular time, so do a 
> > little 
> > > > homework.
> > > > 
> > > > Dusant
> > > > 
> > > > --- In Metastockusers@xxxxxxxxxxxxxxx, "johnm_milton" 
> > > <johnm_milton@xx
> > > > ..> wrote:
> > > > > 
> > > > > Dear Dusant,
> > > > > 
> > > > > I thank you very much for your prompt help, but there is 
> > > something I 
> > > > > don't understand.
> > > > > What you sent me seems an indicator formula or a new 
function 
> > > that 
> > > > > could return me the value (close, high, low) I need. Is it 
> > > exact ? 
> > > > > What is <your value>  , probably Close or High or low ? 
> > > > > I tried to build it but it seems without results.
> > > > > 
> > > > > What I need is to build an Explorer where to list the value 
> of 
> > > two 
> > > > > dates (or moments for intraday charts) and the differences 
> > > between 
> > > > > them.
> > > > > Please forgive my limits and help me again.
> > > > > Sincerely 
> > > > > 
> > > > > John
> > > > > 
> > > > > --- In Metastockusers@xxxxxxxxxxxxxxx, "Dusant" 
> <cooldush@xxxx> 
> > > > wrote:
> > > > > > John,
> > > > > > To pinpoint two dates:
> > > > > > day1:= Input("Enter First Date - 
> mmddyy",010100,123199,010101)
> > ;
> > > > > > m1:= Int(day1/10000);
> > > > > > d1:= Int(day1/100) - (m1*100) ;
> > > > > > y1:= If(Mod(day1,100)>30, 1900+Mod(day1,100), 2000+Mod
> > > (day1,100));
> > > > > > 
> > > > > > day2:= Input("Enter Second Date - mmddyy",010100,123199,
> > 010101);
> > > > > > m2:= Int(day2/10000);
> > > > > > d2:= Int(day2/100) - (m2*100) ;
> > > > > > y2:= If(Mod(day2,100)>30, 1900+Mod(day2,100), 2000+Mod
> > > (day2,100));
> > > > > > 
> > > > > > val1:= ValueWhen( 1, Month() = m1 AND DayOfMonth() = d1 
AND 
> > Year
> > > () 
> > > > > = 
> > > > > > y1, <your value> );
> > > > > > val2:= ValueWhen( 1, Month() = m2 AND DayOfMonth() = d2 
AND 
> > Year
> > > () 
> > > > > = 
> > > > > > y2, <your value> );
> > > > > > 
> > > > > > Dusant
> > > > > > 
> > > > > > --- In Metastockusers@xxxxxxxxxxxxxxx, "johnm_milton" 
> > > > > <johnm_milton@xx
> > > > > > ..> wrote:
> > > > > > > Dear friends,
> > > > > > > I have a question. (hoping my english is good enough)
> > > > > > > I want to develop a simple  explorer wich will indicate 
> the 
> > > > > percent  
> > > > > > > variations between two specific dates (or dates + 
minutes 
> > for 
> > > > > > > intraday data) for a list of equities.
> > > > > > > Now using the valuewhen function the difficulty is that 
I 
> > > have 
> > > > to 
> > > > > > > calculate the number of days (or group of minutes for 
> > > intraday 
> > > > > data)
> > > > > > > from the last value. Another difficulty is that not all 
> the 
> > > > > equities 
> > > > > > > are updated at the same time so the last value is not 
the 
> > > same 
> > > > > for 
> > > > > > > all the equities in the list.
> > > > > > > I wonder if there is a function which allows this; I 
mean 
> > > simply 
> > > > > > > indicating dd+mm+yy+minute for starting and end of 
> > > calculation.
> > > > > > > 
> > > > > > > I thank you in advance for your help.
> > > > > > > John


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/zMEolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
Metastockusers-unsubscribe@xxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/