//
you're reading...

Software

Downloading Fundsupermart daily price history

In case you haven’t notice it, by default Fundsupermart only offers an indexed return graph in the fund’s information page. That may be useful if you only bought the fund at its initial offering and plan to keep it until it divests itself. However most of us only start investing after the fund in question have gained a significant size and thus been around for quite some time. Thus we need the price graph to help decide when is a good time to buy and at what point we should sell. Fortunately Fundsupermart does offer this information but it’s not in a convenient graph form – it offers a historical list of prices and valuation dates and goes back to about three months. In this post, I’ll outline three ways to get a line graphs of the historical prices.

Option One – Excel Web Query

This option involves finding the fund’s historical prices page and use Microsoft Excel to download the data and format it into a nice line graph. Although the example was made using Firefox and Excel, the idea is similar for other brands of web browser and spreadsheet.

1. Go to the Fundsupermart website. For Fundsupermart Singapore this will be http://www.fundsupermart.com.sg – replace the trailing country top-level domain in the end of the URL with HK for Hong Kong and MY for Malaysia branches.

2. From the Funds Info menu choose Daily Prices

3. Choose a Fund House and then choose a dealing date two business days back then click Display. Then click the 3 Months Price History link

4. The price history will be displayed in a separate window. Right click and choose View Page Info
5. Take note of the Address field – this contains the URL of the price history page.

6. Open Excel and create a new document. Chose Data | Import External Data | New Web Query

7. Paste the address obtained earlier and select the table, this should place a green checkbox in the table’s upper-left section as pictured below

8. Import into the current worksheet and use cell A1 as the destination.


9. Delete the first two rows and sort the table so that the dealing date is arranged increasing order. I used the “No.” field and sort descending.

10. Select the “Bid/NAV Price” column and then create a line chart from it. There you have it, a three-month price history chart from Fundsupermart.

Option Two – Fundsupermart Widget
If you happen to use a Mac computer, there is a dashboard widget that displays the fund prices from Fundsupermart Singapore. The widget’s name is (straighforwardly) Fundsupermart Widget and available from the author’s web site (or Apple’s widget directory site) as a free download.

Option Three – Fund Watch for the iPhone and iPod touch
For those that have an iPhone (or iPod touch with Internet connection), Fund Watch may be used to monitor Fundsupermart prices via your iPhone.  Being a commercial application, Fund Watch supports all four regions of Fundsupermart: Singapore, Malaysia, Hong Kong, and India.



Do you enjoy this post? Enter your e-mail address below to receive articles like this one in your mailbox.
* indicates required

Discussion

No comments yet.

Leave a Reply

Free Updates!

Learn how to grow your indie business while keeping your day job.

Categories

Archives

Keep updated!

Don't miss out on new articles!