question

Upvotes
Accepted
7 1 0 6

DSGRID formulae

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?

#contentdatastreamdatastream-for-office
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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?


1 Answer

Upvotes
Accepted
56k 145 45 65

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.