View graphic information in a quote list

Document Sample
View graphic information in a quote list Powered By Docstoc
					Reuters 3000 Xtra                                                                    PowerPlusPro Guide

This guide will show you how you can do the following in Excel, using Reuters PPPro:


      1.   Quickly view static historical data
      2.   View historical data that updates automatically
      3.   View live real-time data
      4.   Snap data at specific time points during the day

      To view the full online help document, go to the Reuters drop down menu in PowerPlus Pro and choose Help > Online Help. Also
      under the Insert Function button, there are full help menus for all PowerPlus Pro functions.


View static historical data of a RIC
You can quickly retrieve static historical data using the Drag & Drop function from a graph into Excel.

1.    Right click to pop up a graph, or use one already embedded in your        2.   Select the line of the analysis by clicking on the line on
      workbook in Reuters 3000 Xtra, Kobra.                                          the graph (you will get little boxes appearing on the
                                                                                     analysis line, see below) then drag the analysis to the
                                                                                     instance of Excel you have open on your task bar (hold
                                                                                     over Excel on taskbar and it will pop open, then drop into
                                                                                     the spreadsheet) or drag your mouse to an open
                                                                                     spreadsheet and drop the data as per below.




View historical data that automatically updates
You can use Reuters Assistants in PPPro to retrieve time-series data such as the last 25 days of closing prices.

 1.   Firstly open PowerPlus Pro (PPPro) You
      can usually find this by going to Start,
      Programs, Reuters 3000 Xtra, PowerPlus
      Pro. You will know that you have PPPro
      open if you see the Reuters menu at the
      top alongside the other drop down
      menus.
Reuters 3000 Xtra                                                            PPPro Guide

2.   Select Reuters, Assistants, Time
     Series Data as per below.




                                                                     3. A window indicating the first step of the three
                                                                      step process will appear.

                                                                     4. You can enter the RIC of the instrument
                                                                     whose time-series want to view and then click
                                                                     Add.

                                                                     Then click Next at the bottom of that window.




                                        5. You are now in Step 2 of the wizard.

                                        In Values by Field/Frequency, there are a number of fields, each
                                        containing available time frequencies. Choose the field that you want to
                                        chart and the time range for the update frequency.

                                        The directory in Bold, in this case, it is the BID, is the directory with the
                                        most available data.

                                        6. Expand the field directory name in bold to view the available frequencies
                                        and select one. In this case, we have selected 1D for a time-series of daily
                                        data.

                                        7. Double click on the fields for which you want to view the time-series to
                                        select them to the right hand box. Ensure you select TIMESTAMP as this
                                        will show the date in the time-series table you return. In this example, you
                                        could select TIMESTAMP and CLOSE, then click Next to go to the next step
                                        in the wizard.




2
Reuters 3000 Xtra           PPPro Guide

                    8. In Step 2a of the wizard, you select the time
                    range for your time-series. Select either, a start
                    date, an end date or both by clicking on the
                    relevant check boxes. Alternatively if you want
                    your time-series to update automatically (to
                    always show you the last certain number data
                    points) – in this example, the last 25 has been
                    chosen, by entering the number 25 in the field
                    Data Points.

                    Then click Next.




                    9. In Step 3, the final step, choose how you
                    want your data to appear. Choose Reuters
                    Format if you would like your time-series to
                    appear with Reuters colours. Or choose None,
                    with no formatting.

                    Also, choose to have your data in Ascending
                    (earliest at the top) or Descending order (most
                    recent data at the top). And then select Finish.




3
Reuters 3000 Xtra                                                                                 PPPro Guide

                                                                   10. In this example, your data should appear as on the right.

                                                                   You can change EUR= to another currency, such as GBP= directly in
                                                                   the relevant spreadsheet cell and see the time-series change to reflect
                                                                   the new currency code.

                                                                   You can also copy the table into another area of the spreadsheet or a
                                                                   new spreadsheet and change EUR= to another currency.

                                                                   To view 30 data points instead of 25, you can change the content of the
                                                                   cell containing EVENTS:25 to EVENTS: 30.

                                                                   You can also edit the interval from Daily to Monthly by changing
                                                                   INTERVAL: D to INTERVAL: M directly in the cell.




Retrieve live real time data
There are several ways of retrieving real time data into Excel, two of which are -
1.       Open both Kobra and PPPro applications. Within Kobra, hit F4 for a quote pop up and type a RIC, such as VOD.L or LCOc1
         or EUR= then hit enter.
2.       With your mouse, select a piece of data such as the Last price, hold your left mouse down and drag it into PPPro. You can
         then drag and drop other data points from the quote browser into PPPro.




4
Reuters 3000 Xtra                                                                          PPPro Guide

Snap data at specific time points during the day

1.   Select Reuters, Assistants, Real-Time Series Data from the Reuters drop down menu.

                                                                                 2. A window indicating the first step of the
                                                                                 three step process will appear.

                                                                                  3. You can enter the RIC of the
                                                                                  instrument whose data you want to snap
                                                                                  and then click Add.

                                                                                   Then click Next at the bottom of that
                                                                                   window.




                                                                                   4. You are now in Step 2 of the wizard.

                                                                                   In Field by Category, choose the
                                                                                   Available Fields folder and then from
                                                                                   there, double click to select the fields
                                                                                   that you want to collect snapped data
                                                                                   for. The fields will move to the right hand
                                                                                   box.




5
Reuters 3000 Xtra                                                    PPPro Guide

                                                            5. You are now in step 2a of the real-time
                                                            series assistant. From here you can
                                                            choose a start date and an end date with
                                                            the time you want to snap the data OR
                                                            you can just tick the box for Schedule (as
                                                            per screenshot) and then choose ‘Every
                                                            day at’ and the time you would like to
                                                            snap the data.

                                                            6. Then make sure you click on the Add
                                                            button below with the double chevron.

                                                            Then click Next.




                                                            7. This is the final step – allowing you to
                                                            choose formatting (top left) and where
                                                            you would like your data to start.

                                                            Then click Finish.




                                                            8. You will get a table of data saying
                                                            ‘snapping’ and at the time you have
                                                            chosen, it will snap your data. You must
                                                            ensure that you leave the spreadsheet
                                                            open for this to take place.




For further help please contact the helpdesk on 0800 44 2000 or use Contact Us from the
Reuters drop down menu in either PowerPlus Pro or Kobra.




6

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:25
posted:3/7/2010
language:English
pages:6
Description: View graphic information in a quote list