question

Upvotes
Accepted
deepblue avatar image
1 ●1 ●1 ●1

Unable to download equity indices data using Datastream

Hi,

I'm trying to download last 2 years of Argentina-DS Market equity index data from Datastream add-in for excel.

Below is the formula I've entered

=@DSGRID("TOTMKAR","DSRI;RI","-2Y","","D","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false;Sym=RIC","")

and I'm getting the below error in excel cell.

I'm unable to understand what is the issue here? Any help would be appreciated.

Thanks.

datastream-apidsws-apiexcelequities
1586532072022.png (4.6 KiB)
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.

wasin.w avatar image   wasin.w

Hello @deepblue

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.

Thanks,


AHS

Jirapongse avatar image   Jirapongse

@deepblue

Hi,

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
78.8k ●250 ●52 ●74

@deepblue

From my checking, DSRI is an invalid data type for TOTMKAR. 

               "DataTypeValues": [
                    {
                        "DataType": "DSRI",
                        "SymbolValues": [
                            {
                                "Currency": "AP",
                                "Symbol": "TOTMKAR",
                                "Type": 0,
                                "Value": "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED"
                            }
                        ]
                    },

You can directly contact the DataStream support team via MyRefinitiv for confirmation.


1586748541213.png (8.2 KiB)
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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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