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
When I used eikon's function StreamingPrice, I tried to pull the value of CF_NETCHNG but got returned NAN instead of 0. For LGOc1-LGOc2 the net change is 0 on screen but in API the value shown is NA it is just a bug in your API that needs to be fixed
Please advised as to why we are getting NAN using the above function but in Eikon, we have 0 values.
Checked this is CODEBK and Eikon Excel - Issue is not replicated. 0 values shows when extracted using these applications, same as quote and MON app
To confirm it, you need to enable the API log when the value is 0. In the log, you will see the retreived data.
For example, I tested with the /AJA.BK and the value of CF_NETCHNG is 0. 
It displays <NA> in the dataframe.
I should display 0, not <NA>.
I recommend to use the RD Library instead.
stream = rd.open_pricing_stream( universe=['/AJA.BK'], fields=['CF_NETCHNG'] ) stream.get_snapshot()
Thank you for reaching out to us.
I can run the code properly.
You may need to enable logging in the library by using the following code.
import eikon as ek
ek.set_log_level(1)
ek.set_app_key('...')
...
hi @Jirapongse
Thanks for the quick turnaround.
The script the client is using is working however what we are getting is NA values instead of 0 which shows in Eikon MON and quote app.
I look for a different RIC that have 0 value for NET CHANGE. see the below screenshot
Instead of getting 0 as values, we are getting NA which is different from the quote app.
I ran the same code on CodeBook and got NA. After checking the log, it is a permission issue.
Please enable log in the Eikon Data API to verify what the problem is.
ek.set_log_level(1)
Hi @Jirapongse
Can you confirm why it is a permission issue?
The reason I ask is because the client and I can get the values using the same code if there is a value aside from 0.
The only time we get NA is when the values shows 0 in Eikon
I entered ek.set_log_level(1) and I dont see access denied.
Please run the following code on CodeBook to verify if it is a permission issue.
import eikon as ek
ek.set_log_level(1)
ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY')
streaming_prices = ek.StreamingPrices(
instruments = ['LGOc1-LGOc2'],
fields = ['CF_NETCHNG'])
streaming_prices.open()
df = streaming_prices.get_snapshot()
streaming_prices.close()
display(df)
Then, check for the following log.
Thanks.
It means that you have permission to access this RIC so you should see the value (2.75) of CF_NETCHNG, not <NA>.
Can you confirm if I have the permission and in quote, net change is showing as "0", should I get NA or 0 in API?
Sample:
As you can see, I get NA in API even the values show as "0" in the quote app.
That is not the RD library.
Please check the Content_Pricing_Snapshot.ipynb sample in CodeBook. The sample is in /_Examples/01. Data Retrieval and Discovery/01.01. Refinitiv Data Library/ directory.
Hi @Jirapongse
I was able to review the folder you shared in CODEBK however the issue is it seems Streaming Prices function is not recognizing the -0 or +0 in CODEBK.
Using the below function, we are able to get 0 values same as in Eikon.
Please confirm. Thanks
