Welcome Guest ( Log In | Register )

Bump Topic Topic Closed RSS Feed
5 Pages < 1 2 3 4 > » Bottom

Outline · [ Standard ] · Linear+

 Fundsupermart.com v8, The MS Excel Masterclass version!

views
     
nexona88
post Jan 22 2015, 06:37 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(Pink Spider @ Jan 22 2015, 05:23 PM)
Recently Shanghai index can swing up to +/-7% a day whistling.gif
*
they don't have like limit up/down thingy? hmm.gif
nexona88
post Jan 22 2015, 08:17 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(yklooi @ Jan 22 2015, 07:20 PM)
Got this from the web....
"How much did shares fall?
At one point Monday, the Shanghai Composite Index was down 8.3 percent. It later trimmed that to a loss of 7.7 percent. Share prices of brokerages were hardest hit, with some falling by the daily loss limit of 10 percent. Despite the sharp fall, the Shanghai Composite Index is still up 55 percent in the past 12 months and up 33 percent for the past three months.
*
thanks. keyword found.. it's 10% icon_rolleyes.gif
nexona88
post Jan 29 2015, 09:55 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
http://www.marketwatch.com/story/too-late-...rket-2015-01-28

cool2.gif whistling.gif
nexona88
post Jan 29 2015, 10:00 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
I am so bearish, I am growing fur! ohmy.gif tongue.gif
nexona88
post Jan 29 2015, 10:03 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
Oil’s Slide Shakes Up Southeast Asia’s Markets
Thailand Overtakes Malaysia as Home to Region’s Second Biggest Stock Market

» Click to show Spoiler - click again to hide... «




This post has been edited by nexona88: Jan 29 2015, 10:06 PM
nexona88
post Jan 30 2015, 03:39 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
The terms "bear" and "bull" can be found on the net..

juz google pun boleh dapat answer yawn.gif semua nak spoonfeed cool2.gif
nexona88
post Jan 30 2015, 10:30 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
US economy grew 2.6 per cent in the fourth quarter – below consensus expectations for a 3 per cent increase. That was a marked slowdown from the 5 per cent annualized pace set in the third quarter.
http://www.ft.com/intl/fastft/270462/us-gr...-fourth-quarter
nexona88
post Jan 31 2015, 09:53 AM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
US Stocks sag at the close; January finishes on weak note
http://www.wral.com/world-stocks-uneven-ah...eport/14405994/
nexona88
post Jan 31 2015, 04:34 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(T231H @ Jan 31 2015, 04:31 PM)
Why NOT? May NOT.
tell you when the time come  tongue.gif
*
laugh.gif rclxms.gif
nexona88
post Feb 2 2015, 05:04 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(woonsc @ Feb 2 2015, 04:21 PM)
haha FSM slowly slipping ur money away~  biggrin.gif  biggrin.gif
*
lol small matter only tongue.gif

not enuf for building bungalow tongue.gif

This post has been edited by nexona88: Feb 2 2015, 05:05 PM
nexona88
post Feb 2 2015, 05:06 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(yklooi @ Feb 2 2015, 05:03 PM)
doh.gif  never knew about that....no wonder Hw site also no updates...thanks for the input, else will still try to check for updates....
*
tomorrow also holiday in KL... Taipusam tongue.gif
nexona88
post Feb 3 2015, 12:33 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(Pink Spider @ Feb 3 2015, 12:30 PM)
How about BolehLand, got chance to reduce rate not this year hmm.gif
nexona88
post Feb 3 2015, 12:43 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(Pink Spider @ Feb 3 2015, 12:37 PM)
Watch out for KLSE yield stocks esp REITs tomorrow brows.gif
*
I will do that brows.gif
nexona88
post Feb 3 2015, 01:04 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(Pink Spider @ Feb 3 2015, 12:51 PM)
aku belum kahwin blush.gif
*
Ada Wang Ada Amoi tongue.gif
nexona88
post Feb 3 2015, 01:36 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(woonsc @ Feb 3 2015, 01:27 PM)
how to search?  rclxub.gif  rclxub.gif
*
lol go to page 76 icon_rolleyes.gif


nexona88
post Feb 3 2015, 04:38 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(woonsc @ Feb 3 2015, 04:33 PM)
haha with your investing skills, you can afford to have 2 wifes loo~  notworthy.gif  notworthy.gif  notworthy.gif
*
1 wifu enuf la, but can have a lot of "extra gf" around brows.gif
nexona88
post Feb 3 2015, 06:03 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(polarzbearz @ Feb 3 2015, 05:42 PM)
Everyone's enjoying our long weekends huh rclxm9.gif

All the girls talk aside, a little bit of off topic technical post here as usual tongue.gif

I've completed the development of the conversion tool and tested it a few rounds, and I think it should be ready-to-go.

----------------------
Released v1.5 for the Spreadsheet, can be downloaded via clicking here. This will really be the last major update for a while (it's just to accommodate a few new Transaction Types after discovering it through long list of FSM data)  icon_idea.gif

Change log:
CODE
Fixed a bug which might cause Summary IRR to be shown as 0 due to retired funds; by using workaround which places dummy values on retired rows without affecting the actual IRR value
Fixed the data validation for Transaction Amount column for type=Dividend (now properly rejects non-positive values)
Updated Data Validation for ""Sales Charge / Redemption Fee"" field from accepting values between 0% - 100% to accepting values between 0% - 200% (semua salah investment-linked insurance policy)
Added ""Unit Split"" and ""Transfer In"" type. The transaction type has the same treatment as per current set-up for Dividends (Add additional units directly to the fund).
Updated formulas and data validation to accomodate the new units
Slight tweak to the formating of ""FACT SHEET DATE"" to Month & Year only.
Separately built FSM CONVERSION TOOL (for copy-pasta from FSM HISTORIC transactions) - compatible with spreadsheet v1.4 or higher (v1.4 spreadsheet will need to manually change some of the Transaction Types, as it is not existing in v1.4 yet)

p/s: as usual, let me know if spotted any errors ya blush.gif

----------------------
And also released v1.0 of the Conversion Tool, can be downloaded via clicking here. Please make sure you carefully read the instructions ya, it may look complicated but once you understand how it works (through the Instructions), you should be able to easily convert FSM data into format which can easily be copied-and-pasted into my template (make sure you paste as VALUE only; otherwise formatting will definitely go haywire).
[attachmentid=4328841]
Change log:
CODE
Initial Version
Tested and working for Spreadsheet v1.4 or higher.
For spreadsheet version 1.4; ""minor tweaks"" to the converted data will be required - if your transactions has ""Transfer In"" or ""Unit Split"" type. This is because v1.4 spreadsheet does not have these T-Type yet.

Special thanks to contributors whom have contributed their sample FSM data to speed up the development & testing of this tool.

*
So Nice of u thumbup.gif thumbup.gif notworthy.gif notworthy.gif

This post has been edited by nexona88: Feb 3 2015, 06:04 PM
nexona88
post Feb 4 2015, 01:15 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(Pink Spider @ Feb 4 2015, 12:41 PM)
Just edited Post #1 in honour of Polarzbearz...

"The MS Excel Masterclass version!"

tongue.gif
*
Good Job to both of u rclxms.gif notworthy.gif
nexona88
post Feb 4 2015, 09:56 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(David83 @ Feb 4 2015, 09:08 PM)
Portfolio ROI: 9.7%, IRR: 4.6%

Laggard: Eastspring Investments Equity Income Fund
Top performer: Aberdeen Islamic World Equity Fund - Class A
*
rclxms.gif thumbup.gif
nexona88
post Feb 4 2015, 10:02 PM

The Royal Club Member
*********
All Stars
48,479 posts

Joined: Sep 2014
From: REality
QUOTE(woonsc @ Feb 4 2015, 09:58 PM)
tongue.gif just my manulife india equity.. tongue.gif ROI 158% Woots~
yeah right.. no wrong.. 158%
  drool.gif  drool.gif  drool.gif
*
woah shocking.gif when u bought it? hmm.gif

5 Pages < 1 2 3 4 > » Top
Topic ClosedOptions
 

Change to:
| Lo-Fi Version
0.0285sec    0.46    7 queries    GZIP Disabled
Time is now: 11th December 2025 - 01:03 AM