I'm data engineer, currently working on stacking data from Datastream API.
In data check, I have following issues in Datastream
1. Why datastream returns NULL value for non-existing future data?
- I think this data return standard need to be fixed.
for example, API without start/end date returns not only today's value, but also null value for tomorrow
2. In data ticker/field, 'VKOSPIX' / 'PI', I found out data is offed by single date.
and also, API returns non existing close price for monday, which is filled with close price of friday.
At first I guesssed the issue is about business day convention or timezone. However, I cannot understand the reason why the value is wrong with real value.