tag:infinitekind.tenderapp.com,2009-01-14:/discussions/moneydance-development/1971-new-thread-on-moneydance-cannot-get-stockmm-prices-is-this-the-end-for-moneydanceInfinite Kind: Discussion 2018-10-18T14:09:39Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T10:02:01Z2017-12-02T10:02:01ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>The prices did download late last night and this morning with one exception.<br>
4 AM Central time.<br>
One of my Mutual Funds (HLEMX) price was from the previous day.<br>
Price shown was for date 11/30/17 instead of the price for 12/1/17.<br>
Where ever they get their prices from is not updating properly.</p></div>JLtag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T12:17:11Z2017-12-26T12:42:03ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>@ ALL</p>
<p>Ran it this morning at 0700 EDT. Sweet! No errors. Fairly quick (like it was with Yahoo). Got all securities that I have checked. Also ran Currency Exchange Rates with no problems.</p>
<p>The observation that Alpha Vantage is load sensitive seems to be a correct one.</p>
<p>Regards,</p>
<p>Jim Gwathmey</p></div>james.gwathmeytag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T15:31:14Z2017-12-02T15:31:16ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>I.m still unable to download any stock prices - the situation is the same as I stated in my post yesterday - installed preview build and new extension - Alpha Vantage key entered.<br>
I have tried reinstalling but the situation remains the same (and at no point do I have an opportunity to reenter my key. I have tried installing a new instance in a fresh directory but the results remain the same. I have no idea what else to try, any help would be appreciated. My question about where the key is stored and whether I can check its accuracy has also not yet been answered. Thanks</p></div>Alantag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T15:45:42Z2017-12-02T15:45:42ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>@Alan</p>
<p>I suspect you initially entered the API key incorrectly but I have no idea where it's stored or how to find it or how to change it. Maybe someone else does? What operating system are you running on? I tried looking on my Mac but had no luck.</p>
<p>Randy</p></div>Randy Mackietag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T15:58:12Z2017-12-26T12:42:03ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>@ Alan,</p>
<p>I had a bit of trouble understanding how to get the key. Upon second request, got message that it was already in hand along with a copy of the key itself. Try re-requesting from Alpha Vantage & see what they say. It you get it, copy into notes or somewhere where you can remember it.</p>
<p>Jim</p></div>james.gwathmeytag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T16:31:23Z2017-12-02T16:31:24ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>I am running Windows 10. I have a copy of the key I was supplied by Alpha Vantage saved in 2 places and I double checked when I typed it into MD. At the very least I would like to start from scratch with the extension but I can't seem to find any way of accomplishing that. If I totally uninstall MD will that help? Will I lose my MD license and have to re-enter all of my online banking info?</p></div>Alantag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T18:01:47Z2017-12-02T18:01:47ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>@JL, as of now (12 PM US Eastern Time) HLEMX downloads the 12/1 price. timestamp,open,high,low,close,volume<br>
2017-12-01,57.6800,57.6800,57.6800,57.6800,0<br>
2017-11-30,57.6800,57.6800,57.6800,57.6800,0<br>
2017-11-29,58.3900,58.3900,58.3900,58.3900,0<br>
2017-11-28,59.1400,59.1400,59.1400,59.1400,0</p>
<p>There is an easy way to check this on Mac or linux systems using curl. Or you can enter the URL below into a browser. AlphaVantage has no way to look up symbols by security name.</p>
<p>@alan, not sure how to reset the APIkey but you can check it by looking at the console log. It should have the URL used including the APIkey, you should see a line:</p>
<p>"getting history using url: <a href="https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=">https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&sy...</a>&apikey=&datatype=csv"</p>
<p>and are replaced by your data.</p>
<p>I am not sure where the API key is stored. I think it is in your main data folder which makes it hard to manipulate other than a python script.</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T18:26:38Z2017-12-02T18:26:39ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>sth</p>
<p>Thank you for the help. The key is indeed incorrect. Can anyone on the MD support staff help me reset the key?</p>
<p>Thanks</p></div>Alantag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T18:37:35Z2017-12-02T18:37:35ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>@IK, this needs a UI obviously in the extension. BUT for anyone who can work with the python interface...</p>
<p>I looked at the code at <a href="https://bitbucket.org/infinitekind/moneydance_open/commits/0196cd78aaa6ac4c8f0f40ce81833a6cd2798cd0">https://bitbucket.org/infinitekind/moneydance_open/commits/0196cd78...</a><br>
for the commit on 11/16 when the AlphaVantage connection was first tested:</p>
<p>The line<br>
String apiKey = root.getParameter("alphavantage.apikey", null);<br>
seems to imply it is a parameter in the root data file.</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T18:55:34Z2017-12-02T18:55:34ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>@stl</p>
<p>Thanks but that price for 12/1 is wrong.<br>
The correct price for 12/1 is 57.48 not 57.68<br>
For some reason they are pushing the wrong price.</p></div>JLtag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T19:17:43Z2017-12-02T19:17:43ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>@JL, yes the data is not perfect. I found a whole bunch of missing values that were zero for some security. You can contact AlphaVantage and ask for corrections.</p>
<p>But I would guess that the problem is more fundamental than that. Yahoo also reports $57.68 as the historical close for that security on 12/1.<br>
<a href="https://finance.yahoo.com/quote/HLEMX/history?p=HLEMX">https://finance.yahoo.com/quote/HLEMX/history?p=HLEMX</a></p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T19:46:33Z2017-12-02T19:46:33ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>@sth Yahoo shows correct closing price but wrong historic price.<br>
If Alpha is getting prices from Yahoo then they are getting wrong prices at least with this one fund.</p></div>JLtag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T20:09:45Z2017-12-02T20:09:45ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>I notice that. AlphaVantage does not say where it is getting its prices. Seems a bit secretive about their organization. However, even if AlphaVantage is getting the daily price on a fund from the Yahoo historic prices then the issue is Yahoo.</p>
<p>This is not something IK can correct or even change. This is not an issue for the Q&ER extension. It is not clear to me which Yahoo number is correct either. I have two values, which is real?</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-02T20:20:52Z2017-12-02T20:20:52ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>Thanks.<br>
I sent an email to AlphaVantage and posted the error on Yahoo Finance community board.</p>
<p>The correct price is the closing price of 57.48 Dec1 2017<br>
Confirmed with broker site and other sites that show quotes.</p></div>JLtag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-03T03:43:23Z2017-12-03T03:43:23ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>I was able to download from AlphaVantage without any errors using the previously linked updater extension and the preview release of Moneydance. :-)</p></div>Christag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-08T01:24:04Z2017-12-08T01:24:04ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>Please Sean and IK, give us an update on fixing the quotes update issue. Year End is fast approaching, and I want to have accurate values for my portfolio by then. I have held off on the work-around because I don't want to do unnecessary work [I don't "need" to have the current values right now], assuming a fix is imminent. But I am starting to wonder!?!</p></div>davet65tag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-08T02:02:41Z2017-12-08T02:02:41ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>For information, Sean posted this on Wednesday:</p>
<p>"I've pushed an update to the extension which has a button to set/change the API key in the main extension window. I've also updated the extension to store the key in the preferences as well as the data file."</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-09T16:14:52Z2017-12-09T16:14:52ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>So do I still have to get the latest preview to use the new extension? When will this fix become the stable release?</p></div>davet65tag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-09T16:23:57Z2017-12-09T16:23:57ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>@davet65 - generally speaking, I have found the preview .x update releases to be every bit as stable as the 'final' releases, with the added advantage of extra bug fixes which I don't want to wait for. I read the changelog and update whenever I see an issue that affects me, and never once had an issue. indeed the biggest issues I have had were when I updated to a major new 'final' release.</p></div>JFGtag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-09T22:04:32Z2017-12-09T22:04:32ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>@davet65, very shortly. The preview release notes <a href="http://infinitekind.com/previewdl/current/changelog.txt">http://infinitekind.com/previewdl/current/changelog.txt</a> seem to imply that the current preview is being prepared for Apple Store release which usually means that will be the "stable" release.</p>
<p>You can probably regard the current preview release is like a Golden Master (GM) release.</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/441756802017-12-09T22:07:39Z2017-12-09T22:07:39ZNew thread on MoneyDance cannot get stock/MM prices. Is this the end for MoneyDance?<div><p>Thanks s@tt and sth. That's reassuring to cautious people like me.</p></div>davet65