Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Teh Hooi Leng calls it a day (Aggregate Asset Management)
06-05-2015, 05:07 PM.
Post: #91
RE: Teh Hooi Leng calls it a day (Aggregate Asset Management)
Try this from Investment Moat.

http://www.investmentmoats.com/stock-mar...readsheet/



(06-05-2015, 04:51 PM)dewdrop Wrote: Thank you all, for your suggestions.

Am keen to try to pull data from Google Finance (which gets data from SGX right?). I understand if I use Google spreadsheet, I can use a formula to automatically update indicators like 'price'. Does anyone know if it is possible to automatically update 'dividend', 'dividend yield' or 'price-to-book'? And where can I find the formula?

@CityFarmer, thanks for sharing the magic formula. Will have a read in detail.

Am just beginning to construct a portfolio, and to track my returns. Look forward to starting this learning journey, and hope not too many bruises along the way Wink

Find Reply
06-05-2015, 10:04 PM.
Post: #92
RE: Teh Hooi Leng calls it a day (Aggregate Asset Management)
need support can ping me haha.
=========== Signature ===========
Dividend Investing and More @ InvestmentMoats.com

Find Reply
07-05-2015, 12:52 AM.
Post: #93
RE: Teh Hooi Leng calls it a day (Aggregate Asset Management)
Take off my hat to you Drizzt for the portfolio spreadsheet! If there is a similar free to use spreadsheet for portfolio NAV calculation, that will be godsend.

Find Reply
07-05-2015, 11:32 AM.
Post: #94
RE: Teh Hooi Leng calls it a day (Aggregate Asset Management)
Thanks for all the info and support, will check that out and ping you all if need be!

Find Reply
07-05-2015, 01:14 PM. (This post was last modified: 07-05-2015, 01:25 PM by kazukirai.)
Post: #95
RE: Teh Hooi Leng calls it a day (Aggregate Asset Management)
(06-05-2015, 04:51 PM)dewdrop Wrote: Thank you all, for your suggestions.

Am keen to try to pull data from Google Finance (which gets data from SGX right?). I understand if I use Google spreadsheet, I can use a formula to automatically update indicators like 'price'. Does anyone know if it is possible to automatically update 'dividend', 'dividend yield' or 'price-to-book'? And where can I find the formula?

If you're keen to use Google Sheets, there is a limit to the kinds of fields you can pull from Google Finance. (see here)

Unfortunately, I don't seem to see Div Yield or P/B or Book Value there so you won't be able to have a sheet of all SGX listed stocks with their Div to P/B all the time.

I use Google Stock Screener for this- they have fields for both div yield and p/b. Run the screen, then copy and paste the results into an excel sheet and work the p/b from there. I also happen to have access to a bloomberg so I also run the lists from there.

Anyway, word of caution, some of the names on the list will look really ugly. I normally just use the list as a shortlist to dig further into each co. (whether FCF is constantly positive etc.).

EDIT: Also not to mention that any one-off unsustainable dividends will totally mess up the ratio so gotta sieve those out too.
Happy investing!

Find Reply
20-05-2017, 01:09 PM.
Post: #96
Teh Hooi Leng calls it a day from Aggregate Asset Management
Some update for fan of Ms Teh:
1. April 2016 - New president of AWARE singapore
2. May 2017 - Sold all 25% of AAM shares and set up her own fund

Name: Inclusif Value Fund (IVF)
link
Administrtor: Swiss-Asia Financial Services
Target: Accredited investor
Management fee: 0%
Performance fee: 20%



I'm just a clown
Who picks you up
Each time you're down

Wish you all the best!
=========== Signature ===========
感恩 26 April 2019 Straco AGM ppt  https://valuebuddies.com/thread-2915-pos...#pid152450

Find Reply
20-05-2017, 03:53 PM.
Post: #97
RE: Teh Hooi Leng calls it a day (Aggregate Asset Management)
Wow interesting from journalist to stand alone FM in 2 years. Am keen to see if there is a secret source that tiger cubs or Goldman alumni also couldn't replicate consistently

http://www.straitstimes.com/business/inv...d-own-firm
=========== Signature ===========
Before you speak, listen. Before you write, think. Before you spend, earn. Before you invest, investigate. Before you criticize, wait. Before you pray, forgive. Before you quit, try. Before you retire, save. Before you die, give. –William A. Ward

Think Asset-Business-Structure (ABS)

Find Reply
20-05-2017, 05:40 PM.
Post: #98
RE: Teh Hooi Leng calls it a day (Aggregate Asset Management)
will AAM still to perform without her ?

thinking to put some into AAM.

Find Reply
20-05-2017, 07:58 PM.
Post: #99
RE: Teh Hooi Leng calls it a day (Aggregate Asset Management)
Looks like she is going it alone. Given her profile and time in AAM, I believe she will attract sufficient AUM to run a 0% management fee fund. It's quite a big risk to fund 100% of the fund's expenses on your own. I wonder how much she is paying SAFS.

In terms of returns, I believe both AAM and Teh will be similar, since they clearly believed in the same strategy. Why did she leave AAM which was clearly enjoying much success? With the phenomenal growth of AAM's AUM, she must have sold her 25% stake for a good profit.

Tried to access the fund's website but wasn't able to. Too many visitors on the first day?

It is too bad that she is no longer writing. Hope to read her articles again.

Wish her success!

Find Reply
20-05-2017, 10:15 PM.
Post: #100
RE: Teh Hooi Leng calls it a day (Aggregate Asset Management)
Just some thots.

How you define AMM's success? Asset gathering or performance?

Swiss-Asia Fund incubator
http://www.swissasia-group.com/fund-management/
http://www.swissasia-group.com/wp-conten...G-PbyP.pdf

THL - AWARE & IVF - is she married?
=========== Signature ===========
"... but quitting while you're ahead is not the same as quitting." - Quote from the movie American Gangster

Find Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)
Valuebuddies.com | Return to Top | Lite (Archive) Mode | RSS Syndication | CONTACT US: n......@valuebuddies.com