What do I have to set in Refinitv-Excel so that Excel gives me a 0 as the value of the formula =RDP.

Best Answer

  • raksina.samasiri
    raksina.samasiri admin
    Answer ✓

    Hi @marcel.thaele ,

    In the formula builder's parameters tab, there's an option "Treat As Zero If Not Available" which after this is applied, the ZAV() will be applied in the Excel formula

    1690795391263.png

    The formula is

    =@RDP.Data("LHAG120cI3.EX","TR.CLOSEPRICE;ZAV(TR.VOLUMEOPENINTERESTRATIO)","CH=Fd RH=IN",B2)

    For example, below is the different between ZAV applied and not applied

    1690795513158.png

Answers

  • marcel.thaele
    marcel.thaele

    I have also found the following solution : =RDP.Data(LHAG120cI3.EX;22;"NULL=0")

    Many thanx Marcel

Categories