Simple test seems to run on wrong period

• 01/08/2018 at 5:01 AM #57661
  David R

  Hi all,

   

  I’ve got another problem I can’t seem to solve.  I have searched the forums, the PRT screener manual and Google but haven’t found an answer.   I have written the most simple of codes, but am not getting what I expect.  As a part of a larger screener, I am wanting to confirm that the most recent day was an up day, i.e. that the price rose.  I like to test each element of my screener as I build it, so wrote and ran the following on the “Australian Market” list in PRT.

  Was yesterday an

  c1 = close > open screener [c1]

  1 2 3

  c1 = close > open   screener [c1]

   

  When I run this, I get shares that were up and shares that were down on the last candle (Friday last week) but all results seem to have an up candle on Thursday last week.  Is there a reason this would be running like this?  Is it to do with using the free version with end of day data or is there something wrong with the code?

   

  Apologies if it is a dumb question and thanks in advance to anybody who can explain what I’m doing wrong.

   

  Thanks,

  David

   

  

  David R

  Participant

  Topics: 3

  Replies: 9

  Been thanked: 0 times
  01/08/2018 at 5:12 AM #57663
  Nobody

  to be clear are you looking for stocks that closed green  or stocks that just closed above open for there is a difference ?  A stock can close above open and still be a down day

  Possibly this is what you require

  c1 = (close > close[1]) SCREENER[c1] (Variation AS "%Chg prev bar")

  1 2 3 4

  c1 = (close > close[1])     SCREENER[c1] (Variation AS "%Chg prev bar")

   

  

  Nobody

  Participant

  Topics: 9

  Replies: 192

  Been thanked: 59 times
  01/08/2018 at 5:25 AM #57664
  David R

  Hi Brisvegas, I was just looking for a green candle.  I would guess that I’d need to do something like

   

  Checking today is up on yesterday

  c1 = close > close[1] screener [c1]

  1 2 3

  c1 = close > close[1]   screener [c1]

  to have an “up day” compared to yesterday.   I just ran that code and it didn’t seem to work either.    Anyway, I’ve attached an example of a chart that I get from the code in my first post if that helps.

  

  David R

  Participant

  Topics: 3

  Replies: 9

  Been thanked: 0 times
  01/08/2018 at 10:17 AM #57674
  Vonasi

  Have you tried using DCLOSE and DOPOEN rather than CLOSE?

  1 user thanked author for this post.

  David R

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  01/08/2018 at 11:03 AM #57679
  David R

  Thanks Vonasi,

   

  DOpen(0) and DClose(0) worked.

   

  I’d still like to know why Open and Close didn’t work as I’m on daily charts.  Maybe one of those features of coding you need to know to get things working in PRT 🙂

   

  I guess I’ll use DOpen, DHigh, DLow and DClose in all of my screener coding from now on.

   

   

  

  David R

  Participant

  Topics: 3

  Replies: 9

  Been thanked: 0 times
  01/08/2018 at 11:37 AM #57686
  Nicolas

  David R wrote:

  I’d still like to know why Open and Close didn’t work as I’m on daily charts

  Because you are scanning with an ‘End Of Day’ account?

  1 user thanked author for this post.

  David R

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  01/08/2018 at 11:40 AM #57688
  Vonasi

  Are you interested in whether yesterday was a green day or whether today is currently a green day? I think ProScreener looks at the current still forming candle to make decisions which is why

  close > open

  1	close > open

  does not work if you are interested in yesterday’s candle.

  close(1) > open(1)

  1	close(1) > open(1)

  does work for that or you can get the same result with

  DClose(1) > DOpen(1)

  1	DClose(1) > DOpen(1)

  I’m not big on ProScreener coding so someone else correct me if I’m wrong please.

  1 user thanked author for this post.

  David R

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  01/08/2018 at 12:10 PM #57693
  David R

  Thanks Nicolas and Vonasi,

   

  It may be because I am using an EOD account.  I would have thought close > open would deliver nothing if it needs to work on the current day data and I’m on EOD.  I ran a test on 20 stocks and it seemed to be looking at the day before yesterday but that could be a coincidence I guess if the program is somehow looking at current day data on an EOD acount.  Anyway, the use of DOpen, DClose etc seems to have at least given me a workaround.  I appreciate your time in considering my problem 🙂

   

  

  David R

  Participant

  Topics: 3

  Replies: 9

  Been thanked: 0 times
  01/08/2018 at 1:46 PM #57716
  Nicolas

  With an EOD account, the screener will always use the bar before the current one, so that is not a coincidence, but the normal behavior of this account type.

  1 user thanked author for this post.

  David R

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
• Author
  Posts