How to mimic the Eikon TR.RecMedianLabel in Datastream using the RECMED value

Hi,

How do I mimic the Eikon TR.RecMedianLabel in Datastream using the RECMED value?

In Eikon, the logic used to determine the label is as per below:

A screenshot of a computerDescription automatically generated

In Datastream the logic used to determine the label:

1729228055421.png

Therefore, if DSWS returns a value of 4 for the field RECMED, based on the above translation, the label would be “UPRF”. In Eikon, the label would translate to “SELL”.

Does anyone know what logic I would need to use to mimic the Eikon label translation?

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @sam.macaluso

    Thank you for reaching out to us.

    According to the TR.RecLabel description, it uses:

    • 1 : Strong Buy
    • 2 : Buy
    • 3 : Hold
    • 4 : Sell
    • 5 : Strong Sell

    However, the RECTXT uses:

    1729489360069.png

    Thereofre, UPRF in Datastream is equal to Sell in Eikon while SELL in Datastream is equal to Strong Sell in Eikon.

    However, please contact the Datastream support team directly via MyAccount to confirm this.