End of week scanning and screening

• 10/14/2022 at 5:56 AM #202510
  OllieB

  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.

  

  OllieB

  Participant

  Topics: 11

  Replies: 24

  Been thanked: 4 times
  10/14/2022 at 10:53 PM #202588
  JS

  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)

  

  JS

  Participant

  Topics: 27

  Replies: 1806

  Been thanked: 876 times
  10/15/2022 at 6:42 AM #202590
  JS

  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.

  

  JS

  Participant

  Topics: 27

  Replies: 1806

  Been thanked: 876 times
  10/15/2022 at 1:14 PM #202596
  OllieB

  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!

   

  

  OllieB

  Participant

  Topics: 11

  Replies: 24

  Been thanked: 4 times
  11/27/2022 at 9:47 AM #204884
  OllieB

  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?

  

  OllieB

  Participant

  Topics: 11

  Replies: 24

  Been thanked: 4 times
• Author
  Posts