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.

# 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

##### Share on other sites
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

```

##### 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),

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));

```

##### Share on other sites

keep plugging, you are on the right track

##### 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

```

##### 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 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 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

```

Now why didn't I think of that? Thanks!

##### Share on other sites

Very simple:

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

##### Share on other sites
Very simple:

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

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

What if the current bar is a Friday?

##### 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];

## 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.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

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

×

• 0
• 0
• 2
• 4
• 0
• ### Posts

• \$MSFT Microsoft stock top of range breakout above 433.1, https://stockconsultant.com/?MSFT
• \$AMZN stock just another breakout, https://stockconsultant.com/?AMZN
• \$AAPL wow, mega move off the 167.75 lower support area , https://stockconsultant.com/?AAPL
• \$SILK Road Medical stock breakout watch above 19.45 , see https://stockconsultant.com/?SILK
×
×
• Create New...