Share Forum - Discuss JSE shares and join the Investor Challenge

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

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

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

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.

Okay, okay, one golden star coming your way.