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!!
Best Answer
-
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.
0
Answers
-
Thanks for your idea Chavalit but further research shows it is for use in Jupyter notebooks. I did try it it and no success.
0 -
Hi @paulgamelin
Please share your sample API call in which you received the data in scientific notation format.
Thanks.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 685 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 252 ETA
- 556 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 652 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛