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:
- When does the week close, is it Friday at 10pm or the following Monday’s open?
- 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.
JSParticipant
Veteran
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)
JSParticipant
Veteran
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.
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!
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?
