DSGRID formulae

vishal.kak
vishal.kak
in Datastream

Can someone help me understand what this DSGRID formulae does -

=@DSGRID("AXBK.NS","cya#(x~INR*100,c)",YEAR(Financials!M35),"","","SDateCellRef=true;SuppressComments=true;Sym=RIC","")


What is the function of : cya#(x~INR*100,c) ?

Is there any documentation for these formulaes?

Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

    @vishal.kak

    Sorry about the issue that you are facing.

    CYA# is a datastream function for the calendar year average. For more information, please refer to this link.

    x~INR*100 represents the trade price in Indian Rupee multiplied by 100.

    However, why this formula doesn't work with YEAR("31/03/2022"), please contact the Refinitiv Eikon with Datastream for Office support team directly via MyRefinitv to verify the parameters.

    I hope that this information is of help.

Answers

  • vishal.kak
    vishal.kak

    Here is the full formulae which works

    =@DSGRID("AXBK.NS","cya#(x~INR*100,c)",YEAR("31/03/2021"),"","","SDateCellRef=true;SuppressComments=true;Sym=RIC","")

    If I change YEAR to ("31/03/2022").

    =@DSGRID(GRDXData!$A$28,"cya#(x~INR*100,c)",YEAR("31/03/2022"),"","","SDateCellRef=true;SuppressComments=true;Sym=RIC","")


    Why doesn't it work?


Categories