Bi-Weekly high low

[Srini85]

Hello, can someone help me by sharing the 15 day high low and close ( ignoring public holidays and weekends)

 

[SleepyZ]

Hello, can someone help me by sharing the 15 day high low and close ( ignoring public holidays and weekends)

See if this works:

input length   = 15;
input vertical = yes;
input label    = yes;

def basis = GetYYYYMMDD() != GetYYYYMMDD()[1];
def count = if !IsNaN(close) and basis then count[1] + 1 else count[1];
def day   = HighestAll(count) - count + 1;

def bn     = BarNumber();
def lastbn = if !IsNaN(close) and IsNaN(close[-1]) then bn else Double.NaN;

AddVerticalLine(if !vertical then Double.NaN else day[1] == length + 1 and day == length, "", Color.WHITE);

def h   = if bn == 1
          then Double.NaN
          else if day[1] == length + 1 and day == length
          then high
          else if day <= length and high > h[1]
          then high else h[1];
plot hh = if day > length
          then Double.NaN   
          else HighestAll(h);

def l   = if bn == 1
          then Double.NaN
          else if day[1] == length + 1 and day == length
          then low
          else if day <= length and low < l[1]
          then low else l[1];
plot ll = if day > length
          then Double.NaN   
          else LowestAll(l);

plot cc = if day > length then Double.NaN
          else HighestAll(if bn == HighestAll(lastbn)
                          then close else Double.NaN);
cc.SetDefaultColor(Color.WHITE);

AddLabel(label, "H: " + AsText(hh) + " | L: " + AsText(ll) + " | C: " + AsText(cc), Color.YELLOW);

#

 

[Kashkian]

See if this works:

Hi SleepyZ, can you please show the code for scanning the biweekly high and low?
I did as follow, but it did not produce spike at the high and low:
plot x= if ll is true then 1 else 0;
plot xx= if hh is true then1 else 0;

 

[SleepyZ]

Hi SleepyZ, can you please show the code for scanning the biweekly high and low?
I did as follow, but it did not produce spike at the high and low:
plot x= if ll is true then 1 else 0;
plot xx= if hh is true then1 else 0;

That code was made to display to the requestor where the hh/ll were and that the days were trading days. It used code that works on a chart but does not work in the scanner.

This should do work to find if the current day is the hh or ll in the last 14 days. Comment out the plot that you are not scanning when scanning for the other. Set scan to DAY.

Scan code

def lastbar = HighestAll( if IsNaN(close[-1]) and !IsNaN(close) then BarNumber() else Double.NaN);

def h = if IsNaN(close) then h[1] else if BarNumber() == lastbar - 14 then high else if BarNumber() > lastbar - 14 then Max(high, h[1]) else h[1];
#plot hh_scan = high == h;

def l = compoundValue(1, if IsNaN(close) then l[1] else if BarNumber() == lastbar - 14 then low else if BarNumber() > lastbar - 14 then Min(low, l[1]) else l[1], low);
plot ll_scan = low == l;

Chart code to verify scan

def lastbar = HighestAll( if IsNaN(close[-1]) and !IsNaN(close) then BarNumber() else Double.NaN);

def h = if IsNaN(close) then h[1] else if BarNumber() == lastbar - 14 + 1 then high else if BarNumber() > lastbar - 14 then Max(high, h[1]) else h[1];
plot hh = h;

def l = compoundValue(1, if IsNaN(close) then l[1] else if BarNumber() == lastbar - 14 + 1 then low else if BarNumber() > lastbar - 14 then Min(low, l[1]) else l[1], low);
plot ll = l;

 

[Kashkian]

That code was made to display to the requestor where the hh/ll were and that the days were trading days. It used code that works on a chart but does not work in the scanner.

This should do work to find if the current day is the hh or ll in the last 14 days. Comment out the plot that you are not scanning when scanning for the other. Set scan to DAY.

Scan code


Chart code to verify scan

Thanks SleepyZ!