JuniorDepot7c – Lots of Actions and Calculations

Market were really turbulent during the last weeks. We committed a lot of trades with Elle and did some important calculations of our trading costs.

1) On 25.06.2018 came the next monthly saving (€100). Additionally, we had €80,86 in cash. The DAX was low enough to buy, so we bought 3 shares of the DK-DAX ETF (DE000ETFL060) at €57,24.

2) On 29.06.2018 we sold our Viacom shares. Since stock trading by DeGiro is though cheap but (contrary to selected ETF) not free, it was a good exercise for Elle to calculate what we have actually earned and to compare the gain with the trading costs.

Date Description FX Cashflow
03-07-2018 Currency exchange EUR 1,04
03-07-2018 Currency exchange USD -1,22
02.07.2018 Custody fee for dividends USD -0,14
03-07-2018 Dividends USD 1,6
03-07-2018 Dividend Tax USD -0,24
29-06-2018 Currency exchange 1,1631 USD -239,92
29-06-2018 Currency exchange EUR 206,08
29-06-2018 Broker Fee EUR -0,5
29-06-2018 Broker Fee EUR -0,03
29-06-2018 Sell 8 at 29,99 USD (US92553P2011) USD 239,92
09-05-2018 Currency exchange 1,1878 USD 239,28
09-05-2018 Currency exchange EUR -201,65
09-05-2018 Broker Fee EUR -0,5
09-05-2018 Broker Fee EUR -0,03
09-05-2018 Buy 8 at 29,91 USD (US92553P2011) USD -239,28

I must admit, in spite of all my hints Elle was unable to calculate how much money we have earned with this trade. Well, she is just a seven year old girl... but can YOU do this?! 😉

Solution: how much we have earned with Viacom stock

In order to solve this problem we apply a filter in Excel to see only the cash movements in EUR and sum them. Respectively, our gain is €4,41 or in relative terms 4,41 / (201,65 + 0,5 + 0,03) = 2,18%.

As to costs, we cannot calculate them so straightforwardly, because the broker fees are in EUR but the custody fee is in USD. Additionally, there is a fee for the currency exchange. But roughly summing just broker fees we obtain €1,06. Thus it was a really expensive trade!

Date Description FX Cashflow
03-07-2018 Currency exchange EUR 1,04
29-06-2018 Currency exchange EUR 206,08
29-06-2018 Broker Fee EUR -0,5
29-06-2018 Broker Fee EUR -0,03
09-05-2018 Currency exchange EUR -201,65
09-05-2018 Broker Fee EUR -0,5
09-05-2018 Broker Fee EUR -0,03
Sum 4,41

[collapse]

As before we are convinced with the Viacom's outstanding fundamentals. However, we also never underestimate the sentiment. Thus looking what happened to RTL and ProSieben (two German peers of Viacom)

we decided not to risk too much and sell. In short term view it was the right decision, as you can see

3 Further we sold 3 shares of DK DAX (DE000ETFL060) at €59,79 today and bought one share of MDAX ETF (DE000ETFL441) at €250,05. This is not only because we believe in MDAX more than in DAX but also because DK DAX distributes the dividends (and we would have to pay the custody fee).

4 Last but not least we reconciled the costs, which cannot be attributed to any particular trade. In our case these are so-called modality fees for NASDAQ stock exchange (we traded GoPro and Viacom on NASDAQ).
Here is the list of all modality fees that were currently paid (and they will be charged further till the total sum reaches €2.50)

So far we have paid €1.76 modality fees. Further our inflow-payments are currently €701 and the netto profit (Gesamtdifferenz) is €1,35. Finally, our portfolio net worth (Kontoguthaben) is €700,46 thus €701 + €1,35 - €1,76 = €700,59 ... which means that our broker DeGiro has stolen €0,13 from us! Just kidding, these Thirteen Cents seems to be custody fees. Indeed, 0,14 USD / 1.16 = -0,120689655 (where 1.16 is an approximate EUR/USD exchange rate on 02.07.2018).

You may think that than it is Degiro's mistake in costs attribution since this custody fee can be unambiguously attributed to the Viacom stock. Well, to stock yes but to trade no. I mean we could have bought Viacom in several tranches but the custody fee for the dividends would be charged only once. However, our suggestion to DeGiro would be to explicitly disclose such "residual&qout; costs.

P.S.
As you might notice, currently we are (almost) breakeven, whereas some weeks ago we can boast with the CAGR of 8%. The cause is our bad luck with Platinum.

However, as we have already said, we are ready to keep this position as a long-term investment. The demand for platinum is driven mostly by the producer of diesel vehicles and the news flow gets positive.

Like this post and wanna learn more? Have a look at Knowledge rather than Hope: A Book for Retail Investors and Mathematical Finance Students

FinViz - an advanced stock screener (both for technical and fundamental traders)