January 2016
NIL
February 2016
March 2016
April 2016
May 2016
June 2016
July 2016
NIL
August 2016
September 2016
October 2016
November 2016
December 2016
January 2017
February 2017
March 2017
April 2017
May 2017
June 2017
July 2017
August 2017
September 2017
October 2017
November 2017
December 2017
January 2018
February 2018
March 2018
April 2018
How do you keep track of your returns?
LikeLike
At a portfolio level, I use an Excel XIRR spreadsheet to keep track of funds in and out. It calculates the internal rate of return and includes cash holdings.
I showed the XIRR table for STI ETF in the most recent quarterly portfolio update post:
https://thumbtackinvestor.wordpress.com/2017/09/24/fy17q3-sti-tti-is-hot-on-your-heels/
It’s the same for my personal portfolio, just input each time there’s a cash withdrawal or infusion and the XIRR function calculates it automatically.
Separately, I keep track of all transactions in another excel spreadsheet, just for recording purposes. (So that I can remember what’s the ave cost of each of my holding)
LikeLike
What is the trading platform you use for US stocks ?
LikeLike
Interactive Brokers mainly.
(IB should start giving me a commission, I lost count of how many times I’ve answered this qn)
LikeLike
Thank you.
LikeLike
AUM is your money or consists of others’ as well? Why such a jump from 2011 to 2012?
LikeLike
Hi John,
AUM is just my personal equity portfolio.
Doesn’t include other joint investments.
Such a big jump cos of my own injection of capital.
TTI
LikeLike
i think you should compare with the S&P annual returns haha.. S&P was on a long bull run … anyone invested in it could have done better than your portfolio..
STI is “weird” in the sense that a lot of the constituent stocks have cycles .. they don’t go up up up like big cap US stocks.
LikeLike
once the bear kicks in SG, it will rewind the gains for the past 10 yrs for many of the stocks here … for US, probably only for past 5 yrs or so..
LikeLike
That, I’m not too sure about.
Neither are you actually.
Nobody knows for sure.
I don’t think the guys back during the start of 1929, truly appreciated how severe the Great Depression would be, until it got well underway and reality hit them.
TTI
LikeLike
nobody can know for sure .. i used history as a guide .. many local popular stocks including DBS took 10 yrs after the 08 crisis to recover to the peak .. (even STI as well) some haven’t yet .. god knows whether they will eventually recover .. so if you’re invested just before the bear kicks in .. good luck .
LikeLike
Yes, I think so.
S&P returns for recent time periods, would likely have done better than my portfolio.
Probably better than the vast majority of fund managers as well.
In fact, probably better than the vast majority of anyone I know.
But that’s because S&P has been in a secular great bull run. There’d always be a market that’s going crazy for a few years.
So what happens if S&P drops 40% for the next 2 years? Do we then say hey look, say Topix has done much better. “Anyone who has invested in Topix would’ve done better”.
So the key is to stick to 1 logical benchmark, and compare to it consistently isn’t it?
My rationale for choosing STI is because this is my LOCAL equities portfolio. Of course I compare it to STI.
I didn’t bother to post anything regarding my US equities, save for some data on Options, but if my portfolio consists of mostly US equities, then perhaps it makes sense to benchmark it to S&P.
LikeLike
S&P is the de facto index … if S&P drops 40% .. i think most stocks will drop by at least that much .. just look at the recent correction. Regardless of whether we like it or not, the whole world’s markets are dependent on S&P.
LikeLike
Hi, saw that u are holding alliance minerals. It has been suspended for 1 week without any news. Getting worried and the suspense really getting me! I hope its not some bad news.
LikeLike
Hi
Alliance keeps getting suspended.
There’s no point worrying right now, the news can be anything really, both good, bad or even a non event.
TTI
LikeLike
Hi TTI,
Just noticed that you have stopped updating your Past Transactions. The last post was in April 2018.
Just curious if there is any specific reason you have done so.
Regards,
LikeLike
Yea, a very specific one:
Laziness.
LikeLike
lol, plus most of my activities have been in the US markets of late.
I’d try to update the transaction records soon.
LikeLike
Cool…just that keeping track of returns would be quiet instructive to all of us who frequent your blog :)
LikeLike
Think only thing of note is that I’ve been paring down my stake in BBR.
LikeLike
i saw you bought large no. of alliance, geo energy and q&m … are you still holding on to the loses? that must be ‘ouch!’
LikeLike
sold long ago, didn’t bother to update this page.
Still holding 100 lots of Q&M right now at the time of typing this though.
LikeLike