I am experiencing the same trying to trouble download stock and mutual fund prices. Total number to update is 32 and by running update function multiple times over last 24 hours have gotten all but 5 to update. I use a Mac, v 2017.7.1 of Moneydance and v1018 of the Q&ER updater (set to Alphavantage & ER disabled). Last full update was 5/30/18. What fixed it for you, davier12? Or, is running the update repeatedly the only solution at this time?
Thank you, derekkent23, for the quick reply. I will wait a bit, see if Alpha Vantage problem sorts out; if it doesn't will try the other one. I don't really know what it is or does but will assume it does what I need (downloading accurate stock and MF prices) and that installation instructions can be followed by an intelligent lay person.
Are MD users in general migrating to this program for accurate and speedy price downloads/updates?
Basically, you enter your security symbols into a symbols window. it stores then for future use. You click on the Update Prices button. The quotes are returned in the Quote Source Prices window. You click to export the quotes in a CSV file format. You use an extension in Moneydance to import the CSV file into Moneydance. Done.
People have reported although there are more steps involved the process is reliable and take less time.
The stand-alone program is feature rich. Most people don’t need these extra features and just use its basic functions. The PDF cover all the features available and thus at first sight can look daunting. Just follow the steps you need and ignore the rest, its simple.
Alpha Vantage has poor coverage of some MF prices especially outside the US and is often late in updating prices. For example, I have 39 securities, Alpha Vantage finds 5 and of these one is over a year out of date. The stand-alone program has two sources, one of these finds 37, all up to date.
Just post if you find initial problems, once set up its easy to use.
and go to Extensions > Manage Extensions, you should see an update for the Quotes and Exchange Rate extension (v1018), install it and set the security prices and exchange rate to Alphavantage, then click on 'Set API key'.
I can't speak for other users, but I have been disappointed with the
Alphavantage solution. I gave it more than enough testing and
perseverance, but "it is what it is".
Using the other solution as mention in the forum is somewhat awkward
(manual steps), but highly reliable. I use it for mutual funds so there
are some quirks that I deal with as a standard daily process:
(1) I have retained the configuration of the mutual funds symbols on
Yahoo finance. In this manner, I can check if Yahoo has
received/processed the updates (or which one could be missing. Usually,
all of them are in by 6:30 (New York). [Probably would do the same thing
with alphavantage becuase ti gets its information from that source]
(2) If #1 is okay, I start up hleofxquotes and do an update. I have it
running idle most times so I don't waste time waiting for it to
start...not that it takes a long time.
(3) From MD, I will click through for the stock loader extension, when I
see that the file has been created, load the data, and apply, followed
by two clicks to close the extension. This one I do not leave open!
(4) enjoy! If Yahoo Finance cooperates, it takes no longer than what it
did before Yahoo Finance stopped updating though their API. And, it is a
whole lot quicker than using alphavantage!
I toyed around with Alphavantage for about a week.
(1) I too keep my tickers configured in a Yahoo finance portfolio.
(2) Instead of generating the CSV file using the hleofxquotes tool, I export the CSV directly from the Yahoo finance portfolio page.
As an added shortcut, I copied the link address of the 'Export' link on the Yahoo portfolio page and created a bookmark to it.
From my browser, I simply click the bookmark and the CSV file (quotes.csv) downloads directly to my 'Downloads' folder.