Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Datastream /
avatar image
Question by kp19864 · Jul 23, 2020 at 08:43 PM · datastreamtrth file format

Retrieving historical constituents FTSE All Share data

Hi All,

I’m Kevin and I’m new in this community. For my dissertation, I have to use the market value, price, and book common equity for the companies within the FTSE All Share from 1965 to 2020. I have used LFTALLSHMMYY within the request table for Datastream for office to retrieve data from 1996 to 2020, but I have a problem retrieving data before 1996 with this procedure.

Does anyone know how I can retrieve the list of constituents of the Ftse All Share before the 1996 year? Or even better how can I retrieve Market Value (MV), Price (p), Book common equity (DWSE) from 1965 to 1995 for the companies listed in the FTSE All Share.

Thank you very much in advance for the help,

Kevin

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.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jirapongse.phuriphanvichai · Jul 31, 2020 at 03:49 AM

@kp19864

I found the following answers when searching the same question in our knowledge database.

How far back does Datastream maintain the FTSE All-Share Index constituents?

  • We have historical month-end constituent lists for the FTSE All-Share Index constituents from January 1996. We do not have month-end constituent lists prior to this date.

    To access the month-end list of the FTSE All-Share Index constituents for a specific month, you can use a mnemonic of the formLFTALLSHmmyy, where "mm" and "yy" are two digit numbers representing the month and year.

  • The year-end FTSE All-Share Index constituent lists are also available on Datastream.

  • In the list code FTALyy, "yy" needs to be the year, for example, FTAL99 for the 1999 list. These year-end lists are available from 1994 to 2000.


However, you need to directly contact the DataStream support team via MyRefinitiv for confirmation.


1596167267142.png (17.1 KiB)
Comment
kp19864

People who like this

1 Show 1 · 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
kp19864 · Jul 31, 2020 at 11:33 AM 0
Share

Thank you very much!

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 >
7 People are following this question.

Related Questions

Is there any way to go from SEDOL to mnemonic?

Fetching daily data into a monthly workfile in eviews does not give me the latest value

How can I figure out Forward PTS Data?

Retrieving vintage matrix works for certain mnemonics but not others?

How Expressions are accounted in DSWS request limits?

  • 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
  • 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