Basic information on financial databases: cook books, tips and tricks & economic news

This blog contains schematic easy to grasp - hands on - help in performing searches in economic databases, making work sets and making them inter-exchangeable between the databases.

* Disclaimer. I am not a finance professional. Most posts are the result of personal findings.

Note:
All presented images are scaled and can be enlarged to original size (click the picture).

Search This Blog

3/16/2010

Datastream: request table using Excel

In Datastream's Time Series menu it's only possible to generate one single Time Series.
Datastream features ' Request Table ' , to circumvent that and create multiple Time Series.
This blog explains with a simple example what to do.

Example workset:

(copy, CTRL-C)

Time Series menu:


After starting Request Table, paste the workset into the proper fields. It's is also possible to press the Navigator button and create a table from scratch.



Next: adjust all fields to the required preferences (like the time series)
Click the buttons above the columns to select.

Update Yes/NO
Request Type: Static (S), Time series (TS), Time series list (TSL), Company accounts (CAF)
Format: (output) things like headers, row titles etc.


Datatypes, functions, CA (for CAF)
Now, here is the trick: for each item it is possible to create its own time series
(included start date and end date)
Frequency: Daily, weekly, monthy, quarterly and yearly
Example: (note the different Time series)


Next it is time to set the Data Destination.
This demands some rather complicated actions.
Just follow the instructions.

First: creating a new Work sheet (the destination of your search)
Right Mouse click > insert new work sheet
(might differ per Excel version)


Now, press this button:


Another screen pops up:


Click the new work sheet TAB and click the first top cell

Press OK

Repeat untill all funds are done:


Finally, press this button:


All data is transported to the new work sheet.
Result:

No comments:

Post a Comment