Again thank you for the help.
If Alpha Vantage does not support Canadian mutual funds then I will have to use the third party method.
I just was not sure if I was doing something wrong. No one else seemed to mention any issues with updating unit prices. All of my funds come up with no data or only returns a price for dec 18, 2017. I am not sure why Alpha would issue a unit prices up to that date and then stop updating.
If anyone can explain why Alpha is not working, please let me know. I would also like to know if it is working for your Canadian Mutual Funds. How do you correct the situation if possible?
In addition, is Moneydance still trying to fix the issue or is it satisfied with the third party fix and is no longer working on the problem. If so will the third party fix become a built in extension for their software?
Ethan on 13 Jan, 2018 08:39 PM
We're still searching for better solutions, but at the moment, Alpha Vantage is the only service we've found that provides a wide coverage of securities at no cost in a format that third-party software can use. We are definitely aware that it is not meeting all of our customer's needs.
It is nice to hear back from Moneydance.
It just seems like users are the only ones working on the problem.
I would like Moneydance to know that I would appreciate a Moneydance extension not a third party work around to downloading unit prices.
Please advise users on the progress; a few update reports would be appreciated.
I am also waiting for this issue to be resolved. For several of my Canadian funds old quotes are still being returned (using Yahoo's fund codes) from Alphavantage, but there have been no new quotes since Dec 2017. Other funds simply return "No data found".
I tried switching a couple from the Yahoo code to standard Can. fund code (e.g. PIMCO Monthly Income A, yahoo code F00000LVW4, standard code PMO005) but standard codes seem to be totally unrecognized.
I use a free stand-alone program to obtain quotes and then import the results into Moneydance.
I entered your example fund into the program and it returned a quote. See screen shot.
The program was originally developed to help out users of MS Money when Microsoft stopped supporting that product. The program is in java, like Moneydance and thus runs on Windows, Mac and Linux computers. The developer has adapted it to work with Moneydance and is actively supporting the program. This program is very stable and the quotes very consistent with the option of two sources, not Alpha Vantage. No strange prices. It has a lot of useful features. These include, obtaining prices from many stocks and fund quoted on different exchanges, US, Canada, UK, Europe and Australia. The program has the ability to convert quotes from one currency to another. Convert prices in Pence to Pounds, if required, for UK stocks and funds. More features in the pipeline. Provide a means for importing all this data into Moneydance. You can also import exchange rates along with your security prices, if required.
Take a look at his thread and download the PDF outlining how to use the program and link to download the program.