Stock Performance Spreadsheet
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Stock Performance Spreadsheet as PDF for free.
More details
- Words: 546
- Pages: 18
STOCK MARKET PERFORMANCE SPREADSH
INVESTMENT PURCHASE INFORMA COMPANY
INDUSTRY
China mobile
Communication
BP
Energy
Coca cola companyDrink
WALMART
Merchandise
Shandong Airlines Air transport
STOCK EXCHANGE
NYSE
NYSE
NYSE
NYSE
SHE
TICKER
BETA
CHL
0.94
BP
0.75
KO
0.58
WMT
0.21
200152
0.38
NOTE: 1) Total Investment Principle CANNOT EXCEED US$1.0 M for the 5 companies. Each company can have a larger or smaller investment principle than the other companies.
ANCE SPREADSHEET/TEAM NAME:
URCHASE INFORMATION EPS
PER
TOTAL NUMBER OF SHARES PURCHASED
PURCHASE INVESTMENT PRICE PER PRINCIPLE (US$) SHARE (US$)
＄15007.12
4.08
12.16
49.54
3.68
14.25
53.61
$200,018.91
2.7
20.13
53.31
$349,980.15
3.39
14.61
49.23
$249,989.94
5.71
$50,002.68
14.92
59527
TOTAL INVESTMENT PRINCIPLE
$1,000,000
panies. r companies.
2)
S INVESTMENT PURCHASE INFORMATION COMPANY
STOCK EXCHANGE
TICKER
SHARES
China mobile
NYSE
CHL
3028
BP
NYSE
BP
3731
NYSE
KO
6565
WALMART
NYSE
WMT
5078
Shandong Airlines
SHE
Coca cola company
200152
59527
TOTAL PRINCIPLE
SHARE PRICE TREND: 11 WEEK MOVEMENT Week of 9/21 PRINCIPLE
DATE
PRICE
Week of 9/ PRINCIPLE
$150,007.12
DATE 30-Sep
＄200018.91
30-Sep
$349,980.15
30-Sep
$249,989.94
30-Sep
$50,002.68
30-Sep
$999,999
TOTAL PRINCIPLE
$
GAIN/LOSS $
TOTAL PRINCIPLE
Week of 9/28 PRICE
Week of 10/05 PRINCIPLE
DATE
PRICE
PRINCIPLE
$49.54
$150,007.12
5-Oct
$50.13
$151,793.64
$53.61
$200,018.91
10-Oct
$52.27
$195,019.37
$53.31
$349,989.94
5-Oct
$54.81
$359,827.65
$49.23
$249,989.94
5-Oct
$49.97
$253,747.66
￥5.71(＄0.8 366)
$50,002.68
5-Oct
￥5.97(＄0.87 47）
$52,068.27
TOTAL PRINCIPLE GAIN/LOSS
$999,998.80 $0
TOTAL PRINCIPLE GAIN/LOSS
$1,012,456.59 1.25%
Week of 10/12 DATE
PRICE
Week of 10/19 PRINCIPLE
DATE
PRICE
15-Oct
$51.26
$155,215.28
20-Oct
$51.37
15-Oct
$53.66
$200,205.46
20-Oct
$56.40
15-Oct
$54.84
$360,024.60
19-Oct
$55.01
14-Oct
$50.34
$255,626.52
20-Oct
$51.89
15-Oct
￥6.10(＄0.89 36)
$53,193.33
23-Oct
￥6.23(＄0.9 126)
TOTAL PRINCIPLE GAIN/LOSS
$1,024,265.19 2.43%
TOTAL PRINCIPLE GAIN/LOSS
Week of 10/19
Week of 10/26
PRINCIPLE
DATE
PRICE
Week of
PRINCIPLE
DATE
$155,548.36
26-Oct
$49.29
$149,250.12
8-Nov
$210,428.40
28-Oct
$57.82
$215,726.42
8-Nov
$361,140.65
26-Oct
$54.07
$354,969.55
8-Nov
$263,497.42
26-Oct
$50.49
$256,388.22
8-Nov
$54,324.34
28-Oct
￥6.31(＄0.92 43)
$55,020.81
3-Nov
$1,044,939.17 4.49%
TOTAL PRINCIPLE GAIN/LOSS
$1,031,355.12 3.14%
3-Nov TOTAL PRINCIPLE
Week of 11/02 PRICE
Week of 11/09
PRINCIPLE
DATE
PRICE
$47.63
$144,223.64
11-Nov
$49.12
$58.43
$218,002.33
10-Nov
$59.93
$54.49
$357,726.85
11-Nov
$56.16
$51.25
$260,247.50
13-Nov
$53.24
￥6.05(＄0.88 62)
$52,752.82
13-Nov
￥6.81(＄0.99 76)
TOTAL PRINCIPLE GAIN/LOSS
$1,032,953.15 3.30%
TOTAL PRINCIPLE GAIN/LOSS
Week of 11/09 PRINCIPLE
Company
Date
$148,735.36 (sell) China Mobile
11-Nov
$223,598.83 (buy)stryker corporation
11-Nov
$368,690.40 (sell) Shandong Air
13-Nov
$270,352.72 (buy)Microsoft Corporation
13-Nov
$59,384.14 $1,070,761.45 7.08%
Share Price
Total Shares
Principle
$49.12
3028
$148,735.36
$49.46
3007
$148,735.36
59527
$59,384.14
2023
$59,384.14
￥6.81(＄0.9976) $29.36
INVESTMENT PURCHASE INFORMATION COMPANY
STOCK EXCHANGE
TICKER
stryker corporation
NYSE
SYK
BP
NYSE
BP
NYSE
KO
WALMART
NYSE
WMT
Microsoft Corporation
NASDAQ
MSFT
Coca cola company
TOTAL PRINCIPLE
ASE INFORMATION
Week of 11/16
SHARES
PRINCIPLE
DATE
PRICE
3007
$148,735.36
18-Nov
$49.46
3731
$223,598.83
18-Nov
$59.55
6565
$368,690.40
18-Nov
$56.87
5078
$270,352.72
19-Nov
$54.15
2023
$59,384.14
19-Nov
$30.11
$1,070,761.45
TOTAL PRINCIPLE GAIN/LOSS
Week of 11/16
Week of 11/23
PRINCIPLE
DATE
PRICE
Week
PRINCIPLE
DATE
$148,726.22
25-Nov
$50.38
$151,492.66
2-Dec
$222,181.05
25-Nov
$59.22
$220,949.82
2-Dec
$373,351.55
23-Nov
$58.24
$382,345.60
2-Dec
$274,973.70
24-Nov
$54.96
$279,086.88
2-Dec
$60,912.53
24-Nov
$29.98
$60,649.54
2-Dec
$1,080,145.05 8.01%
TOTAL PRINCIPLE GAIN/LOSS
$1,094,524.50 9.45%
TOTAL PRINCIPLE
Week of 11/30 PRICE
PRINCIPLE
$51.24
$154,078.68
$58.96
$219,979.76
$57.96
$380,507.40
$54.47
$276,598.66
$29.78
$60,244.94
TOTAL PRINCIPLE GAIN/LOSS
$1,091,409.44 9.14%
INVESTMENT PERFORMAN
T PERFORMANCE CHARTS
INVESTMENT PURCHASE INFORMA COMPANY
INDUSTRY
China mobile
Communication
BP
Energy
Coca cola companyDrink
WALMART
Merchandise
Shandong Airlines Air transport
STOCK EXCHANGE
NYSE
NYSE
NYSE
NYSE
SHE
TICKER
BETA
CHL
0.94
BP
0.75
KO
0.58
WMT
0.21
200152
0.38
NOTE: 1) Total Investment Principle CANNOT EXCEED US$1.0 M for the 5 companies. Each company can have a larger or smaller investment principle than the other companies.
ANCE SPREADSHEET/TEAM NAME:
URCHASE INFORMATION EPS
PER
TOTAL NUMBER OF SHARES PURCHASED
PURCHASE INVESTMENT PRICE PER PRINCIPLE (US$) SHARE (US$)
＄15007.12
4.08
12.16
49.54
3.68
14.25
53.61
$200,018.91
2.7
20.13
53.31
$349,980.15
3.39
14.61
49.23
$249,989.94
5.71
$50,002.68
14.92
59527
TOTAL INVESTMENT PRINCIPLE
$1,000,000
panies. r companies.
2)
S INVESTMENT PURCHASE INFORMATION COMPANY
STOCK EXCHANGE
TICKER
SHARES
China mobile
NYSE
CHL
3028
BP
NYSE
BP
3731
NYSE
KO
6565
WALMART
NYSE
WMT
5078
Shandong Airlines
SHE
Coca cola company
200152
59527
TOTAL PRINCIPLE
SHARE PRICE TREND: 11 WEEK MOVEMENT Week of 9/21 PRINCIPLE
DATE
PRICE
Week of 9/ PRINCIPLE
$150,007.12
DATE 30-Sep
＄200018.91
30-Sep
$349,980.15
30-Sep
$249,989.94
30-Sep
$50,002.68
30-Sep
$999,999
TOTAL PRINCIPLE
$
GAIN/LOSS $
TOTAL PRINCIPLE
Week of 9/28 PRICE
Week of 10/05 PRINCIPLE
DATE
PRICE
PRINCIPLE
$49.54
$150,007.12
5-Oct
$50.13
$151,793.64
$53.61
$200,018.91
10-Oct
$52.27
$195,019.37
$53.31
$349,989.94
5-Oct
$54.81
$359,827.65
$49.23
$249,989.94
5-Oct
$49.97
$253,747.66
￥5.71(＄0.8 366)
$50,002.68
5-Oct
￥5.97(＄0.87 47）
$52,068.27
TOTAL PRINCIPLE GAIN/LOSS
$999,998.80 $0
TOTAL PRINCIPLE GAIN/LOSS
$1,012,456.59 1.25%
Week of 10/12 DATE
PRICE
Week of 10/19 PRINCIPLE
DATE
PRICE
15-Oct
$51.26
$155,215.28
20-Oct
$51.37
15-Oct
$53.66
$200,205.46
20-Oct
$56.40
15-Oct
$54.84
$360,024.60
19-Oct
$55.01
14-Oct
$50.34
$255,626.52
20-Oct
$51.89
15-Oct
￥6.10(＄0.89 36)
$53,193.33
23-Oct
￥6.23(＄0.9 126)
TOTAL PRINCIPLE GAIN/LOSS
$1,024,265.19 2.43%
TOTAL PRINCIPLE GAIN/LOSS
Week of 10/19
Week of 10/26
PRINCIPLE
DATE
PRICE
Week of
PRINCIPLE
DATE
$155,548.36
26-Oct
$49.29
$149,250.12
8-Nov
$210,428.40
28-Oct
$57.82
$215,726.42
8-Nov
$361,140.65
26-Oct
$54.07
$354,969.55
8-Nov
$263,497.42
26-Oct
$50.49
$256,388.22
8-Nov
$54,324.34
28-Oct
￥6.31(＄0.92 43)
$55,020.81
3-Nov
$1,044,939.17 4.49%
TOTAL PRINCIPLE GAIN/LOSS
$1,031,355.12 3.14%
3-Nov TOTAL PRINCIPLE
Week of 11/02 PRICE
Week of 11/09
PRINCIPLE
DATE
PRICE
$47.63
$144,223.64
11-Nov
$49.12
$58.43
$218,002.33
10-Nov
$59.93
$54.49
$357,726.85
11-Nov
$56.16
$51.25
$260,247.50
13-Nov
$53.24
￥6.05(＄0.88 62)
$52,752.82
13-Nov
￥6.81(＄0.99 76)
TOTAL PRINCIPLE GAIN/LOSS
$1,032,953.15 3.30%
TOTAL PRINCIPLE GAIN/LOSS
Week of 11/09 PRINCIPLE
Company
Date
$148,735.36 (sell) China Mobile
11-Nov
$223,598.83 (buy)stryker corporation
11-Nov
$368,690.40 (sell) Shandong Air
13-Nov
$270,352.72 (buy)Microsoft Corporation
13-Nov
$59,384.14 $1,070,761.45 7.08%
Share Price
Total Shares
Principle
$49.12
3028
$148,735.36
$49.46
3007
$148,735.36
59527
$59,384.14
2023
$59,384.14
￥6.81(＄0.9976) $29.36
INVESTMENT PURCHASE INFORMATION COMPANY
STOCK EXCHANGE
TICKER
stryker corporation
NYSE
SYK
BP
NYSE
BP
NYSE
KO
WALMART
NYSE
WMT
Microsoft Corporation
NASDAQ
MSFT
Coca cola company
TOTAL PRINCIPLE
ASE INFORMATION
Week of 11/16
SHARES
PRINCIPLE
DATE
PRICE
3007
$148,735.36
18-Nov
$49.46
3731
$223,598.83
18-Nov
$59.55
6565
$368,690.40
18-Nov
$56.87
5078
$270,352.72
19-Nov
$54.15
2023
$59,384.14
19-Nov
$30.11
$1,070,761.45
TOTAL PRINCIPLE GAIN/LOSS
Week of 11/16
Week of 11/23
PRINCIPLE
DATE
PRICE
Week
PRINCIPLE
DATE
$148,726.22
25-Nov
$50.38
$151,492.66
2-Dec
$222,181.05
25-Nov
$59.22
$220,949.82
2-Dec
$373,351.55
23-Nov
$58.24
$382,345.60
2-Dec
$274,973.70
24-Nov
$54.96
$279,086.88
2-Dec
$60,912.53
24-Nov
$29.98
$60,649.54
2-Dec
$1,080,145.05 8.01%
TOTAL PRINCIPLE GAIN/LOSS
$1,094,524.50 9.45%
TOTAL PRINCIPLE
Week of 11/30 PRICE
PRINCIPLE
$51.24
$154,078.68
$58.96
$219,979.76
$57.96
$380,507.40
$54.47
$276,598.66
$29.78
$60,244.94
TOTAL PRINCIPLE GAIN/LOSS
$1,091,409.44 9.14%
INVESTMENT PERFORMAN
T PERFORMANCE CHARTS
Related Documents
Stock Performance Spreadsheet
July 2020 11
Stock Performance Spreadsheet
July 2020 9
Stock Performance Spreadsheet
July 2020 12
Stock Performance Spreadsheet
July 2020 5
Stock Performance Spreadsheet
July 2020 6