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.
JSParticipant
Veteran
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”)
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.
JSParticipant
Veteran
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…
Thank you JS, that works a treat, can’t thank you enough.
Thank you for responding and your input robertogozzi, I shall be saving this thread.