Author Topic: So what are people buying  (Read 13649 times)

Patrick

  • Administrator
  • Hero Member
  • *****
  • Posts: 2550
  • Karma: +47/-2
    • View Profile
So what are people buying
« 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

Moneypenny

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1891
  • Karma: +37/-0
    • View Profile
    • Bu Valiere
Re: So what are people buying
« Reply #1 on: April 23, 2013, 10:40:20 am »
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.  ;)

Patrick

  • Administrator
  • Hero Member
  • *****
  • Posts: 2550
  • Karma: +47/-2
    • View Profile
Re: So what are people buying
« Reply #2 on: April 23, 2013, 10:52:11 am »
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

Patrick

  • Administrator
  • Hero Member
  • *****
  • Posts: 2550
  • Karma: +47/-2
    • View Profile
Re: So what are people buying
« Reply #3 on: May 02, 2013, 03:35:16 pm »
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

Patrick

  • Administrator
  • Hero Member
  • *****
  • Posts: 2550
  • Karma: +47/-2
    • View Profile
Re: So what are people buying
« Reply #4 on: May 02, 2013, 03:48:42 pm »
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

MrBig

  • I've just arrived
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: So what are people buying
« Reply #5 on: May 03, 2013, 11:11:37 am »
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.

Russell

  • I've just arrived
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: So what are people buying
« Reply #6 on: May 03, 2013, 01:54:56 pm »
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.

Patrick

  • Administrator
  • Hero Member
  • *****
  • Posts: 2550
  • Karma: +47/-2
    • View Profile
Re: So what are people buying
« Reply #7 on: June 03, 2013, 04:28:27 pm »
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

Moneypenny

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1891
  • Karma: +37/-0
    • View Profile
    • Bu Valiere
Re: So what are people buying
« Reply #8 on: June 03, 2013, 06:15:04 pm »
Okay, okay, one golden star coming your way.  ;)

Shi

  • Jr. Member
  • **
  • Posts: 82
  • Karma: +4/-0
    • View Profile
Re: So what are people buying
« Reply #9 on: June 04, 2013, 11:32:14 am »
 :) and 2 thumbs up from me  :TU: