How to get trading status of RICs through python api ?

wyj

@alex

when i run the below codes

start=time.strftime("%Y-%m-%dT01:29:00",time.localtime(time.time()))
end=time.strftime("%Y-%m-%dT07:00:00",time.localtime(time.time()))
df=ek.get_timeseries(['000001.SZ','600781.SS'],fields=["Open","High","Low","Close","Volume"], start_date = start,end_date =end,interval='minute')

I get the result like this: "ERROR"

('600781.SS', ': ', 'Error: TSINoDataAvailable, ErrorCode: TA-TSINoDataAvailable, Fault: TSIError, Description: No data available for the requested date range', '\n')

and I know the reason is that RIC(600781.SS) is suspended on Nov-23-2017。

Is there a function to calculate fun(600781.SS) 's trading status ,for example I hava a code list like this

lst=['000001.SZ',
 '000002.SZ',
 '000004.SZ',
 '000005.SZ',
 '000008.SZ',
 '000009.SZ',
 '000010.SZ',
 '000011.SZ',
 '000012.SZ',
 '000014.SZ',
 '000016.SZ',
 '000017.SZ',
 '000018.SZ',
 '000020.SZ',
 '000021.SZ',
 '000022.SZ',
 '000023.SZ',
 '000025.SZ',]

if there is a function to get trading status , I can avoid upper "ERROR"s when I try to get data .Thanks a lot!@Alex Putkov.1 @Jirapongse

Jirapongse

You can try this one:

df = ek.get_data(['600781.SS', '000001.SZ', '000002.SZ', '000004.SZ', '000005.SZ', '000008.SZ', '000009.SZ', '000010.SZ', '000011.SZ', '000012.SZ', '000014.SZ', '000016.SZ', '000017.SZ', '000018.SZ', '000020.SZ', '000021.SZ', '000022.SZ', '000023.SZ', '000025.SZ'], ["PRC_QL_CD"])

The result is:

(   Instrument PRC_QL_CD
 0   600781.SS       SDL
 1   000001.SZ          
 2   000002.SZ          
 3   000004.SZ          
 4   000005.SZ          
 5   000008.SZ          
 6   000009.SZ          
 7   000010.SZ          
 8   000011.SZ          
 9   000012.SZ          
 10  000014.SZ          
 11  000016.SZ          
 12  000017.SZ          
 13  000018.SZ          
 14  000020.SZ       SUS
 15  000021.SZ          
 16  000022.SZ       SUS
 17  000023.SZ          
 18  000025.SZ          , None)

The above code shows the value of PRC_QL_CD which is a real-time field.

The definition of this field is defined in the RDMFieldDictionary file.

PRC_QL_CD  "PRICE CODE"           118  NULL        ENUMERATED    3 ( 3 )  ENUM             1
!
! Price qualifier code for equities, bonds, and options, generally related to the 
! quote price.

It is an enumerated field. Its values are defined in the enumtype.def file.

PRC_QL_CD    118
!
! VALUE      DISPLAY   MEANING
! -----      -------   -------
      0        "   "   normal market or not allocated
...
     19        "SDL"   instrument suspended while drawing of lots takes place
...
     54        "SUS"   Suspended
...
     94        "CLS"   Market closed
...