|
PureBytes Links
Trading Reference Links
|
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);
------------------------ 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/
|