Near or at High/Low of Day/Year question???

[evanevans]

I put the following code together. But I'm having problems getting it to work right. I'm putting it on a 1 minute chart. Is that the issue? How do you check for High of Year on a Minute chart? Any help?

(@Welkin my brother? )

# ChartAlert New High/Low of Year
# Evan Evans

input PCTnearHOY = 0.09;
input PCTnearLOY = 0.09;

def agg = AggregationPeriod.Day;

#def HOD = Highest(High(period = agg), 1);
def HOY = Highest(High(period = agg), 252);
#def LOD = Lowest(Low(period = agg), 1);
def LOY = Lowest(Low(period = agg), 252);

DefineGlobalColor("isHOY",Color.Green);
DefineGlobalColor("nearHOY",Color.Dark_Green);
DefineGlobalColor("nearLOY",Color.Dark_Red);
DefineGlobalColor("isLOY",Color.Red);
DefineGlobalColor("default",Color.Current);

AssignBackgroundColor(if Close >= HOY then GlobalColor("isHOY")
   else if Close >= (HOY*(1-PCTnearHOY)) then GlobalColor("nearHOY")
   else if Close <= LOY then GlobalColor("isLOY")
   else if Close <= (LOY*(1+PCTnearLOY)) then GlobalColor("nearLOY")
   else GlobalColor("default"));

 

[evanevans]

Ok, looks like I got it all worked out. Here's the latest code:

# ChartAlert New High/Low of Year
# Evan Evans
# August 31, 2020

input PCTnearHOY = 0.09;
input PCTnearLOY = 0.09;

def agg = AggregationPeriod.Day;

def HOD = Highest(High(period = agg), 1);
def HOY = Highest(High(period = agg), 252);
def LOD = Lowest(Low(period = agg), 1);
def LOY = Lowest(Low(period = agg), 252);

DefineGlobalColor("isHOY",CreateColor(0,30,80));
DefineGlobalColor("nearHOY",CreateColor(0,60,50));
DefineGlobalColor("nearLOY",CreateColor(50,60,00));
DefineGlobalColor("isLOY",CreateColor(80,30,0));
DefineGlobalColor("default",Color.Current);

AssignBackgroundColor(if Close >= (HOY*(1-PCTnearHOY)) and Close<HOY and HOD<>HOY then GlobalColor("nearHOY")
   else if HOD==HOY then GlobalColor("isHOY")
   else if LOD==LOY then GlobalColor("isLOY")
   else if Close <= (LOY*(1+PCTnearLOY)) and Close>LOY and LOD<>LOY then GlobalColor("nearLOY")
   else GlobalColor("default"));

 

[Welkin]

It appears to be correctly pulling the high and low values from the past 252 days on to the minute, however on the minute aggregation the values can be off from the daily if you show Extended Trading Hours, any highest highs or lowest lows made during ETH will be the values used. You cannot pull higher aggregation period data that is greater than 30 days (the max a 1min chart can be set to). So you could also use AggregationPeriod.MONTH with a Highest() length of 12, but AggregationPeriod.YEAR will not work.

 

[evanevans]

It appears to be correctly pulling the high and low values from the past 252 days on to the minute, however on the minute aggregation the values can be off from the daily if you show Extended Trading Hours, any highest highs or lowest lows made during ETH will be the values used. You cannot pull higher aggregation period data that is greater than 30 days (the max a 1min chart can be set to). So you could also use AggregationPeriod.MONTH with a Highest() length of 12, but AggregationPeriod.YEAR will not work.

Thanks that's a great workaround. Many thanks. I did not get a chance to test your alternative sentiments today. I was busy buildling a 3 screen 70 position monitoring setup. Pretty much dialed in now, so I might load 'er up tomorrow and twiddle with it. Hope you're doing good.

 

[Welkin]

Thanks that's a great workaround. Many thanks. I did not get a chance to test your alternative sentiments today. I was busy buildling a 3 screen 70 position monitoring setup. Pretty much dialed in now, so I might load 'er up tomorrow and twiddle with it. Hope you're doing good.

Doing fine, thanks for asking, and yea I haven't had much time to test it all either, mainly just put it together and threw it out into the wild Lol. will be messing around on globex with it tonight/through the rest of the week. You'll have to adjust some settings and tweak some things, as I just kind of used some random values that I thought would be appropriate but might not work in actual practice. some of the new sentiment stuff won't plot unless there is enough tick data, so if you see something not working try bumping up the tick aggregation a bit until it does.