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 bendavid.dalka · Sep 18, 2018 at 05:27 AM · datastreamdates

Downloading Datastream data referring to varying dates in large dataset

Hi all,

I have a question regarding the download of stock price data referring to specific dates, varying throughout the dataset. I use Datastream to download stock price data matching to M&A announcement retrieved from the SDC Mergers&Acquisitions database. Specifically, I need to download stock price data referring to specific announcement dates, varying from company to company. (e.g. Deal A was announced on 10jun2016, so I want to retrieve the target stock price 30 trading days prior to the transaction. For Deal B, the announcement date may be 26jun2016. And so on...)

As the sample is quite large (>90.000 transactions over a 20-year period), I am looking for a way to only download the stock price data for the relevant dates for each transaction (i.e. I only need a few specific dates per transaction, but the dates are different for each transaction). I want to avoid downloading stock price data of the last 20 years for all companies, because it would result in an immense ammount of unused data. Of course, I also want to avoid manually having to download the data for each company and date, as this would take me months.

I would be glad, if someone knew a way of automatically downloading only the stock price dates relevant for the regarding transaction for a large dataset, on the basis of the companies' Datastream code.

Thanks a lot for your help!

Ben

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.

4 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by paul.bacon · Oct 10, 2018 at 06:31 AM

Hi @bendavid.dalka

I have been thinking about this request a fair bit, personally i think this is best tackled from a request table.. rather than through the API

Step 1 - Identify the companies & the M&A date, then use Excel functionality to create two new dates (the start & end date for each instruments time series).

Step 2 - Drop this information into a request table and each request will run from between your imputed start and end dates.

See the images attached for reference.


ma1.jpg (32.2 KiB)
ma2.jpg (107.4 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 Monika.Stankovic · Sep 18, 2018 at 08:26 AM

@bendavid.dalka

Hello,

This forum is for software developers using Thomson Reuters APIs. The moderators on this forum don't have the expertise to answer general product or content search and explanation questions for Thomson Reuters products.

For questions such as this one you posted it is best to contact Thomson Reuters Helpdesk by either calling the Helpdesk number in your country or by following the link below:

http://my.thomsonreuters.com/ContactUsNew

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 Alex Putkov. · Sep 18, 2018 at 10:23 AM

@bendavid.dalka
I'm not sure I understand the challenge. Perhaps I'm missing something here, but what you're asking for seems trivial to me. When you're requesting timeseries from Datastream Web Service you can specify the time period. There's an example in the tutorial for Datastream Web Services on this portal:
https://developers.thomsonreuters.com/eikon-apis/datastream-web-service/learning?content=47128&type=learning_material_item
So, if I understand the desired workflow correctly, you read the data from "SDC Mergers&Acquisitions database" (I don't know what that database is, but from my perspective it doesn't matter). This data contains the symbol for the company you're interested in and the deal date. You use this symbol and the 30 day time period preceding the deal date to construct and execute the timeseries request to Datastream Web Service. Where's the challenge?

Comment

People who like this

0 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
rajat.agarwal · Oct 10, 2018 at 05:06 AM 0
Share

I guess, the challenge would be that DSWS has a limit of 10m datapoints a month. Given that OP has >90000 transactions, i.e. >180000 companies (target and acquiror), he will not be able to retrieve more than 5 days of data (5 datapoints) per company, which I suppose is insufficient.

avatar image
Answer by bendavid.dalka · Oct 10, 2018 at 07:44 AM

Hi @paul.bacon @Alex Putkov ,

thanks for your answers. I forgot to update the status of this post, as I already found out how to solve the issue and that this forum is not quite the right spot to post this question.

I have pretty much done it like paul.bacon proposed to do it. Create start and end dates for each company in Stata based on the Acquisition Announcement Date and then splitting the dataset into subsets to make processing a request via the Datastream Excel plug-in possible.

Thanks a lot for your input!

Comment

People who like this

0 Show 2 · 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
rajat.agarwal · Oct 13, 2018 at 08:31 AM 0
Share

Hi @bendavid.dalka, I've been trying to do something similar as you are, but am running into some problems there. Especially handling requests for so many companies using request tables. Could you please elaborate a bit more on your approach? Of course also via PM if that's better for you.

That would be incredible helpful, thanks!

avatar image
bendavid.dalka rajat.agarwal · Oct 15, 2018 at 05:56 AM 0
Share

Hi @rajat.agarwal, I simply split the data into a volume that the request table can handle (e.g. 80.000 companies). The issue I had first, is that I wanted to have both the number of shares (NOSH), as well as the undisturbed price (UP). For me, it was not really sensible to include both measures at once, because Datastream would output two lines per company, which makes copying the data annoying. So, I ran seperate requests for each measure. It is probably not the best way of doing it, because the macro does take some processing time, but it worked out fine for me.

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

Related Questions

WorldScope Fundamental Dates

DSWS API through Matlab question.

Retrieve Datastream data when we only subscribe to Eikon

Is there a VBA macro to refresh DataStream DSGRID() functions?

I can access DSWS via Excel but not via DatastreamDSWS2R

  • 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