If you are running the latest build of Moneydance and the v1018 of Q & ER, then it’s as good as it gets with that setup.
I have given up on the Q & ER extension.
I am now using a free stand-alone program that 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.
I have taken a guess on the symbols for the three securities you mentioned and entered them into the stand-alone program, see screen shot.
It looks like AlphaVantage has changed the timing criteria again for free downloads. It now times out after 4 stock prices. The page https://www.alphavantage.co/premium/ says that it allows 5 prices each minute but they may have adjusted that to push folks to pay for a "premium" API key. It may be a cat and mouse game to try to stay within AVs continually moving target for free service. This was just the kind of thing that Infinite Kind was trying to avoid by not scraping web pages to get around the Yahoo blocks as hleofxquotes does. Sigh.
In certain high-frequency use cases that exceed our standard call-frequency limit (5 requests per minute), we offer a dedicated, premium API key which allows various tiers of API calls per minute. ... This premium API key is priced exactly at the cost charged by our cloud hosting and infrastructure provider.
Given the pricing structure, I doubt that this is the cost of the cloud hosting. I can get a lot of hosting infrastructure for that price! In fact it seems that they mean each subscriber pays the whole cost of hosting!
I do appreciate all of the community recommendations, but stock price updates have been a part of the product since I started with the 2011 version. I only updated to 2017 recently, because that was the only official way to get stock prices, and now that does not even work.
I'm mostly frustrated with IK -- the inability to download stock prices has been the most talked about issue on this site for months now -- and I have not seen one response from them.. Why would they not acknowledge the problem and give us an idea of what they are planning as a solution? Or just say they will not be supporting stock price updates... something, anything? That is is really bad customer service, to say the least.
If you are not satisfied with the support you are receiving I can only suggest you do what people should initially do whenever they are dissatisfied and that is complain to the management.
In the case of Moneydance that means Sean Reilly and his email is
sreilly (at) infinitekind (dot) com
Yes the quality of support being shown of late, well in quite a while in my opinion, is bad, it reflects badly on the support people, badly on the product and badly on the company and in the long run could cause the company to fail, I'd rather see the company and the product succeed. As some one who frequents these forums and chimes in with suggestions where I can I know I'm frustrated with the current situation.
TiK is not to blame for AlphaVantage, what their business model was was questioned at an early stage, I think we are now starting to see their intention and I question their ethics in how they have gone about it. Where TiK has failed is in their complete silence, a cardinal rule of support is to acknowledge problems and keep the customer informed, most customers are not unreasonable.
Ian O on 22 Aug, 2018 03:02 PM
Sorry to hear you're encountering issues while using Moneydance. Alpha Vantage have introduced a new premium service, the details of which can be seen on their website here - https://www.alphavantage.co/premium/
We needed to make some adjustment in the extension so it can accommodate this new service and prices can download smoothly. Downloading may appear a bit slower in the new version but shouldn't result in errors, this is because Alpha Vantage's free service allows 5 requests per minute. We have just published v1020 of the extension. This version should improve things for some customers but we're still tweaked the extension and hope to release an optimised version soon. I'll ensure you'rel notified when this new version is available.
Please accept my apologies for the inconvenience caused by this issue.
If I understand the Alpha Vantage premium service levels correctly, it would cost me $49.95/mo to get 30 stock prices. That's a bit much for me so I guess I'll have to continue with maintaining a portfolio on Morningstar's website, exporting my stock/fund prices to Excel and then importing a csv file to Moneydance using Mike Bray's security price loader. Because it's less convenient I'll probably only do it once a week now. Bummer!
I hope that that is not the long term solution/goal for this problem -- for each MD user to pay Alpha Vantage roughly $240-$720 a year to get stock quotes! For me, just to get 60 stock quotes - once a day? I don't think so!
It don't really have a problem paying for the service -- like $20 a year - maybe. Not 5 times (or more) than the cost of the software that requires it!
Have you reached out to Alpha Vantage to negotiate some kind of integration deal that would be integrated into MD? That would seem like a logical solution, rather than making each user deal with AV... Just a thought...