Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by matt.edwards · Jun 15, 2020 at 11:18 PM · pythoneikon data apidata fieldsstreaming pricepython real-time api

Data fields for the Eikon streaming API

I was using the following call to get bid/ask/last data using Eikon's streaming API.

sp = ek.StreamingPrices(instruments = ['XOM'],
                        fields = ['CF_BID','CF_ASK','CF_LAST', 'CF_DATE', 'CF_TIME']
sp.open()
sp.get_snapshot()

Everything was working fine till this morning and now all I get is the following:

  Instrument
0        XOM

It looks like it does not recognize the data fields anymore. Did something change on the back-end? If so, what are the new fields I should be requesting?

Appreciate any help you can provide.

Thanks,


Matt

People who like this

0 Show 3
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
nick.zincone.1 ♦♦ · Jul 08, 2020 at 02:21 PM 0
Share

Hi @matt.edwards,

I don't have visibility into when these updates occur. Have you tried the request without specifying the service parameter?

avatar image
matt.edwards nick.zincone.1 ♦♦ · Jul 08, 2020 at 02:56 PM 0
Share

Yes, just tried it without the service parameter and the call still fails to return any CF_* fields.

avatar image
REFINITIV
nick.zincone.1 ♦♦ matt.edwards · Jul 08, 2020 at 03:22 PM 0
Share

Hi @matt.edwards,

Thanks for confirming. Let me open a ticket with the support desk on your behalf.

6 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by nick.zincone.1 · Jun 16, 2020 at 08:20 PM

Hi @matt.edwards, @jordan.carney,

There appears to be some changes in the API Proxy that may be affecting some customers. This is currently being looked into and I will update you once I hear back.

In the meantime, try the following to see if it helps. Note: the code segment below includes a setting for service.

sp = ek.StreamingPrices(instruments = ['XOM'],
                        fields = ['CF_BID','CF_ASK','CF_LAST', 'TRDPRC_1', 'HST_CLOSE'],
                        service = "IDN_RDFNTS_CF",
                        on_refresh = lambda sp, instrument, fields : print(fields),
                        on_update = lambda sp, instrument, fields : print(fields),
                        on_status = lambda sp, instrument, status : print(status))


Comment

People who like this

0 Show 2 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
matt.edwards · Jun 18, 2020 at 01:22 PM 0
Share

Hi @nick.zincone.1, any updates on this? Do I need to always set the "service" going forward and can it change? Thanks.

avatar image
REFINITIV
nick.zincone.1 ♦♦ matt.edwards · Jun 18, 2020 at 03:09 PM 0
Share

Hi @matt.edwards,

I have not heard back but will update you here when I do. Going forward, you should not have to set the service. I believe this should be resolved once the Proxy is updated.

avatar image
REFINITIV
Answer by nick.zincone.1 · Jun 16, 2020 at 12:03 AM

Hi @matt.edwards,

It is likely due to the time of day you requested for this data. If you requested the data before market open, the data elements you requested may have been blanked out during the closing run for this particular instrument. At some point outside of trading hours, perhaps very early in the morning or late a night, the values were reset. The closing run is dependent on the exchange or feed providing the data in the backend. Did you try after market open? I just tried now and I do see values.

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
matt.edwards · Jun 16, 2020 at 12:20 AM 0
Share

Hi Nick:
I just tried and get the same response. I have tried this while the market was open and then after it was closed. Never had an issue with these since I have been using this in the last 3 months - even after the market close I would get values along with the last update time and date. Now I get nothing.

avatar image
REFINITIV
Answer by nick.zincone.1 · Jun 16, 2020 at 12:56 AM

Hi @matt.edwards,

Ok, thanks for confirming. If this was working before, then there is likely something within your environment. Below is the full notebook I just tried within Eikon:

I would first try this and show your output as I did. If you haven't done so already, shutdown and restart Eikon. I don't have an immediate explanation if the above example gives you completely different results - we'll have to troubleshoot further.


ahs.png (12.4 KiB)
Comment

People who like this

0 Show 2 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
matt.edwards · Jun 16, 2020 at 04:53 AM 0
Share

Hi @nick.zincone.1:

Thanks for following-up. I restarted Eikon and have tried a different machine as well with the same results. Here is the output from my last session. Note: I have added "OPEN_PRC" as one of the fields and it seems to be the only one working

In [2]: import eikon as ek
   ...: ek.set_app_key(appKey)
   ...: ek.__version__
Out[2]: '1.1.2'

In [3]: sp = ek.StreamingPrices(
   ...:     instruments = ['XOM'],
   ...:     fields   = ['CF_BID','CF_ASK','CF_LAST', 'CF_DATE', 'CF_TIME', 'OPEN_PRC']
   ...: )

In [4]: sp.open()
Out[4]: <StreamState.Open: 3>

In [5]: sp.get_snapshot()
Out[5]: 
  Instrument  OPEN_PRC
0        XOM     45.35

In [6]: 
avatar image
REFINITIV
nick.zincone.1 ♦♦ matt.edwards · Jun 16, 2020 at 06:03 PM 0
Share

Can you change the request to steam prices to this:

sp = ek.StreamingPrices(universe = ['XOM'],
                        fields = ['CF_BID','CF_ASK','CF_LAST', 'TRDPRC_1', 'HST_CLOSE'],
                        on_refresh = lambda sp, instrument, fields : print(field),
                        on_update = lambda sp, instrument, fields : print(field),
                        on_status = lambda sp, instrument, status : print(status))

I'm just curious if this is specific to CF_<field> fields. I removed a few of the CF_<fields> you had in your original call and replaced them with some realtime fields.

This is what happens when I apply the above:

ahs.png (33.1 KiB)
avatar image
Answer by matt.edwards · Jun 16, 2020 at 06:22 PM

Yes, it does look like it mainly the 'CF_' fields. I tried your code and got the following:

In [20]: sp.open()
{'TRDPRC_1': 48.38}
{'TRDPRC_1': 48.37}
{'TRDPRC_1': 48.37}
{'TRDPRC_1': 48.365}
...
{'TRDPRC_1': 48.4201} 
{'TRDPRC_1': 48.425} 
{'status': <StreamState.Open: 3>, 'code': 'Open', 'message': 'All is well'} 
{'TRDPRC_1': 48.42, 'HST_CLOSE': 47.14}
Out[20]: <StreamState.Open: 3>

In [21]: sp.get_snapshot()
Out[21]: 
  Instrument  TRDPRC_1  HST_CLOSE
0        XOM     48.41      47.14

So, I did get values for TRDPRC_1 and HST_CLOSE but nothing for any of the 'CF_*' fields.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by jordan.carney · Jun 16, 2020 at 07:06 PM
Yeah I'll +1 on this exact issue. Data not related to the CF_ fields remains in tact and coherent while the CF_ fields simply disappear. It also started at the exact same time as OP. Any resolution or ideas? I've exhausted all my options ( port switching, fresh install, off/on the individual applications via Eikon config, colleagues API key) to no avail.
Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
nick.zincone.1 ♦♦ · Jun 16, 2020 at 07:10 PM 0
Share

@jordan.carney, @matt.edwards,

I’ve reached out to the product group to report this issue. I will post an update once I hear back. Thanks for your patience.

avatar image
Answer by matt.edwards · Jun 17, 2020 at 01:32 PM
Thanks Nick, that appears to work for now. Please let me know what we need to do longer term and how we can prevent this in the future.
Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
nick.zincone.1 ♦♦ · Jul 08, 2020 at 02:31 PM 0
Share

Hi @matt.edwards,

If you encounter issues with the Proxy process within Eikon again, the best way to get things resolved quickly and to have visibility into when it will happen is to go through the Refinitiv Support desk.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
12 People are following this question.

Related Questions

StreamingPrices limits on Data API

Can I change the row header with the 'Rh' parameter using the Eikon Data API?

How to obtain Reuters central bank key rate polls in Python with Data API (Codebook)?

Proper parameters for retrieving bid ask information via Eikon Data API via Python.

No data available for Dutch stocks between 17:30 and 17:35 local time.

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges