*Official* SGXcafe Thread

Gnoixed

Member
Joined
Nov 27, 2008
Messages
317
Reaction score
0
Day Change = (-1.84%)
P&L = (-13.78%)
P&L + Dividends = (-13.43%)
P&L + Dividends + Closed = (-10.04%)
 

Gnoixed

Member
Joined
Nov 27, 2008
Messages
317
Reaction score
0
Day Change = (-1.54%)
P&L = (-12.93%)
P&L + Dividends = (-12.64%)
P&L + Dividends + Closed = (-9.83%)
 

potNPan

Member
Joined
Jun 1, 2010
Messages
472
Reaction score
5
Day Change = -85 (-0.58%)

Don't remember last Friday got update or not but that was also red. Thanks, Trump.
 

dolph001

Senior Member
Joined
Apr 29, 2008
Messages
505
Reaction score
5
anyone got a problem with the XIRR and time-weighted returns? When I key in some of my past transactions, I get things like -100% on some years and 1000% on others. Wonder what's the underlying algo.

Check out Internal Rate of Return.

XIRR uses dates to calculate IRR. if your portfolio is small and you FIFO, your XIRR will be very big negative or positive.

i.e. A portfolio with a single contra position with 10% gain over 3 days is roughly 10866909% XIRR.


Sorry ah... reading thread from the very first post
 

Gnoixed

Member
Joined
Nov 27, 2008
Messages
317
Reaction score
0
Day Change = (-1.51%)
P&L = (-14.25%)
P&L + Dividends = (-13.96%)
P&L + Dividends + Closed = (-11.15%)
 

dolph001

Senior Member
Joined
Apr 29, 2008
Messages
505
Reaction score
5
Some of my 2013 contract notes are incomplete. Then some of them I bought in 2013 and sold in 2014, like that might as well just take out that 2 years to better reflect my positions in these 2 years.

Should have the habit of putting everything in excel for all my years, but too bad I only have that habit ever since 2012.

yyhwin, does this look familiar to you?

3.png


This person also started recording in excel since 2012, but incomplete data in 2013 .:s13:
 

OngHuatHuat

High Supremacy Member
Joined
Jul 10, 2006
Messages
28,381
Reaction score
2,491
I never really keep track.
Now based on whatever contract I have on hand, I am + 44.41 % since 2012/2013, including paper loss on noble, excluding my recent purchase which I do not wish to disclose.

MrNtANz.jpg


some financial blogger
 

dolph001

Senior Member
Joined
Apr 29, 2008
Messages
505
Reaction score
5
I never really keep track.
Now based on whatever contract I have on hand, I am + 44.41 % since 2012/2013, including paper loss on noble, excluding my recent purchase which I do not wish to disclose.

This guy +50% at end 2015. Roughly there la.
Is that you?=:p
 

OngHuatHuat

High Supremacy Member
Joined
Jul 10, 2006
Messages
28,381
Reaction score
2,491
Not me.

In 2012/2013, I shifted most of my funds from stock market to real estate market, so that I can take advantage of my young age to own more properties.
In 2014, I restarted my stock investment after a significant decrease of my funds in previous 2 years.



This guy +50% at end 2015. Roughly there la.
Is that you?=:p
 
Joined
Apr 22, 2016
Messages
106
Reaction score
9
Check out Internal Rate of Return.

XIRR uses dates to calculate IRR. if your portfolio is small and you FIFO, your XIRR will be very big negative or positive.

i.e. A portfolio with a single contra position with 10% gain over 3 days is roughly 10866909% XIRR.


Sorry ah... reading thread from the very first post

Thanks! This does seem similar to what I was doing - adding those 1 to 2 days trades. Didn't seem to have a problem when I was doing it in Excel though..
 
Important Forum Advisory Note
This forum is moderated by volunteer moderators who will react only to members' feedback on posts. Moderators are not employees or representatives of HWZ Forums. Forum members and moderators are responsible for their own posts. Please refer to our Community Guidelines and Standards and Terms and Conditions for more information.
Top