question

Upvotes
Accepted
igorg avatar image
646 ●21 ●33 ●41

Dex2. Unexpected result for some RICs

I use dex2 manager in COM API to request ISIN and SEDOL fields:


Sample code:

            HRESULT l_hr = m_RData->put_InstrumentIDList(CComVariant(a_InstrumentIDList));
            if (l_hr == S_OK)
            {
                l_hr = m_RData->put_FieldList(CComVariant(a_FieldList));
                if (l_hr == S_OK)
                {
                    l_hr = m_RData->put_RequestParam(CComVariant(a_RequestParam));
                    if (l_hr == S_OK)
                    {
                        l_hr = m_RData->put_DisplayParam(CComVariant(a_DisplayParam));
                    }
                    else
                    {
                        wstring w_request(a_RequestParam);
                        string error("[EikonComDex2] Couldn't set the RequestParam: " +
                            string(w_request.begin(), w_request.end()));
                        m_logger->Log(error, DCLogger::DC_LOG_LEVEL_ERROR);
                        DataCollectorHelper::CoutLog(error, DC_RED);
                    }
                }
                else
                {
                    wstring w_fields(a_FieldList);
                    string error("[EikonComDex2] Couldn't set the FieldList: " +
                        string(w_fields.begin(), w_fields.end()));
                    m_logger->Log(error, DCLogger::DC_LOG_LEVEL_ERROR);
                    DataCollectorHelper::CoutLog(error, DC_RED);
                }
            }

a_InstrumentIDList : 1 RIC or comma separated RICs

a_FieldList : "TR.ISIN,TR.SEDOL"

a_DisplayParam: "RH:In"


If instrument list is "FROG.OQ", I receive:

'FROG.OQ','IL0011684185','BMX6JW3'


If instrument list is ",FROG.OQ" , I receive:

'FROG.OQ',IL0011684185,'BMX6JW3'
'FROG.OQ','null','BMX6JW3'


If instrument list is ",,,FROG.OQ" , I receive:

RIC field is invalid
RIC field is invalid
'FROG.OQ',IL0011684185,'BMX6JW3'
'FROG.OQ','null','BMX6JW3'


This is reproducible. Could you check if this is a bug?


Second case:

If instrument list is "ACET.OQ", I receive:

'ACET.OQ','US0070021086','BMC5RV6'
'ACET.OQ','US0070021086',null


Thanks

eikoneikon-com-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.

1 Answer

· Write an Answer
Upvotes
Accepted
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

I do reproduce the second issue (with ACET.OQ), and I raised case 09179007 for it with Refinitiv Helpdesk.

I'm afraid I do not reproduce the issue with ",FROG.OQ" or ",,,FROG.OQ". With these inputs I get empty rows returned for empty symbols in the input and a single row for FROG.OQ at the end. In other words on my end the behavior is as one should expect.

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.

igorg avatar image igorg

You're right. FROG works as expected today.

ACET.OQ returns 2 records.

Helpdesk suggests to replace TR.ISIN with TR.ISINCode and TR.SEDOL with TR.SEDOLCode. I tried. It works as expected for that symbol. But it does not looks like a fix, more like a workaround. And unfortunately I cannot replace them without proper QA. 12000 RICs do not have this issue. And only 1 or 2 have..

igorg avatar image igorg igorg

The data was fixed by Helpdesk. Now it works as expected.

Thanks

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.