Spreadsheet: 804492d1668100659-looking-for-the-correct-formula-to-retrieve-the-data-test-car-252-
Sheet: Sample

 |  |  |  |  | CAR(252) (T0) - (T+252)
Item | Stock code | Company name | Date of Announcement |  | Cumulative abnormal return
1 | 1046 | Universe Entertainment and Culture Group Company Limited | 2021-11-04 00:00:00
1C | 571 | eSun Holdings Limited
2 | 8635 | Novacon Technology Group Limited | 2021-11-01 00:00:00
2C | 8205 | Shanghai Jiaoda Withub Information Industrial Company Limited
3 | 1421 | Kingbo Strike Limited | 2021-10-22 00:00:00
3C | 1343 | Wei Yuan Holdings Limited
4 | 1172 | Magnus Concordia Group Limited | 2021-10-18 00:00:00
4C | 1232 | Golden Wheel Tiandi Holdings Company Limited
5 | 1716 | Most Kwai Chung Limited | 2021-10-15 00:00:00
5C | 8401 | Stream Ideas Group Limited
6 | 8609 | Eggriculture Foods Limited | 2021-10-12 00:00:00
6C | 969 | [NAME] (Holding) Company Limited
7 | 1536 | YUK WING GP | 2021-10-05 00:00:00
7C | 8152 | M&L Holdings Limited
8 | 1255 | TATA Health International Holdings Limited | 2021-09-30 00:00:00
8C | 676 | Pegasus International Holdings Limited
9 | 6933 | Sino-Entertainment Technology Holdings Limited | 2021-09-29 00:00:00
9C | 536 | Tradelink Electronic Commerce Limited
10 | 2263 | [NAME] | 2021-09-27 00:00:00
10C | 3678 | Holly Futures Company Limited
11 | 1701 | [NAME] | 2021-08-24 00:00:00
11C | 8668 | Ying Hai Group Holdings Company Limited
12 | 8069 | WWPKG Holdings Company Limited | 2021-08-17 00:00:00
12C | 1235 | Travel Expert (Asia) Enterprises Limited
13 | 451 | GCL New Energy Holdings Limited | 2021-07-15 00:00:00
13C | 1798 | China Datang Corporation Renewable Power Co., Limited
14 | 812 | Southwest Securities International Securities Limited | 2021-07-08 00:00:00
14C | 6877 | CLSA Premium Limited
15 | 3390 | Tycoon Group Holdings Limited | 2021-06-18 00:00:00
15C | 2633 | Jacobson Pharma Corporation Limited
16 | 8111 | China Technology Industry Group Limited | 2021-05-10 00:00:00
16C | 841 | Asia Cassava Resources Holdings Limited
17 | 712 | Comtec Solar Systems Group Limited | 2021-03-15 00:00:00
17C | 1399 | Veson Holdings Limited
18 | 1260 | Wonderful Sky Financial Group Holdings Limited | 2021-03-19 00:00:00
18C | 3623 | China Success Finance Group Holdings Limited
19 | 498 | PYI Corporation Limited | 2021-03-01 00:00:00
19C | 301 | SANVO Fine Chemicals Group Limited
20 | 442 | Hifood Group Holdings Co., Limited | 2021-02-25 00:00:00
20C | 2882 | Hong Kong Resources Holdings Company Limited
21 | 8019 | [NAME] | 2021-01-22 00:00:00
21C | 8452 | FY Financial (Shenzhen) Co., Ltd
22 | 61 | Green Leader Holdings Group Limited | 2021-01-20 00:00:00
22C | 1229 | Nan Nan Resources Enterprise Limited
23 | 182 | Concord New Energy Group Limited | 2020-11-20 00:00:00
23C | 1811 | CGN New Energy Holdings Co., Ltd
24 | 2218 | Yantai North Andre Juice Co., Ltd. | 2020-10-23 00:00:00
24C | 2119 | CK Life Sciences Int'l., (Holdings) Inc.
25 | 2222 | NVC International Holdings Limited | 2020-10-14 00:00:00
25C | 2023 | China Ludao Technology Company Limited
26 | 8400 | Asia Pioneer Entertainment Holdings Limited | 2020-09-10 00:00:00
26C | 70 | Rich Goldman Holdings Limited
27 | 3395 | Persta Resources Inc. | 2020-08-28 00:00:00
27C | 81 | China Overseas Grand Oceans Group Limited
28 | 643 | Carry Wealth Holdings Limited | 2020-07-31 00:00:00
28C | 8521 | ST International Holdings Company Limited
29 | 3836 | China Harmony Auto Holding Limited | 2020-07-17 00:00:00
29C | 1293 | Baoxin Auto Group Limited
30 | 3389 | Hengdeli Holdings Limited | 2020-05-07 00:00:00
30C | 389 | Oriental Watch Holdings Limited
31 | 8050 | Quantum Thinking Limited | 2020-04-14 00:00:00
31C | 1402 | i-Control Holdings Limited
32 | 8297 | My Heart Bodibra Group Limited | 2020-03-31 00:00:00
32C | 8507 | i.century Holding Limited
33 | 600 | China Infrastructure Investment Limited | 2020-03-20 00:00:00
33C | 2178 | Petro-king Oilfield Services Limited
34 | 252 | Southeast Asia Properties & Finance Limited | 2020-02-26 00:00:00
34C | 1127 | Lion Rock Group Limited
35 | 875 | China Finance Investment Holdings Limited | 2019-12-19 00:00:00
35C | 1340 | Huisheng International Holdings Limited
36 | 1212 | Lifestyle International Holdings Limited | 2019-11-11 00:00:00
36C | 3308 | Golden Eagle Retail Group Limited
37 | 668 | Doyen International Holdings Limited | 2019-09-30 00:00:00
37C | 8439 | Somerley Capital Holdings Limited
38 | 1742 | HPC Holdings Limited | 2019-08-16 00:00:00
38C | 1447 | SFK Construction Holdings Limited
39 | 2886 | Binhai Investment Company Limited | 2019-06-24 00:00:00
39C | 2337 | United Strength Power Holdings Limited |  |  |  | <---------- return the sum of return of T-1, T+0, T+1 (from S column in the '1636' tab, return the sum of S838:S840 )
40 | 727 | Crown International Corporation Limited | 2019-05-08 00:00:00
40C | 29 | Dynamic Holdings Limited
41 | 2225 | Kakiko Group Limited | 2019-04-25 00:00:00
41C | 6819 | IntelliCentrics Global Holdings, Ltd.
42 | 1323 | Newtree Group Holdings Limited | 2019-03-15 00:00:00
42C | 202 | EverChina International Holdings Company Limited
43 | 335 | Upbest Group Limited | 2019-03-05 00:00:00
43C | 993 | Huarong International Financial Holdings Limited
44 | 1246 | Boill Healthcare Holdings Limited | 2019-02-22 00:00:00
44C | 9 | KEYNE LTD
45 | 8162 | [NAME] | 2019-01-25 00:00:00
45C | 1712 | Dragon Mining Limited
46 | 733 | Hopefluent Group Holdings Limited | 2019-01-04 00:00:00
46C | 108 | Riverine China Holdings Limited
47 | 931 | China LNG Group Limited | 2018-12-20 00:00:00
47C | 1205 | CITIC Resources Holdings Limited
48 | 1372 | Bisu Technology Group International Limited | 2018-12-14 00:00:00
48C | 1559 | Freetech Road Recycling Technology (Holdings) Limited
49 | 185 | ZH International Holdings Limited | 2018-12-07 00:00:00
49C | 1321 | China New City Commercial Development Limited
50 | 1636 | China Metal Resources Utilization Limited | 2018-11-21 00:00:00 |  |  | Step 1: Retrieve the 253 days return data from the relevant stock code tab (like '1636'!S:S)
50C | 2600 | Aluminum Corporation of China Limited
51 | 704 | Huscoke Resources Holdings Limited | 2018-11-15 00:00:00
51C | 702 | Sino Oil and Gas Holdings Limited
52 | 871 | China Dredging Environment Protection Holdings Limited | 2018-10-31 00:00:00
52C | 8523 | Kingbo Strike Limited
53 | 911 | Qianhai Health Holdings Limited | 2018-10-19 00:00:00
53C | 932 | Shunten International (Holdings) Limited
54 | 1621 | Vico International Holdings Limited | 2018-09-26 00:00:00
54C | 632 | Pearl Oriental Oil Limited
55 | 8296 | Sino-Life Group Limited | 2018-08-15 00:00:00
55C | 193 | Capital Estate Limited
56 | 370 | China Best Group Holding Limited | 2018-07-20 00:00:00
56C | 1143 | China Healthcare Enterprise Group Limited
57 | 1470 | Prosper One International Holdings Company Limited | 2018-07-03 00:00:00
57C | 513 | Continental Holdings Limited
58 | 122 | Crocodile Garments Limited | 2018-06-25 00:00:00
58C | 3322 | Win Hanverky Holdings Limited
59 | 1124 | Coastal Greenland Limited | 2018-05-18 00:00:00
59C | 313 | Richly Field China Development Limited
60 | 164 | China Baoli Technologies Holdings Limited | 2018-04-19 00:00:00
60C | 921 | Hisense Home Appliances Group Co., Ltd.
61 | 627 | Fullsun International Holdings Group Co., Limited | 2018-01-15 00:00:00
61C | 1243 | WANG ON PROPERTIES LIMITED
62 | 39 | China Beidahuang Industry Group Holdings Limited | 2017-12-29 00:00:00
62C | 97 | HENDERSON INVESTMENT LIMITED
63 | 721 | CHINA FINANCIAL INTERNATIONAL INVESTMENTS LIMITED | 2017-12-27 00:00:00
63C | 129 | ASIA STANDARD INTERNATIONAL GROUP LIMITED
64 | 397 | [NAME] Financial Holdings Limited (Power Financial Group Ltd) | 2017-12-20 00:00:00
64C | 431 | Greater China Financial Holdings Limited
65 | 1010 | PacRay International Holdings Limited | 2017-11-21 00:00:00
65C | 2166 | Smart-Core Holdings Limited
66 | 899 | Asia Resources Holdings Limited | 2017-11-06 00:00:00
66C | 287 | WINFAIR INVESTMENT COMPANY LIMITED
67 | 641 | CHTC FONG’S INDUSTRIES COMPANY LIMITED | 2017-10-27 00:00:00
67C | 31 | CHINA AEROSPACE INTERNATIONAL HOLDINGS LIMITED
68 | 8295 | ZZ CAPITAL INTERNATIONAL LIMITED | 2017-10-13 00:00:00
68C | 1290 | China Huirong Financial Holdings Limited
69 | 8082 | SAGE INTERNATIONAL GROUP LIMITED | 2017-10-04 00:00:00
69C | 8220 | Bingo Group Holdings Limited
70 | 65 | Grand Ocean Advanced Resources Company Limited | 2017-09-27 00:00:00
70C | 866 | China Qinfa Group Limited
71 | 1682 | HIGHLIGHT CHINA IOT INTERNATIONAL LIMITED | 2017-08-31 00:00:00
71C | 518 | TUNGTEX (HOLDINGS) COMPANY LIMITED
72 | 200 | Melco International Development Limited | 2017-07-25 00:00:00
72C | 1076 | Imperial Pacific International Holdings Limited
73 | 352 | Fortune Sun (China) Holdings Limited | 2017-07-10 00:00:00
73C | 2310 | Times Universal Group Holdings Limited
74 | 601 | Group Sense (International) Limited | 2017-06-20 00:00:00
74C | 8007 | Global Strategic Group Limited
75 | 485 | China Sinostar Group Company Limited | 2017-06-01 00:00:00
75C | 2288 | Rykadan Capital Limited
76 | 279 | FREEMAN FINTECH CORPORATION LIMITED | 2017-04-28 00:00:00
76C | 6178 | Everbright Securities Company Limited
77 | 1341 | CLEAR LIFT HOLDINGS LIMITED | 2017-04-07 00:00:00
77C | 558 | L.K. Technology Holdings Limited
78 | 794 | COME SURE GROUP (HOLDINGS) LIMITED | 2017-03-06 00:00:00
78C | 8191 | [NAME] (ASIA) HOLDINGS COMPANY LIMITED
79 | 1297 | SINOSOFT TECHNOLOGY GROUP LIMITED | 2017-02-21 00:00:00
79C | 1206 | TECHNOVATOR INTERNATIONAL LIMITED
80 | 989 | GROUND INTERNATIONAL DEVELOPMENT LIMITED | 2017-02-14 00:00:00
80C | 6166 | China VAST Industrial Urban Development Company Limited
81 | 585 | IMAGI INTERNATIONAL HOLDINGS LIMITED | 2017-02-02 00:00:00
81C | 1461 | ZHONGTAI FUTURES Company Limited
82 | 205 | SEEC MEDIA GROUP LIMITED | 2017-01-18 00:00:00
82C | 1831 | ShiFang Holding Limited
83 | 658 | China High Speed Transmission Equipment Group Co., Ltd. | 2016-12-29 00:00:00
83C | 3996 | China Energy Engineering Corporation Limited
84 | 1150 | Milan Station Holdings Limited | 2016-12-15 00:00:00
84C | 264 | China International Development Corporation Limited
85 | 865 | Jiande International Holdings Limited | 2016-12-01 00:00:00
85C | 2286 | [NAME]
86 | 1068 | China Yurun Food Group Limited | 2016-11-25 00:00:00
86C | 411 | LAM SOON (HONG KONG) LIMITED
87 | 8059 | Glory Flame Holdings Limited | 2016-11-23 00:00:00
87C | 8366 | Fraser Holdings Limited
88 | 2399 | China Fordoo Holdings Limited | 2016-10-11 00:00:00
88C | 393 | Glorious Sun Enterprises Limited
89 | 1062 | China Development Bank International Investment Limited | 2016-10-06 00:00:00
89C | 901 | Goldstone Investment Group Limited
90 | 365 | Unisplendour Technology (Holdings) Limited | 2016-09-27 00:00:00
90C | 1157 | Zoomlion Heavy Industry Science and Technology Co., Ltd.
91 | 3816 | KFM Kingdom Holdings Limited | 2016-09-14 00:00:00
91C | 1166 | SOLARTECH INTERNATIONAL HOLDINGS LIMITED
92 | 92 | CHAMPION TECHNOLOGY HOLDINGS LIMITED | 2016-08-17 00:00:00
92C | 862 | Vision Values Holdings Limited
93 | 434 | Boyaa Interactive International Limited | 2016-08-02 00:00:00
93C | 1039 | Changyou Alliance Group Limited
94 | 620 | DTXS Silk Road Investment Holdings Company Limited | 2016-07-27 00:00:00
94C | 132 | CHINA INVESTMENTS HOLDINGS LIMITED
95 | 1301 | D&G Technology Holding Company Limited | 2016-07-21 00:00:00
95C | 1496 | AP Rentals Holdings Limited
96 | 1176 | Zhuguang Holdings Group Company Limited | 2016-06-08 00:00:00
96C | 119 | Poly Property Group Co., Limited
97 | 8153 | Code Agriculture (Holdings) Limited | 2016-05-05 00:00:00
97C | 8112 | Cornerstone Financial Holdings Limited
98 | 290 | China Fortune Financial Group Limited | 2016-03-23 00:00:00
98C | 111 | Cinda International Holdings Limited
99 | 827 | [NAME] (Group) Limited | 2016-01-27 00:00:00
99C | 8189 | TIANJIN TEDA BIOMEDICAL ENGINEERING COMPANY LIMITED
100 | 8006 | Sino Splendid Holdings Limited | 2016-01-08 00:00:00
100C | 426 | One Media Group Limited
101 | 471 | CMMB Vision Holdings Limited | 2015-12-18 00:00:00
101C | 8337 | Directel Holdings Limited
102 | 496 | Kasen International Holdings Limited | 2015-12-11 00:00:00
102C | 1222 | WANG ON GROUP LIMITED
103 | 254 | National United Resources Holdings Limited | 2015-11-27 00:00:00
103C | 306 | KWOON CHUNG BUS HOLDINGS LIMITED
104 | 905 | Mastermind Capital Limited | 2015-11-10 00:00:00
104C | 1160 | Goldstone Capital Group Limited
105 | 444 | Sincere Watch (Hong Kong) Limited | 2015-10-27 00:00:00
105C | 2033 | Time Watch Investments Limited
106 | 482 | Sandmartin International Holdings Limited | 2015-10-14 00:00:00
106C | 927 | FUJIKON INDUSTRIAL HOLDINGS LIMITED
107 | 117 | Eyang Holdings (Group) Co., Limited | 2015-10-06 00:00:00
107C | 99 | Wong's International Holdings Limited
108 | 58 | Sunway International Holdings Limited | 2015-09-14 00:00:00
108C | 695 | Dongwu Cement International Limited
109 | 412 | Heritage International Holdings Limited | 2015-08-31 00:00:00
109C | 86 | Sun Hung Kai & Co. Limited
110 | 1196 | Realord Group Holdings Limited | 2015-07-07 00:00:00
110C | 154 | Beijing Enterprises Environment Group Limited
111 | 1378 | China Hongqiao Group Limited | 2015-06-12 00:00:00
111C | 486 | United Company RUSAL Plc
112 | 428 | Harmony Asset Limited | 2015-05-19 00:00:00
112C | 2324 | Capital VC Limited
113 | 8067 | Oriental University City Holdings (H.K.) Limited | 2015-05-08 00:00:00
113C | 1064 | [NAME]
114 | 858 | Extrawell Pharmaceutical Holdings Limited | 2015-03-27 00:00:00
114C | 1889 | Wuyi International Pharmaceutical Company Limited
115 | 5 | HSBC Holdings plc | 2015-03-18 00:00:00
115C | 939 | China Construction Bank
116 | 499 | Qingdao Holdings International Limited | 2015-03-10 00:00:00
116C | 456 | New City Development Group Limited
117 | 2339 | Beijing West Industries International Limited | 2015-01-30 00:00:00
117C | 6830 | [NAME]
118 | 6888 | Freetech Road Recycling Technology (Holdings) Limited | 2015-01-23 00:00:00
118C | 8356 | CNC Holdings Limtied
119 | 2389 | Genvon Group Limited | 2015-01-22 00:00:00
119C | 1830 | [NAME] (PRC) Holdings Limited
120 | 8147 | Millennium Pacific Group Holdings Limited | 2015-01-07 00:00:00
120C | 8005 | Yuxing InfoTech Investment Holdings Limited
121 | 8045 | Jiangsu NandaSoft Technology Company Limited | 2014-12-24 00:00:00
121C | 8092 | ITE (Holdings) Limited
122 | 1359 | China Cinda Asset Management Co., Ltd | 2014-12-23 00:00:00
122C | 165 | China Everbright Limited
123 | 1033 | [NAME] Fibre Company Limited | 2014-12-22 00:00:00
123C | 3337 | Anton Oilfield Services Group
124 | 1075 | Capinfo Company Limited | 2014-12-19 00:00:00
124C | 1037 | Daiwa Associate Holdings Limited
125 | 515 | TC Orient Lighting Holdings Limited | 2014-12-19 00:00:00
125C | 894 | Man Yue Technology Holdings Limited
126 | 2700 | Green International Holdings Limited | 2014-12-16 00:00:00
126C | 1338 | BaWang International (Group) Holding Limited
127 | 726 | South East Group Limited | 2014-12-15 00:00:00
127C | 366 | Luks Group (Vietnam Holdings) Company Limited
128 | 145 | The Hong Kong Building and Loan Agency Limited | 2014-12-15 00:00:00
128C | 1397 | Baguio Green Group Limited
129 | 379 | PME Group Limited | 2014-12-10 00:00:00
129C | 605 | China Financial Services Holdings Limited
130 | 209 | Winshine Entertainment & Media Holding Company Limited | 2014-12-09 00:00:00
130C | 114 | Herald Holdings Limited
131 | 8120 | ORI UNICORN | 2014-12-08 00:00:00
131C | 567 | Daisho Microline Holdings Limited
132 | 295 | Kong Sun Holdings Limited | 2014-11-24 00:00:00
132C | 1004 | China Smarter Energy Group Holdings Limited
133 | 91 | International Standard Resources Holdings Limited | 2014-11-21 00:00:00
133C | 7 | Hoifu Energy Group Limited
134 | 95 | LVGEM (China) Real Estate Investment Company Limited | 2014-11-21 00:00:00
134C | 680 | Nan Hai Corporation Limited
135 | 2728 | SHINHINT (JINTAI ENERGY H) | 2014-11-21 00:00:00
135C | 8009 | Chinese Energy Holdings Limited
136 | 8132 | China Oil Gangran Energy Group Holdings Limited | 2014-11-17 00:00:00
136C | 852 | Strong Petrochemical Holdings Limited
137 | 1141 | Mission Capital Holdings Limited | 2014-11-13 00:00:00
137C | 8029 | Sun International Resources Limited
138 | 377 | New Island Development Holdings Limited | 2014-10-21 00:00:00
138C | 1008 | Brilliant Circle Holdings International Limited
139 | 8041 | Luxey International (Holdings) Limited | 2019-07-11 00:00:00
139C | 483 | Bauhaus International (Holdings) Limited
140 | 8321 | [NAME] | 2019-05-20 00:00:00
140C | 8217 | Luen Wong Group Holdings Limited
141 | 1633 | Sheung Yue Group Holdings Limited | 2019-03-15 00:00:00
141C | 747 | Shenyang Public Utility Holdings Company Limited
142 | 495 | [NAME] | 2019-02-26 00:00:00
142C | 864 | Wing Lee Property Investments Limited
143 | 1241 | Shuanghua Holdings Limited | 2020-08-06 00:00:00
143C | 48 | China Automotive Interior Decoration Holdings Limited
144 | 1355 | Legend Strategy International Holdings Group Company Limited | 2020-06-29 00:00:00
144C | 8237 | Link Holdings Limited
145 | 1104 | APAC Resources Limited | 2020-06-22 00:00:00
145C | 159 | Brockman Mining Limited
146 | 8645 | Nomad Technologies Holdings Limited | 2020-06-05 00:00:00
146C | 8282 | Gameone Holdings Limited
147 |  |  | 2019-12-31 00:00:00
147C | 8473 | Mi Ming Mart Holdings Limited
148 |  |  | 2019-12-31 00:00:00
148C | 510 | CASH Financial Services Group Limited
149 |  |  | 2020-12-31 00:00:00
149C | 1165 | Shunfeng International Clean Energy Limited
150 |  |  | 2020-12-28 00:00:00
150C | 1518 | New Century Healthcare Holdings Co. Limited
 |  |  |  |  |  | Step 2: Subtract the stock return by market return ('HSI data'!I:I) on the exact dates as the individual stock by daily basis, getting the abnormal return of a specific trading day.
 |  |  |  |  |  | Step 3: Let the abnormal return of, for example, T0 be R0, T+1 be R1
 |  |  |  |  |  | Step 4: F101 needs to return (1+R0)*(1+R1)*…*(1+R252)