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: 529
- Pages: 18
STOCK MARKET PERFORMANCE SPREADSH
INVESTMENT PURCHASE INFORMA COMPANY
INDUSTRY
STOCK EXCHANGE
TICKER
BETA
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$)
TOTAL INVESTMENT PRINCIPLE
$1,000,000
panies. r companies.
2)
S INVESTMENT PURCHASE INFORMATION COMPANY
Wal-mart Stores.Inc
STOCK EXCHANGE
TICKER
SHARES
NYSE
5082
NYSE The Procter & Gamble Company
3496
The Coca-Cola Company
NYSE
3827
Sony Corporation
NYSE
8878
Qingdao Haier Co., Ltd.
SHANG HAI EXCHANGE
43824 TOTAL PRINCIPLE
SHARE PRICE TREND: 11 WEEK MOVEMENT Week of 9/21 PRINCIPLE
DATE
PRICE
Week of 9/ PRINCIPLE
DATE
$249,983.58
2009.9.29
$49.19
$249,983.58 2009.9.29
$200,006.16
2009.9.23
$57.21
$200,006.16 2009.9.23
$199,999.02
2009.9.24
$52.26
$199,999.02 2009.9.24
$250,004.48
2009.9.23
$28.16
$250,004.48 2009.9.23
$100,006.37 $1,000,000
2009.9.29
15.33 (RMB) =$ 2.282
TOTAL PRINCIPLE GAIN/LOSS
$100,006.37 2009.9.29 999999.61 -0.39
TOTAL PRINCIPLE
Week of 9/28
Week of 10/05
PRICE
PRINCIPLE
$49.19
$249,983.58 2009.10.09
$50.16
$254,913.12
$57.21
$200,006.16 2009.10.09
$58.28
$203,746.88
$52.26
$199,999.02 2009.10.07
$55.08
$210,791.16
$28.16
$250,004.48 2009.10.09
$28.42
$252,312.76
$100,006.37 2009.10.09
$2.52
$110,436.48
$ 2.282
TOTAL PRINCIPLE GAIN/LOSS
999999.61 -0.39
DATE
PRICE
TOTAL PRINCIPLE GAIN/LOSS
PRINCIPLE
$1,032,200.40 $0.09
Week of 10/12 DATE
PRICE
Week of 10/19 PRINCIPLE
DATE
PRICE
2009.10.16
$51.90
$263,755.80 2009.10.19
$51.87
2009.10.16
$57.45
$200,845.20 2009.10.20
$58.77
2009.10.12
$55.14
$211,020.78 2009.10.19
$55.40
2009.10.15
$29.30
$260,125.40 2009.10.19
$29.63
2009.10.12
$2.66
$116,571.84 2009.10.21
$2.77
TOTAL PRINCIPLE GAIN/LOSS
$1,052,319.02 5.23%
TOTAL PRINCIPLE GAIN/LOSS
Week of 10/19
Week of 10/26
PRINCIPLE
DATE
PRICE
Week
PRINCIPLE
DATE
$263,603.34 2009.10.26
$50.46
$256,437.73 2009.11.05
$205,459.92 2009.10.29
$59.59
$208,326.64 2009.11.09
$212,015.80 2009.10.26
$54.13
$207,155.51 2009.11.09
$263,055.14 2009.10.29
$30.59
$271,578.02 2009.11.02
$121,392.48 2009.10.29
$2.95
$129,280.80 2009.11.06
$1,065,526.68 6.55%
TOTAL PRINCIPLE GAIN/LOSS
$1,072,778.70 $10,772,778.70 7.73% $1,072,778.70
TOTAL PRINCIPLE
Week of 11/02 PRICE
Week of 11/09
PRINCIPLE
DATE
PRICE
$51.27
$260,554.14 2009.11.12
$53.69
$61.85
$216,227.60 2009.11.10
$62.31
$55.47
$212,283.69 2009.11.13
$56.68
$29.24
$259,592.72 2009.11.09
$29.50
$3.11
$136,342.49 2009.11.13
$3.33
TOTAL PRINCIPLE GAIN/LOSS
$1,085,000.64 8.50%
TOTAL PRINCIPLE GAIN/LOSS
11/09 PRINCIPLE
company
Share Price
$272,852.58 (sell)The Procter & Gamble Company
$62.31
$217,835.76 (buy)Nokia corporation(ADR)
$13.27
$216,914.36 (sell)Sony Corporation
$29.50
$261,901.00 (buy)Tencent Holdings Ltd $145,933.92 $1,115,410.59 11.54%
HKD138.00=$17.80
total Shares 3496
Principle
COMPANY
$217,835.76 Wal-mart Stores.Inc
16415
$217,827.05 Nokia corporation(ADR)
8878
$261,901.00 The Coca-Cola Company
14,713
$261,891.40 Tencent Holdings Ltd
Qingdao Haier Co., Ltd.
STOCK EXCHANGE
TICKER
SHARES
NYSE
5082
NYSE
16415
NYSE
3827
Hang Seng Index SHANG HAI EXCHANGE
14713 43824
Week of 11/09 PRINCIPLE
DATE
PRICE
PRINCIPLE
$272,852.58 2009.11.12
$53.69
$272,852.58
$217,827.05 2009.11.10
$13.27
$217,827.05
$216,914.36 2009.11.13
$56.68
$216,914.36
$261,891.40 2009.11.09
$17.80
$261,891.40
$145,933.92 2009.11.13
$3.33
$145,933.92
$1,115,419.31 TOTAL PRINCIPLE GAIN/LOSS
$1,115,419.31 11.70% $2,230,838.62
Week of 11/16 DATE
PRICE
Week of 11/23
PRINCIPLE
DATE
PRICE
2009.11.20
$54.68
$277,883.76 2009.11.24
$55.03
2009.11.18
$13.98
$229,481.70 2009.11.25
$13.50
2009.11.20
$57.61
$220,473.47 2009.11.25
$58.25
2009.11.18
$19.25
$283,225.25 2009.11.25
$19.12
2009.11.20
$3.33
$145,933.92 2009.11.24
$3.35
TOTAL PRINCIPLE GAIN/LOSS
$1,156,998.10 15.70%
TOTAL PRINCIPLE GAIN/LOSS
Week of 11/23
Week of 11/30
PRINCIPLE
DATE
PRICE
PRINCIPLE
$279,662.46 2009.12.02
$54.88
$278,900.16
$221,602.50 2009.12.01
$13.52
$221,930.80
$222,731.40 2009.12.01
$58.24
$222,884.48
$281,312.56 2009.12.03
$19.42
$146,810.40 2009.12.02
RMB24.96($3.72)
$1,152,119.32 15.21%
TOTAL PRINCIPLE GAIN/LOSS
$285.726.46 $163,025.28 $1,172,467.18 17.25%
INVESTMENT PERFORMAN
T PERFORMANCE CHARTS
INVESTMENT PURCHASE INFORMA COMPANY
INDUSTRY
STOCK EXCHANGE
TICKER
BETA
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$)
TOTAL INVESTMENT PRINCIPLE
$1,000,000
panies. r companies.
2)
S INVESTMENT PURCHASE INFORMATION COMPANY
Wal-mart Stores.Inc
STOCK EXCHANGE
TICKER
SHARES
NYSE
5082
NYSE The Procter & Gamble Company
3496
The Coca-Cola Company
NYSE
3827
Sony Corporation
NYSE
8878
Qingdao Haier Co., Ltd.
SHANG HAI EXCHANGE
43824 TOTAL PRINCIPLE
SHARE PRICE TREND: 11 WEEK MOVEMENT Week of 9/21 PRINCIPLE
DATE
PRICE
Week of 9/ PRINCIPLE
DATE
$249,983.58
2009.9.29
$49.19
$249,983.58 2009.9.29
$200,006.16
2009.9.23
$57.21
$200,006.16 2009.9.23
$199,999.02
2009.9.24
$52.26
$199,999.02 2009.9.24
$250,004.48
2009.9.23
$28.16
$250,004.48 2009.9.23
$100,006.37 $1,000,000
2009.9.29
15.33 (RMB) =$ 2.282
TOTAL PRINCIPLE GAIN/LOSS
$100,006.37 2009.9.29 999999.61 -0.39
TOTAL PRINCIPLE
Week of 9/28
Week of 10/05
PRICE
PRINCIPLE
$49.19
$249,983.58 2009.10.09
$50.16
$254,913.12
$57.21
$200,006.16 2009.10.09
$58.28
$203,746.88
$52.26
$199,999.02 2009.10.07
$55.08
$210,791.16
$28.16
$250,004.48 2009.10.09
$28.42
$252,312.76
$100,006.37 2009.10.09
$2.52
$110,436.48
$ 2.282
TOTAL PRINCIPLE GAIN/LOSS
999999.61 -0.39
DATE
PRICE
TOTAL PRINCIPLE GAIN/LOSS
PRINCIPLE
$1,032,200.40 $0.09
Week of 10/12 DATE
PRICE
Week of 10/19 PRINCIPLE
DATE
PRICE
2009.10.16
$51.90
$263,755.80 2009.10.19
$51.87
2009.10.16
$57.45
$200,845.20 2009.10.20
$58.77
2009.10.12
$55.14
$211,020.78 2009.10.19
$55.40
2009.10.15
$29.30
$260,125.40 2009.10.19
$29.63
2009.10.12
$2.66
$116,571.84 2009.10.21
$2.77
TOTAL PRINCIPLE GAIN/LOSS
$1,052,319.02 5.23%
TOTAL PRINCIPLE GAIN/LOSS
Week of 10/19
Week of 10/26
PRINCIPLE
DATE
PRICE
Week
PRINCIPLE
DATE
$263,603.34 2009.10.26
$50.46
$256,437.73 2009.11.05
$205,459.92 2009.10.29
$59.59
$208,326.64 2009.11.09
$212,015.80 2009.10.26
$54.13
$207,155.51 2009.11.09
$263,055.14 2009.10.29
$30.59
$271,578.02 2009.11.02
$121,392.48 2009.10.29
$2.95
$129,280.80 2009.11.06
$1,065,526.68 6.55%
TOTAL PRINCIPLE GAIN/LOSS
$1,072,778.70 $10,772,778.70 7.73% $1,072,778.70
TOTAL PRINCIPLE
Week of 11/02 PRICE
Week of 11/09
PRINCIPLE
DATE
PRICE
$51.27
$260,554.14 2009.11.12
$53.69
$61.85
$216,227.60 2009.11.10
$62.31
$55.47
$212,283.69 2009.11.13
$56.68
$29.24
$259,592.72 2009.11.09
$29.50
$3.11
$136,342.49 2009.11.13
$3.33
TOTAL PRINCIPLE GAIN/LOSS
$1,085,000.64 8.50%
TOTAL PRINCIPLE GAIN/LOSS
11/09 PRINCIPLE
company
Share Price
$272,852.58 (sell)The Procter & Gamble Company
$62.31
$217,835.76 (buy)Nokia corporation(ADR)
$13.27
$216,914.36 (sell)Sony Corporation
$29.50
$261,901.00 (buy)Tencent Holdings Ltd $145,933.92 $1,115,410.59 11.54%
HKD138.00=$17.80
total Shares 3496
Principle
COMPANY
$217,835.76 Wal-mart Stores.Inc
16415
$217,827.05 Nokia corporation(ADR)
8878
$261,901.00 The Coca-Cola Company
14,713
$261,891.40 Tencent Holdings Ltd
Qingdao Haier Co., Ltd.
STOCK EXCHANGE
TICKER
SHARES
NYSE
5082
NYSE
16415
NYSE
3827
Hang Seng Index SHANG HAI EXCHANGE
14713 43824
Week of 11/09 PRINCIPLE
DATE
PRICE
PRINCIPLE
$272,852.58 2009.11.12
$53.69
$272,852.58
$217,827.05 2009.11.10
$13.27
$217,827.05
$216,914.36 2009.11.13
$56.68
$216,914.36
$261,891.40 2009.11.09
$17.80
$261,891.40
$145,933.92 2009.11.13
$3.33
$145,933.92
$1,115,419.31 TOTAL PRINCIPLE GAIN/LOSS
$1,115,419.31 11.70% $2,230,838.62
Week of 11/16 DATE
PRICE
Week of 11/23
PRINCIPLE
DATE
PRICE
2009.11.20
$54.68
$277,883.76 2009.11.24
$55.03
2009.11.18
$13.98
$229,481.70 2009.11.25
$13.50
2009.11.20
$57.61
$220,473.47 2009.11.25
$58.25
2009.11.18
$19.25
$283,225.25 2009.11.25
$19.12
2009.11.20
$3.33
$145,933.92 2009.11.24
$3.35
TOTAL PRINCIPLE GAIN/LOSS
$1,156,998.10 15.70%
TOTAL PRINCIPLE GAIN/LOSS
Week of 11/23
Week of 11/30
PRINCIPLE
DATE
PRICE
PRINCIPLE
$279,662.46 2009.12.02
$54.88
$278,900.16
$221,602.50 2009.12.01
$13.52
$221,930.80
$222,731.40 2009.12.01
$58.24
$222,884.48
$281,312.56 2009.12.03
$19.42
$146,810.40 2009.12.02
RMB24.96($3.72)
$1,152,119.32 15.21%
TOTAL PRINCIPLE GAIN/LOSS
$285.726.46 $163,025.28 $1,172,467.18 17.25%
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