Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
MaeAnthea.Diaz avatar image
16 ●1 ●1 ●2

API Data item for COUPON_TYPE_CD

While looking into Agency Pools we noticed it doesn't mention if it's fixed or float. What fields can we use to pull if pools are fixed, float, or IO? Isins below as examples: US36179WXH68 US36179WXJ25 US3140QNEY46 US3140QNFM98 US31418EB825 US31418EB908 US31418ECA64

We’re doing this using the API we previously used field COUPON_TYPE_CD to distinguish between fixed, float, and IOs

It was returning a value of L which doesn’t appear as a valid value. Is there any other fields we can use?

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

Shadab Hussain avatar image Shadab Hussain
Hi @MaeAnthea.Diaz,

Can you please confirm which API you are using?


1 Answer

· Write an Answer
Upvotes
Accepted
raksina.samasiri avatar image
14.4k ●30 ●5 ●10

hi @MaeAnthea.Diaz

I assume that you are using the get_data method in Eikon Data API in order to retrieve data.

However, this forum is more for programming-type queries, rather than content queries. I would recommend you to contact the Eikon support team directly via MyRefinitiv to get the content you're looking for.

Plus, I've also tried to find the code you're using to retrieve this data but not sure which one it is, could you please confirm?

  1. using COUPON_TYPE_CD, I got <NA> with an error msg mentioned that the record couldn't be found for these instruments
    1647237937198.png
  2. so I tried with TR.FiAmortizationType instead and got the value 'L' you mentioned, is this field being used?
    1647237917285.png

1647237937198.png (50.4 KiB)
1647237917285.png (91.9 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.