Quotes not updating
Hi
My quotes are not updating my Security/stock prices. It stopped updating a month ago and I have checked all the obvious options without success. Exchange rates update but the securities get an error message 'Error downloading...no data found'. I have run the Test but just get X History X.
Any help most welcomed
Showing page 3 out of 6. View the first page
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
61 Posted by Noname on 16 Aug, 2017 11:17 AM
Funds are updating again. No longer a problem at this time.
62 Posted by Noname on 01 Nov, 2017 10:39 PM
Quotes note updating today. Anyone else having problems?
63 Posted by robnich1 on 01 Nov, 2017 10:49 PM
Yes, none of my quotes are updating today: "...message code 999 and request denied" for each one.
64 Posted by dk on 01 Nov, 2017 10:51 PM
Yes. Just started this evening - error code 999, whatever that means.
65 Posted by JL on 01 Nov, 2017 10:53 PM
Getting an quote error also.
Uninstalled Quotes add on and reinstalled. No change.
Found the following in the Console Window
"Found invalid txn ... will delete locally"
66 Posted by ATucker on 01 Nov, 2017 10:56 PM
+1. Quotes not updating. MD2014.5, Q&E extension v8.2.
Response code 999. Worked on 31OCT. Does not work on 01NOV.
67 Posted by Michael Blaiss on 01 Nov, 2017 11:19 PM
Same problem here--999-no quotes. Hope there is a quick fix.
68 Posted by John F on 01 Nov, 2017 11:28 PM
I believe this is the result of Yahoo shutting down their Yahoo Finance API. I suspect the service finally went kaput today after being announced as such back in May.
69 Posted by dwg on 02 Nov, 2017 02:02 AM
I do not known if Sean has seen this site but it may be worth a look at as an alternative to yahoo:
https://www.tiingo.com/welcome
70 Posted by Darren on 02 Nov, 2017 02:28 AM
Quotes not working here also. This just started tonight.
71 Posted by jonh on 02 Nov, 2017 05:39 AM
Yahoo seems to have a problem 2-3 times a year. It's usually fixed the next morning. I've been wondering how long this service was going to continue. I don't understand why the downloader uses only Yahoo and not offering a broader selection. Sometime in the last year or so IK added Goggle Finance to the Historical selection but not to the current quote selection. I tried turning off the current choice and changing Historical to Google. That gave me some more quotes but not the complete selection I usually get.
72 Posted by John F on 02 Nov, 2017 02:08 PM
jonh - Both Yahoo and Google offered free downloads of quote data through a little unknown API available on their websites. My impression is that these APIs were not intended for widespread use by commercial products like Moneydance, bu instead, were provided for individual investor use. As such, Google elected to terminate their service some time prior to this year and Verizon decided to terminate Yahoo's service after buying the company. If you search the internet, you'll see that other companies are charging a fee for this service.
73 Posted by John on 02 Nov, 2017 03:04 PM
This is the same problem about which I just started a new thread... sorry! But John F's reply sounds as if MD will no longer be able to obtain quotes from Yahoo. Is that correct?
74 Posted by JL on 02 Nov, 2017 03:10 PM
Posted the following in another post.
There was an old previous post that said Yahoo was stopping access to their Quote API.
So I guess it has finally stopped completely.
The only work around I have found is installing the Security Price Entry extension.
If you do not have a lot of securities then this might work for you until they find a replacement.
I did a test of this by only entering prices to only those securities I have in my portfolio.
It is a shame it lists all securities even old ones.
Those you do not own just leave those blank.
Before doing it make sure you backup MD just in case you mess up.
FYI: I also uninstall the Quote updater.
75 Posted by Wer Digo on 02 Nov, 2017 03:18 PM
Thank you, JL. I have a portfolio set up on My Yahoo and can obtain current security prices there (20 minute delay, I guess), exporting them as a .csv file. That's easy to import into Quicken; maybe there's a way to use it with MD.
On Thursday, November 2, 2017 11:10 AM, JL <[email blocked]> wrote:
#yiv5539087381 pre {width:92%;margin:10px 2%;padding:5px 2%;background:#efefef;border:1px solid #d6d6d6;}#yiv5539087381 blockquote {margin-left:0;padding-left:1em;border-left:5px solid #ccc;}
76 Posted by JL on 02 Nov, 2017 03:42 PM
It would nice if someone from MD to pop in and say something.
Maybe someone here has an email to Sean or anyone at MD to make sure they are aware of this problem.
Not a good way to keep and communicate with users.
That said, I do wish there was a way to import a csv into MD quotes module instead of using the extension.
77 Posted by Jim on 02 Nov, 2017 05:24 PM
It certainly looks like AlphaVantage would work. I'm happy obtaining my own (free) API key.
78 Posted by -Kevin N. on 02 Nov, 2017 05:56 PM
Hi Jim,
I tried getting a quote (csv) for a Fidelity mutual fund, ticker FAGIX using the AlphaVantage API. It's last quote was for 10/31/2017.
We'll have to see if they can provide quotes for November and beyond. However, if they (AV) are getting their quotes from Yahoo, well then...
-Kevin N. (not a member of MD support)
79 Posted by jonh on 02 Nov, 2017 05:58 PM
@John F: "Both Yahoo and Google offered free downloads of quote data through a little unknown API available on their websites."
Indeed. I've been using it for more than a decade, automatically downloading to .csv. Then end of an era, here is reply (probably a smoke screen by Verizon) found on yahoo.uservoice.com where may folks are screaming in distress.....
AdminYahoo Product Support (Admin, Yahoo) responded · November 02, 2017
It has come to our attention that this service is being used in violation of the Yahoo Terms of Service. As such, the service is being discontinued. For all future markets and equities data research, please refer to finance.yahoo.com.
80 Posted by Jim Kuhn on 02 Nov, 2017 05:59 PM
I obtained an API key and issued a request before posting. The information
was all current.
81 Posted by jonh on 02 Nov, 2017 05:59 PM
The extension has 'historical quotes' from Google. I tried that yesterday without much luck, using a date range 01Nov->01Nov. I'm wondering exactly how that part of the extension is supposed to work.
82 Posted by Jim on 02 Nov, 2017 06:05 PM
> I obtained an API key and issued a request before posting. The information
was all current.
But I was only looking at stocks on a couple of exchanges... they were right up to date.
83 Posted by joe.bachofen on 02 Nov, 2017 07:41 PM
If it's true that Moneydance was relying on the Yahoo API for free updates without authorization that is disappointing but understandable. This makes Moneydance worthless for my purposes but it can be easily fixed by modifying the Security Price Input extension to accept CSV files or clipboard pastes. We can then get the stock prices from Google or Yahoo for the stock prices we want; I get those anyway for my own use in a spreadsheet. Both Yahoo and Google allow private users to set up portfolios; that's where I get the prices I can input to the Moneydance extension if it were changed to accept them from a CSV file or clipboard paste. Let me know if I can help.
84 Posted by joe.bachofen on 02 Nov, 2017 07:51 PM
A simple alternative to a CSV import through the Security Price Input extension would be the existing File | Import feature. Moneydance can add the Stock table to the Account list as a receiver of the CSV file. Let me know if I can help.
85 Posted by jonh on 02 Nov, 2017 08:01 PM
@Joe "Both Yahoo and Google allow private users to set up portfolios; that's where I get the prices I can input to the Moneydance extension if it were changed to accept them from a CSV file or clipboard paste. Let me know if I can help."
This is interesting. I'll see if I can find the right place. I liked the prior download api cause I emailed it do myself and didn't have to fire up the browser and log on to a site full of blazing advert's. Maybe I can set up a portfolio populated with 1 share of each holding. Are you manually inputing from the data you get or does one of these extensions allow input from a .csv or paste? I have never looked at the extensions carefully.
86 Posted by dwg on 02 Nov, 2017 08:44 PM
Moneydance does allow you to import prices from a CSV file but it is on a security by security bases, I suspect the extension was using this capability as I think the Yahoo API was only downloading one price at a time in any case.
87 Posted by dwg on 02 Nov, 2017 08:51 PM
FWIW a fellow user has created an extension to load security prices from a CSV file see:
https://bitbucket.org/mikerb/moneydance-2015/wiki/Security%20Price%...
88 Posted by Dan Hanger on 02 Nov, 2017 11:50 PM
dwg's suggestion above is the best solution (hopefully temporary) I've found so far to this problem. It was pretty painless to build my portfolio on my Yahoo account--I only have about 15 securities and it only took a few minutes, but once done it's done. Then it's a simple matter of exporting to csv from the Yahoo portfolio, then using the extension he linked to. Almost as painless as the currently defunct updater extension, just a couple of quick steps to get it done.
89 Posted by John on 03 Nov, 2017 12:03 AM
Mike's extension sounds like what I'm looking for, but I need a bit more guidance on downloading and installing it. Full commit, raw, etc? Sorry, beyond me.
90 Posted by Dan Hanger on 03 Nov, 2017 12:18 AM
Follow this link:
https://bitbucket.org/mikerb/moneydance-2015/downloads/
Download the extension at the bottom right to a known location on your local drive, then in MD extension menu at bottom left 'add from file', browse to the saved extension file and install. Run the extension using the instructions at this link:
https://bitbucket.org/mikerb/moneydance-2015/wiki/Security%20Price%...
If you need more details just ask.
Dan