|
PureBytes Links
Trading Reference Links
|
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@xxxxxxxxx> 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/
|