Trades in Weekly scale seem to be executed on Fridays
Author: RickTg
Creation Date: 11/9/2015 6:10 PM
profile picture

RickTg

#1
I do not know if this is the correct place to post this but here it goes.

I have just realized after looking at the trades after running a backtest that is in a scale of weekly that all trades seem to be executed on Fridays. In reality, if a security meets the criteria for purchase on A friday, it will be purchased at the open or a specified price or better on the following Monday. This discovery leads me to believe that all of my backtests are invalid.

I have searched the forum but have not been able to find a solution. After thinking about the problem, I think that if I run the strategy in a daily scale but do my processing on the last trading day of the week, my trades will be executed on the first trading day of the following week. But, I do not know how to determine the last bar of the trading week.

I do not know if this whole issue is a non problem but it has me bothered that I can not find an explanation or a solution. Please help me either find a solution in the forum by pointing me to the correct place or by explaining how I might overcome this problem.

Thanks

Rick
profile picture

Eugene

#2
The weekly bar completes on Friday. If your system triggers an AtClose[bar] order, it will be executed this Friday. If the order was AtLimit/Stop/Market[bar+1], it will be executed on the next bar: Monday on the open (AtMarket) or any day during the next week for AtStop/Limit.

However, since with Weekly data it's not (easily) possible to determine the actual order execution date, in the Entry Date column the next Friday's date is printed. I think this is what has confused you: the next Weekly bar's close date in the Entry Date column. This does not mean that your order was executed on the next Friday. This is a non-issue.
profile picture

Cone

#3
Maybe it would be more helpful for you to discuss a specific example. Create a small script, post it, pick a symbol and scale, and describe what you see... then we'll be able to tell you precisely why it should be that way.
profile picture

RickTg

#4
Thank you for those answers. As long as my Buy/Sell at Market/Limit are actually executed on Monday, then you are correct - this is a non issue.
profile picture

Eugene

#5
Right. The Limit/Stop order execution date may fall on any day of the week; Monday is for AtMarket only.
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).