[EquisMetaStock Group] Re: Is there a way to display date in explorer report ?

["Jose Silva" <josesilva22@xxxxxxxxx>]

Try this for dmmyy/ddmmyy date value exploration outputs:

==================
Column B: dd/mm/yy
==================
---8<-------------

event:=RSI(14)>30;

{ Perhaps more useful: }
event:=Cross(RSI(14),30);

y:=ValueWhen(1,event,Year());
y:=If(y<2000,y-1900,y-2000);
m:=ValueWhen(1,event,Month())*100;
d:=ValueWhen(1,event,DayOfMonth())*10000;

y+m+d

---8<-------------


Or for yymmdd/ymmdd format:

=================
Column B: y/mm/dd
=================
---8<-------------

event:=RSI(14)>30;

{ Perhaps more useful: }
event:=Cross(RSI(14),30);

y:=ValueWhen(1,event,Year());
y:=If(y<2000,y-1900,y-2000)*10000;
m:=ValueWhen(1,event,Month())*100;
d:=ValueWhen(1,event,DayOfMonth());

y+m+d

---8<-------------

Full year date formats such as yyyymmdd produce rounding-off 
calculation errors in MetaStock.


jose '-)
http://www.metastocktools.com



--- In equismetastock@xxxxxxxxxxxxxxx, "Safdar" <Safdar@xxxx> wrote:
>
> Hello
> Suppose I want to run an exploration 
> cola
> barssince(rsi(14)<30)
> 
> Now is it possible to display in colb the date of the bar where
> rsi(14) >30?
> 
> Thanks







------------------------ Yahoo! Groups Sponsor --------------------~--> 
Try Online Currency Trading with GFT. Free 50K Demo. Trade 
24 Hours. Commission-Free. 
http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/BefplB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

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