Bloomberg Quote Server for Canadian Mutual Funds

[Septaj]

Bloomberg now lists Canadian mutual fund historical prices for the preceding 5 years.

It is not clear whether the prices are adjusted for distributions, or whether distributions are available.

Prices for mutual funds in many countries are apparently now available: http://www.bloomberg.com/markets/funds/

Hope you will add the Distributions module for Yahoo Historical in FM Personal. Without distributions, FM Personal is severely crippled.

[Mark]

Hi Septaj,

I just tested retrieving a sample Canadian fund from both "Bloomberg" and "Bloomberg (Historical)", and they both retrieved the requested data okay. Were you asking a question about Bloomberg, or just pointing out that they offer these quotes? FYI, the example ticker symbol I used was AUI-U:CN.

As you may have seen, we also recently added a new server "Google (Historical Mutuals)", as described here:

viewtopic.php?f=6&t=2504

So, there are multiple sources for historical quotes on Canadian mutual funds.

You have requested the distribution feature for Yahoo (Historical) be added to the Personal version many times in your posts. We will just have to disagree on this. I do not see the Personal version as being "severely crippled" without this feature. You have many alternatives. You can use "Yahoo (Adjusted Historical)" if you want to automatically include distribution information in items you don't own. If you do own investments, record your actual distributions as transactions. You can manually enter distributions, import them from a variety of files, or retrieve them from your broker. If this feature is very important to you, you can of course use the Professional version.

[Septaj]

1) Are either Bloomberg Historical or Google Historical adjusted for distributions? If not, performance calculations for these will not be correct.

2) Do FM yield calculations for Yahoo Historical with distributions, & Yahoo Adjusted Historical present the same results? I have asked this before but you have not provided a complete answer. I asked how FM uses the distribution "adjusted" numbers from Yahoo Adjusted Historical in the yield calculations.

3) Hobbling FM Personal may make business sense for Beiley Software, but it remains a significant detriment for FM Personal users. As another has commented here: without distributions, Fund Manager is useless for determining historical performance of mutual funds - or equities, or other investments - one may wish to purchase.

[Mark]

Hi Septaj,

Fund Manager is portfolio management software. It is meant to track and report the performance of your portfolios. It is not data mining software. You can use Fund Manager to record your holdings, with all their associated transactions, and you will get accurate reports, including performance numbers.

if you're trying to use Fund Manager to data mine, and want to include distribution data, you can use the Yahoo (Adjusted Historical) quote server, which does include the effects of distributions.

1) No, Bloomberg/Google historical quotes are not adjusted for distributions. You should use these servers for retrieving actual prices, and record your received distribution in your held investments.

2) Yes. See my other post where you asked about this, and I spent considerable effort trying to reproduce your situation, and explained the results in detail. If you have un-answered questions on that, please post your follow-up question in that topic:

viewtopic.php?f=5&t=2482&p=9271#p9271

3) You can use Yahoo (Adjusted Historical) for this. You can also use any other data source you may have access to. Besides retrieving prices, you can import from a wide variety of file formats. You did not provide a link to the other comment you referenced, so I can't comment on that particular user's comment.

Fund Manager's main purpose is not data mining, as I've mentioned above. It is more geared towards tracking the portfolios/investments that you own. In these cases you want actual closing prices, and record/import/retrieve your actual transactions to get accurate performance figures.