total points

Viewing 7 posts - 1 through 7 (of 7 total)
  • #222207

    after searching most of today I’m now resigned to asking for advise, I know I’ve found it here before.

    I’ve created about 5 different proscreeners which I’ve now written in 1, my question is how do I allocate a numeric value to each depending on it’s reliability and add them all together.

    For instance on the attached I would say EXS2 and RSBBS2 and then DAS3 are the most reliable. What I want to do is allocated each condition a numeric value which can be added together if conditions are met. So say EXS2 = 1 and RSBBS2 = 2 and then DAS3 =4 then if all conditions are met in proscreener it gives a result of 7, if the 1st 2 conditions are met it gives a result of 3, individual conditions being met give their own allocated values.

    I’m not 100% sure but I believe a saw a proscreener which gave a “TP” result column.

    Many thanks in anticipation.

     

     

     

     

    #222209
    JS

    Hi,

    You can try this…

    If EXS2 then

    EXS2=1

    EndIf

    If RSBBS2 then

    RSBBS2=2

    EndIf

    If DAS3 then

    DAS3=4

    EndIf

    Total =(EXS2 + RSBBS2 + DAS3 + … + … + ….)

    Screener[Total](Total as “Total”)

    #222212

    Hi RS

    Sadly not the result I was looking for, the Proscreener (see attached) delivered 228 instruments and each came to a total of 3131 (basically all conditions were met). If I run the same code with RSI as the citeria only 10 instruments are delivered.

    #222214
    JS

    Hi,

    When I give the 10 conditions all a value of 1 and I screen for US stocks, I get 1 stock with 4 points, a lot of stocks with 3 points, etc…

    #222245
    #222250

    Thank you JS, that works a treat, can’t thank you enough.

    1 user thanked author for this post.
    avatar JS
    #222251

    Thank you for responding and your input robertogozzi, I shall be saving this thread.

    1 user thanked author for this post.
Viewing 7 posts - 1 through 7 (of 7 total)

Create your free account now and post your request to benefit from the help of the community
Register or Login