|
PureBytes Links
Trading Reference Links
|
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<1000<FONT
face="Courier New" color=#000000>;
C=A>0<FONT
face="Courier New" color=#000000>;
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="Courier New"
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=#ff00ff>"low"<FONT face="Courier New"
color=#000000>,1.3<FONT
face="Courier New" color=#000000>);<FONT face="Courier New"
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">
|