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?
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?
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.
