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.

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
80k ●257 ●52 ●75

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