|
PureBytes Links
Trading Reference Links
|
Markus,
Please note that Date column is included in each exploration
automatically
(first is ticker, second is date/ time)
Alternativelly you can use DateNum() function to display date
in YYYMMDD format
AddColumn( DateNum(), "YYYMMDD" );
or Day(), Month(), Year functions:
AddColumn( Year(), "year" );
AddColumn( Month(), "month" );
AddColumn( Day(), "day" );Best
regards,Tomasz Janeczkoamibroker.com
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
IVA GmbH
To: <A title=amibroker@xxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Monday, October 28, 2002 7:32
PM
Subject: Re: [amibroker] Please
help!!
Jayson,
thanks for your suggestion, but itīs still
somewhat crippled.
Maybe TJ can implement another AFL function. Iīll
go ahead and ask him.
Do you have a suggestion how I could find the
lowest value, for instance th lowest low, for bar number 100 and
150.
I messed around with llv and lowest but couldnīt
figure it out how to implement the cum function!!
Thanks a lot
Markus
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
<A title=jcasavant@xxxx
href="">Jayson
To: <A title=amibroker@xxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Monday, October 28, 2002 7:08
PM
Subject: RE: [amibroker] Please
help!!
<SPAN
class=517260218-28102002>Markus,
<SPAN
class=517260218-28102002>
<SPAN
class=517260218-28102002>Since you cannot use Date() in an exploration
perhaps you could live with....
<SPAN
class=517260218-28102002>
<SPAN
class=517260218-28102002>
AddColumn(<FONT
color=#0000ff>BarsSince(b <FONT
color=#000000>AND <FONT
color=#000000>C),<FONT
color=#ff00ff>"condition date"<FONT
color=#282828>);
the
alternative would be to use Datenum() but I find the format to be a bit
challenging as it is different then the usual 10/21/02 format
.
<SPAN
class=517260218-28102002>datenum would return this as 1021021 where 102 is
the year 2002 , 10 is the month and 21 the day.
not
what you want but perhaps something you can
adapt.....
Jayson
<FONT face=Tahoma
size=2>-----Original Message-----From: funnybiz@xxxx
[mailto:funnybiz@xxxx]Sent: Monday, October 28, 2002 9:43
AMTo: amibroker@xxxxxxxxxxxxxxxSubject: [amibroker]
Please help!!
Dear folks,
I have two questions regarding the code below, if
you care:
1./ I need to find out when a given condition
happens in relation to its bar number, i.e. I -letīs say- want to find out
where a condition happens closest to bar number 1000. Can I use the
iif-function with "true result" being a cum-fun function which has multiple
values.
2./ when I use this scan, I seem to get the
proper results in terms of the low value and bar number, but the date Iī,
given is always the last barīs date INSTEAD of the dateīs bar when the
conditon happens. How can I get the conditionīs bar date, please?
Sorry for my ignorance and the waste of your
time<g>.
Markus
- - - - - - - - - -
A=<FONT face="Courier New"
color=#0000ff>IIf<FONT face="Courier New"
color=#000000>(Low<<FONT face="Courier New"
color=#0000ff>Ref<FONT face="Courier New"
color=#000000>(Low,-<FONT face="Courier New"
color=#ff00ff>1),<FONT
face="Courier New" color=#0000ff>Cum<FONT face="Courier New"
color=#000000>(1<FONT
face="Courier New" color=#000000>),<FONT face="Courier New"
color=#ff00ff>0);
B=A<<FONT face="Courier New"
color=#ff00ff>1000;
C=A><FONT face="Courier New"
color=#ff00ff>0;
Filter=1<FONT
face="Courier New" color=#000000>;<FONT face="Courier New"
color=#0000ff>
AddColumn(<FONT
face="Courier New" color=#0000ff>Cum<FONT face="Courier New"
color=#000000>(1<FONT
face="Courier New" color=#000000>),<FONT face="Courier New"
color=#ff00ff>"total barnumber"<FONT face="Courier New"
color=#000000>,1.3<FONT
face="Courier New" color=#000000>);<FONT face="CourierNew"
color=#0000ff>
AddColumn(<FONT
face="Courier New" color=#0000ff>ValueWhen<FONT face="Courier New"
color=#000000>(B AND C,Low,<FONT
face="Courier New" color=#ff00ff>2<FONT face="Courier New"
color=#000000>),<FONT face="Courier New"
color=#ff00ff>"low"<FONT face="Courier New"
color=#000000>,1.3<FONT
face="Courier New" color=#000000>);<FONT face="CourierNew"
color=#0000ff>
AddColumn(<FONT
face="Courier New" color=#0000ff>ValueWhen<FONT face="Courier New"
color=#000000>(B AND C,<FONT face="Courier New"
color=#0000ff>Cum(<FONT
face="Courier New" color=#ff00ff>1<FONT face="Courier New"
color=#000000>),2<FONT
face="Courier New" color=#000000>),<FONT face="Courier New"
color=#ff00ff>"condition bar number"<FONT face="Courier New"
color=#000000>,1.3<FONT
face="Courier New" color=#000000>);<FONT
face="Courier New">Post AmiQuote-related messages
ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Post AmiQuote-related messages ONLY to:
amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
|