XIRR will change based on end date, assuming U place the last date as "=TODAY()"
Thus, if used properly - it'll change every DAY, not just every month... if U changed the end date lar

This post has been edited by wongmunkeong: Aug 9 2015, 09:16 PM

bro, as long as your XIRR is setup as below, it'll be good
eg
ColA; ColB
1/1/2013; -10000
1/2/2013; -10000
1/3/2013; -10000
.
.
.
=Today();-SUM(Bx:By) ie sum all the rows above for row B but negative it, ie turn it positive

Thanks YKLooi.
Heheh - way too complicated for me.
I just use IF >=365, then show the XIRR, else show simple returns

er.. mana? CH? MY? INDONESIA? BRAZIL? RUSSIA?
nothing major yet wor (net falls of >20%pa) or i missed something?

ya lor small cut only so far
not even comparative to ASEAN ETF's 52 weeks hi vs now (-13% to -16%)

thought U saw real nice lelong blood..

BTW, Shanghai Index up again 4%+.
Yo yo yo!

i know what i am - generally a "long term PUNTER/TRADER", rare like "honest politicians"
but.. seriously, i do look at both net ROI & IRR leh - to get a balanced view

This post has been edited by wongmunkeong: Aug 11 2015, 01:00 PM

wake me when/if it hits 1500+/-

Bull has been gored 3 days in a row & yesterday's was the biggest 1 day hit since 2014 Feb.
Come on baby... gimme value!

momma said:
1. when everyone is ASKING or DOING.. still not enough blood yet (if opportunistic).
2. when everyone curses and/or everything goes silent.. THEN enough blood for opportunistic "fire breakout, rob"

just sharing what momma told me

copulation or capitulation.. doesn't matter coz my YingLish & IQ not enuf hi to UnderStand..
only know keep on going with the plans momma helped me draw up - die die save, invest VCA, buying spree when fire breaks-out

sumimasen.. watashiwa baka-sama

Gold?
May be a wee bit too late now since gold in RM and USD up liao
If one were to be buying when gold went down down down (ie. 2014 last quarter) till like last month+/-, now staring at "forex" gains.
my bad - i tread gold as a different "currency" and average down whenever less than my average cost by xx.xx%

Just a thought

kamsiah kamsiah bro

heheh - momma said only way to grow/learn is to be a bit "uncomfortable" - thus U growing/learning well,
VS my lazy butt didn't google translate capibaralation (not growing/learning)

Thanks to fellow forumer, AVFan, who posted in US stocks thread

Five charts that prove this selloff is serious
http://www.cnbc.com/2015/08/24/market-sell...ive-charts.html

Bottom line: hang-on folks, the ride's beginning.. wohoo!
(thank gawd for asset allocation yeah babe, yeah!)

US futures down 2%+
CH went mad.. but still 52 weeks hi lo is +ve
ASEAN is circling round the toilet bowl, though not flushed down yet (ie. less than 20%-25% kaboom from 52 weeks hi-lo)
Be calm my beating heart - dunno whether from excitement or fear - most probably both

This post has been edited by wongmunkeong: Aug 24 2015, 04:50 PM

dude - even with so much sell downs, those who bought earlier, within the 52 weeks, are still making 30%+/- leh.
IMHO - it aint a bargain... yet

This post has been edited by wongmunkeong: Aug 25 2015, 04:13 PM

energy / petroleum companies still down leh
CVX (Chevron or locally AKA Caltex): ttm PE 11+/-, forward PE 13+/-, Net DY% 4.10%+/- (after 30% tax); bought in yesterday night, thus know a bit more details on CVX;
XOM (ExxonMobil or locally AKA Mobil.. er.. now gone from MY): ttm PE 12+/-, forward PE didn't check
BP
etc etc

Just sharing my PoV
Brent Crude Oil per barrel is currently $42+/-,
fell more than 52% from it's 52 weeks high of $90+
AND
the last time 3 times it fell to $43+/- and below was:
1. a month in Dec 2008 (then boing)
2. 2 months+ in Nov-Jan 2004 (then boing)
3. before that, generally Brent Crude was $30 and below till even $10 per barrel

Taking the above
+ keeping in mind value of $ 2004 and further VS current value of $
+ looking at good & efficient companies (ie. cost to produce per barrel <= $20+/-)
VS
- current stockpile
AND
eventually if price of crude keeps "staying below" break-even, we'll have:
+consolidation of oil producers (ie. survivors eat small fellows) thus more "price control" by sellers
+cheap energy encourages "non-saving" attitude, ie. use lar - buy big cars, use more aircond, etc - creating higher demand
(sounds like the cycle of life & basic economy 101 right?)

Anyhow - i bought to be able to hold for >3 years, not with survival $ ya.
Your mileage may vary if your reasoning + holding power differs - no right/wrong, just wong here

This post has been edited by wongmunkeong: Aug 27 2015, 11:50 AM

As i'm not trading mutual funds / ETFs or stocks, i'd risk "catching a falling knife" if it's of value to me & fits my plans since i pray to buy at discounts

Trading-wise, definitely won't try unless with great premiums-to-risk rewards + a few exit plans (cut loss).

Just thinking that some fellow investors here may understand the "don't catch a falling knife" too literally.
It depends on how it fits one's plans.

Yo J.Passing.By,

Not sifu lar bro - just "see food, eat food" (black hole for food)

U talking about "market correction"?
In "market talk"-wise, yeah i read 10%+/- is such an animal,
20%+/- is a crash, etc etc
---
However, personally i worry about such words being used to categorized, thus summarily programming/affecting my own investing or trading response/thoughts.

Case in point:
It fell 9%-11% yeah. "Correction".
but ar - is it "corrected enough"
eg for China's Shanghai index - the past year+ run-up was like 120%+/- but these past months fell 30%+ only, heck even if 40%, it'll still be crazy-high VS time, though 2 days back it's index has fallen within the 1, 3 & 6 years' standard deviation - becoming a well-behaved animal again
VS
should i assume that it's alright now since "correction" happened liao?
eg. can just buy that index/market liao safe enough
---

Sorry, i digress - just had to point out the danger of using simple "categorization" words that can affect one's judgement/actions.

I'm unsure whether the prices for these 2 days are cosmetic - for quarterly reports.
U talking about US markets right?
All i can "see" & "fact" (my reality, based on my personal perception) is:
1. US markets have hit crazy volatility last Thu till now
We are talking about historically happening like.. 3 or 4 times in EVER! (ie. longer than "Malaysia" existed)

2. Lots of disagreements / bear-bull fighting
Past 2 days - S&P500 opened up very high , then fell, then yesterday jumped like a man on fire

3. I agree with U that S&P500 is now within "normal" price band
- ie not way above or below 1 or 3 or 6 years' standard deviation.
BUT NOT lelong yet generally - i won't happily go buy just coz of some commission discount/promo unless it happens to be my time for VCA

I think at item (3.) - we share the same reality.

However there are pockets of lelong if one were to look into -
eg
to me: HCP or healthcare REITs, CVX+XOM+COP or energy sector
and yes, $ where my mouth is did get into those 2 sectors / stocks

Note - still hope hunting / GTC (good till cancelled) for crazy fear if it continues down another 10%+ for KO & PAYX
i generally hope & buy, then zzz-monitor held
VS buy and hope

This post has been edited by wongmunkeong: Aug 27 2015, 03:02 PM

bro - not saying "mutual funds are bad" like tinkosong ar
just another PoV:
a. Equity Mutual Funds: Mgt Fees 1.5% - 2%pa die die must pay whether market up/down/left/right
VS
b. ETFs: Mgt fees 0.25%pa to 0.75%pa
VS
c. Stocks of individual companies: No mgt fees pa

Assuming:
1. One has the discipline/hunger to save
2. One has enough to transact RM2.5K to RM3K per transaction
3. One has enough time/hunger to do homework
AND
Assuming overall equity market returns 8%pa-10%pa before fees

Just holding (a.) vs (b.) vs (c.):
Mutual funds will "lose us": 1.5% / 10% pa = 15% of our returns every year
VS
ETFs: 0.5% / 10% pa = 5%
VS
Stocks: 0%

Compound the "loses" 60 years (30 years build-up +30 years retirement) and whoa... comparatively lar
Keep in mind whether make or lose, still 1.5% to 2% mgt fees ar.

To some, like me, it may be worth the pain/effort to build up into ETFs and stocks -
ie. while still holding current equity funds / reallocating between funds,
new cash investments only into ETFs and direct stocks.

Screenshot of simple Excel for easy visualization
10% CAGR


8% CAGR


This post has been edited by wongmunkeong: Aug 27 2015, 04:36 PM

heheh - like i said, no absolutes (right/wrong).
I dont begrudge people from making a living
Just that if i myself sweat a bit more and can "pay myself" that 1.5%-2%pa - whoa..

Notice i didn't even compare "entry cost" - each vehicle has it's uses.
Each person may use a vehicle very differently
Those with businesses and/or high flying /paying jobs - i guess no point DIY into ETFs & stocks
VS
kuli like me heheh - hard earned $ leh, i must be like sniper (headshot!) when possible to ensure best deployment of bullet given what is known


This post has been edited by wongmunkeong: Aug 27 2015, 05:18 PM

Got it at ultra-low $70s and it's my 1 of 6 opportunity bullets for 6 months.
Yup, as i shared pros/cons - i dunno where's the bottom & the stockpile, but cycles being cycles..

This post has been edited by wongmunkeong: Aug 27 2015, 08:24 PM