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

marcel.thaele

...DP.Data("LHAG120cI3.EX",22) instead of the displayed "NULL" ?

Find more posts tagged with

excel

#product

Accepted answers

raksina.samasiri

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

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

All comments

raksina.samasiri

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

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

marcel.thaele

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

Many thanx Marcel

EXPLORE OUR SITES