Hi.
I downloaded the instrument details for the US instruments using REST requests like this:
https://eodhd.com/api/fundamentals/ZAL.US?filter=General&api_token=xxxxxxxxxxxx.xxxxxxxxxx&fmt=json
283 of the instruments that I downloaded look like this:
{
"Code": "ZAL",
"Type": "Common Stock",
"Name": "ZAL",
"Exchange": null,
"CurrencyCode": "USD",
"CurrencyName": "US Dollar",
"CurrencySymbol": "$",
"CountryName": "USA",
"CountryISO": "US",
"OpenFigi": null,
"ISIN": null,
"LEI": null,
"PrimaryTicker": null,
"CUSIP": null,
"CIK": null,
"EmployerIdNumber": null,
"FiscalYearEnd": null,
"IPODate": null,
"InternationalDomestic": null,
"Sector": null,
"Industry": null,
"GicSector": null,
"GicGroup": null,
"GicIndustry": null,
"GicSubIndustry": null,
"HomeCategory": null,
"IsDelisted": true,
"DelistedDate": "2017-09-08",
"Description": null,
"Address": null,
"AddressData": null,
"Listings": {},
"Officers": {},
"Phone": null,
"WebURL": null,
"LogoURL": "",
"FullTimeEmployees": null
}
Many of the attributes are NULL, including Exchange, all the market identifiers and all the classifications. All of the 283 affected instruments have "IsDelisted": true
.
From the EOD api I see that at least some of these instruments have been traded while they were listed. EG:
https://eodhd.com/api/eod/ZAL.US?from=2016-10-13&to=2016-10-13&period=d&api_token=xxxxxxxxxxxx.xxxxxxxxxx&fmt=json
[
{
"date": "2016-10-13",
"open": 37.29,
"high": 37.29,
"low": 37.225,
"close": 37.225,
"adjusted_close": 37.225,
"volume": 200
}
]
My question is what is the semantics of a NULL Exchange value? It would seem that the instrument was traded, but where? NYSE or NASDAQ or somewhere else?
I can supply a list of the 283 affected instruments if it helps.
Thanks,
Adam Crowther