|
How to create your own scrolling newswire
You can download the worksheet from this tip and be ready to go,
but if you want to dive into the techniques used to create it,
follow these steps:
- Use the Reuters Tools Quote tool to create a real-time quote for
the N2_UBMS instrument code along with the fields you want
to query. In our application we used the array formula
below and placed the formula in the cells C4 to J4. (For example,
BROADCAST TEXT is the field which contains the text of the
news headline.
| {=REUTER|IDN!'N2_UBMS,[BROADCAST TEXT,PNAC,TOPIC
CODE,PROD CODE,CO IDS,LANG IND,SOURCE FEED NME,STORY TIME]' |
- Select the range containing the DDE link (cell C4:J4 in our case),
and then click on Data Series... from the ReutersTools menu.
- Use the Data Series wizard to create a data series.
- Once the Data Series is collecting data, you can add column labels
and formatting.
- After you're done, Choose Data> Filter> AutoFilter from the
Excel menu. This action adds drop-down arrows to your column
headings and makes it easy to query your news database. For
example, if you're using our worksheet xlnews.xls and you
would like to see if there are any stories in the news database
on Disney, click on the down arrow in Comp ID (cell G3) scroll
down to DIS.N. Show me
|
