Answered By: IESE Library Last Updated: Jan 17, 2018 Views: 1097
The request table enables you to manage groups of refreshable requests.
You can view the details of all your requests together. You can schedule the table to be updated at a future time or overnight. You can select which requests you want to update.
- Getting Started: Using Datastream Excel Add-in select: Datastream > Request Table > New Request Table
Browse Sample Sheets to see some examples.
- Online help: Select Help >Contents >Datastream Advance for Office > Using Excel with Datastream > Using Request Table
- First results sheet, Sheet1, is created automatically. If you use the Data Destination column to put results on additional sheets, remember to create them
- Request table rows can be copied and edited so you can quickly build a table of related requests - remember to edit Data Destination to avoid overwriting results
- Remember that the Request Type is TS for time series request andTSL for time series list request
- You can have a list of values both in the Series and the Datatype columns
- Set Update to No to save time by not resubmitting requests every time.
- Selecting the Process Table button has no effect if Excel thinks you are currently editing a cell in the table. Try selecting the blank row at the foot of the table and clicking Process Table again.
- You may get a Visual Basic error when trying to open a request table on a PC without Datastream installed. Just ignore and you can still access the data.
One of the advantages of a Request Table is that it keeps a record of your Datastream requests (very useful if you want to revise and re-submit).