question

Upvotes
Accepted
21 0 0 0

CBOEVIX Data not available for the Refinitiv Eikong API on R, I already have the license required to see it, but the data is not dowloading

For almost two years I have been using the R API to download some data for an Option Strategy, which includes VIX and S&P values. Since May, the VIX Data became an extra service, which I am paying for. Nevertheless, the VIX Data works only on Excel, my code finds no data for it when trying to retrieve it, while all the other values will be download as usual.

eikon-data-api#contentr-studio
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.

Upvotes
Accepted
21 0 0 0

I just did it with different Securities to be sure, and the issue is that for CBOEVIX I get Value: "NA", while all the other show a value, which makes sense, since it is the only security also not working in my code. I know that VIX requires since May an extra license to see the data, but I do have it, and I can even pull data on Excel for this same ticker!



{"DataResponse": {"AdditionalResponses": null,

"DataTypeNames": null,

"DataTypeValues": [{"DataType": "PI",

"SymbolValues": [{

"Currency": "NA",
"Symbol": "CBOEVIX",
"Type": 6,
"Value": "NA"

}

]

}

],

"Dates": [

"2023-07-18T00:00:00"

],

"SymbolNames": null,

"Tag": null

},

"Properties": null

}

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.

Upvotes
77k 240 52 72

@mag

Thank you for reaching out to us.

Are you using the Datastream R library (DatastreamDSWS2R)?

I ran the following code and could get the data properly.

1689759848105.png

For Eikon Data API for R, the code is:

get_data(instruments = list(".VIX"), 
         fields = list("TR.PriceClose"))

1689760021814.png

Please share the code that you are using.


1689759848105.png (17.1 KiB)
1689760021814.png (11.5 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.

Upvotes
21 0 0 0

Yes, I am using DatastreamDSWS2R


This is the formula I use to get the data for VIX and other Indexes.


PARA[['VOLA_UNDERL_HEADER']] = 'VIX'

PARA[['VOLA_UNDERL_DS_DATA_KEY']] = 'CBOEVIX'

PARA[['VOLA_UNDERL_DS_DATA_VALUE_TYPE']] = 'PI'


All of the rest are working (and have been for 2 years) but since VIX data became a separate subscription, I get this error on my Logs, and I dot understand why this is happening.


INFO [2023-07-17 11:49:16] CBOEVIX|PI|2023-01-16: Retrieve data from DS

WARN [2023-07-17 11:49:16] CBOEVIX|PI|2023-01-16: Retrieved data is not valid! Value: NA

INFO [2023-07-17 11:49:16] CBOEVIX|PI|2023-01-17: Retrieve data from DS

WARN [2023-07-17 11:49:16] CBOEVIX|PI|2023-01-17: Retrieved data is not valid! Value: NA

INFO [2023-07-17 11:49:16] CBOEVIX|PI|2023-01-18: Retrieve data from DS

WARN [2023-07-17 11:49:16] CBOEVIX|PI|2023-01-18: Retrieved data is not valid! Value: NA

INFO [2023-07-17 11:49:16] CBOEVIX|PI|2023-01-19: Retrieve data from DS

WARN [2023-07-17 11:49:16] CBOEVIX|PI|2023-01-19: Retrieved data is not valid! Value: NA

INFO [2023-07-17 11:49:16] CBOEVIX|PI|2023-01-20: Retrieve data from DS

WARN [2023-07-17 11:49:16] CBOEVIX|PI|2023-01-20: Retrieved data is not valid! Value: NA



Thanks

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.

Upvotes
77k 240 52 72

@mag

You can check the request at https://product.datastream.com/DswsClient/Docs/TestRestV1.aspx.

First, use the Get Token to get a token.

1689761643126.png

Then, use the retrieved token with the Get Data to retrieve PI for CBOEVIX.

1689761739385.png

The retrieved response should be like this:

{"DataResponse": {"AdditionalResponses": null,
"DataTypeNames": null,
"DataTypeValues": [{"DataType": "PI",
"SymbolValues": [{
"Currency": "U$",
"Symbol": "CBOEVIX",
"Type": 5,
"Value": 13.3
}
]
}
],
"Dates": [
"2023-07-18T00:00:00"

],
"SymbolNames": null,
"Tag": null
},
"Properties": null
}

1689761643126.png (22.8 KiB)
1689761739385.png (53.3 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.

Upvotes
77k 240 52 72

@mag

If you got NA while using the TestRest client, it could be a permission issue.

I submitted a ticket to the Datastream Web Service support team to verify your permission. The case number is 12749088. The support team will contact you regarding this issue.

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.