Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

BlueHorseshoe

How to Identify Last Trading Day of Month in EL?

Recommended Posts

I'm hoping that someone can help me out with EL code to identify the last trading day of the month as part of a strategy entry condition?

 

Any help would be greatly appreciated.

 

Bluehorseshoe

 

there is no direct keyword for such a function;

you have to build yourself a filter.

 

eg.


if month = jan
and date = 29
and day = fri
then last.trading.day = true;

Share this post


Link to post
Share on other sites
there is no direct keyword for such a function;

you have to build yourself a filter.

 

Hi Tams,

 

Thanks for your reply. Your suggestion is what I had attempted to do (in a very clunky and inelegant fashion!). I found it very difficult to incorporate weekend dates into a filter. I'm not convinced that my solution below works - can you see any obvious issues with it?

 


variables:
m(0),
count(0),
dom(0),
sess(0),
buywindow(false);

sess=CurrentSession(0);
If sess<>sess[1] then begin
m=month(d);
if m<>m[1] then
count=1
Else count=count+1;
dom=dayofmonth(d);
End;

If dayofweek(date)<4 then
BuyWindow = 	(m=1 and dom=31) or 
		(m=2 and dom=28) or 
		(m=3 and dom=31) or 
		(m=4 and dom=30) or 
		(m=5 and dom=31) or 
		(m=6 and dom=30) or 
		(m=7 and dom=31) or 
		(m=8 and dom=31) or 
		(m=9 and dom=30) or 
		(m=10 and dom=31) or 
		(m=11 and dom=30) or 
		(m=12 and dom=31);

If dayofweek(date)=4 then
BuyWindow = 	((m=1 and dom=31) or (m=1 and dom=30)) or 
		((m=2 and dom=28) or (m=2 and dom=27)) or 
		((m=3 and dom=31) or (m=3 and dom=30)) or 
		((m=4 and dom=30) or (m=4 and dom=29)) or 
		((m=5 and dom=31) or (m=5 and dom=30)) or 
		((m=6 and dom=30) or (m=6 and dom=29)) or
		((m=7 and dom=31) or (m=7 and dom=30)) or 
		((m=8 and dom=31) or (m=8 and dom=30)) or
		((m=9 and dom=30) or (m=9 and dom=29)) or
		((m=10 and dom=31) or (m=10 and dom=30)) or
		((m=11 and dom=30) or (m=11 and dom=29)) or
		((m=12 and dom=31) or (m=12 and dom=30));

If dayofweek(date)=5 then
BuyWindow = 	((m=1 and dom=31) or (m=1 and dom=30) or (m=1 and dom=29)) or 
		((m=2 and dom=28) or (m=2 and dom=27) or (m=2 and dom=28)) or 
		((m=3 and dom=31) or (m=3 and dom=30) or (m=3 and dom=29)) or 
		((m=4 and dom=30) or (m=4 and dom=29) or (m=4 and dom=29)) or 
		((m=5 and dom=31) or (m=5 and dom=30) or (m=5 and dom=29)) or 
		((m=6 and dom=30) or (m=6 and dom=29) or (m=6 and dom=28)) or
		((m=7 and dom=31) or (m=7 and dom=30) or (m=7 and dom=29)) or 
		((m=8 and dom=31) or (m=8 and dom=30) or (m=8 and dom=29)) or
		((m=9 and dom=30) or (m=9 and dom=29) or (m=8 and dom=28)) or
		((m=10 and dom=31) or (m=10 and dom=30) or (m=10 and dom=29)) or
		((m=11 and dom=30) or (m=11 and dom=29) or (m=11 and dom=28)) or
		((m=12 and dom=31) or (m=12 and dom=30) or (m=12 and dom=29));


If (BuyWindow or DayofMonth(date)=1) then
Buy this bar;

Share this post


Link to post
Share on other sites

another idea

 

month31 = jan or mar or may or jul or aug or oct or dec;

if month31 = true
and day = fri 
and date >= 29
then last.trading.day = true;

Share this post


Link to post
Share on other sites

What bar interval are you using? What is the symbol? Is the symbol day session only or does it include a night session?

 

I'm hoping that someone can help me out with EL code to identify the last trading day of the month as part of a strategy entry condition?

 

Any help would be greatly appreciated.

 

Bluehorseshoe

Share this post


Link to post
Share on other sites
What bar interval are you using? What is the symbol? Is the symbol day session only or does it include a night session?

 

Hi Onesmith,

 

The strategy is for trading the ES contract, though I generally test such things against other closely correlated instruments (ES.D, Spiders, YM, Big S&P, Diamonds, NQ etc) as a measure of robustness. In other words, I would expect it to have a positive expectancy regardless of whether the Globex session were included in the testing.

 

It aims to take advantage of the 'window dressing' that is common around the end/start of the month, and therefore provides for long entries only. The entry is made intraday once other conditions have been met (in addition to the end of month condition that I am struggling to code).

Share this post


Link to post
Share on other sites
Very simple:

 

vars: lastTradingDay(false);
lastTradingDay = false;
If month(date of next bar) <> month(date) then begin
lastTradingDay = true;
end;

 

well... smart idea, but not a well thought out solution.

 

What if the current bar is a Friday?

Share this post


Link to post
Share on other sites

With this is enougth. Works in intraday bar.

 

//Calculo de la sesion del mes

If time = 0005 and month(date) <> month(date[1]) then Sesion = 1

Else If time = 0005 then Sesion = Sesion[1] + 1

Else Sesion = Sesion[1];

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.