Financial Statement data via EIkon API get_data is downloaded in scientific notation

Downloading financial statement data using the Eikon API get_data sometimes delivers numbers formatted in scientific notation like 5.4e-14. I down load several large files with several thousand RIC Codes and a variety financial statement data. I then upload the data to SQL Server. SQL Server fails to accept the scientific notation data but has no problem with the traditional number data.

Is there away to get the Eikon API to only deliver data in a traditional number format rather than using scientific notation? Or is there away to convert the scientific notation delivered in the panda dataframe for all the columns to get the data in a traditional number format?

Thanks, appreciate any help!!

Find more posts tagged with

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

Hi @paulgamelin

I think you can set number format on the dataframe.

I have not verified this but this kind of article would help, https://kiwidamien.github.io/stylish-pandas.html

Please also be reminded that the data retrieved with Eikon Data API cannot leave the desktop, such as uploading them to other SQL Server.

All comments

chavalit-jintamalit

Hi @paulgamelin

I think you can set number format on the dataframe.

I have not verified this but this kind of article would help, https://kiwidamien.github.io/stylish-pandas.html

Please also be reminded that the data retrieved with Eikon Data API cannot leave the desktop, such as uploading them to other SQL Server.

paulgamelin

Thanks for your idea Chavalit but further research shows it is for use in Jupyter notebooks. I did try it it and no success.

chavalit-jintamalit

Hi @paulgamelin

Please share your sample API call in which you received the data in scientific notation format.

Thanks.

EXPLORE OUR SITES