Datastream Event Studies: calculating destination cells in Request Table

Datastream offers Request Table for event studies, which enables you to work with different Time Series per fund/equity (etc.) Just like in my former post can working with (very) large work sets be very tedious (not to mention complicated) when you are interested in event studies.

This is what you are supposed to do: (old method)

First of all: create a new work sheet (right mouse click)

Having done that, the next step is making your destionation cells (where to put your request table data, you don't want them on your menu)

This pops up:

Go to the new work sheet and select a destination cell > next screen:

Press OK





Back in the menu it looks like this.

Imagine having to repeat this 800 times?

Here comes the time saver: (new method)

Take a new Excel work sheet, and put in this formula:
 ="=Blad1!$cell"&rij() (Dutch);
="=Sheet1!$cell"&row() (English)

Drag down (with the + at the right bottom corner of the cell)

Copy the result into your Request Table

Voila, loads of time saved.

If you want to investigate more than one data type, you can change the formula.
For instance, like this: (5 rows)
="=Sheet1!$A"&5*ROW()

In the Dutch language version of Excel the function would be:
="=Blad1!$A"&5*RIJ()
(the data destination shifts 5 rows)

*) many thanks to Aart Bijkerk, who pointed this out to me.