End of week scanning and screening

Viewing 5 posts - 1 through 5 (of 5 total)

Author

Posts
10/14/2022 at 5:56 AM #202510 quote
OllieB
Participant

Junior
Hi,

I’d like to do a lot of my scans on a weekend. However, my current screeners use the weekly timeframe and when i use the basic price functions (high, low, close) the return values seem to refer the prior week. Example, if i run my scans tomorrow (15-Oct-22) the data seems to be for the week before this one (the week beginning 3-Oct-22). Yet if i run the scans on a Monday the return data seems to refer to the current/live week.

Can anyone help me please with understadning:
1. When does the week close, is it Friday at 10pm or the following Monday’s open?
2. How I can program my screeners to run at a weekend to use the data of the 5 trading days before?
Any advice at all would be appreciated as i find the weekly very scanning very frustrating!

Thanks.
10/14/2022 at 10:53 PM #202588 quote

JS
Participant

Master

Hi @OllieB

When I use a weekly time frame, I get these prices:

Open is the price of Sunday 23:00 (IG opens with me on Sunday 23:00)

Close is the price of Friday 22:00 (IG closes with me on Friday 22:00)

High is the highest price of the week (between Sunday 23:00 and Friday 22:00)

Low is the lowest price of the week (between Sunday 23:00 and Friday 22:00)

10/15/2022 at 6:42 AM #202590 quote

JS
Participant

Master

So, I think the best time to screen, with a weekly timeframe, is between Friday 22:00 and Sunday 23:00.

You then have the “complete” prices of the past week.

10/15/2022 at 1:14 PM #202596 quote

OllieB
Participant

Junior

Hi JS, Thanks for taking the time to reply. I’ll do some checks this weekend but I am pretty sure if i do my weekly scan now (Saturday afternoon) I’ll get the results for the week prior to the 1 that’s just happened. Its as if PRT considers the weekend part of the live trading week and only returns values for closed weeks. I’ll post a bit more once i have some data one way or the other!

11/27/2022 at 9:47 AM #204884 quote
OllieB
Participant

Junior
Hi all, OK, i am narrowing in on the problem:
- If i use a daily timeframe and scan at a weekend then the returned results seem OK.
- But if i use a weekly timeframe and scan at a weekend then the returned results are not OK.
When using the weekly all results seem to reference the prior week. Eg, today is Sunday the 27th November. If i do a simple close[0] on an instrument i get the value for the week ending 20th November, not the value right now (which is nearly all cases would be 9 or 10pm Friday 25th November). Any ideas please?
Author

Posts