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 2 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
31 Posted by -Kevin N. on 21 Jun, 2017 04:48 PM
Hi Tom Freeman,
MD 2017.3 (1619)
Q&ER updater v.1001
Just as an FYI, I can not reproduce this issue either with the updater set as follows:
Currency Exchange Rates; Do Not Update
Historical Security Prices: Do Not Update
Current Security Prices: Yahoo Finance - USA
-Kevin N.
32 Posted by Noname on 21 Jun, 2017 05:00 PM
Still have this problem. MD 2014.5(986). Just updated to v82 Q&E and still have this problem. Kevin do you still run 2011? If so do you have the problem there?
33 Posted by -Kevin N. on 21 Jun, 2017 05:14 PM
Hi PC2MAC,
MD 2011r2+ (808)
Q&ER Updater v. 82
I'm not seeing this issue with MD 2011 either. I have the Q&ER Updater set to the same settings as in my post # 31
-Kevin N.
34 Posted by Tom Freeman on 21 Jun, 2017 05:24 PM
I just tested this on MD 2014 v82 of the Q&E extesnion and could not replicate the issue.
Can I get a screen shot of your extension window? Then please go to help > open console window. From the console window run the extesnion, then use the copy to clipboard to paste the contents here.
Tom Freeman
Infinite Kind Support
35 Posted by Rob Barnard on 21 Jun, 2017 06:28 PM
Tony
Here’s a selection of today’s screenshots of the Q&E extension using various options . I have also included a couple of screen shot from April when I previously raised this issue showing the error messages then.
I’m a UK user.
The Q&E seems to have slowed down completely and now times out.
Here is the clipboard copy
Starting Moneydance 2014.5 (980) at Wed Jun 21 19:05:16 BST 2017
Settings Folder: C:\Users\arbar_000\.moneydance
OS: Windows 8 6.2 x86
Java: 1.7.0_45 (Oracle Corporation)
Is in sandbox: false; restricted file access: false
Initializing Moneydance SSL
Created new custom trust manager
TRUSTMGR: initialized custom stream handler factory...
opening last file: Personal Finances
opening file from folder: C:\Users\arbar_000\.moneydance\Documents\Personal Finances.moneydance
opening file from folder: C:\Users\arbar_000\.moneydance\Documents\Business Finances.moneydance
opening file from folder: C:\Users\arbar_000\.moneydance\Documents\My Finances.moneydance
opening file from folder: C:\Users\arbar_000\.moneydance\Documents\Personal Finances.moneydance
set antialiasing to HRGB
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=ATRLON%3A&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=BNKRLON%3A&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=BARCLON%3A&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=FRCLLON%3A&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=GB0032897653.LON&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=GB0032897653.LON&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
Saving to C:\Users\arbar_000\.moneydance\Documents\Personal Finances.moneydance\root.mdinternal
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=GB0033030296.LON&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=GB0003418950.LON&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
opening file from folder: C:\Users\arbar_000\.moneydance\Documents\Business Finances.moneydance
opening file from folder: C:\Users\arbar_000\.moneydance\Documents\My Finances.moneydance
opening file from folder: C:\Users\arbar_000\.moneydance\Documents\Personal Finances.moneydance
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=GB0031960478.LON&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=GB0031960478.LON&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=GB00B6QQDK47.LON&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=GB0031289217.LON&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=PRULON%3A&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=PRU.LON&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=BNC.LON&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=SLLON%3A&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://uk.old.finance.yahoo.com/d/quotes.csv?s=WTANLON%3A&f=slt1hgv&e=.csv
caught IOException: java.net.ConnectException: Connection timed out: connect
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=ATRLON%3A&f=sl1d1t1c1ohgv&e=.csv
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=BNKRLON%3A&f=sl1d1t1c1ohgv&e=.csv
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=BARCLON%3A&f=sl1d1t1c1ohgv&e=.csv
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=FRCLLON%3A&f=sl1d1t1c1ohgv&e=.csv
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=GB0032897653.LON&f=sl1d1t1c1ohgv&e=.csv
Import error: discarding currency snapshot with zero date: "GB0032897653.LON",N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=GB0032897653.LON&f=sl1d1t1c1ohgv&e=.csv
Import error: discarding currency snapshot with zero date: "GB0032897653.LON",N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=GB0033030296.LON&f=sl1d1t1c1ohgv&e=.csv
Import error: discarding currency snapshot with zero date: "GB0033030296.LON",N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=GB0003418950.LON&f=sl1d1t1c1ohgv&e=.csv
Import error: discarding currency snapshot with zero date: "GB0003418950.LON",N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=GB0031960478.LON&f=sl1d1t1c1ohgv&e=.csv
Import error: discarding currency snapshot with zero date: "GB0031960478.LON",N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=GB0031960478.LON&f=sl1d1t1c1ohgv&e=.csv
Import error: discarding currency snapshot with zero date: "GB0031960478.LON",N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=GB00B6QQDK47.LON&f=sl1d1t1c1ohgv&e=.csv
Import error: discarding currency snapshot with zero date: "GB00B6QQDK47.LON",N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=GB0031289217.LON&f=sl1d1t1c1ohgv&e=.csv
Import error: discarding currency snapshot with zero date: "GB0031289217.LON",N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=PRULON%3A&f=sl1d1t1c1ohgv&e=.csv
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=PRU.LON&f=sl1d1t1c1ohgv&e=.csv
Import error: discarding currency snapshot with zero date: "PRU.LON",N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=BNC.LON&f=sl1d1t1c1ohgv&e=.csv
Import error: discarding currency snapshot with zero date: "BNC.LON",N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=SLLON%3A&f=sl1d1t1c1ohgv&e=.csv
trying to retrieve URL: https://download.finance.yahoo.com/d/quotes.csv?s=WTANLON%3A&f=sl1d1t1c1ohgv&e=.csv
Currency Name raw rate user rate
Witan Investment Trust 9.842519685039369 0.09842519685039369
Standard Life 25.97402597402597 0.2597402597402597
Santander 19.157088122605366 0.19157088122605367
Prudence Savings Account 0.007377313433276258 7.377313433276258E-5
Henderson UK Index Fund PEP (Rob) 16.89189189189189 0.16891891891891891
Henderson UK Index Fund PEP (Paula) 16.89189189189189 0.16891891891891891
Pru Self Select PEP 98 5.5096418732782375 0.05509641873278238
M&G Recovery Unit Trust -Sterling A Acc 31.347962382445143 0.31347962382445144
M&G Episode Growth Fund ISA (Rob) Sterling A Income 172.0578114246387 1.720578114246387
M&G Episode Growth Fund ISA (Paula) Sterling A Income 172.0578114246387 1.720578114246387
M&G Global Recovery Fund -SterlingA Income 58.5514374377891 0.585514374377891
JP Morgan Emerging Markets 12.95336787564767 0.1295336787564767
Asian Total Return 35.3356890459364 0.35335689045936397
F&C Investment Trust 16.920473773265652 0.1692047377326565
Bankers Trust 13.36898395721925 0.1336898395721925
Prudential 5.5096418732782375 0.05509641873278238
Australian Dollar 1.677 1.677
Bahamian Dollar 1.2676 1.2676
Bermudian Dollar 1.2644 1.2644
Brazilian Real 4.2202 4.2202
Bulgarian Lev 2.2165 2.2165
Canadian Dollar 1.6877 1.6877
Chilean Pesos 841.99 841.99
Chinese 'Yuan' Renminbi 8.6407 8.6407
Costa Rica Colon 719.54 719.54
Danish Krone 8.44 8.44
Egyption Pound 23.0107 23.0107
Euro 1.1347 1.1347
Fijian Dollar 2.6158 2.6158
Hong Kong Dollar 9.87 9.87
Icelandic Krona 133.15 133.15
Indian Rupee 81.7955 81.7955
Indonesian Rupiah 168.36460899999997 16836.4609
Israeli New Shekel 4.4812 4.4812
Jamaican Dollar 162.93 162.93
Jordonian Dollar 8.964 0.8964000000000001
Lebanese Pound 19.0992 1909.92
Malaysian Ringgit 5.4266 5.4266
Mexican Pesos 23.0593 23.0593
New Zealand Dollar 1.7512 1.7512
North Korean Won 1138.702 1138.702
Norwegian Kroner 10.8203 10.8203
Pakistani Rupee 132.631 132.631
Philippines Peso 63.631 63.631
Romanian Leu 5.2172 5.2172
Saudi 'Arabian' Riyal 4.7411 4.7411
Singapore Dollars 1.7583 1.7583
South African Rand 16.5436 16.5436
South Korean Won 14.447000000000001 1444.7
Sudan Pound 8.4475 8.4475
Swedish Krona 11.0903 11.0903
Swiss Franc 1.2322 1.2322
Taiwan Dollars 38.513 38.513
Thai Baht 43.016 43.016
Trinidad and Tobago Dollar 8.5095 8.5095
Turkish Lira 0.01 1.0
US Dollar 1.2656 1.2656
Venezuelan Bolivar 12.63 12.63
Yeni T�rk Liras? 4.4703 4.4703
Zambian Kwacha 0.01 1.0
Barclays 46.44681839294008 0.4644681839294008
INVESCO Perpetual Global Smaller Companies-Acc shares 4.301075268817205 0.04301075268817205
British Pound 1.0 1.0
updating currency: Zambian Kwacha ()
downloading from: https://download.finance.yahoo.com/d/quotes.csv?s=GBPZMK=X&f=sl1d1t1c1ohgv&e=.csv
updating currency: Yeni T�rk Liras? ()
downloading from: https://download.finance.yahoo.com/d/quotes.csv?s=GBPTRY=X&f=sl1d1t1c1ohgv&e=.csv
updating currency: Venezuelan Bolivar ()
downloading from: https://download.finance.yahoo.com/d/quotes.csv?s=GBPVEF=X&f=sl1d1t1c1ohgv&e=.csv
updating currency: US Dollar ()
downloading from: https://download.finance.yahoo.com/d/quotes.csv?s=GBPUSD=X&f=sl1d1t1c1ohgv&e=.csv
updating currency: Turkish Lira ()
downloading from: https://download.finance.yahoo.com/d/quotes.csv?s=GBPTRL=X&f=sl1d1t1c1ohgv&e=.csv
updating currency: Trinidad and Tobago Dollar ()
downloading from: https://download.finance.yahoo.com/d/quotes.csv?s=GBPTTD=X&f=sl1d1t1c1ohgv&e=.csv
updating currency: Thai Baht ()
downloading from: https://download.finance.yahoo.com/d/quotes.csv?s=GBPTHB=X&f=sl1d1t1c1ohgv&e=.csv
updating currency: Taiwan Dollars ()
downloading from: https://download.finance.yahoo.com/d/quotes.csv?s=GBPTWD=X&f=sl1d1t1c1ohgv&e=.csv
updating currency: Swiss Franc ()
downloading from: https://download.finance.yahoo.com/d/quotes.csv?s=GBPCHF=X&f=sl1d1t1c1ohgv&e=.csv
updating currency: Swedish Krona ()
downloading from: https://download.finance.yahoo.com/d/quotes.csv?s=GBPSEK=X&f=sl1d1t1c1ohgv&e=.csv
updating currency: Sudan Pound ()
downloading from: https://download.finance.yahoo.com/d/quotes.csv?s=GBPSDG=X&f=sl1d1t1c1ohgv&e=.csv
updating currency: South Kor (truncated)
36 Posted by lexrom on 21 Jun, 2017 07:02 PM
I am using windows 10. I am attaching the screenshot and the error log.
37 Posted by Noname on 21 Jun, 2017 07:15 PM
I can't take screenshots but the pertinent information in the console says: trying to retrieve URL: https://download.finance.yohoo.com/d/quotes.csv?s=[stock symbol]&f=s|1d1t1c1ohgv&e=csv
trying to retrieve URL: https://ichart.finance.yohoo.com/d/table.csv?s=[stock symbol]&d=5&e=21&f=2017&g=d&a=5&b=14&c=2017& ignore=.csv caught IO exception:java.net.ConnectException: Operation timed out
38 Posted by -Kevin N. on 21 Jun, 2017 09:02 PM
Hi PC2MAC, Hi lexrom,
Try setting Historical Security Prices to Do Not Update.
-Kevin N.
39 Posted by Noname on 21 Jun, 2017 09:39 PM
I don't have that option available to select.
40 Posted by Noname on 21 Jun, 2017 10:00 PM
Correction, I found the do not update option and set it but still taking hours to update current prices.
41 Posted by Noname on 21 Jun, 2017 10:03 PM
Ok now I went and closed MD and reopened and now it's working correctly. Seems the Do not update option did the trick. Thanks Kevin!
42 Posted by -Kevin N. on 21 Jun, 2017 11:10 PM
Hi PC2MAC,
I'm glad to hear that it worked.
Good to know that it takes a restart.
Thanks for posting back with your results.
-Kevin N.
43 Posted by lexrom on 22 Jun, 2017 12:39 AM
Thanks ! That worked.
Lex
44 Posted by Rob Barnard on 22 Jun, 2017 06:58 AM
Tony
I have tried the various combination settings with the Quotes extension and restarting but none of these have worked I’m afraid.
Regards
Rob
45 Posted by jeffcarp on 26 Jun, 2017 01:43 PM
Google Finance has the ability to create custom portfolios. There is an option to "Download to OFX" (and spreadsheet) which provides the security name, ticker and last price. Given the broken automatic updates of security prices, how can we use this Google Finance functionality to bulk upload this OFX file (or the CSV file)?
46 Posted by Rob Barnard on 28 Jun, 2017 08:31 PM
Tom
What’s going on?
I have downloaded Moneydance 2017, been charged £48.79 and the security updater still doesn’t work
Seriously unhappy
Regards
Rob
47 Posted by jeffcarp on 29 Jun, 2017 03:34 PM
Perhaps it's just because of a lack of communication (I hope) but I get the sense that Moneydance doesn't feel a strong sense of urgency or obligation to restore this functionality through an alternative provider. That's disappointing.
48 Posted by dwg on 29 Jun, 2017 09:12 PM
The problem is finding an alternative provider. I do not think there are too many that provide such a free service and in such a way that it can be programatically downloaded and imported.
49 Posted by jeffcarp on 29 Jun, 2017 09:18 PM
Why is the search being limited to free providers? Moneydance is not free software. Quicken has a source. The new Moneywiz released yesterday with investment support has a source. I would expect Moneydance to come up with a source, free or not, given that we paid for this software. If that changes the pricing model, so be it. The functionality is important.
50 Posted by jeffcarp on 29 Jun, 2017 09:19 PM
Regardless, this issue has been known for at least two and a half months now. It's time for the leadership of Moneydance to speak out and tell us what their plans are.
51 Posted by dwg on 29 Jun, 2017 10:43 PM
Jalan
For what it is worth this is what the Moneywiz folks wrote on Jun 29 about quotes:
"We use Yahoo Finance for quotes downloading"
As for Quicken I cannot talk directly about them but the company that does the Australianised version is Reckon and they have an arrangement with the Australian and New Zealand exchanges to get quotes from them and host on Reckon servers, no doubt at a cost which the users pay for, the full version of Reckon gives you 2 years worth of quotes or you use the subscription version, either way the cost currently works out to be about $130 per year.
However you are only getting quotes for these two countries and I would imagine that Quicken only gives you Quotes for North America. Moneydance however is used by users world wide so needs sources for many countries. To use the Quicken/Reckon model for world wide prices I do not think would be viable.
52 Posted by Tom Freeman on 30 Jun, 2017 09:38 PM
@Rob
I want to confirm that you are using the updated version of the Q&E extesnion, v 82.
You may also want to try adding a .l to your ticker symbols. I am able to retrieve current prices on 3 I tried.
Tom Freeman
Infinite Kind Support
53 Posted by Rob Barnard on 03 Jul, 2017 12:24 PM
Hi Tom
I’m now running Moneydance 2017 – on ‘Manage Extensions’ for the Q&E extension I have V1001 installed. The Security Price Entry function has an Update button next to it which I’ve clicked several times but it still stays as Update rather than Installed.
I have amended three securities with a .L but I still don’t get anything. My settings are Currency: Yahoo Currency rates – this works, Historic security rates – Don’t update, Current Security rates – Yahoo Finance USA. I don’t get anything and the error message is Error Downloading Connection timed out.
Regards
Rob
54 Posted by Rob Barnard on 03 Jul, 2017 12:57 PM
Tom
Just re-run and it’s updating!!
I’m getting securities quoted in pence coming through as pounds – how do I correct/adjust?
Thanks
Rob
55 Posted by Rob Barnard on 03 Jul, 2017 01:35 PM
Tom
It’s okay, I’ve found how to change sterling pounds to pence to get the right values appearing
Looks as though things are working again.
Thanks for all your help
Rob
56 Posted by Noname on 07 Aug, 2017 11:34 PM
New problem today. Mutual funds aren't updating. Anyone else having this problem?
57 Posted by Terry on 08 Aug, 2017 01:11 AM
Yes, I am having the same issue with Funds. As others have said, I am very disappointed in "new day, new problem." Paying customers deserve better, in my opinion. Last week it was Vanguard connections, then Discover Card connections.
It's very tiring to be dealing with a new problem every week/day.
Terry
58 Posted by lexrom on 08 Aug, 2017 12:44 PM
The mutual funds not updating seems to be a Yahoo problem. This happens
from time to time and is not a moneydance proble.
59 Posted by Tom Freeman on 15 Aug, 2017 07:05 PM
If the funds are still not updating, if you could provide some ticker symbols I could look them up and see if the issue is Yahoo or MD.
I've been using Yahoo finance for years to track security prices and I am becoming more and more discouraged each time they change their finance pages.
Tom Freeman
Infinite Kind Support
60 Posted by lexrom on 15 Aug, 2017 08:17 PM
I have no problem. It's fixed.