DSGRID formulae

vishal.kak

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?

Find more posts tagged with

datastream

datastream-for-office

#content

Accepted answers

Jirapongse

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

All comments

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?