Open Excel. Excel menu bar should have Reuters Tools on upper left corner




Дата канвертавання26.04.2016
Памер10.29 Kb.
You can only obtain Reuters data in Excel if you are working on a PC that has access to Reuters.

Open Excel.

Excel menu bar should have Reuters Tools on upper left corner.

Make sure the cursor is on an empty cell and can write down several columns w/o overwriting data.

Click on Reuters Tools, and then select History.

Enter the symbol of the company.

Frequency of information is under “Type” – for Minute by minute pricing data, highlight minute. Go available fields and click on All or Master Fields; select LS (last price), also select Date and Time. Enter number of periods – 400 will cover all the minutes in one trading day; and number of days – in this case 1. Minute by minute trading data covers a maximum of 2 days. Click on Copy Link.

Note: the information in the columns is subject to change and will not be accessible when you are not connected to Reuters. To lock in the information in the columns it is best to copy & past as values to another section of the worksheet:

Highlight data

Copy

Paste Special



Values
You can also specify dates for pricing data by clicking on Custom and filling in date fields.

To populate a symbol table that updates data (and can be locked in with copy/paste as above) first put the symbols of the companies you want information in a column. For a list of all data fields available in Reuters select Help, Workstation and type in Data Fields in Index.

FYI: Xdd is ex dividend data, yhi is yearly high.



Once you have all the symbols and data fields in place, place cursor in corner of table (in yellow), click on Financial Data Tools and select symbol table to populate your table.



 

na

ls

beta

div

xdd

yhi

ibm

International Business Machines

79.46

0.89

0.2

08Aug2005

99.1

t

AT & T Corp

19.54

0.77

0.2375

06Jul2005

20.3

f

Ford Motor Company

9.86

1.38

0.1

29Jul2005

15


База данных защищена авторским правом ©shkola.of.by 2016
звярнуцца да адміністрацыі

    Галоўная старонка