Dear community,
I am having a bit of trouble with DSWS API operating through Python. Hoping for your experience and help!
I am running the DSWS api through python and run the following request
instrument_request = 'DE0007236101'
#fields_request = ['P']
fields_request = ['x(P)~E0','x(UP)~E0','x(PI)~E0','x(PI)~E0','x(PO)~E0','x(PA)~E0','x(PB)~E0','x(PH)~E0','x(PL)~E0','AF','x(MP)~E0','(x(VO)*1000)','(x(VC)*1000)','x(CP)~E0', 'x(GP)~E0', 'NOSH']
start_request = '-20Y'
end_request = '2020-06-30'
# Run the actual request
df = ds.get_data(instrument_request,fields_request,start=start_request,end=end_request)
print(df)
That query produces the following error for the earlier dates obviously:
raise Exception("Invalid JSON Date")
Exception: Invalid JSON Date
It runs smoothly if use '-10Y' orfor any date after '2003-01-01'. The actual time series is longer and should contain data. The response is:
Instrument DE0007236101 ...
Field x(P)~E0 x(UP)~E0 x(PI)~E0 ... x(CP)~E0 x(GP)~E0 NOSH
Dates ...
NaN 104.548 161.80 1524.0 ... None None 594780
NaN 108.683 168.20 1584.3 ... None None 594840
NaN 108.554 168.00 1582.4 ... None None 594840
NaN 105.323 163.00 1535.3 ... None None 594840
NaN 104.677 162.00 1525.9 ... None None 594840
... ... ... ... ... ... ...
2020-06-24 101.100 101.10 1473.8 ... None None 850000
2020-06-25 102.300 102.30 1491.3 ... None None 850000
2020-06-26 101.880 101.88 1485.1 ... None None 850000
2020-06-29 103.800 103.80 1513.1 ... None None 850000
2020-06-30 104.300 104.30 1520.4 ... None None 850000
Any ideas what, would be solving the issue?
Thank you very much for any help. It is highly appreciated!
