question

Upvotes
Accepted
bendavid.dalka avatar image
1 ●1 ●1 ●2

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

datastream-apidsws-api
icon clock
10 |1500

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

4 Answers

Upvotes
Accepted
paul.bacon avatar image
446 ●2 ●2 ●2

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)
icon clock
10 |1500

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

Upvotes
Monika.Stankovic avatar image
1.1k ●3 ●3 ●3

@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

icon clock
10 |1500

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

Upvotes
Alex Putkov.1 avatar image
39.2k ●75 ●11 ●27

@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.refinitiv.com/en/api-catalog/eikon/datastream-web-service/Tutorials#dsws-tutorial--microsoft-visual-studio
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?

icon clock
10 |1500

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

rajat.agarwal avatar image rajat.agarwal

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.

Upvotes
bendavid.dalka avatar image
1 ●1 ●1 ●2

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!

icon clock
10 |1500

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

rajat.agarwal avatar image rajat.agarwal

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!

bendavid.dalka avatar image bendavid.dalka rajat.agarwal

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.

Click below to post an Idea Post Idea