question

Upvotes
Accepted
2 0 1 3

$$ER: E100,INVALID CODE OR EXPRESSION ENTERED for a Credit Default Swap

Hello,
I am having trouble getting the Total Return Index from selected Credit Default Swaps.
The Error-Code: $$ER: E100,INVALID CODE OR EXPRESSION ENTERED keeps showing up, regardless of which CDS I choose in Datastream. I am able to get the Total Return Index for Stocks and Bonds, CDS are the only type that do not work:

datasream-request.png

result.png


Does anyone have a solution for this problem?
Thank you in advance!


eikonrefinitiv-dataplatform-eikon#contentexceldatastreamindexdatastream-for-officeexcel-error
result.png (46.0 KiB)
datasream-request.png (430.4 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
Accepted
82.7k 279 53 77

@enes.salija

I found the similar issue regarding the AXL5$AX and RI. The answer of that issue is that the RI datatype is not available for CDS.

Therefore, if it returns NA, it could mean that the requested data type is not available for that instrument.


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.

@Jirapongse,

thank you for your answers. I will therefore work with the Spread Mid and not with the Total Return Index

Upvote
82.7k 279 53 77

@enes.salija

Thank you for reaching out to us.

I couldn't retrieve RI for BAC5$AR with the static request.

1698635009557.png

It returns NA. Please contact the Datastream support team directly via MyRefinitiv to verify if this BAC5$AR can provide the Total Return Index (RI) data.

The data that shows on the website is Spread Mid (SM).

1698635280286.png


1698635009557.png (8.6 KiB)
1698635280286.png (35.7 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
2 0 1 3

@Jirapongse ,

Thank you for your response, are you able to get the Total Return Index from any Credit Default Swap, that way maybe I know if it is even possible to get the Total Return Index from CDS in general. Is the Formular "X(RI)~USD" that I have used the same as "RI" that you have used, if not what does the X stand for exatly?


Unfortunately the Refinitiv support cannot help me due to their agreement with my university so I have to find another way.

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.

Upvote
82.7k 279 53 77

@enes.salija

The X in this formula ("X(RI)~USD") should be a symbol substitution.

I am not sure if this BAC5$AR instrument can provide the Total Return Index.

Can you retrieve it without currency conversion?

The same formula works fine with other instruments.

=@DSGRID("IBTRYML","X(RI)~U$","-2Y","-0D","D","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")

1698832244676.png



1698832244676.png (19.0 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
2 0 1 3

@Jirapongse

I have tried it woithout the X and wthout the currency conversion but it still doesn't work.
I have also tried different Credit Default Swaps and I am only able to get the "Spread Mid" as you did. I also tried getting any Datatypes that are under the section of Credit Defaul Swap but unfortunately it only works for the Spread Mid as seen in the attached pictures.

all.png

1698834421220.png




all.png (171.2 KiB)
1698834421220.png (111.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.