How to get trading status of RICs through python api ?

wyj
wyj Explorer
in Eikon Data APIs

@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
Tagged:

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In
Register

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    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
    ...

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In
Register

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In
Register

Quick Links

Categories