User is using API Python to retrieve EOD data but received an error

ek.set_app_key('4e49391e9c524b9081b97cdbc046113aa317f957')
screener_exp ='SCREEN(U(IN(Equity(active,public,primary))), IN(TR.ExchangeCountryCode,TH))'
field2 = ['TR.TickerSymbol','TR.PriceCloseDate','TR.PriceOpen','TR.PriceHigh','TR.PriceLow','TR.CLOSEPRICE','TR.Volume','TR.TSVWAP','TR.CompanyMarketCap']
parameter={'SDate':0, 'EDate':0, 'Frq' : 'D' }
df = pd.DataFrame()
df, e = ek.get_data(screener_exp,fields=field2, parameters=parameter)
The error that client received
Instrument HTECH.BK
Ticker Symbol HTECH
Date 2022-12-21T00:00:00Z
Price Open 3.94
Price High 3.98
Price Low 3.92
Close Price NaN
Volume 124100
VWAP NaN
Company Market Cap 1.188e+09
----------------------------------------------------------------------------------
no vwap and close_price , and retrieve only 8-10 stocks .
Best Answer
-
Try '0' as string value of 'SDate' and 'EDate' in parameter instead of numeric 0.
0
Answers
-
Hi Ladaporn,
Your code got no big problem at my end. I replaced 'TR.CLOSEPRICE', with 'TR.PriceClose'. It returns 887 stocks as shown below.
0 -
@frank.ling1 but you also facing the same with "TR.TSVWAP " : <NA> , could you pls help check
0 -
Thank you @frank.ling1 , client is able to retrieve data now
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
- 616 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 中文论坛