When I used Eikon's function StreamingPrice, I tried to pull the value of CF_NETCHNG but got retu...

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.

All comments

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.

Hello.

I ran the same script and I don't get access denied information

@Jirapongse

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.

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.

HI @Jirapongse

To confirm, getting NA is correct?

NA means that we have 0 values in Eikon, right?

@Jirapongse

It is still giving me NA as values.

What seems to be the issue?

Hi @Jirapongse

Any update on this please?

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