Problem with Power BI integration that doesn't sync real-time structures (CF_ASK, CF_LAST, etc) via
Hi everyone,
I am trying to integrate some RIC information into Power BI through python scripts that have already been tested on Refinitiv Eikon API with CodeBook. All scripts worked just fine, both historical and real-time data, as shown below.
Below are the codes used in the examples above.
1)
"import refinitiv.data as rd
rd.open_session()
rics = [
'/HOM24',
'/HON24',
'/HOQ24',
'/HOU24',
'/HOV24',
'/HOX24',
'/HOZ24',
'/HOF25',
'/HOG25',
'/HOH25',
'/HOJ25',
'/HOK24'
]
ho = rd.get_data(
universe = rics,
fields = [
'DSPLY_NAME',
'TRDPRC_1',
'PCTCHNG',
'HST_CLOSE',
'TR.ACCUMULATEDVOLUME',
'EXPIR_DATE',
'TR.FOFirstDeliveryDay',
'TR.FOLastDeliveryDay'
]
)
ho"
2)
"import refinitiv.data as rd
rd.open_session()
rics = ['BRL=']
brl = rd.get_data(
universe = rics,
fields = [
'CF_ASK',
'CF_LAST'
]
)
brl"
Historical data scripts are already integrated correctly, but real-time data scripts do not sync, as shown below.
I'm missing any step here? Thanks for all help.
Best Answer
-
Well, I already solved that problem too.
Nevertheless, thanks for all help.
"explanation below for all users that may have that problem in the future too"
I just discovered that the sync is capped into 5 databases as a limit bounder, so I just condensed the information requested from the get_data from all databases that I wanted into a 3 databases only. Now everything is working just fine.
0
Answers
-
Hi @edu
Unfortunately, I am unable to understand what the issue is. There appears to be an image that did not render - I believe there is a maximum of 2 images that can be sent in a single question.
Could you send the missing image? I assume it is describing the issue?
0 -
Hi @nick.zincone, the problem is that the loading screen starts rendering but doesn't finish syncing the script for real-time data such as historical data.
0 -
Hi @edu
It's unclear where you are running your test or who produced the dialog stating "Connecting...". That is not part of the library as far as I'm aware.
When I run the entire application within a Jupyter environment, there are no issues.
0 -
Hi @nick.zincone,
The problem is not in Jupyter environment, but with Power BI. I had no problems syncing historical data like ‘TRDPRC_1’ and ‘PCTCHNG’, for example. But when I try to sync real-time data like 'CF_ASK' and 'CF_LAST', the connection screen from Power BI doesn't finish. It has been there for a long time and simply doesn't complete loading my data from the python script, that's the major problem.
Let's say the historical data is synced in a few seconds, meanwhile the real-time data just doesn't complete the loading screen connection as I mentioned before.
0 -
You need to run Eikon or Workspace on the same machine and use the application key.
The code is:
import refinitiv.data as rd
rd.open_session(app_key="<App Key>")
rics = ['BRL=']
brl = rd.get_data(universe = rics,fields = ['CF_ASK','CF_LAST'])
session = rd.session.get_default()
session.close()
print(brl)You can use the App Key Generator app to generate application keys. For more information, please refer to the Quick Start page.
0 -
Hi @Jirapongse, thanks for the info.
I already tried using the app_key as a parameter into open_session, but I was using the app_key name itself which opened an error pop-up in the past, that's why I start using the open_session without a parameter and aparently it worked just fine for historical data but not for real-time data.
Since you mentioned again about the app_key, I searched again into the app_key resource from refinitiv eikon and found the api_key, which is the correct parameter to use as an app_key inside the open_session and that worked perfectly.
But now the problem is that I'm getting a handshake error because I'm already doing too many requests (SS below).
Do you hane any idea how to handle with this error?
Thanks.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛