The JSE and finance forum for South Africa
General Category => Shares => Topic started by: Patrick on April 23, 2013, 10:14:03 am
-
One of the cool things about running that competition is that I can do some data mining. Call me a geek, but I love data. The first interesting piece I thought I'd look into, is what are people putting their money into. So here's the list of the top30 shares, and how much money was sent their way. Looks like Orca has been promoting CML quite well :)
Obviously we're working with a small set here, with 42 participants, there's a total of just under R17m that people could have spent.
CML 1085017.6000
SAB 851485.4400
SGL 820938.5400
MTN 590895.8000
APN 588954.7500
PNC 508734.8000
OML 439934.4000
CPI 428710.0000
BIL 409717.6800
ACT 345937.5000
LON 345760.2000
AVI 317433.6000
AGL 307071.0000
MTA 286474.5400
KIO 278594.4000
NED 266349.6000
SOL 228303.9000
CFR 226580.9000
HAR 221250.0000
WHL 220425.9400
DSY 216742.8000
KAP 205800.0000
ELI 203100.1600
STXDIV 175745.4400
NPN 170522.9000
JDG 168000.0000
ABL 166091.8000
OCE 165025.0000
MDI 162400.0000
OLG 159874.0000
-
Thank you for this, was going to be my next request.
Now, since you love data so much ;D , what is the % change for each company since start of comp, apologies for asking :-[, but this is what happens when you flaunt your skills so basically you own fault. ;)
-
what is the % change for each company since start of comp
Wish I could tell you, but I don't record the price movements, just the price at purchase (which could be different for every user) and the current price. I thought since there are so many websites with price history I could just get that data there.
For example, here's CML's history since the comp started testing last monday, if you want something else, just edit the share code: http://markets.ft.com/research//Tearsheets/PriceHistoryPopup?symbol=CML:JNB
Day Date Open High Low Close Volume
Tuesday April 23 5,085 5,085 5,040 5,050 135,734
Monday April 22 5,100 5,139 5,005 5,068 916,397
Friday April 19 5,139 5,144 5,057 5,100 2,306,122
Thursday April 18 4,996 5,131 4,900 5,075 572,130
Wednesday April 17 5,090 5,090 4,960 5,013 515,068
Tuesday April 16 5,100 5,140 5,061 5,089 1,231,958
Monday April 15 5,061 5,159 4,978 5,105 1,196,708
-
Here's what people bought in April, numbers are in rand:
SAB 3134240.1100
CPI 2517367.5200
VOD 2362729.4200
CML 2036572.7000
BIL 1975941.0600
MTN 1724088.1600
SGL 1563793.4600
APN 1518500.3600
WHL 1434728.7500
CFR 1395544.1900
SOL 1379699.8300
JDG 1297510.1200
ABL 1293936.8800
STX40 1288646.6800
ANG 1171821.1300
DSY 1079267.3500
OML 1077487.6500
KIO 1017480.4800
NPN 1008883.2300
BTI 1005563.5400
FSR 1003214.0000
STXIND 866367.8400
PNC 855271.8000
AGL 844558.1400
TKG 843573.1000
FBR 834490.5000
MSM 834375.9000
SBK 802016.6600
LON 691304.3300
HAR 677549.1000
-
And for fun, here's what the top 10 have bought:
CML 503254.0000
OML 398397.7200
PNC 360970.0000
ELI 287882.8000
CGR 199601.6000
ACT 199196.2500
KAP 145000.0000
KIO 134937.0000
MTN 126680.0000
NPN 119586.0000
OMN 107100.0000
MRF 105000.0000
OCE 100000.0000
NTC 99671.4200
RLF 99602.1500
AMS 99600.0000
CLH 99592.5000
LHC 99487.0800
APN 99256.0800
SAB 95452.0000
GFI 80418.0000
DST 71744.0000
ILV 65040.0000
SBK 59706.6600
ZED 49996.8000
AVI 48433.8000
SPG 21609.0000
SHB 100.0000
And of course the bottom 10 buyers purchases:
SGL 1066850.7200
CZA 482760.0000
VOD 408974.0800
HAR 367370.0000
KAP 223000.0000
GFI 210420.0000
MTN 148239.0000
JDG 102960.0000
CGR 97956.0000
AEG 93480.0000
BIL 89635.0000
SAH 80000.0000
JSE 75010.0000
CSB 64630.0000
CML 53710.0000
APN 48443.0000
SLL 30000.0000
TBS 27833.0000
SAP 26700.0000
SAB 24504.5000
AGL 23000.0000
ANG 17080.0000
AFR 14100.0000
SOLBE1 14055.0000
DST 12500.0000
ARL 9379.0000
EMI 9270.0000
LON 8160.0000
STANSX 7500.0000
TON 6444.5000
-
It would be interesting to see how a challenge top 10 ETF would do. Take the 10 most purchased shares from the top 10 in the previous month and purchase for the next month.
-
I think its also interesting to note that roughly 50% of competitors have positive growth and 50% negative growth. I always thought it would be about 70% positive and 30% negative. I suppose its swings and round abouts.
-
Thank you for this, was going to be my next request.
Now, since you love data so much ;D , what is the % change for each company since start of comp, apologies for asking :-[, but this is what happens when you flaunt your skills so basically you own fault. ;)
Flaunting once more: http://www.investorchallenge.co.za/com_share_stats.php
-
Okay, okay, one golden star coming your way. ;)
-
:) and 2 thumbs up from me :TU: