Hi, There seems to be very limited data getting returned in commodities futures.
As an example (interval = "day", continuous = False): For Zinc Jan Futures (53503239) - query for 2017-12-01 to 2017-12-30 returns 0 records For Zinc Dec Futures (53495559) - query for 2017-11-01 to 2017-11-30 returns 0 records Even for: Zinc Feb Futures (53514503) - query for 2018-02-01 to 2018-02-15 returns 0 records
In fact, the only data being returned is for current month. For Zinc Mar Futures (53561095) - query for 2018-03-01 to 2018-03-18 also returns data. Zinc April (53644807) is also returning data but only for current month - not for previous months.
It seems that all commodity data is being purged beyond current month. Even currency data has a lot of data holes and there is almost no documentation anywhere on the extent of data actually present in your systems.
That works - but there seem to be lot of data holes. As an example for instrument_code 53779463 which represents the latest contract for GOLDGUINEA, no data exists between 2017-11-09 and 2017-12-28.
Also, any idea on when currencies (CDS-FUT) will also get done ?
@rahulchitale, You are looking at future month instrument token and trying to access data of a 4th future month instrument. API is returning empty response because there is no data. You must be looking for historical data of current month contract and that would be 53650439(GOLDGUINEA18MARFUT). You can check out more information about continuous data here.
Hi Sujith - let me clarify - as per what Nikhil suggested, I've taken the latest contract for GoldGuinea as of today (which works out to be GOLDGUINEA18JUNFUT expiring on 29th June, 2018) and then tried to do a six month lookup on that.
API is not returning empty data. I'm getting continuous data for it, but there is a gap in the daily data from 9th Nov to 28th Dec 2017 (ie: API is returning a dataset which contains day data prior to this date and after this date). Hence my flag on the 'hole'.
I believe that the API shouldn't really be returning partial data with holes in the middle regardless of which contract is queried for.
What you are, I believe, asking to try to run a cont futures query with the current month contract. Doing that does seem to work for some cases, but for example, running it with
instrument_token: 53444871 (SILVER18MARFUT), from_date:2017-09-19,to_date:2018-03-19 gives the somewhat cryptic error from the server: "Error occured while fetching continuous data"
Also, any idea on when currencies (CDS-FUT) will also get done ?
We have informed data team, they are looking into this.
As of now, we can't guarantee any timeline for CDS continuous data.
You are looking at future month instrument token and trying to access data of a 4th future month instrument.
API is returning empty response because there is no data.
You must be looking for historical data of current month contract and that would be 53650439(GOLDGUINEA18MARFUT).
You can check out more information about continuous data here.
API is not returning empty data. I'm getting continuous data for it, but there is a gap in the daily data from 9th Nov to 28th Dec 2017 (ie: API is returning a dataset which contains day data prior to this date and after this date). Hence my flag on the 'hole'.
I believe that the API shouldn't really be returning partial data with holes in the middle regardless of which contract is queried for.
What you are, I believe, asking to try to run a cont futures query with the current month contract. Doing that does seem to work for some cases, but for example, running it with
instrument_token: 53444871 (SILVER18MARFUT), from_date:2017-09-19,to_date:2018-03-19 gives the somewhat cryptic error from the server:
"Error occured while fetching continuous data"