{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["EventStudy","Input","REQUEST_TABLE"],"not_rendered":{"charts":0,"images":32,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"EventStudy","index":0,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[41,10,42,15],[43,10,44,15],[20,8,22,15],[24,8,25,15],[26,8,27,15],[28,8,28,15],[30,8,30,15],[36,8,36,15],[16,8,18,15],[0,7,0,15],[3,8,3,15],[6,8,8,15],[10,8,11,15],[13,8,14,15]]}
["Estimation window from",null,null,null,null,null,null,"Manual"]
["to",null,null,null,null,null,null,null,null,"* More detailed manual (in English) can be downloaded at: http://www.eur.nl/edsc/english/tools/"]
["Event window from"]
["to",null,null,null,null,null,null,null,"---------------------------------------- Step 1: Fill in the query form in this sheet ----------------------------------------"]
["DataType","P#T"]
[null,null,null,null,null,null,null,null,"What's your estimation window?"]
["Company","Date","Index",null,"IndexName","IndexCode",null,null,"Estimation window is the period over which the normal return is calculated. It's common to use the period prior to the event as the estimation window. For example, if you want to estimate over 120 days before the event, you can fill in -121 and -2 for \"Estimation window from\" and \"to\", respectively. "]
["UK2553568","2007-09-05",1,null,1,"S&PCOMP"]
["UK2016180","2007-07-23",1]
["UK2692740","2007-07-17",1,null,null,null,null,null,"What's your event window?"]
["UKB1313R4","2007-06-11",1,null,null,null,null,null,"Event window is the period over which the event happens. For example, if your event window is (-1, 1), then for items \"Event window from\" and \"to\" you need to fill in -1 and 1, respectively."]
["UK2350521","2007-03-19",1]
["UK2596604","2007-02-07",1,null,null,null,null,null,"What variable do you want in your query?"]
["UK2436562","2007-01-07",1,null,null,null,null,null,"Normally, we use stock price for event study. The code for stock price \"P#T\" is already filled in for you. If you need something else than stock price, please check Datastream Navigator for the code."]
["UKB0VTVH9","2006-09-22",1]
["UK2395072","2006-09-20",1,null,null,null,null,null,"What companies do you want in your query?"]
["UK2368193","2006-08-28",1,null,null,null,null,null,"Under item \"Company\", please fill company codes as a column. Only the following codes can be used in this tool: ISIN, SEDOL, DSMnemonic, and DSCode. Some codes are filled in under this column to show you an example. Please replace them with your own codes."]
["UK2179221","2006-07-08",1]
["UK2681403","2006-07-06",1]
["UK2490502","2006-06-23",1,null,null,null,null,null,"What are your event dates?"]
["UK2954558","2006-06-22",1,null,null,null,null,null,"Under item \"Date\", please fill a list of event dates as a column. Please make sure that the list is in the format which can be recoganized by Excel as dates. Some codes are filled in under this column to show you an example. Please replace them with your own codes."]
[]
[]
[null,null,null,null,null,null,null,null,"Do you need market index?"]
[null,null,null,null,null,null,null,null,"No, I don't need a market index. Fill in 1 for the column \"Index\" as shown in the example and ignore \"IndexName\" and \"IndexCode\". "]
[]
[null,null,null,null,null,null,null,null,"Yes, I need one index.  (a) Fill in 1 for the column \"Index\"; (b) Fill in the Datastream code for the index under \"IndexCode\" as shown in the example. The code in example is for S&P 500 index."]
[]
[null,null,null,null,null,null,null,null,"Yes, I need multiple indicies. Check for more detailed manual online at the website given above."]
[]
[null,null,null,null,null,null,null,null,"------------------------------------------------------- Step 2: Submit query  -------------------------------------------------------"]
[]
[null,null,null,null,null,null,null,null,"1. Save this file on the hard disk of the computer."]
[null,null,null,null,null,null,null,null,"2. Change macro security in Excel: click the button options > Mark Enable and click OK"]
[null,null,null,null,null,null,null,null,"3. Go to Excel sheet \"REQUEST_TABLE\" and press the button \"Process Table\""]
[]
[null,null,null,null,null,null,null,null,"------------------------------------------------------- Step 3: Read the output ------------------------------------------------------- "]
[]
[null,null,null,null,null,null,null,null,"In Excel sheet \"Esoutput1\", you'll find the following items:"]
[null,null,null,null,null,null,null,null,"Name",null,"Identifier of the company"]
[null,null,null,null,null,null,null,null,"EventDate",null,"The event date you entered for "]
[null,null,null,null,null,null,null,null,"EstimationDate0",null,"One day before your estimation window starts. You might need it to calculate the return on the first day of your estimation window."]
[]
[null,null,null,null,null,null,null,null,"EvaluationDate0",null,"One day before your event window starts. You might need it to calculate the return on the first day of your event window."]
[]
[null,null,null,null,null,null,null,null,"PriceEstDay0",null,"Closing price on EstimationDate0 "]
[null,null,null,null,null,null,null,null,"PriceEvlDay0",null,"Closing price on EvaluationDate0 "]
[null,null,null,null,null,null,null,null,"IndexEstDay0",null,"Index price on EstimationDate0 "]
[null,null,null,null,null,null,null,null,"IndexEvlDay0",null,"Index price on EvaluationDate0 "]
[null,null,null,null,null,null,null,null,"* In sheet \"Esoutput1\", each column contains information for one company. "]
[null,null,null,null,null,null,null,null,"* If you have more than 255 firms, you'll also get a sheet \"Esoutput2\" for next 255 firms, and so forth."]
[null,null,null,null,null,null,null,null,"* Number of days refers to trading days not calendar days."]

{"sheet":"Input","index":1,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Series","DataTypes","StartDate","EndDate","Frequency"]

{"sheet":"REQUEST_TABLE","index":2,"n_rows":1499,"n_cols":26,"rows_kept":1499,"cut":false,"hidden":false,"merged":[[4,11,5,11],[4,12,5,12]]}
[]
["3.0.14.30"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"     Last Refreshed: "]
[null,"Update","Request Type","Format","Series Lookup","Datatype/Expressions","Start Date","End Date","Freq","Reserved for Chart Name",null,"Status","Description",null,null,"Statistics",null,null,null,"Sequencing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rows","Cols","Total","Started","Finished","Duration"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REQUEST_TABLE"]