question

Upvotes
Accepted
23 7 4 10

How to handle blank data in the field entry

I am trying to get details of cusip "313586RC5" with RFA8 Java. I can see a field entry (fid = 69, name = COUPN_RATE) returning a blank value. fhlb-ofcomroaming-profilesvbollinendesktop313586rc.png

But if you google it for that cusip I can see coupon rate as "0.000%"

http://www.fanniemae.com/syndicated/documents/mbs/debtmarketing/debtoutstanding/noncallabledebtoutstanding.csv

Is this issue with API or how to handle this situation.

treprfarfa-apifieldsOMMADS
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
9.6k 10 7 7

All COUPN_RATE are the same value which is blank.

0.0 Real/price fields returned by MarketData interfaces in RFA 7.6 means blank while -0.0 means zero. This is the IDN style(legacy feed/MarketData interfaces). Hence, 0.0 should be treated as blank and -0.0 should be treated as zero in MarketData interfaces.

While Elektorn feed/OMM interfaces in RFA8, blank means blank and 0.0 means zero.

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
32.2k 40 11 19

@applicationdevelopment

Hello,

This fid 69, COUPN_RATE, comes blank from Elektron data feed, i.e. blank is the value that is published for 313586RC5=TWEB.

Neither RFA nor your subscriber app have an issue displaying a non-blank value as blank.

However, there is a discrepancy between data feed value and Fannie Mae site value.

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
9.6k 10 7 7

Hello @applicationdevelopment

This is case 05089287 and I am taking care of the case. Please see my response in the case's email.

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
23 7 4 10

@Pimchaya.Wongrukun

We do not see any updates to case 05089287 on https://my.thomsonreuters.com/mtrTrackMyCases

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
9.6k 10 7 7

Hello @applicationdevelopment

Please see the response in email "RE: Case: 05089287 Data discrepancy between RFA 7 and 8 [ ref:_00D30602X._5004011rxAu:ref ]" which I have sent to you(applicationdevelopment@fhlb-of.com). If you have any questions/concerns, please respond to the email then I will help you accordingly.

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.