[amibroker] Re: Exploration Help Needed

["pakaypakay" <pakaypakay@xxxxxxxxx>]

Thanks Graham.  I was able to get the DateTime() function to work for 
me.  I only wanted the time info, but at least the format is correct 
this way.

--- In amibroker@xxxxxxxxxxxxxxx, Graham <kavemanperth@xxxx> wrote:
>
> try changing the time format in your computer, I think AB uses this.
> then use datetime() in your explorations
> 
> On 11/2/05, pakaypakay <pakaypakay@xxxx> wrote:
> > I am trying to create an Exploration to map out when intraday 
highs
> > and lows occur throughout each day.  I would like to export the
> > results to Excel, but I can't get the TimeNum() column to display 
in
> > the proper format of hh:mm:ss for Excel.  If you run the 
exploration
> > below, you will notice that the Text Column I added to do this 
does
> > not show the correct time, although it is correctly displayed in 
the
> > interpretation window.  Any help is appreciated.
> >
> > Thank you,
> > pakay
> >
> >
> > //Exploration to find the intraday high and low at various times
> > throughout the day.
> >
> > DayHi = HighestSince(TimeNum()==093300, High, 0);
> > DayHiTimeBars = HighestSinceBars(TimeNum()==093300, High, 0);
> > DayHiTime = Ref(TimeNum(), -DayHiTimeBars);
> > _N(DayHiTimeStr = NumToStr(DayHiTime, 1, False));
> > _N(DayHiTimeStr2 = StrLeft(DayHiTimeStr, 2)+":"+StrMid
(DayHiTimeStr,
> > 2, 2));
> >
> > "\nDay High = "+DayHi+" at "+DayHiTimeStr2;
> >
> > DayLo = LowestSince(TimeNum()==093300, Low, 0);
> > DayLoTimeBars = LowestSinceBars(TimeNum()==093300, Low, 0);
> > DayLoTime = Ref(TimeNum(), -DayLoTimeBars);
> >
> >
> > Filter = TimeNum()==100000 OR TimeNum()==103300 OR TimeNum()
==120000
> > OR TimeNum()==150000 OR TimeNum()==161500;
> > AddColumn(DayHi, "DayHi");
> > AddColumn(DayHiTime, "DayHiTime", 6.0);
> > AddTextColumn(DayHiTimeStr2, "DayHiTime");
> > AddColumn(DayLo, "DayLo");
> > AddColumn(DayLoTime, "DayLoTime", 6.0);
> >
> >
> >
> >
> >
> >
> > Please note that this group is for discussion between users only.
> >
> > To get support from AmiBroker please send an e-mail directly to
> > SUPPORT {at} amibroker.com
> >
> > For other support material please check also:
> > http://www.amibroker.com/support.html
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> 
> 
> --
> Cheers
> Graham
> AB-Write >< Professional AFL Writing Service
> Yes, I write AFL code to your requirements
> http://e-wire.net.au/~eb_kavan/ab_write.htm
>







------------------------ 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/GHeqlB/TM
--------------------------------------------------------------------~-> 

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For other support material please check also:
http://www.amibroker.com/support.html

 
Yahoo! Groups Links

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

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

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