tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/3143-stock-price-updaterInfinite Kind: Discussion 2018-10-18T14:10:10Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-23T20:08:39Z2018-01-23T20:08:39ZStock price updater<div><p>Hi Paul,</p>
<p>What version and build number of Moneydance are you using? (Menu bar > Help > About Moneydance)<br>
e.g MD 2017.6 (1656)</p>
<p>What build number of the Quotes and Exchange Rates updater extension are you using? (Menu bar > Extensions > Manage Extensions > Q&ER updater)<br>
e.g. v.1012</p>
<p>Did you purchase Moneydance through the Moneydance website?</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-23T20:12:19Z2018-01-23T20:12:20ZStock price updater<div><p>Thanks Kevin.</p>
<p>I’m using Moneydance version 2017.6 (1656)</p>
<p>Q&ER updater version 1012</p>
<p>Yes, I bought Moneydance direction from the Moneydance website.</p></div>Paul Smithtag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-23T20:27:47Z2018-01-23T20:27:47ZStock price updater<div><p>Hi Paul,</p>
<p>When you install v.1012 of the Q&ER updater, you should be prompted to get a free, API key from AlphaVantage and you're provide with a field to enter it.</p>
<p>Did you do so?</p>
<p>-Kevin N.</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-23T20:57:02Z2018-01-23T20:57:03ZStock price updater<div><p>That doesn’t sound familiar. Can I remove it and reinstall and see if that happens?</p>
<p>Paul</p></div>Paul Smithtag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-23T20:59:04Z2018-01-23T20:59:04ZStock price updater<div><p>Hi Paul,</p>
<p>Yes, I would suggest you give that a try.</p>
<p>-Kevin N.</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-23T21:08:16Z2018-01-23T21:08:17ZStock price updater<div><p>I removed and reinstalled it. But it didn’t prompt me for any key. How can I get that key and what do I do with it once I have it?</p>
<p>Paul</p></div>Paul Smithtag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-23T21:19:44Z2018-02-04T15:35:49ZStock price updater<div><p>Hi Paul,</p>
<p>I'm afraid that I'm not sure how to proceed from here.</p>
<p>I will yield to the Moneydance support staff to help you further.</p>
<p>Sorry that I couldn't be of more help but without the prompt and subsequent API key, the Q&ER updater will not retrieve your quotes.</p>
<p>If you are interested, there is a free, third-party app called hleofxquotes that can create a QIF file or CSV file that can be imported into Moneydance to update your quotes. It's what I use instead of the Q&ER updater. Forum member derekkent23 posted information about it here.<br>
<a href="http://help.infinitekind.com/discussions/investments/3036-third-party-quote-and-exchange-rate-program-from-hleofxquotes">http://help.infinitekind.com/discussions/investments/3036-third-par...</a></p>
<p>He posted an updated PDF info here:<br>
<a href="http://help.infinitekind.com/discussions/investments/3036-third-party-quote-and-exchange-rate-program-from-hleofxquotes#comment_44650028">http://help.infinitekind.com/discussions/investments/3036-third-par...</a></p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-23T21:24:31Z2018-01-23T21:24:31ZStock price updater<div><p>The new Quotes and Exchange Rates is available in Moneydance via Extensions --> Manage Extensions. You'll see an 'Update' button next to the extension name.</p>
<p>The new extension pulls data from <a href="https://Alphavantage.co">https://Alphavantage.co</a> which is a free service that specifically provides an API for people and apps to retrieve prices for exchange rates and security prices.</p>
<p>When using the updated extension for the first time, you should select Alpha Vantage as the source. You’ll then be prompted to visit the Alpha Vantage site to claim an API key. This may be the step you're missing. You can then enter the key into Moneydance to begin downloading your prices and rates.</p>
<p>Ethan<br>
Infinite Kind Support</p></div>Ethantag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-23T22:53:45Z2018-01-23T22:53:46ZStock price updater<div><p>Ethan and Kevin, thanks very much. That seems to have worked. I was able to get an API key and found the place to select Alpha Vantage as the source. Cheers! :-)</p></div>Paul Smithtag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-23T23:17:37Z2018-01-23T23:17:37ZStock price updater<div><p>Hi Paul,</p>
<p>You're welcome. I'm glad to hear that you were able to get things sorted.</p>
<p>Thank you for reporting back with your results.</p>
<p>-Kevin N.</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-25T05:52:35Z2018-01-25T05:52:35ZStock price updater<div><p>I have downloaded the extension and got the API key from Alpha Advantage and my automatic stock quotes don't come through, error coming up as per below.</p>
<p>Error while downloading currency exchange rates:sun.security.validator. Validator exception No trusted certificate found</p></div>Michael Atag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-25T07:46:27Z2018-01-25T07:46:27ZStock price updater<div><p>You also need Moneydance 2017.6 as a minimum, the error you are reporting would seem to indicate you are running an older version.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-26T15:22:49Z2018-01-26T15:23:50ZStock price updater<div><p>I also had this issue. I am using the latest 2017.6 and the latest exchange rate. I tried to do a historical download using the drop menus of Security Prices and select Google Finance - History Only. I try the Set API Key, and it shows the one for AlphaVantage. No option for Google. I get mostly the error forbidden. The result is 151 securities skipped, 19 errors, and 19 quotes obtained. It may be working but not sure why it reports the error.</p>
<p>When I use the AlphaVantage, I get 151 securities skipped, 0 errors, and 19 quotes obtained. I only have 19 selected to update, so it appears it is finally working for the Alphavantage.</p>
<p>Your knowledge base article needs to be updated as it still shows the Yahoo connection to update stocks.</p></div>jenkins007tag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-01-27T15:16:37Z2018-01-27T15:16:37ZStock price updater<div><p>Same problem. I have the latest Moneydance and the latest Securities updater and it stopped working a few days ago.</p></div>hsmoliartag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-02-03T20:15:43Z2018-02-03T20:15:43ZStock price updater<div><p>Still not working. Is there anyone from Infinite Kind support staff that's working on this?<br>
I have the latest Moneydance on the Mac 2017.6(1656) and I'm very frustrated.</p></div>hsmoliartag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-02-04T13:53:18Z2018-02-04T13:53:19ZStock price updater<div><p>I am having the same issues updating stocks and no answer from my post last week. i am running High Sierra, Java 1.8, and the latest MD 2017.7 (1663)......some of my stocks update and some do not using AlphaVantage. This is getting very frustrating.</p></div>Jefftag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-02-04T18:22:07Z2018-02-04T18:22:08ZStock price updater<div><p>Same issue here, some update and some do not. Very frustrated as well.</p></div>Christag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-02-04T18:34:16Z2018-02-04T18:34:16ZStock price updater<div><p>Hi Jeff, Chris,</p>
<p>Have you tried the hleofxquote tool mentioned in my post # 7?<br>
<a href="http://help.infinitekind.com/discussions/investments/3143-stock-price-updater#comment_44570555">http://help.infinitekind.com/discussions/investments/3143-stock-pri...</a></p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-02-04T19:32:29Z2018-02-04T19:32:30ZStock price updater<div><p>No I have not tried that. Was hoping to just have an application like the current updater that does not require a lot of manual work.</p></div>Bush, Jefftag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-02-05T16:19:45Z2018-02-05T16:19:45ZStock price updater<div><p>You mean something along the lines of <strong>"...and current prices can be downloaded automatically."</strong> as it states in their blurb about the program when encouraging you to buy?</p>
<p>Please can someone from IK comment on this and explain what is being done?</p>
<p>What I find is that the Alphavantage updater gives varying results, sometime bringing in prices in pounds, sometimes pence (but not for all stocks). There is a thought that this depends on whether the exchange is open or closed, but I am not convinced.</p>
<p>I have tried the hleofxquote tool but it is far more cumbersome, in part because whilst the Yahoo2 works for half of my stocks, it fails on the others, so I have to use the FT one which works for the other half plus the exchange rates. So that is a double update and between the two I have to change the stock codes in the first window. It is NOT a reasonable work around for non technical people.</p></div>JimRBtag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-02-05T16:41:23Z2018-02-05T16:41:24ZStock price updater<div><p>EXACTLY…..We need the automated downloads to work without having to go thru so much manual work on hleofxquote…this is not a workable solution and alphavantage is spotty. This kind of stock syncing has been going on for 15+ yrs with software programs.</p></div>Bush, Jefftag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-02-05T17:43:50Z2018-02-05T17:43:50ZStock price updater<div><p>Disclaimer: I am not affiliated with IK and am not a MD user. I maintain the hleofxquotes tool. As such, my main interest is mostly on user case that I could use to improve the tool functionality.</p>
<p>@JimRB: Your use case is an interesting one: fetching from multiple quote sources and merge result into a single price list. If you think this is something useful for your usage, do you mind posting more details (list of quotes that failed on Yahoo and OK on FT and vice versa) at <a href="http://help.infinitekind.com/discussions/investments/3036-third-party-quote-and-exchange-rate-program-from-hleofxquotes">http://help.infinitekind.com/discussions/investments/3036-third-par...</a></p>
<p>Best,</p></div>hleofxquotestag:infinitekind.tenderapp.com,2009-01-14:Comment/445701522018-02-10T18:23:09Z2018-02-10T18:23:09ZStock price updater<div><p>I've posted this in the other thread as requested.</p>
<p>On playing around further with and without the ".L" suffix (Yahoo needs it for mutual funds, FT does not accept it), and changing the format of currencies from (for example) GBPJPY to JPYGBP=X, there is one that is not found in each, but Yahoo has an added oddity of nearly a month old prices for three funds.</p></div>JimRB