The JSE and finance forum for South Africa

General Category => The Investor Challenge => Topic started by: Luna on June 11, 2014, 10:02:06 am

Title: Wheres the money?
Post by: Luna on June 11, 2014, 10:02:06 am
Hi Patrick,

I bought 25858 MIX shares on 2014-06-05 for 4.30 and sold them today for 4.39.

My holdings are:

Total dividends received: R1,944.80
Cash on hand (including dividends): R4.15 (0% of portfolio)
Total fees paid: R40,876.68
Net profit on share sales: R158,169.66

What just happened? I did not receive cash in hand? I did not sell at a loss.

I've just been cheated out of R113,396.62 ?

I'm not way at the bottom of the leaderboard which should not be the case.  :'(

Regards,
Luna.
Title: Re: Wheres the money?
Post by: letlhogonolo on June 11, 2014, 10:24:53 am
My Money is also gone.
Title: Re: Wheres the money?
Post by: Patrick on June 11, 2014, 10:56:42 am
Ok so lets see:
June so R600 000
+Total dividends received: R1,944.80
-Total fees paid: R40,683.88
+Net profit on share sales: R158,169.66
=719430.58
-R599,348.70
=120081.88

So your cash on hand should be R120 081.88 right?

Then we need to figure out how you have a negative holding in PNC...
Title: Re: Wheres the money?
Post by: CompTester on June 11, 2014, 11:05:55 am
Selling is on hold till I figure out the bug...
Title: Re: Wheres the money?
Post by: Patrick on June 11, 2014, 11:28:01 am
Bug is fixed, refunds will be coming.
Title: Re: Wheres the money?
Post by: Luna on June 11, 2014, 11:51:56 am
Ok. Will wait for the money.
Title: Re: Wheres the money?
Post by: Patrick on June 11, 2014, 12:16:03 pm
Ok, all 8 people who sold this morning should have their cash back...
Title: Re: Wheres the money?
Post by: Moneypenny on June 11, 2014, 12:24:11 pm
You are a very proficient, hands-on administrator Patrick, we all appreciate it.
Title: Re: Wheres the money?
Post by: Luna on June 11, 2014, 12:35:15 pm
Thanks Patrick
Title: Re: Wheres the money?
Post by: letlhogonolo on June 11, 2014, 12:56:37 pm
 ;)
Title: Re: Wheres the money?
Post by: letlhogonolo on June 11, 2014, 01:10:35 pm
My total networth on the leaderboard is incorrect as well as the displayed profit from sales in my holdings.
Title: Re: Wheres the money?
Post by: Patrick on June 11, 2014, 02:23:24 pm
How far off is it. Most likely you're not taking 30% off your profits for tax...
Title: Re: Wheres the money?
Post by: letlhogonolo on June 11, 2014, 03:37:02 pm
Its off by a bit. So I thought I'd dust off my old high school algebra book to do the calculations.

I copied my trading history and copied it into an excel spreadsheet.
I summed up all the transactions excluding shares I currently own, they give me
a total of R27,460.29 profit. Minus the transaction costs, R9,376.28, which gives me
R18,084.01. Multiplied by 0.3 to get the tax that must be subtracted, which gives me
R5,425.20 tax.

The net worth is R635,773.60 (at time I did this calculation). Subtracting tax, gives me
R630,348.40. Which is a 5.05% gain.

(phew)
Title: Re: Wheres the money?
Post by: Luna on June 19, 2014, 03:31:05 pm
Ok so lets see:
June so R600 000
+Total dividends received: R1,944.80
-Total fees paid: R40,683.88
+Net profit on share sales: R158,169.66
=719430.58
-R599,348.70
=120081.88

So your cash on hand should be R120 081.88 right?

Then we need to figure out how you have a negative holding in PNC...

If I look at my account via the leaderboard it shows:

PNC   PINNACLE TECH HLDGS LTD   -92           1327   1333   0.43%   -R1,226.36   -0.17%
VOD   Vodacom Group Ltd                   4723   12700   13106   3.2%   R618,996.38   84.57%

while if I look at my account via the "My Holdings" tab:

VOD   Vodacom Group Ltd                    4723   12700   13106   3.2%   R618,996.38   84.57%

Not sure why I have a negative shares holding PNC via the leaderboard.....
Title: Re: Wheres the money?
Post by: Patrick on June 19, 2014, 03:44:03 pm
Thanks, I see that. I'll fix it after the weekend migration,I'm putting a freeze on code changes until then.