Can’t get specific date on screener to work

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

Author

Posts
01/20/2021 at 12:39 AM #158599 quote
cc267
Participant

Average
I want to use a specific date in my screener. My understanding is, I need to create a “date” indicator myself in probuilder to work as a variable in a screener?

so i went into probuilder and my syntax is:
```
idate = Date
RETURN Date/100000
```
Its divided by 100000 as it doesn’t seem to display correctly on the chart. I have attached screenshot of the chart.

I have produced simple screener below to illustrate date issue as i’m clearly not doing something correct here as the screener is blank.
```
indicator1 = CALL "idate"
c1 = (indicator1 = 202.10104)
indicator2 = ADX[14]
c2 = (indicator2 < 60)

criteria = Volume

SCREENER[c1 AND c2] (criteria AS "Volume")
```
01/20/2021 at 1:02 AM #158602 quote

robertogozzi
Moderator

Legend

That seems correct. Try eliminating line 1 from the indicator.

01/20/2021 at 1:29 AM #158605 quote

cc267
Participant

Average

Deleted line 1 on the indicator but the screener is still showing no stocks.

01/20/2021 at 5:17 AM #158613 quote
robertogozzi
Moderator

Legend
Is that date the current date?

Because screeners can only screen live.

Or try replacing the last line with:
```
SCREENER[summation[20](c1 AND c2)] (criteria AS "Volume")
```
So that you check conditions for all days in 2021.
01/20/2021 at 2:29 PM #158681 quote

cc267
Participant

Average

I’ve changed the last line to what you suggested but it still brings up nothing.

I was under the impression from previous threads that you could scan on a specific day? https://www.prorealcode.com/topic/scan-on-specific-date/

Do you know why the indicator shows the date with several decimals instead of the format its suppose to (YYYYMMDD)? I found a thread where someone else also said the date is not showing how it should? https://www.prorealcode.com/topic/date-in-proscreener-is-displayed-as-20-2m/ Is this a glitch with the software?

01/20/2021 at 2:47 PM #158684 quote

robertogozzi
Moderator

Legend

You shouldn’t use division, because it may be displayed by the indicator as, say, 20M, but it’s kept internally as a complete number, so it won’t affect expressions.

It’s not a real glitch, simply date & time data type are not supported.

I think you should try removing the division and compare the returned value with a complete date such as 20210104.

01/20/2021 at 3:07 PM #158687 quote

cc267
Participant

Average

This is what I get without the division (see screenshot), it reverts to two decimals. So when i enter a date in screener as YYYMMDD it doesn’t recognise it.

01/21/2021 at 12:45 PM #158819 quote

Vonasi
Moderator

Master

cc267 wrote:

(see screenshot),

What screenshot? There is nothing attached.

01/21/2021 at 3:00 PM #158831 quote

cc267
Participant

Average

I click select file and can see the picture attached but then when i submit nothing is showing up?

01/21/2021 at 6:34 PM #158850 quote
robertogozzi
Moderator

Legend
This is the indicator:
```
return Date
```
This is the screener:
```
MyDate     = CALL "MyIndicatorDATE"
c1         = (MyDate = 20210104)
indicator2 = ADX[14]
c2         = (indicator2 < 60)
criteria   = Volume
SCREENER[summation[22](c1 AND c2)] (criteria AS "Volume")
```
they work.

MyIndicatorDATE.itf DATEscreener.itf DATEscreener-pic.jpg
01/21/2021 at 7:46 PM #158858 quote

cc267
Participant

Average

Thankyou Roberto! This works perfectly now, thanks for all your help.
Author

Posts