Since Excel 2011 for Mac does not support the msxml2.xmlhttp or winhttp.winhttprequest.5.1 objects (for downloading of webpage), and does not support creating HTML/XML data objects (for manipulation of data) and does not support regular expressions (wtf?) (for data extraction), this macro relies on two applications bundled with OSX: cURL (to download the page), and the Perl Interpreter (to extract and manipulate data).

The command being run is as follows (+ explanation):

curl: "See URL". Used to download pages/resources at a URL.
--silent: Does not print progress
--get: Uses HTTP GET to send the data specified in -d
-d: The data to send
"id=FUND_CODE_HERE": The "fund code" part of the URL
https://www.fundsupermart.com.my/main/fundinfo/dailyPricesHistory.tpl: The webpage

So this command downloads the webpage at https://www.fundsupermart.com.my/main/fundinfo/dailyPricesHistory.tpl?id=FUND_CODE_HERE

|: The "pipe" character. This sends the output of the first command to the second command.
perl: Run the Perl Interpreter. This is a program that can run codes in the Perl programming language.
-0777: Prevents line splitting (take all input and consider it as one line)
-n: Take previous output and take it into Perl line by line
-e: Execute the given command (in quotations, explained below)

At this stage, we've taken the downloaded page and dumped it into Perl for processing. The next step is to run Perl code/instructions to extract and manipulate the data.

print "$1;$2": Print the first extracted data ($1, this is the NAV), and second extracted data ($2, this is the date)
if: Run the "print" command if the next pattern matches
/"a">.*?(\d+\.\d+).*?bdtext_style\W>(.*?)<\/td>/s: This is the pattern (Regular Expression pattern), it just describes the text of the HTML file and extracts the NAV (\d+\.\d+) and date (.*?)

QUOTE(skynode @ Feb 6 2017, 08:50 PM)
Okay, I need to hear out some ideas/opinions from you guys.

PROBLEM A
Remember I was asking reg PMB transfer of funds to FSM?  Now I am having a dilemma.
In view of current market being quoted as possibly overvalued by others...
Option 1 : Should I reinvest ALL my funds from PMB to my designated portfolio and enjoy the zero percent sales charge?
OR
Option 2 : Should I just reinvest RM10k first, then do VCA for the remaining funds every month but losing out on the zero percent sales charge once the 1 month period has passed?
Which is more logical and economical?

PROBLEM B
I am going to put in RM1000 into PRS to get the one-off RM1000 initiative from government.  Rather than RM1000, would it be also reasonable to top up RM3000 every year (till 2021) to enjoy the tax rebate benefit?

PROBLEM C
Manulife Equity USA versus Aberdeen Global Fund
Global fund has better diversification (includes European countries) but why are most people more keen on 100% USA fund?  Isn't it riskier?  Or is it because the presumed Risk Reward ratio is better?

hmm.gif  hmm.gif  hmm.gif