Home

Thomson One Analytics Excel Addin User Guide

1. Insert Options Field or Expression Jas FFOL Expression Layout 4nd Caption Cell Reference 651 Get Cell Options Close After putting IBM and Y 2002 in Cell A1 and B1 respectively and hit G et Cell button user can adjust the Insert O ption by selecting a position for Caption of the item If double clicking or dragging the item TotalD ebt to cell B2 The above example generate the below result B2 h Be PFOLCTF TotalDebt 61 A451 459200101 2002 Z TotalDebt 260171 PFD L TF TotalD ebt B1 A 1 is automatically created by the Item Lookup function and TotalD ebt as caption is put to the left of the formula 23 D ata definition can be got by right click on items C Set Lookup Set Look up opens the below box Thomson OME Analytics Open Look in feileensx a P z2companies O4f235 03 15 17 37 Set E 300million 11 28 01 12 04 02 Set g SCompanies 06 04 03 14 06 19 Set 4911 06 11 03 15 42 26 Set F ADRlocalkecord 05 01 02 16 44 28 Set P bigsales 12 06 02 12 57 57 Set P brazilian OS5 5 01 12 00 32 Set m Canadian ctiveDPS 0325 03 16 33 24 Set P Compustat 05 21103 15 28 29 Set P CSNAS 08 19 02 18 36 36 Set P EURO 6 20 02 13 22 08 Set F Financial Osf27 02 12 04 10 Set Food 11foifo 12 19 49 Set P FortuneSo O813S 02 18 00 46 Set s hewson 12 09 02 11 22 30 Set File name ha Cancel D ouble clicking on any of the sets will insert the pat
2. Analytics its power and flexibility PFD L is modeled after the Excel expression language It incorporates powerful features like time period conversion time series analysis and cross sectional analysis All of these are absolutely essential for financial products aimed at professional end users such as Portfolio Managers or Investment Bankers The PFD L function wizard can be found under Wizard Function Wizard on the Excel Addin Menu Bar Function Arguments EP a x Expression hws CashandSTInvestments E ws CashandsTinve Period o O Ajen Key s 0 am Options jma YS native FEL y paf a al ReadyToCalc Returns data From Thomson4nalytics using the Following expression PFOL database item or expression period entit optional arguments Options Formula result Help on this Function Cancel 1 Single Entity PFDL Syntax is PFD L database indicator expression item property period key options For example PFD L Sales Y 01 IBM A Database indicator It is used when user wants to pull data from a specific database other than the default one It includes Worldscope ws D atastream ds Compustat cs Extel ex Disclosure sec US Pricing usp First Call fc IBES History ibh Thomson Financial tf B Expression Argument This is the field or calculation that will be evaluated It can be any data item available in
3. S plus 9 digits for example S000047767 is the primary issue of Thomson Quote Q plus 9 digits for example Q000051981 is the Thomson quote of the primary issue that is trading on Frankfurt exchange Clicking on an entity insert that Entity K ey into the active cell of the spreadsheet Item Lookup Users can search through literally thousands of data items and retrieve the desired ones Clicking on Item Lookup to open the search box For instance to search all the data items in Thomson Financial that contain the word debt type the word into the Search box and press Search See the results in the sample Item Lookup window below 22 Thomson OME Analytics Item Lookup a a e x Data Items For Search For Item Thomson Financial debt CurLTDebePctCurTotalCapital InterestExpenseonDebt LTDebtissuancecFStmt LTDebtPckCommonEgsyravg LTDebtPckComrmonE quity LTDebtPctTotalCapital LTDebtPctTotalCapitalsyrayvg LTDebtReductionCF stmt STDebkondCurPortl Toebt l B Earnings E Financial Statement Information l os CE Foreign Business E E General Company Information E Key USD Items vee Co PerShare Data TokalbebePctCormonEquity ES Ratios vee Eq Stock Data Fy Stock Performance Data WeightedCostOrbebt WeightorDebt WkdCoskorDebt Specify Company by Key value Lookup Cell Reference ag Get Cell Specify Period by Period value Yesterday DBCPD
4. Thomson One Analytics such as PriceClose Sales NetIncome etc O r an item with period notification such as Sales Y 2002 O ra user defined name such as TotalCurrentA ssets TotalCurrentLiabilities Or a function such as TMAX usp pricehigh usp cpd 1y O r a cell reference For example PFD L ws Sales Y 01 IBM PFD L ws sales ws CostofG oodsSold Y 01 IBM PFD L ws sales Y 2002 ws sales Y 2001 IBM PFD L tsum cs sales 0q 4 IBM PFD L a1 Y 2001 IBM where cell al has the expression C Item property Item property is optional Itis attached to an item for descriptive information It includes the following Description pfdl tf PrimarySicCode description msft returns prepackaged software instead of the code 7372 Period pfdl ws sales period msft returns the year for the sales number instead of the sales number Footnote footnoted pfdl ws sales footnote msft returns the footnote of the sales item for Microsoft is there is any And footnoted returns true if there is a footnote Source returns the D atabase from which the Item Came tf Sales Source Worldscope given the sales number pulled is from Worldscope SourceCode returns the data item code from the Source of the Item WS Cash SourceCode 02003 the source code for Cash in the Worldscope D atabase as provided by Worldscop
5. by nothing or a zero Include one of the following in the options argument to replace data codes N nothing or Z zero or 0 For example PFD L ws sales ws cpa IBM zero Currency Translation is specified by including the 3 character ISO code of the desired target currency in the options argument For example pfdl Sales Y01 T G BP would return the AT amp T annual sales figure for fiscal year 2001 in British Pound Sterling Scale can be specified by entering one of the following values 3 thousands 6 millions 9 billions and 12 trillions or one of the words none thousands millions billions or trillions PFD L ws sales ws cpa IBM 3 Adjusted data can be controlled by one of the following options Adj Adjust share based data for splits or other capital changes or Unadj Do not adjust share based data for splits or other capital changes PFD L ds priceclose ws cpa IBM adj Pad data can be controlled by entering one of the following values Pad Pad market data into nonactive market dates or NoPad Do not pad market data into nonactive market dates 2 Portfolio PFDL Portfolio PFD L will use each constituent entity s data point to run certain statistical calculation and populate only the final result without showing each data points involved 1 tt Syntax is PFD L expression tolerance level set op
6. to visually select an ending cell Choose to have periods decrease or increase and click OK to fill the cells specified B Using AutoFill to fill from multiple cells Select the range of PFD L cells to be copied and extend the selection to include the target range Then right click on the selected range From the Thomson One Analytics 19 context menu choose either Fill Selection Periods Back or Fill Selection Periods Forward AutoFill will immediately begin processing their request If it cannot tell which direction users wish to fill users will be prompted by a screen similar to the following Thomson Analytics Fill Function o Thomson Analytics Fill Function cannot determine which direction you wish to Fill P2 Do you wish to Fill RIGHT and OVERMWRITE cells in the area YES to Fill RIGHT and Overwrite NG to Fill DOW and Overwrite CANCEL to cancel Fill Ves Ho Cancel Once AutoFill knows which direction to fill it will finish processing their request If more than one cell is selected when either the toolbar button is clicked or the AutoFill item is chosen from the Thomson One Analytics context menu AutoFill will prompt users for the period direction with the following dialog box Choose a direction and click OK to continue processing Thomson Analytics Fill Function ki Enter 1 for Backward Periods xk Enter 2 for Forward Periods Ok Cancel 6 Convert Value HE This feature will convert formula sheets
7. without building PFD L formula from scratch Users can choose data items either by selecting new items creating a custom list of data items or by loading a previously saved list of items Users can choose companies either by selecting entities to create their own custom set or by importing a previously saved set from Thomson O ne Analytics Users can also choose to save some or all of the Report Wizard settings to make future extractions fast and easy With Excel open click on the Wizards drop down menu and select Report Wizard The Report Wizard main dialog will appear To load a previously saved project either click the Load Project button to browse for a project file or the Recent Projects button to the right of the Load Project button 28 Thomson OME Analytics Report Wizard a E x Thomson ONE Analytics Report Wizard The Thomson ONE Analytics Report Wizard allows pou to download data and create simple reports directly in Excel Follow the steps below to retrieve your data Current Project Step 1 Select Items Step 2 Select Entities ealan Descr Add Save Entity Marne ds priceclose We sales Ws netncome International Business Machine Corp za Microsott Corp Dell Computer Corp a Oracle Corp ien a Entities Add Edit Items Load Saved Items Add Entities 4 Step 4 Select the Starting Period and Number of Periods Starting Period most recent period Ending Pernod historical pernod F
8. 7 And for Geographic Segment calculation the syntax is PFD L cs G eosegcalc cs entityname 1 1 7 4 8 which return the geographic segment name for the entity in a8 for time period in i7 2 Set Onented Financial Data Language Overview This additional functionality allows users to retrieve data values for a set of companies with only one SFDL formula while maintaining similar syntax to that of PFDL formulas While similar in syntax SFDL and PFDL differ in their intended use PFDL was designed to provide users with a high degree of analytical and computational flexibility within formulas returning one value per formula SFDL on the other hand has been designed as a quick and efficient way to retrieve data items for a large amount of companies returning numerous values for one formula SFDL is different from portfolio PFDL in that SFDL will populate each constituent s data point in one cell and the result of it is a column or row of data points SFDL is more for set component s value display instead of manipulate them into statistical parameter The PFD L function wizard can be found under Wizard Function Wizard on the Excel Addin Menu Bar Function Arguments l 3 x SF L Expression ws CashandSTinvestments kd we CashdndsTinve Period logo i t t lt t isi s i a S yoo DisplayText Peah YS Cash Options hme O M native Direction bom 0 y ja a anf an Il Mo help
9. The Comps Wizard dialog box will appear Load Project To load a different project click on the button Select a D atabase by clicking on the database drop down list Comps Wizard can build three different components which are Reports Charts or Reports and Charts To select one of these options click on the Build Components drop Build Components Reports Charts Reports and Charts down list Under the Base Company Selection enter a base company by typing a ticker key in the text box and press the Enter key or click on the Search button to search for a desired company Under the Peer Selection click on D efault Set to build a peer set of companies that have the same SIC Code and are 5 up down in sales from the base company or click the Build Set button to build a peer set of companies that the user wishes to compare to the base company The Select Set dialog box will appear 26 Select Set Build Set Saved Set Search Enter Company Kep Search Add Peer Selection Max 25 Current 6 QUEBECOR WORLD INCORPORATED COMPAGNIE INDUSTRIALI RIUNITE SFA TOPPA PRINTING CO LTD WNO NY EMAF PLE READER S DIGEST ASSOCIATION INCORPORA Remove Clear All OK Cancel From this box users can choose to build a set by adding entities one by one or bring up a saved set or click on the Search tab to open up the below search window Search Criteria Industry Location Compare to co
10. Thomson One Analytics Excel Add in User Guide Version 2 0 THOMSON ONE BANKER Analytics Eileen Xie 646 822 3544 Eileen xie tin com Thomson Financial 195 Broadway New York NY 10007 Thomson One Analytics Excel Add In Overview 1 Premier Financial Data Language PF DL Overview 1 aMoOOW gt 2 3 Single Entity PFDL Database indicator Expression Argument Item property Period Argument and Data Filling Key Argument Options Argument Portfolio PFDL Index PFDL and Segment PFDL 2 Set Oriented Financial Data Language Overview 1 A B 2 Syntax Display text Direction Execution 3 Time Oriented Financial Data Language Overview 1 MOO gt 2 Syntax Starting Period Ending Period Display Text Add Periods Frequency Execution 4 Menu Bar 1 A B C D 2 3 A B 4 5 Thomson One Analytics button Database title drop down menu HEGamBon gt Options Log in the Excel Add in Upload and Download Portfolio Upload Portfolio Insert Macro Button Compustat Datastream IBES History Disclosure IDC US Pricing Worldscope Application Options Data Options Calculate Auto Fill GN HNAAUBR KR ER SP Q Q _ O XO A Using AutoFill to fill from one cell B Using AutoFill to fill from multiple cells 6 Convert Value 7 Open Website 8 Lookup A Company Indx Lookup B Item Lookup C Set Lookup 9 R
11. available Direction Formula result Help on this Function Cancel 1 Syntax SFDL database expression period displaytext options direction For example SFD L ws Sales Y 98 Sales 1998 right will return the text Sales 1998 After executing the formula it returns a column of year 98 sales numbers for the selected set For database indicator expression period option definition please refer to the PFD L chapter above A Display text This is the printed header text for that column of data Users can put any string in a pair of quotation mark to serve as the column header such as Sales 1998 B Direction Optional If direction is omitted the values are added down This argument can be 66 29 66 up down right or left The values the formula pulls will fill into cells to the Up Down Right or Left of the header cell 2 Execution To execute SFD L Click on the E button for PFDL Formula Calculation x Al Worksheets Activesheet Cancel Selection Data Download SFOL and check the D ata Download SFD L radio button The blow box will pop up Select Set Build Set Saved Set Range Enter Company Fey Search Set Selection Max 5000 Current 0 Remove Clear All OF Cancel 10 T here are three ways of entering the set To build a set by keyin
12. c at Excel Startup Calculate Workbooks on Opening Turning this Feature on means that whenever a workbook that has been enabled to work with OpenClac is opened all PFOL and TFOL Formulas in the workbook will automatically be calculated C Opencalc ON OpenCalc OFF Always Turn OpencCale ON at Excel Startup Enable the current Workbook For OpenCalc Toolbar Options If Hotkeys enabled on toolbar OK Cancel Automatic Calculation will refresh a Thomson One Analytics spreadsheet whenever the Enter key on the Keyboard is hit This is the TA layer of calculation control and the equivalent of the Excel Calculation Option 17 B Data Options Thomson Analytics Data Options E 2 x PFDL Default Options Base Periods FAA Return Values Scale No Scale Thousands i Millions Billions Trilions Retum as HNA C Return az Blank Return as Zero 0 Data Code Return Values Retum Data Code C Return as Blank Retum as Zero 0 CUFFency M Use Native Currency US Dollar Miscellaneous M Adjust share based data for splits and other capital changes M Pad market data into nonactive market dates holidays i Insert cell comments for PFDL error descriptions This window can set the return of data code scale of the Thomson One Analytics value returned default currency translation and miscellaneous issues 4 Calculate When AutoCalc is turned off t
13. e TargetCurrency returns the Currency that the user is translating into WS Sales T argetCurrency USD if their currency translation will be introduced in the Menu Bar Options D ata O ptions section is set to translate everything into USD NativeCurrency returns the Currency in which the data is stored WS Sales N ativeCurrency G BP if the Entity users re running the PFD L expression for is acompany whose data is stored in Ponds ExchangeRate returns the specific Exchange Rate used to translate the Item WS Sales ExchangeRate 1 6300 for the value used to translate from the Native Currency to the Target Currency on that day EntityK ey returns the Entity K ey for the item used to run the FD L expression WS Sales E ntityK ey C000003062 if users ran the expression for Microsoft ScalingFactor returns the Scaling factor used to display the item as defined in the Context WS Sales ScalingFactor 1000000 if the context is set to display all values in Millions Millions is the default value ScalingFactorT ext returns the Scaling factor text representative of the scaling factor used to display the item as defined in the Context WS Sales ScalingFactorT ext Millions if the context is set to display all values in Millions Millions is the default value Period Argument and D ata Filling This argument can be attached to an item name in a pair of square bracket or in the period field It can a
14. ed historical financials Users can get up to 5 years and 8 quarters estimate on EPS sales net income EBIT EBITDA DPS CPS Earning before G oodwill etc including individual analyst s information and consensus statistics E IBES History This database has captured historical monthly estimate on EPS F Disclosure With as reported US and ADR s quarterly and annual financials It has weekend price close information G Thomson Financial This is a pool of about 1 000 most frequently used items from all the other databases running on Thomson O ne Analytics It has a hierarchy that will search though other databases for a matching value This is the default database H IDC US Pricing This is another out sourced database from IDC that provides daily pricing info for only US and ADR companies I Worldscope With global coverage it provides standardized annual financials and monthly pricing data It also has quarterly sales dividends EPS shares outstanding etc This is the default database for financial statement reports a Application Options w Data Options ai TA Office Options Options are used to set the context of the platform and data contents of Thomson One Analytics 16 A Application O ptions Thomson OME Analytics Application Options a a x Automatic Calculation Retrieve data only when calced manually From toolbar button or right click menu Always turn calculation to Automati
15. ei Wali rT i i M EALE er Patioa FE 12014 2 hjani Pika Ei ie G ppe Magin 601 Co Ratio 5 TO het Petar gins D28 DebtEpiiy SH 11 ie 255 imi Coverage 12 Chshare Jaw PER SHARI areas fe bare AAN eS a aay sea off azsa E COME STATEMENT dMilieers 2 Biet Si io ape kag epee keg Dec pbk dagin cid Api 177 280 00 ITE 25800 a ceed oj Cas Sool Fo oo 00 Ta Egi 0i m Seir ai Ainin Experdes 2A tdi FFER 2 amalin 5 Dor eNi 1220600 12 24 6 00 AT Oper iry noc 1065300 16 787 0 aT iire Exper 8 30 00 7 0 00 Sco income i iein g cT o TINNI 25 10 Wizard Thomson One Analytics Wizards enable users to build an analysis easily Comps Wizard Function Wizard Price Wizard Function Wizard PFDL fx Function Wizard SFDL E Report Wizard Function Wizard TEDL cra Searching Wizard A Comps Wizard Comps Wizard is used to compare a base company to a set of peer companies Users can select comparable companies by using the system default query to find peer set adding entities one by one to create their own custom set or importing a previously saved set from Thomson One Analytics web server There are pre built reports and charts as well as the features to create user defined snapshot reports by selecting items that are interested Click on the Wizard drop down menu on the Thomson One Analytics toolbar and select Comps Wizard
16. eports 10 Wizard A Comps Wizard B Report Wizard C Price Wizard D Searching Wizard Thomson One Analytics Excel Add In Overview The Thomson One Analytics Excel Add In is probably one of the most valuable features that Thomson One Analytics offers its users Using the Add In financial analysts can pull data directly into Excel from a wealth of financial databases such as Worldscope Compustat U S Pricing First Call I B E S History and Extel using the powerful PFD L Premier Financial D atabase Language SFD L Set Financial D atabase Language and TFD L Time series Financial D atabase Language syntax Users can easily create modify and save customized reports to serve their specific needs The Company Index Lookup and Item Lookup features available in the Add In allow users to perform fast searches through literally thousands of companies and financial data items Users can also take advantage of more than 50 Income Statements Cash Flows Balance Sheet Earnings and Overview reports that have been pre built and reside in the Thomson One Analytics Excel Add In Reports Library The Thomson O ne Analytics toolbar allows users to take advantage of all the Add In s features 1 Premier Financial Data Language PFD L Overview Thomson One Analytics features the Premier Financial D ata Language PFD L a proprietary financial language designed to support financial database access This language gives Thomson One
17. g in identifiers one by one Bring up a saved set on the web server or specify a cell range on the spreadsheet After using the Add button to add entities into the Set Selection window users can further editing the set by removing some companies then clicking on OK to execute 3 Time Oniented Financial Data Language Overview This additional functionality allows users to retrieve a series of data values across a period of time with only one TFD L formula while maintaining similar syntax to that of PFD L formulas TEDL has been designed as a quick and efficient way to retrieve a data item across a period of time returning numerous values for one formula The TFDL function wizard can be found under Wizard Function Wizard on the Excel Add in Menu Bar Function Arguments a i 2 TFOL StartPeriod 049 s 2001 EndPeriod m9 0000 Afe IO Key a 0 ja m DisplayText Down o yN Down ma of Options ies native Down Mo help available Options Formula result Down Help on this Function Cancel 1 Syntax TFDL database expression startperiod endperiod key displaytext options direction addperiods frequency For example TFDL TF Volume DBCPD 1Y B 2 Volume NAN none DOWN 0 will return text Volume in the cell After executing the formula it 11 returns a co
18. h of the set into a cell i e eileenx 22companies set Users then can run calculation based on this cell by using cell reference for example PFD L saverage ws sales Y 2002 amp E16 amp This example will return the average sales number for the set 24 iiz Company Full Report Ei Company Chark Summary Reports Library Balance Sheet Reports C Open PFDL Workbook Cash Flow Reports Income Statement Reports WiSBusinessSegmentheview WS CashFlawStmtIndustrialniversalwvEB Portfolio Reports j Wy SGeographiccegmentheview Ratio Reports wWSIncomeStmtTrendIndustrialw EB This is the store of pre build and formatted reports Users can use it for sample PFD L expressions and run the reports for data research purposes Below is screen shot of a sample report User can change the ticker in cell F4 and run data for another company sH Mc rosoft Gael YS Compa Tear shert Won Ream a P A olf i Ble dt yes Jest Foma ok Daa ibindeay Help Thorson Fisi Cal Unk Types a question for help AERE ans u als E ee eee 2 See ee ee Da Fa ta ba Th to z Wy ei hens n Change Thoreon ONE Analstics Thorson Finencal phones mali Lookup Pepats Wiwi oF _ Fee Ach E Sa ta a i ae ey Company Tearsheet Enter Tioiarki j Beeont Brice Pe Batis Dr Yid i5 otal Aeburm i Wr Pri oo oo sm uw m a Eaemamgo ANSE e ao e Rete oae oe eee A mi HIS Mmk
19. his is the button to use to run the spreadsheet It has four choices PFDL Formula Calculation 2 x fall worksheets Activesheet Cancel Selection Data Download SFOL Please refer to SFD L chapter execution section for D ata D ownload feature 5 Auto Fill pa A Using AutoFill to fill from one cell To access the AutoFill function click on the source cell and click on the above button or Right click on the source cell and select the AutoFill menu item from the Thomson One Analytics context menu Thomson Analytics AutoFill Starting Cell e2 Starting Cell Formula pfdif wa sales y2001 ibm Cells to Fill Ending Cell Please enter the number of cells to fill E Fill Down Fill Right Number of Cells fil C FilUp Fill Left Periods go back in time Periods go foward in time Cancel After clicking AutoFill with a single source cell selected the A utoF ill dialog appears The selected cell s address and PFD L formula show at the top of the dialog There are two ways to specify a target range using the AutoFill dialog One is to use the Cells to Fill tab above specify the number of cells to be filled and the direction in which to fill AutoFill knows where the active cell is located and will warn users if users enter a number that would put the ending cell outside of the worksheet boundaries The other is to use the Ending Cell tab enter an ending cell address or
20. ieve Down Retrieve Right Cancel Choose Starting sell Fill D own Right then use the Browse button to open the user s web folder name the set and save 14 D Insert Macro Button InsertButton d Calculation Buttons CalcPFOL Button a Company Lookup Button J Calc Workbook Button da Item Lookup Button Cale Worksheet Button Calc Selection Button CalcSFOL Button This feature will help users to insert a Macro button automatically into a spreadsheet with the functions illustrated by the button s name 2 Database title drop down menu Thomson Financial This window shows all the databases an account has access to The default is Thomson Financial database A Compustat O ut sourced from S amp P It provides standardized US and Canadian and AD R s annual and quarterly financials It also has S amp P domestic index data and some business segment and geographic segment data Month end price close high low is available B Datastream Pricing database It does not have any financials However it has each currently trading companies price close high low trading volume PE etc on a daily bases It has global coverage and users can also get data at the index issue and quote level C Extel Financials It provides as reported global companies financials Has a strong coverage for European companies 15 3 D First Call Global coverage with analyst s estimate With limit
21. into value sheets and keep the charts and format By clicking on the above button the below box will open Convert Formulas To alues x C Activesheet Cancel Selection I Values are added to new Workbook 20 Selecting an area and Convert 7 Open Website ry This button will lunch the website 8 Lookup Fa Company Index Lookup He Item Lookup Lan Set Lookup A Company Indx Lookup Thomson OME Analytics Entity Lookup Lookup Search For Company By entityName search Option contains thomsen st Search Results Page 1 of 1 9 Found Entity Mame Quote Symbol CUSIP Sedol Karl Thomson Holdings F HE 6267476 EK Mippon Thompson Company Limited 6480 TO 6643562 JR Thales HO FR 4162791 Fit Thales ADR THLEY oo LOO 2160 75 oy Thomson T MS FF S9889S0 FT Thomson ADF TMS 00o 18109 2515656 LT Thomson Corp Toc ooF903105 eo ds l LT Thomson Intermedia PLE THM L 0412605 THI THOMSON 54 aa First Previous ext Last Close 21 The Company Index Lookup is a very convenient and fast way to perform text searches for a company or index Users can search by entity name CUSIP Sedol Valor ISIN Entity Key and etc On Thomson One Analytics the Entity K ey has the following format Index I plus 9 digits for example 000000001 is for S amp P 500 Company C plus 9 digits for example C000067102 is Thomson ADR Issue
22. k and worksheet to place the report set Report Heading Options and Set Cell O ption Click on Finish to see the report display C Price Wizard Price Wizard is used to build a report with daily pricing data for both indexes and companies Selecting items first then adding entities into the main area setting time series Currency and Finish to complete the report 30 Thomson Analytics Price wizard om E M _ a NIKKEI 500 Thomson Corp D Searching Wizard The Thomson ONE Analytics Searching Wizard allows analysts to create queries and then run comp report for companies resulted from the queries Users can choose from over 10 000 quantitative and qualitative screening items to identify specific companies and then display those results directly in their custom Excel models Clicking on Searching Wizard opens the below window 31 Step 1 Searching Rules _ x Select Item to Search On Data Items For Search For Item Worldscope oe profitmar GrossProfitMargin H E Accounting Practices GrossProfitMargins tr v ff ADRIGAAP Specific Items E E Company Information E E Earnings Information E E Financial Statement Information l a Foreign Business iw Foreign Exchange Rates E Fundamental Patios 6 Growth Rates HE Interim Data oof Key Items in USD B Segment Data 0 Stock Data fq Stock Performance OperatingProfitMargin OperatingProfitMarginSY rwg Searching Criteria Start wi
23. lso be a cell reference Standard period argument formats are Absolute periods such as Y 2001 Y01 Q 3Y 2001 Q 3Y 2002 Jan2002 Jan02 31Mar2002 31Mar2002 Relative such as database specific period Oy 0q Om Ow 0d 1y 6m 260d Company specific period cpa current period annual cpg current period quarterly cpm current period monthly cpw cpd cpa 1 cpq 4 cpd 1m same day one month ago cpd ly same day one year ago When period is omitted it uses the default database time For example PFD L usp priceclose 29N ov02 IBM pulls the same data points as PFD L usp priceclose 29Nov02 IBM When using cell reference in an amp need to be used for converting the date into a text format such as PFD L usp priceclose amp C1 amp IBM While in the period field the amp is not needed such as PFD L usp priceclose C1 IBM D ata Filling function can be activated by going to O ptions D ata O ptions D ata Filling Thomson OME Analytics Data Options a a x Data Options Data Filling Base Periods Automatically return the value From the most Frequent data period available For example if both a quarterly and annual time series is available take the data From the quarterly time series concel The existence of D ata Filling simplifies the use of the period argument in that it enables users to apply the same time period and forma
24. lumn of daily trading volume for a whole year starting from the most resent date for the company in cell B2 A Starting Period Required Starting period for which the expression is to be evaluated B Ending Period Required Ending period for which the expression is to be evaluated C Display Text Optional String value returned to the cell that contains the TFD L formula If Display Text is omitted the Expression is used as the return value D Add Periods Optional String containing whether periods are to be added before or after the data or not at all If it is omitted periods are not added This argument can be none before or after E Frequency O ptional String containing the frequency for which the report should be run If it is omitted the server determines the proper frequency based on the starting and ending period sent The frequency argument is only effective with a daily starting period 1 tt N tt otherwise it is ignored This argument can be annual quarterly monthly weekly or daily 2 Execution Execute as PFD L calculation 4 Menu Bar Thomson ONE Analytics Thomson ONE Analytics Databases Options Gni Aem EA Lookup Reports Wizards a 12 Thomson One Analytics button Thomson ONE Analytics pions H Calc PFDL t AutoFill cea Convert Formulas To Values InsertBukton ef Lookup Reports Wizards Upload Portfoli
25. mpanies within TOL s County Code Region State Compare to companies within TOC s C Dow Jones Industry Group C Dow Jones Market Sector in any industry i in any region country or stake Financial Comparison All companies whose Sales M Exclude ALR M Active companies only E is within gt OF THOMSON CORPORATION THE is within 5 companies above or below of THOMSON CORPORATION THE Click on the Next button to select which reports charts users would like to build 27 Thomson Analytics Comps Wizard Step 4 Select Predefined Reports and or Custom Report Predefined Reports Custom Report Reports an l Market Data Balance Sheet Margins Select All F Yaluation Analysis Balance Sheet 1 r Growth l l Clear All M Kep Financials T Income Statement T Key Margins T Income Statement Margins T Key Ratios D Income Statement 1 r Growth Balance Sheet T Cash Flow statistics Industry Geographic Statistical Functions Included with Reports where appropriate gd Mee Select All MW Median M Market Share Clear All a Load Project Save Project Cancel lt Back laar Users can choose from the Predefined Reports or go to Custom Report to select items Then click on the Finish button to build the reports that were selected B Report Wizard The Thomson One Analytics Report Wizard allows users to download data and create simple reports directly in Excel
26. o Download Portfolio Login Info ChangeProjectCode kb bh Thomson ONE Analytics Help About This drop down menu is a get together of the rest of the menu bar and more A Login the Excel Add in allooi mon After installing the add in bar check Login Info to make sure using the correct ID and Password This is to enable the user to access the data server and also the web folder the user has controlled by the same ID and Password B Upload and Download Portfolio E Download Portfolio Users can download a set from the web into spreadsheet format and save it locally A set needs to be saved online before downloading To download portfolio click on the item the below box will appear 13 Download Portfolio E Porfolio Mame amp Location Worksheet Options Starting cell A a Fill Down Sw Fil Right Use the Browse button for sets saved online and choose Starting sell Fill D own Right and OK to start the download Two columns of information will fill into Excel TA Entity Code and Company Ticker Upload Portfolio ide Upload Portfolio Users can also upload a list of Tickers TA Entity Code Sedol Valor ISIN etc from Excel onto the their exclusive web folder and save it online To upload portfolio click on the item the below box will appear Upload Portfolio E x Forfolio Mame amp Location worksheet Options Starting cell A E Retr
27. requency End of Last Month DBCPM E fi Tear gol 1 r E Year Load Project Save Project Clear Settings Cancel Back Hest gt Starting Period Ending Period and Frequency are used when series of historical data needs to be pulled Click on the Next button for the report layout options 29 Thomson Analytics Report Wizard Worksheet Options Data Options Program Options Step 5 Set Worksheet Options Not Required Set Cell Options Select Where to Place Results Set Report Heading Options E Active Workbook M Them Headings f Values Only Active Worksheet I Entity Names Values and Formulas New Worksheet W Default Keys Hew workbook M Curency S ource Select How to Arange Report Cavout Options arouo By Entity Entities Down Pernods Side By Side One ltem per Sheet One Entity per Sheet Group By ltem Entities Across Items Side By Side Group By ltem Entities Down Pernods Side By Side Group By Entity Entities Across Entity tems In Sane Column Group By Entity Entities Across lems Side By Side Group By Entity Entities Down Pernods Side By Side Group By Entity Entities Down Entity Items In Same Aow Group By Period Entities Across Entities Side By Side Values Only Group By Pernod Entities Down tems Side By Side Values Onl Load Project Save Project Clear Settings Cancel lt Back Hest gt Eimer Users can choose the workboo
28. t to pull data with different reporting frequencies For example tf priceclose 30Mar03 will return the price close of that day and tf sales 30Mar03 will return the quarterly revenue as of the date Key Argument Thomson One Analytics will search through the Entity Key Ticker CUSIP SEDOL ISIN and VALOR to determine the entity to be accessed If the key value entered does not match any of those standard keys Thomson O ne Analytics returns a key not found error Users can use pfdl ws sales y2001 IBM or replace ticker IBM with the CUSIP 741903108 SEDO L 2005973 or Entity Key C000002474 F Options Argument This argument is a string value made up of the options to be applied to the calculation and result The option argument when omitted the options setting which will be introduced later in the Menu bar section is effective When not omitted it overwrites the options setting The general syntax of the options within the string is shown below option optionz where each option in the string is separated from the next option by acomma The following sections show the short and complete forms used for each option For example PFD L ws sales ws cpa 1IBM zero 3 jpy returns IBM s most recent annual sales in Japanese Y en JPY in thousands 3 and if the result is NA return 0 instead zero Data Codes such as NA CF etc can be replaced
29. th Active Companies Start with Item Expression Operator Value W S CurrentMarkebCap gt 1000 W S OperatingProfitMargin 2 Custom Clear Lisk Back Cancel Users can add criteria by double clicking on an item to open the query criteria builder 32 Seach Expression x Item Expression W5 Asset Turnover Relationship to Value concel_ When query is build click on the Next button to proceed to the next step Selecting report items Again users double click on an item to add it to the report Click on the Finish button to execute the report 11 Help e Users can select help topic and content from the below window for information as to how to use Thomson One Analytics Add in Thomson Analytics Excel Addin Hide Back Forward Stop Refresh Print Options Contents Index Search Report Wizard pansa Tt Be tte T lt T T YS Worksheet H Thomson Analytics Toolbar Options H Company Lookup m term Lookup PFDL Premier Financial Dai peels ee au l l may choose where to ce SPOL Set Oriented Financte place your results ce TFOL Time Series Financial report heading options H Function Glossary cell options and how to Ee Thomson Analytics AutoFill arrange your items and H Currency Codes entities H LX Global Exchange List H Comps Wizard Eg Report Wizard J The Report Wizard Worksheet Optior tem Selection Step 5 oe
30. tions The set can be the name of a saved set under the user ID and Password a string of hard coded identifiers or a string of cell reference For example PFD L ssum tf totalassets cpal IBM msft csco jpy where IBM MSFT and CSCO are entity identifiers PFD L saverage ds priceclose 0d ds priceclosel 1d amp al amp amp a2 amp amp a3 amp where al a2 and a3 has entity identifiers in them PFD L SA verage ws sales 0 amp B 1 amp where cell b1 has the name of a saved set on the web server under the user ID and Password Tolerance level means the percentage of NA tolerated in the set of value used in the calculation When it was set as 10 the calculation will run only when more than 90 of the data points are values instead of data codes 3 Index PFDL and Segment PFDL y t For Index the Syntax is PFD L database indicator expression surfix period Entitykey index options For example PFD L ds priceclose 0d I000000001 index where 1000000001 is the Thomson One Analytics entity key for S amp P 500 index When using cell reference it is A1 amp index For Business Segment calculation the syntax is PFD L cs bussegcalc cs entityname 1 1 7 4 8 which return the business segment name for the entity in a8 for time period in i

Thomson One Analytics Excel Addin User Guide

Contents

Download Pdf Manuals

Related Search

Related Contents