question

Upvotes
Accepted
1 0 0 0

Data turn to be #name?

my data cannot be found in excel, it turn to be #name? with the formula =@DSGRID("L:GENT","FTSROE","2018","2020","Y","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")

pythonapidatastream-apidsws-api
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
39.2k 75 11 27

#NAME? error in Excel indicates that the function name is not recognized by Excel, which in turn indicates that the add-in providing the function is not loaded into the session of Excel.

DSGRID function will be available when Refinitiv Eikon - Microsoft Office add-in is loaded and when Datastream add-on is enabled under Refinitiv Eikon add-ons. You also must be signed in to use any Excel worksheet functions provided by Refinitiv Eikon - Microsoft Office.

For more details see the Help for Refinitiv Eikon - Microsoft Office. From Refinitiv Eikon tab in Excel ribbon select Help - Refinitiv Eikon - Microsoft Office Help. In the Help window navigate to Datastream for Office with Charting - How to install Datastream for Office.

icon clock
10 |1500

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

Click below to post an Idea Post Idea