question

Upvotes

Python query

Hi Refintiv - in reviewing the auction data you guys provide, I am seeing a few issues for the data for Mexico. Can you please help review/fix the below issues: • 05/24/22 – MBONO has two lines reported: in addition to primary auction reported with SecOffCode = 23 there is a greenshoe option reported with SecOffCode = 3. However, the amount reported seems to be too high – it is 35% of the issuance, while by the rules it cannot be more than 20% • 09/29/20 – Reuters has 10,721 mp reported while Banxico online report has 10,050 mp. Does Reuters number include greenshoe? • 05/26/20 – Reuters has no MBONO entry, while Banxico online report suggests there was issued 3y in the amount of 5,200 mp • 04/29/19 – Reuters data has 2 entries for MBONO: one with settle 5/2/19 and another one with (nonstandard) settle 4/30/19 • 04/2/19 – IssueAmount/AvgYieldPrice/IssuePrice/ TotalPricePublic for MBONO is identical to the next entry for UDIBONO (inflation linker) which is likely a copy-paste error • 03/12/19 – IssueAmout is missing for MBONO • 03/05/19 – Reuters has 2 entries for MBONO: same ISIN and settle but different IssuePrice, why two entries? • 01/22/19 – IssueAmount is empty for MBONO, should be 9,700,000 • 10/16/18 – Reuters data has no entry for MBONO • 08/21/18 – there are additional lines with IndicativeAmount filled but IssueAmout equal to #N/A, what are these entries? • 07/17/18 – same as 8/21/18 there are two entries for MBONO, one with empty IssuePrice/IssueYield/IssueAmount • 07/10/18 – the IssueAmount for MBONO is most likely incorrect as it is too small, seems to be a copy paste error from UDIBONO (inflation linkers) • 06/26/18 – same problem as 7/10/18, the IssueAmount/IssuePrice is most likely incorrect as it is the same as the below entry for UDIBONO (linker) • 06/05/18 - IssueAmount is empty for MBONO, should be 9,000,000 • 04/03/18 - same problem as 7/10/18, the IssueAmount is most likely incorrect as it is the same as the below entry for UDIBONO (linker) • 11/07/17 – IssueAmount for MBONO and CETES seems to be swapped (1,500,000 and 8,500,000) • 10/30/17 – IssueAmount for MBONO seems to be wrong, Banxico online report suggests there was issued 5y in the amount of 8,000 mp • 08/01/17 - IssueAmount for MBONO seems to be too small • 07/18/17 – IssueAmount for MBONO is empty • 07/04/17 - Reuters has no MBONO entry, while Banxico online report suggests there was issued 10y in the amount of 8,500 mp • 06/27/17 – same issue as 07/04/17 • 05/02/17 - IssueAmount for MBONO seems to be too small, not aligned with Banxico • 04/10/17 - Reuters has no MBONO entry, while Banxico online report suggests otherwise • 03/07/17 - IssueAmount for MBONO seems to be not aligned with Banxico online report • 02/07/17 - IssueAmount for MBONO seems to be not aligned with Banxico online report • 12/13/16 - IssueAmount for MBONO seems to be not aligned with Banxico online report • 12/06/16 - IssueAmount for MBONO is empty • 10/31/16 - IssueAmount for MBONO is empty • 08/30/16 - IssueAmount for MBONO is too small, misaligned with Banxico • 08/16/16 - IssueAmount for MBONO is empty • 07/05/16 – there is no MBONO entry in Reuters data • 04/12/16 – most likely typo in IssueAmount for MBONO, IssueAmount should be 3,000,000 not 300,000 • 12/22/15 - IssueAmount for MBONO seems to be not aligned with Banxico online report, seems as if IssueAmout was copied from TotalAppliedFor • 12/08/15 - IssueAmount for MBONO is too small, seems to be a copy paste error from UDIBONO (inflation linkers) • 12/01/15 - IssueAmount for MBONO is too small, seems to be a copy paste error from UDIBONO (inflation linkers) • 11/24/15 - most likely typo in IssueAmount for MBONO, IssueAmount should be 8,000,000 not 800,000 • 09/01/15 - IssueAmount for MBONO seems to be not aligned with Banxico online report • 07/07/15 – there is no MBONO entry in Reuters data • 03/17/15 - IssueAmount for MBONO seems to be not aligned with Banxico online report • 01/20/15 - most likely typo in IssueAmount for MBONO, IssueAmount should be 2,500,000 not 250,000 • 06/04/13 - there is no MBONO entry in Reuters data • 05/07/13 - there is no MBONO entry in Reuters data • 04/09/13 - there is no MBONO entry in Reuters data • 03/12/13 - there is no MBONO entry in Reuters data • 02/12/13 - there is no MBONO entry in Reuters data • 01/15/13 - there is no MBONO entry in Reuters data

python#product#contentpython apiwealth-management-web-services
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
10.3k 18 6 9

@BryanAlvin.Buenaventura Thanks for your post - as this is a content issue you should usually open a support ticket in Workspace - on this occasion I have done this for you with Case number: 13545646. The relevant team will reach out to you shortly. I hope this can help.

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.