Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by fidel.esteves · Nov 09, 2020 at 12:53 PM · apifundamental data

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

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")})

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

6 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jason.ramchandani · Nov 10, 2020 at 01:12 AM

@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.

Comment
fidel.esteves

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by jonathan.legrand · Nov 09, 2020 at 03:27 PM

Hi @fidel

Would you be so kind as to provide an example RIC where the two dates are different? They don't have to be the actual ones you noticed the issue for, just any example you found.

Comment
fidel.esteves

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by fidel.esteves · Nov 09, 2020 at 04:39 PM

@jonathan.legrand Thanks for the response. Here are some examples:



A important note is that in most of the instances the two fields are the same.


1604939850939.png (34.0 KiB)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by jonathan.legrand · Nov 09, 2020 at 04:56 PM

Hi @fidel.e

Thank you for the information provided.
When we say calculation date that is the latest reported available estimate of a company. Then for the date, that is the latest date associated with the returned data.

FYI: There isn't always a difference between 'date' and 'calc date' that is within the field TR.CompanyMarketCap since

• The market cap is not available for UK, US, and other markets, as the shares outstanding are updated from sources, such as annual reports, press releases, etc.

• The market cap field is available only for very few regions, such as Hong Kong, Japan, etc. These are the markets from which we receive shares outstanding directly from the exchange feed. We have two fields to display the market cap, FID 2150 (MKT_VALUE) and FID 2744 (MKT_CAP). Once the exchange sends shares outstanding, it gets multiplied with the share price available under the quote section. Hence, the market cap is calculated automatically and displayed under FID 2150 (MKT_VALUE) for Japanese and FID 2744 (MKT_CAP) for Hong Kong stocks.


Does that answer your question?

Comment
fidel.esteves

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by fidel.esteves · Nov 09, 2020 at 05:06 PM

@jonathan.legrand Just to confirm... That means that if the market cap was released in 2017-02-17, but there were further adjustments in 2019-01-15, the "Date" gets 2017-02-17 and "Calc Date" gets 2019-01-15, right?


So, in the majority of data, where the two fields are the same, there is no further adjustments after release?!

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by fidel.esteves · Nov 09, 2020 at 05:11 PM

FYI: I am retrieving historical values of market cap for REFINITIV UNITED STATES PRICE RETURN INDEX constituents. It seems to return coherent data.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
11 People are following this question.

Related Questions

HTTP or PYTHON APIs

Can't get quaterly data

Missing fundamentals data via Python API

How should I get support for the ThomsonReuters.Desktop.SDK.DataAccess API not responding

API request returns error invalid RIC for get_timeseries

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges