*Official* SGXcafe Thread

[dolph001]

I seriously think this XIRR thing is a joke.
Until now I still dunno what is going wrong with this table:

share your transactions lor. i help you proof read

 

[lewissac]

Day Change = (-0.13%)
P&L = (+1.51%)
P&L + Dividends = (+1.51%)
P&L + Dividends + Closed = (+1.51%)

 

[OngHuatHuat]

I shared my transactions on sgx cafe.

share your transactions lor. i help you proof read

 

[exactmat]

Day Change +129 (+1.44%)
P&L -105.5 (-1.15%)
P&L + Div +53.6 (+0.58%)
P&L + Div + Cls +3,402.89 (+37.03%)

 

[Layers]

Day Change = (-0.13%)
P&L = (+1.51%)
P&L + Dividends = (+1.51%)
P&L + Dividends + Closed = (+1.51%)

sic link?

Sent from Sony E6853 using GAGT

 

[lewissac]

sic link?

Sent from Sony E6853 using GAGT

Pai seh, how to sic link ah? Just created sgxcafe account. So not really sure how to do that.

Edit: found it. Slightly complicated than expected.
https://www.sgxcafe.com/user/profile?username=div1g4in

 

[OngHuatHuat]

Search my shared profile.
I didn't hide any information.

share your transactions lor. i help you proof read

 

[Gnoixed]

Day Change = (+1.35%)
P&L = (-5.87%)
P&L + Dividends = (-5.60%)
P&L + Dividends + Closed = (-2.36%)

 

[giffgaff]

Day Change = +237 (+0.95%)

thanks to keppel!

 

[potNPan]

Day Change = -158 (-0.76%)

 

[dolph001]

I shared my transactions on sgx cafe.

your XIRR, excluding dividends, is only 14%

You might want to check your dividend history

 

[OngHuatHuat]

your XIRR, excluding dividends, is only 14%

You might want to check your dividend history

How you get the XIRR without dividend?

So I only manage to achieve XIRR of 14% without dividend.
Quite sad.

 

[dolph001]

How you get the XIRR without dividend?

So I only manage to achieve XIRR of 14% without dividend.
Quite sad.

I copy paste all your transactions into spreadsheet.
Change all buy transaction values to negative (cash outflow)
Add portfolio value at today's date

=XIRR(cashflow amounts, cashflow dates)

 

[dolph001]

How you get the XIRR without dividend?

So I only manage to achieve XIRR of 14% without dividend.
Quite sad.

erm... paiseh
I copied the "Total Cost" instead of "Total Value".
Your net cashflow is +191 only.

XIRR, excluding dividends is +0.07%

 

[OngHuatHuat]

erm... paiseh
I copied the "Total Cost" instead of "Total Value".
Your net cashflow is +191 only.

XIRR, excluding dividends is +0.07%

Now it is only 0.07 % without dividend. I feel so sad.

https://www.sgxcafe.com/user/profile?username=yyhwin

So this XIRR of 176.42% actually bluff people.
Sigh.....

 

[TheIntelligentInvestor]

Cost = 777,144.362, Current Value = 820,585.69, Cash Holdings = 0.0
Day Change = +8.11 (+0.0%)
P&L = +43,441.33 (+5.59%)
P&L + Dividends = +80,618.18 (+10.37%)
P&L + Dividends + Closed = +337,410.11 (+43.42%)

 

[Average]

Day Change = +0.0%
P&L = -2.1%
P&L + Dividends = -1.8%
P&L + Dividends + Closed = -1.5%

Sent from 穷小子 using GAGT

 

[dixie pig]

Cost = 777,144.362, Current Value = 820,585.69, Cash Holdings = 0.0
Day Change = +8.11 (+0.0%)
P&L = +43,441.33 (+5.59%)
P&L + Dividends = +80,618.18 (+10.37%)
P&L + Dividends + Closed = +337,410.11 (+43.42%)

Hi bro, do you share your transactions/portfolio on sgxcafe?

 

[Dividends Warrior]

Hi bro, do you share your transactions/portfolio on sgxcafe?

Yes, he does. He is tii.

https://www.sgxcafe.com/user/profile?username=tii

 

[Gnoixed]

Day Change = (-0.30%)
P&L = (-6.15%)
P&L + Dividends = (-5.89%)
P&L + Dividends + Closed = (-2.65%)