3000 Xtra - Analysing Data

XC-X114Reuters3000Xtra:Analysing Data Using Charts and Pre-built ModelsThomson Reuters Markets Academy Participants GuideWorkshop purpose:Learn how to quickly create and customise charts in Reuters3000Xtra and how to access and utilise the comprehensive set of analytical tools.Discover intuitive pre-built models to analyse instruments such as stocks,yield curves and FX rates.10Summary and ClosePrinted:08June2009What tools are availableBenefits of the charting tools in Reuters3000XtraCreating a chartAdding a target cursor to view price and newsHands-on Exercise:Creating bar and line chartsAdding a target cursor to view price and newsTo view a price from the chart click on the target cursor icon in the chart toolbar and select Vertical cursor from the drop-down list.With your mouse drag the cursor to the required date on the chart.The price(s)for that date will bedisplayed in the top left of the chart.You may wish to view news relating to an instrument on a specfic date e.g.there may have been a large price movement. Move the cursor to the required date then right-click and select Related News.A news browser will appear displaying news for that date.Please note the news database provides13months of historical news.To remove the cursor simply click on the cursor icon in the chart toolbar.Hands-on Exercise:Creating bar and line chartsStep1:Open a new flex screen and insert a Quote Object and a Metastock Chart.Enter the constituents of the DAX into the quote<0#.GDAXI>.Step2:Drag&drop the code for BASF into the Metastock Chart frame.Question1:What type of analysis is displayed by default?Step3:Change the analysis to CandleStick.(Note:you have to select the analysis first,otherwise the"Select Analysis" button is greyed out.)Step4:Add a target cursor at the latest peak.Question2:What was the date and the corresponding price?Question3:What happened on that day?This section contains:Adding additional analsyes to your Metastock Chart Adding multiple instrumentsAdding and editing a trendlineHands-on exercise:Adding analyses and trendlinesAs you can see the two moving averages have been over-laid on the bar chart.For some analyses it may be appropriate to view them as a sub-chart e.g.Momentum,as it will have a different scale.To view as a sub-chart,first create the analysis.Then click on the analysis line and with the mouse drag the cursor to the bottom right of the chart and release.A sub-chart has now been created:To delete an analysis from the chart simply click on the analysis line and press the Delete key.As you have seen it is very quick and easy to add additional analsyes to your chart.If you would like to learn more about any of the analyses e.g.the formula used,just click on the analysis line and press the F1key to open the on-line help for a specific analysis.Adding multiple instrumentsSo far we have learnt how to create and customise a chart as well as adding additional analyses.In this section we will learn how to add multiple instruments to one chart.You may require to display two or more instruments in one chart e.g.view two companies in the same sector so for this example we will chart the share price for BP and BG Group.In Kobra activate a blank window so that the yellow boarder appears.Go to the Insert menu at the top of the screen and select Metastock chart.Type the RIC BP.L into the command line,you should be viewing the BP.L Bar OHLC chart.Now we need to add the second instrument so click on the Insert Analysis icon and select BAR OHLC from the drop-down list.Change the RIC to BG.L and click on Add and then Cancel to remove the pop-up.Your chart should resemble the screen below:As you can see BG.L has been added to the left y-axis of the chart.If you would like both instruments on the same axis simply click on the left-y axis and with your mouse drag your cursor to the right-y axis and release.There is no limit to the number of instruments you may have in one chart.Adding and editing a trendlineOne of the essential elements of Technical Analysis is to identify trends.Adding and customising trendlines in Metastock Chart is simple and easy to do.Metastock Chart offers a range of trendlines to choose from and for this example we are going to add a Line to the chart.Click on the icon in the chart toolbar and select Line from the drop-down list then move the cursor back into the chart.Click into the chart and hold the left mouse key to place the start of the trendline.Keep the mouse selected to draw the line and release the mouse where you wish the Line to finish.You have now added a trendline to the chart.It is possible to draw multiple trendlines on the chart,just select the desired tredlines from the drop-down list and draw in the same way.If you would like to edit your trendline simply click on the Line and use the mouse to re-position,extend or shorten the Line. To delete the trendline left mouse click on the Line and press the Delete key.If you would like to learn more about trendlines or any aspect of Metastock just click into the chart and press the F1key to access the comprehensive on-line help.Hands-on exercise:Adding analyses and trendlinesStep1:Create the line chart for Cable(GBP=)in a new Metastock Chart window.Step2:Add two Simple Moving Averages:7days and30days.Step3:Add horizontal resistance and support lines,i.e.lines that touch a recent peak and a recent trough. Question:At what level do you see support and resistance for the exchange rate,i.e.what price levels are displayed for your horizontal lines?In place editingHands-on exercise:Changing the date rangeenables you to make these changes with just a few easy clicks.Just click on the section you wish to change e.g.if you wish to change the instrument click on the RIC in the top left of the chart and select another RIC from the drop-down list.If you wish to change the analysis just click on the analysis name in the legend and select an alternative from the drop-down list:The start and end dates are controlled by the two cells at the top right of the chart:If you would like to change the start date,click on the first date and select the desired date from the calendar.Similarly,if you would like to change the end date click on the second date and make the change.As you can see in-place editing is very quick and easy to use.You may wish to explore what else may be changed using this feature by simply clicking on different areas of the chart.Hands-on exercise:Changing the date rangeGo back to your GBP chart and change the date range so that you display the rates since the beginning of this year. Change the analysis type to bar chart(OHLC).Question:On what day was Cable trading at the lowest point?What was the corresponding price?Saving a chartHow to save and access a chart templateOnce you have created a Metastock Chart you may wish to save it.If you save the Flex sheet the chart will automatically be saved as part of the sheet.If you would like to save the chart as an independent file,allowing you to use it in other Flex Sheets then right-mouse click in the chart,select Chart then Save As.To retrieve the saved chart right-mouse click in a chart window,select Chart and then Open to select the appropriate file.Please note saving via the right-click menu is available from version5.0onwards.How to save and access a chart templateWithin the Metastock Chart a set of instrument/market specific templates are available which provide a pre-defined set of analyses relevant for the instrument or market area.You can also create,save and apply your own templates.Exporting the chart to Word and ExcelHands-on exercise:Exporting data into Microsoft Excelexport the raw data to Excel then select the analysis,right-click and select Edit,Copy and paste into Excel.Alternatively select the analysis and use the mouse to drag and drop the data behind the chart into Excel.(Note,this is not possible if you are using Reuters3000Xtra in a Citrix/Hosted environment.)Its important to be aware that this is a non-updating export to Excel compared with a dynamic(realtime)export that can be achieved using PowerPlus Pro.Hands-on exercise:Exporting data into Microsoft ExcelStep1:Open Excel and/or a new spreadsheet.Step2:Create a bar chart for the ADIDAS share price<ADSG.DE>in the Metastock Chart.Step3:Drag&drop the chart(data points)into Excel.Question1:How far back does the history go,i.e.what is the first date displayed?Question2:What field names are displayed?Question3:What field names are displayed when you drag&drop a line chart?Question4:Does the table in Excel update,i.e.will todays close be listed tomorrow?This section contains:Introduction to Quick chartsHands-on exercise:Creating a deposit curveHands-on exercise:Creating a deposit curveQuestion1:Which type of Quick Chart do you need to select when creating a deposit curve? Question2:How many contributors/brokers are available?Question3:Is it possible to chart interest rate swap and forward starting swaps?Exercise:Using the drop-down menus create a chart displaying the current and historic(one year ago)composite USD deposit curve.Note:Using the Quick Charts toolbar,You can view the numerical data and/or export the data and chart to Microsoft Excel.Additional exercise1:Using the drop-down menus create a chart displaying the German Consumer Price Index.Additional exercise2:Using the drop-down menus create a chart displaying the Forecast for the currency pair CHF vs.JPY.Which type of Quick Chart enables you to display the estimated EPS for Thomson Reuters(TRIL.L)?This section contains:What are the key benefits of using pre-built modelsAccessing and navigating pre-built modelsHands-on exercise:The Equity Sector BrowserHands-on exercise:Studying Yield CurvesPre-built models in the Excel environmentXtra's Home page.This is a navigation model that is used for exploring the main features of Reuters3000Xtra.Reuters3000Xtra uses two different working environments,so some models have been built in Kobra and others in PowerPlus ProThe models within Kobra are generally used to display data in a very clear and useful way.The models in PowerPlus Pro are generally used to calculate and analyse data.Note in version5.1some analytical PowerPlus Pro models have been replaced with"Calculators".These can be integrated into your Kobra flex screen.Although the lay-out looks slightly different and simplified,the key funtionalities have remained unchanged.They are just as powerful as their relatives(the related XMS model)but even more user friendly. You can access these calculators from Get Going or selecting the relevant one from your object selector in KobraThe"old"XMS models are still available.You can access them from Get Going>Model Browser>ArchiveAccessing and navigating pre-built modelsThere are a number of methods to access the pre-built screens and calculators contained in the Xtra Market Suite(XMS)in Reuters3000Xtra.One of the most convenient is by using the home page Get Going.When selecting a relevent job role,the model will display information and calculators that we believe are most relevant to you.Please note that Analytics and Calculators are listed in the left column.When you hover with your mouse over the name of the model,a pop-up text will display a brief description of the model and whether this model is based in Kobra or in the Excel environment(PowerPlus Pro-PPPro).If the analysis you are interested in is not listed,click on"Model Browser" in the left most column and search for your model by typing in a keyword.For example,when we select the jobe role"Interest Rate Swap Trader"we can easily access pre-built models such as the Xtra Menu,FX and Interest Rate Gateway and Swap Focus.time,fundamental and historical data.Searching for modelsReuters3000Xtra contains over100XMS models.The best way to find a model is to use the model browser via GetGoing.For this example we will search for the Economic Overview model.1Click on Model Browser on the left hand side of the screen2Type Economic Overview in Search for Models box3Click GO4Click on the title to open the modelIf you do not know the full name of the model you can either type in a single word or you can browse by market category. You will notice that models built in Kobra are identified by the"K"symbol in the title(see above screen shot).Those thatopen in PowerPlus Pro have an Excel symbol in the title:The models are being reviewed and updated on a regular basis.New upgrades are indicated in the Model Browser and you can download the newest version by clicking on"Download Update".This does only take a few seconds.To learn more about the model or to access the help files please go to"Help">"Help on Sheet".Hands-on exercise:The Equity Sector BrowserFind the model"Equity Sector Browser"in the Model Browser.Question1:What does the model do?Open the model and enter the code for IBM(IBM.N)In what tab can you find the ROE ratio?Question3:How many stocks are compared to IBM when you select the FTSE index?Hands-on exercise:Studying Yield CurvesOpen the model"Yield curves"from Get Going.Enter the currencies USD,CAD and AUD and display the benchmark curve for each currency.What instruments are used as"Benchmarks"?Question2:What is the AUD yield for the10year sector?Question3:What is the5year yield spread between CAD and USD?Pre-built models in the Excel environmentLet's open one of the models in PowerPlus Pro,e.g."Swap Points and Outrights".This is a model which enables us to calculate cross currency forward rates for broken dates and it is one of the most widely used models of Xtra.In this workshop,however,we will not focus on the purpose and content of this model but on the formal lay-out of the screen.To find out more about how this model works,you can join us for the workshop"Monitor and analyse FX Swaps and Forwards"and/or read the comprehensive on-line help file(top right corner of the display).Contact us and object specific helpline help facility.Select the Metastock chart and press F1 to obtain help on all of the available analyses and get access to a comprehensive help index and search facility. Alternatively you can ask for personal assistance by clicking on the"Contact Us"button at the top of your screen.A member of our Thomson Reuters Support Staff will contact you immediately.Comprehensive help files are also available for the pre-built displays and models.The"Help"buttons are located in the top right corner of the model.ReviewSummary of key learning pointsClose1)A quick way of creating a chart in Kobra is to__________and________the RIC from a Quote Object into Metastock.2)If you want to view the news headlines for a specific point in the past you first have to insert a target____________.3)You can add analyses by clicking on the analysis__________in the toolbar.4)To access online_______and detailed information regarding the analyses,press the_____function key.5)Using pre-defined______________,you can quickly create charts which display relevant analyses for thedisplayed instrument.6)You can easily customise the start and end date,time-zone,currency or instrument using"In-place__________".7)You can easily export the raw data to_________by selecting the analysis and using the mouse to drag and drop the data behind the chart.It is important to be aware that the data does not_________.A dynamic(realtime)export can only be achieved using_______________.8)Metastock Charts is a tool which provides powerful charting and analysis capabilities making it easy and convenient to display__________charts and perform technical analysis whereas Quick Charts enables you to access___________ charts.9)In Quick Charts you do not need to know any codes and functionalities.You can select instruments and other criteria from___________________.10)To view a chart regarding the Swiss CPI,you can use the________________chart.Regarding pre-built models and Calculators:11)Pre-built models can be accessed from the Reuters3000Xtra home page_____________.Models which are more display oriented and provide market overviews are usually based in the____________environment,whereas analytical models are based in_____________.12)In analytical models,the font colour___________indicates cells where user input is required or possible.13)To view a brief description of the model,you can___________over the title in Get Going.Summary of key learning pointsDuring this class you have learnt how to quickly create and customise Metastock charts,add additional analyses,chart multiple instruments and export the chart image as well as the raw data to Excel.You have learnt how to access Quick Charts and what pre-defined charts are available.You have also learnt how to access and navigate pre-built displays to analyse financial market instruments.These "models"can be accessed from your home page Get Going.They offer comprehensive on-line help files.CloseYou can learn more about how to use Reuters3000Xtra by visiting the following classes:-Reuters3000Xtra:Introduction to the Key Components and Data-Reuters3000Xtra:Searching for Data and News-Reuters3000Xtra:Displaying Data and Screen Design-Reuters3000Xtra:Retrieving Data in ExcelThese workshops are the main components of the Reuters3000Xtra certification programme.For more details please visit our Customer Zone.Where to get further help...Please use the URL links below to contact one of our Thomson Reuters specialists. Customer Zone/customersContact us/contactsGuide to Reuters Data/support/data/Reuters training/academy©Reuters2005.All rights reserved.Reuters and the sphere logo are the trademarks or registered trademarks of the Reuters group of companies around the world. Published by Reuters Limited, The Reuters Building,South Colonnade,Canary Wharf, London,E145EP.Reuters,by publishing this document,does not guarantee that any information contained herein is and will remain accurate or that useof the information will ensure correct and faultless operation of the relevant service or equipment.Reuters,its agents and employees,shall not be held liable to or through any user for any loss or damage whatsoever resulting from reliance on the information containedherein.This document contains information proprietary to Reuters and may not be reproduced,or used in whole or part without the expresswritten permission of Reuters.Any Software,including but not limited to,the code,screen,structure,sequence,and organisation thereof,and Documentation areprotected by national copyright laws and international treaty provisions.This manual is subject to U.S.and other national exportregulations.Reuters uses your data in accordance with Reuters privacy policy in the privacy footer at .Reuters Limited is primarilyresponsible for managing your data.As Reuters is a global company your data will be transferred and available internationally,includingin countries which do not have privacy laws but Reuters seeks to comply with its privacy policy.If you wish to see or correct data held onyou or no longer wish to receive information about developments in Reuters Group products and services,such as free trials or eventsor you wish to change your preferred method of receiving communication,please email esupport@ writing"Personal Details"in the subject title.For more information:Send us a sales enquiry at/salesenquiryato。