What is the difference between the fields "date" and "Calc date"

fidel.esteves

When requesting the data for Market Cap of some assets, I am seeing some differences between the two fields (date and Calc date). What exactly means each of the fields?

The code I used is shown bellow:

data = ek.get_data(assets,

['TR.CompanyMarketCap',

'TR.CompanyMarketCap.date',

'TR.CompanyMarketCap.calcdate'],

{'SDate':startDate.strftime("%Y%m%d"),

'EDate':endDate.strftime("%Y%m%d")})

jason.ramchandani01

@fidel.esteves The companies you have shown are all delisted. I suspect that in this case the Date field is used to represent the last date where there was a record of market cap. This seems to align with the delisted RICs for example VASC.OQ^B17 - the 17 represents the year of delisting. Its the same in all of the examples you showed us. In this case there is a situation where the company was delisted but still active (VASC.OQ^B17). So the field to be aware of is the Date field which correctly states the last price entry on 17-Feb-2017 (the last date for which we had a price). You can check this on the chart.

Now there may be some reason why a further calculation was done on a date after it had delisted - perhaps something to do with administration process, some dilution or change in capital structure due to a takeover or something similar. I think in this case the company was taken over by a company called Teleflex on 17-Feb-2017. So the shares were bought by that company and something might have happened under the new ownership - though the shares themselves are not longer listed or traded. However, the market cap calculation should not change, and i'm speculating here, it might be a change in shares outstanding but with no new (market) price. This is really a content question and can get into some detail as the story with each company may be quite different.

Just to clarify Jonathan's comment, all listed companies will have a market cap number - based on their shares outstanding and the current (or in the case of illiquid securities - the most recent) shareprice. I believe this is the main difference between the two output values 'calc date' and 'date'. So in the case of daily series the most recent market cap would be reported - however if the company was illiquid and hadn't traded for a few days - you might want to know the date of the last calculation (ie when there was a price traded) - that would be the calc date. In the case of delisted companies this is more complicated as I have alluded to above. I think its best to raise a content query with the helpdesk (Helios Menu ==> Contact Us) as they will be able to provide you with a definitive reason or logic for delisted issues you are following. I hope this can help.