How are FORMAT column options used with the SCREENER function ?

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • 11/17/2021 at 10:46 AM #181729 quote
    bobt
    Participant
    Average

    Hi,

    I’m doing some work with a screener where I’d ideally like to output text instead of simply returning a number ( from documentation I believe only numbers can be displayed in columns returned by screeners).

    However, looking at the function list, when looking up “SCREENER”, I also see DATEFORMAT, NUMBERFORMAT, PERCENTFORMAT and STRINGFORMAT options that can be used for displaying column results.

     

    I can’t find these options documented  – are they new ? How are they used ? and do they hint at move to being able to display text in columns returned by SCREENER ?

    Grateful for any info you can provide ……

    11/23/2021 at 7:15 PM #182150 quote
    robertogozzi
    Moderator
    Master

    I never heard about those keywords, they must be something in the pipeline that might be added in a future version.

    11/24/2021 at 9:34 AM #182188 quote
    bobt
    Participant
    Average

    Roberto,

     

    Many thanks for the reply.

    OK, I’ll just have to keep an eye on new releases then – returning text would be amazingly useful for screeners ……

     

    Regards,

    Bob

    12/07/2021 at 10:45 AM #182922 quote
    erike
    Participant
    Junior

    I also have the same need as Bob and saw the keyword (future). See attached file.
    Before this is implemented, is there a way to solve this by code?

    -Erik

    dateformat.png dateformat.png
    12/07/2021 at 3:34 PM #182950 quote
    robertogozzi
    Moderator
    Master

    No, a specific instruction is needed.

    12/07/2021 at 4:35 PM #182956 quote
    Nicolas
    Keymaster
    Master

    Hey guys, here is how it works with this new way of displaying numbers in the sorting criteria column:

    SCREENER(DATE as “DATE” DATEFORMAT) => 10 mai 2021
    SCREENER(DATE as “DATE” STRINGFORMAT) => 20210510
    SCREENER(DATE as “DATE” NUMBERFORMAT) => 20,2M
    SCREENER(DATE as “DATE” PERCENTFORMAT) => 2021051000%

    bobt thanked this post
    12/08/2021 at 11:10 AM #182998 quote
    bobt
    Participant
    Average

    Many thanks Nicolas, that helps clarify things – I’ll give that a try.

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.

How are FORMAT column options used with the SCREENER function ?


ProScreener: Market Scanners & Detection

New Reply
Author
author-avatar
bobt @bobt Participant
Summary

This topic contains 6 replies,
has 4 voices, and was last updated by bobt
4 years, 3 months ago.

Topic Details
Forum: ProScreener: Market Scanners & Detection
Language: English
Started: 11/17/2021
Status: Active
Attachments: 1 files
Logo Logo
Loading...
Do you like cookies? 🍪 We use cookies to ensure you get the best experience on our website. (Learn more)
©2026 ProRealCode - Trading & Coding with ProRealTime™