Some MKTCAP values from API /rank/ranks are empty in year 2000 and 2001

DataMiner and API
1

hi P123,
I’m downloading MKTCAP data from API /rank/ranks, found some empty value for market cap, for example for the below ticker’s market cap and the date. I tested 2 years, there are around 50 ~ 100 tickers every week which have empty market cap value.

MKT_CAP, ticker: TIMB , date: 2000-01-29
MKT_CAP, ticker: TBH^11 , date: 2000-01-29
MKT_CAP, ticker: TLK , date: 2000-01-29
MKT_CAP, ticker: HKT.2^00 , date: 2000-01-29
MKT_CAP, ticker: BSB.1^02 , date: 2000-01-29
MKT_CAP, ticker: CHRT^09 , date: 2000-01-29
MKT_CAP, ticker: BBVAY^05 , date: 2000-01-29
MKT_CAP, ticker: EIR.1^02 , date: 2000-01-29
MKT_CAP, ticker: NMR , date: 2000-01-29
MKT_CAP, ticker: BRPBY^01 , date: 2000-01-29
MKT_CAP, ticker: TLXFQ^09 , date: 2000-01-29
MKT_CAP, ticker: KZIA , date: 2000-01-29
MKT_CAP, ticker: SPMYY , date: 2000-01-29
MKT_CAP, ticker: 3NHEI^00 , date: 2000-01-29
MKT_CAP, ticker: NGG , date: 2000-01-29
MKT_CAP, ticker: MCB.1^02 , date: 2000-01-29
MKT_CAP, ticker: CLL^04 , date: 2000-01-29
MKT_CAP, ticker: IBN , date: 2000-01-29
MKT_CAP, ticker: MIELY , date: 2000-01-29
MKT_CAP, ticker: 3BWPSY^02 , date: 2000-01-29
MKT_CAP, ticker: SNN , date: 2000-01-29
MKT_CAP, ticker: OTPGF , date: 2000-01-29
MKT_CAP, ticker: BNPZY , date: 2000-01-29
MKT_CAP, ticker: CS , date: 2000-01-29
…

Can you confirm if this is expected or any potential data issue? thanks

Taofen

2

Hi Taofen,
I checked some of the tickers in the list and they do have mktcap=NA for those 2000-01-29 dates. It is not an API issue.

If you run a backtest in the screener with the rule mktcap=NA for universe United States (Incl Foreign Primary), it shows that there are about 100-150 tickers with mktcap=NA in the years 2000-2001. That number quickly drops in mid-2001. The tickers in your list are mostly ADRs. The data in the early years is known to have some gaps, but I will confirm that we have no way to populate these.

3

Thank you for your quick reply.