stock prices not updating

David's Avatar

David

16 Apr, 2017 09:51 PM

Still having this problem. I have Q&ER installed and it does not indicate any problems in the advanced window. This has worked in the past but not since December.

Showing page 2 out of 2. View the first page

  1. 31 Posted by -Kevin N. on 24 Apr, 2017 03:59 PM

    -Kevin N.'s Avatar

    Hi bossie88,

    Is is possible for me to go back to v78 until this issue is resolved?

    v.78 is still available on the 'Extensions' website. (Make sure to click the '2014 & Older' tab.)
    http://infinitekind.com/extensions

    HTH -Kevin N.

  2. 32 Posted by -Kevin N. on 24 Apr, 2017 04:15 PM

    -Kevin N.'s Avatar

    Hi bossie88,

    Scratch that. v.78 is not available on the 'Extensions' website. It only looks like it is.

    Sorry about that.

    -Kevin N.

  3. Support Staff 33 Posted by Sean Reilly on 24 Apr, 2017 05:19 PM

    Sean Reilly's Avatar

    I've just adjusted v78 to account for that error and attach build 81 which I believe should fix it. Can anyone with an older version of Moneydance give it a try and let me know if it solves the problem for you?

    Sean Reilly
    Developer, The Infinite Kind
    http://infinitekind.com

  4. 34 Posted by -Kevin N. on 24 Apr, 2017 05:52 PM

    -Kevin N.'s Avatar

    Hi Sean,

    MD 2011r2+ (808)
    Q&ER updater v.81 Historical Prices-Yahoo USA, Current Prices-Yahoo USA
    Win 7 Home

    v.81 is throwing the same error as v.79. :(

    -Kevin N.

  5. 35 Posted by bosie88 on 24 Apr, 2017 06:26 PM

    bosie88's Avatar

    Hi Sean - I tried v.81 with MD2010r3 and I am getting the same java security certificate error. The error also appears with the current version of v79 posted on the extensions webpage.

    In the meantime, would it be possible to re-post v78 as it existed until today so that users of older versions of Moneydance can at least be able to get the current quotes?

  6. 36 Posted by -Kevin N. on 24 Apr, 2017 08:39 PM

    -Kevin N.'s Avatar

    Hi bosie88,

    I have a v.74 of the Q&ER updater that you're welcome to..

    Safe computing 101 dictates that you scan the file for viruses.

    -Kevin N.
    (not a member of MD support)

  7. 37 Posted by edfix on 25 Apr, 2017 03:06 AM

    edfix's Avatar

    Sorry if this repeats--I've been having trouble getting my profile established.

    I am using Version 2008r3 (631) and having the same problem. I tried installing the pre-2015 yahooqt.mxt, but doesn't work.

    Any chance of getting a yahooqy.mxt I can use?

  8. 38 Posted by j.girouard on 25 Apr, 2017 12:48 PM

    j.girouard's Avatar

    Hi Sean,

    I am running MD 2012.5 on a Mac, installed the extension and here's what happens:

    - When I update the stock prices, I can see the new prices OK

    - The prices shown on the home page are the old ones.

  9. 39 Posted by Mke Jacksoni on 25 Apr, 2017 01:07 PM

    Mke Jacksoni's Avatar

    I downloaded the .mxt file posted by Sean Reilly on19/4/17 and updated the Q and E extension. I have MD 2015 and look to update quotes from Yahoo finance UK
    The Q and E extension still does not update quotes although historical data is now updated. Using Test I get the following message when the extension eventually works through the updates
    "Historical prices successfully downloaded: 5 Current Quote - eventually timed out

  10. 40 Posted by bosie88 on 25 Apr, 2017 03:07 PM

    bosie88's Avatar

    Hi Kevin N. - Thanks for posting v.74 of the Q&ER extension. I installed it and have regained the ability to download current quotes. Phew!

    In the meantime, Moneydance support continues to post v.79 on the extension webpage, which obviously does not work with older versions of Moneydance. They really need to repost the previous version for the affected users.

  11. 41 Posted by -Kevin N. on 25 Apr, 2017 04:06 PM

    -Kevin N.'s Avatar

    Hi bossie88,

    You're welcome. I'm glad to hear that it worked for you.

    I'm sure that Sean & Co. are working on a fix.

    -Kevin N.

  12. 42 Posted by Joe LG on 25 Apr, 2017 08:38 PM

    Joe LG's Avatar

    I am running 2014.5 (986) and have installed v79 from manage extensions. I have been able to successfully download stock quotes. However, I have not been able to get market index values.

  13. 43 Posted by Srini on 26 Apr, 2017 12:25 PM

    Srini's Avatar

    Sean & Co., do we have a fix for the exception error (java.security.cert.CertificateException: Untrusted Server Certificate Chain) that is being encountered for MD 2011.

    Regards
    Srini

  14. 44 Posted by richardelli on 26 Apr, 2017 07:39 PM

    richardelli's Avatar

    I should have mentioned in my post that I am running the current version (2017.2, [1597]), and am having problems with the stock indexes, as I have reported. This is not an older version of the program.

  15. Support Staff 45 Posted by Sean Reilly on 27 Apr, 2017 08:51 AM

    Sean Reilly's Avatar

    Hi Srini (and everyone with an older Moneydance), I just updated the version of the extension for pre-2015 versions of Moneydance and published it to the extension manager. You should now be able to update to the latest public version of that extension using the Extensions->Manage Extensions menu and get the version that works.

    It is likely that certain prices (like historical prices) also don't update, but that is a limitation that you'll have to accept if you'd prefer not to upgrade Moneydance. This is because earlier versions of Moneydance cannot accept the certificate provided by the new Yahoo https service and Yahoo seems to no longer be providing quotes on the old http interface.

    Thanks,

    Sean Reilly
    Developer, The Infinite Kind
    http://infinitekind.com

  16. 46 Posted by edfix on 28 Apr, 2017 05:46 PM

    edfix's Avatar

    I am still not able to install the pre-2015 version of yahooqt.mxt. I'm using version 2008r3 (631). I tried downloading the pre-2015 version you have posted here, but get an error: "java.lang.NullPointerException". When I try downloading the extension via the Moneydance menus, the stock price updater doesn't appear in the list of available extensions. What do I try next?

  17. 47 Posted by Mike Jackson on 04 May, 2017 11:42 AM

    Mike Jackson's Avatar

    To Sean Reilly
     I downloaded the .mxt file posted by you on19/4/17 and updated the Q and E extension. I have MD 2015.5(1225) and look to update quotes from Yahoo finance UK
    The Q and E extension still does not update quotes although some historical data is now updated. Using Test I get the following message when the extension eventually works through the updates
    "Historical prices successfully downloaded: 5 Current Quote - eventually timed out"
    Only some of the historical data is downloaded but i presume the problem is the time out on the quotes.
    Did your .mxt file just correct for Yahoo USA

  18. 48 Posted by Michael on 19 May, 2017 02:44 AM

    Michael's Avatar

    Sean,

    I just tried v82 and received this message: Error: java.lang.NoClassDefFoundError: com/moneydance/util/BasePropertyChangeReporter

  19. 49 Posted by srini on 19 May, 2017 04:06 PM

    srini's Avatar

    Hi Sean,

    Is there a new issue since today. I am using version 1001 of the extension for 2015+
    I am getting error msg as "Received response code 502 and message 'connection'"

    Is it only my issue or across board now....

    Console logs below
    ------

    "COALINDIA.NS",N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A
    Import error: discarding currency snapshot with zero date: "COALINDIA.NS",N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A
    connecting to: https://ichart.yahoo.com/table.csv?s=COFFEEDAY.BO&d=4&e=19&f=2017&g=d&a=4&b=10&c=2017&ignore=.csv with method: GET
    Connecting to ichart.yahoo.com
    acceptable protocols:
      TLSv1
      TLSv1.1
      TLSv1.2
    Supported cipher suites:
      TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384
      TLS_DHE_RSA_WITH_AES_256_CBC_SHA256
      TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA
      TLS_RSA_WITH_AES_256_CBC_SHA
      TLS_DHE_RSA_WITH_AES_256_CBC_SHA
      TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256
      TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256
      TLS_RSA_WITH_AES_128_CBC_SHA256
      TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA256
      TLS_ECDH_RSA_WITH_AES_128_CBC_SHA256
      TLS_DHE_RSA_WITH_AES_128_CBC_SHA256
      TLS_DHE_DSS_WITH_AES_128_CBC_SHA256
      TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA
      TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA
      TLS_RSA_WITH_AES_128_CBC_SHA
      TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA
      TLS_ECDH_RSA_WITH_AES_128_CBC_SHA
      TLS_DHE_RSA_WITH_AES_128_CBC_SHA
      TLS_DHE_DSS_WITH_AES_128_CBC_SHA
      TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
      TLS_DHE_RSA_WITH_AES_256_GCM_SHA384
      SSL_RSA_WITH_3DES_EDE_CBC_SHA
      SSL_DHE_RSA_WITH_3DES_EDE_CBC_SHA
      SSL_DHE_DSS_WITH_3DES_EDE_CBC_SHA
    Connecting with https headers:
    GET /table.csv?s=COFFEEDAY.BO&d=4&e=19&f=2017&g=d&a=4&b=10&c=2017&ignore=.csv HTTP/1.1
    Content-Type: text/plain
    Host: ichart.yahoo.com
    Connection: close

    ---end headers
    HTTP/1.1 502 Connection refused
    Date: Fri, 19 May 2017 14:08:29 GMT
    Strict-Transport-Security: max-age=0
    Via: http/1.1 media-router39.prod.media.sg3.yahoo.com (ApacheTrafficServer [cMsEf ]), https/1.1 r04.ycpi.inc.yahoo.net (ApacheTrafficServer [cMsSf ])
    Server: ATS
    Cache-Control: no-store
    Content-Type: text/html
    Content-Language: en
    Content-Length: 3066
    Age: 0
    Connection: close

    connecting to: https://download.finance.yahoo.com/d/quotes.csv?s=COFFEEDAY.BO&f=sl1d1t1c1ohgv&e=.csv with method: GET
    Connecting to download.finance.yahoo.com
    acceptable protocols:
      TLSv1
      TLSv1.1
      TLSv1.2
    Supported cipher suites:
      TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384
      TLS_DHE_RSA_WITH_AES_256_CBC_SHA256
      TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA
      TLS_RSA_WITH_AES_256_CBC_SHA
      TLS_DHE_RSA_WITH_AES_256_CBC_SHA
      TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256
      TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256
      TLS_RSA_WITH_AES_128_CBC_SHA256
      TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA256
      TLS_ECDH_RSA_WITH_AES_128_CBC_SHA256
      TLS_DHE_RSA_WITH_AES_128_CBC_SHA256
      TLS_DHE_DSS_WITH_AES_128_CBC_SHA256
      TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA
      TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA
      TLS_RSA_WITH_AES_128_CBC_SHA
      TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA
      TLS_ECDH_RSA_WITH_AES_128_CBC_SHA
      TLS_DHE_RSA_WITH_AES_128_CBC_SHA
      TLS_DHE_DSS_WITH_AES_128_CBC_SHA
      TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
      TLS_DHE_RSA_WITH_AES_256_GCM_SHA384
      SSL_RSA_WITH_3DES_EDE_CBC_SHA
      SSL_DHE_RSA_WITH_3DES_EDE_CBC_SHA
      SSL_DHE_DSS_WITH_3DES_EDE_CBC_SHA
    Connecting with https headers:
    GET /d/quotes.csv?s=COFFEEDAY.BO&f=sl1d1t1c1ohgv&e=.csv HTTP/1.1
    Content-Type: text/plain
    Host: download.finance.yahoo.com
    Connection: close

    ---end headers
    HTTP/1.1 200 OK
    Date: Fri, 19 May 2017 14:08:30 GMT
    P3P: policyref="https://policies.yahoo.com/w3c/p3p.xml", CP="CAO DSP COR CUR ADM DEV TAI PSA PSD IVAi IVDi CONi TELo OTPi OUR DELi SAMi OTRi UNRi PUBi IND PHY ONL UNI PUR FIN COM NAV INT DEM CNT STA POL HEA PRE LOC GOV"
    Cache-Control: private, no-cache, no-store
    Content-Length: 47
    Content-Type: application/octet-stream
    Age: 0
    Strict-Transport-Security: max-age=0
    Via: http/1.1 media-router-api2.prod.media.sg3.yahoo.com (ApacheTrafficServer [cMsSf ]), https/1.1 r04.ycpi.inc.yahoo.net (ApacheTrafficServer [cMsSf ])
    Server: ATS
    Connection: close

    connecting to: https://download.finance.yahoo.com/d/quotes.csv?s=COFFEEDAY.BO&f=sl1d1t1c1ohgv&e=.csv with method: GET
    Connecting to download.finance.yahoo.com
    acceptable protocols:
      TLSv1
      TLSv1.1
      TLSv1.2
    Supported cipher suites:
      TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384
      TLS_DHE_RSA_WITH_AES_256_CBC_SHA256
      TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA
      TLS_RSA_WITH_AES_256_CBC_SHA
      TLS_DHE_RSA_WITH_AES_256_CBC_SHA
      TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256
      TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256
      TLS_RSA_WITH_AES_128_CBC_SHA256
      TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA256
      TLS_ECDH_RSA_WITH_AES_128_CBC_SHA256
      TLS_DHE_RSA_WITH_AES_128_CBC_SHA256
      TLS_DHE_DSS_WITH_AES_128_CBC_SHA256
      TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA
      TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA
      TLS_RSA_WITH_AES_128_CBC_SHA
      TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA
      TLS_ECDH_RSA_WITH_AES_128_CBC_SHA
      TLS_DHE_RSA_WITH_AES_128_CBC_SHA
      TLS_DHE_DSS_WITH_AES_128_CBC_SHA
      TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
      TLS_DHE_RSA_WITH_AES_256_GCM_SHA384
      SSL_RSA_WITH_3DES_EDE_CBC_SHA
      SSL_DHE_RSA_WITH_3DES_EDE_CBC_SHA
      SSL_DHE_DSS_WITH_3DES_EDE_CBC_SHA
    Connecting with https headers:
    GET /d/quotes.csv?s=COFFEEDAY.BO&f=sl1d1t1c1ohgv&e=.csv HTTP/1.1
    Content-Type: text/plain
    Host: download.finance.yahoo.com
    Connection: close

    ---end headers
    HTTP/1.1 200 OK
    Date: Fri, 19 May 2017 14:08:31 GMT
    P3P: policyref="https://policies.yahoo.com/w3c/p3p.xml", CP="CAO DSP COR CUR ADM DEV TAI PSA PSD IVAi IVDi CONi TELo OTPi OUR DELi SAMi OTRi UNRi PUBi IND PHY ONL UNI PUR FIN COM NAV INT DEM CNT STA POL HEA PRE LOC GOV"
    Cache-Control: private, no-cache, no-store
    Content-Length: 47
    Content-Type: application/octet-stream
    Age: 2
    Strict-Transport-Security: max-age=0
    Via: http/1.1 media-router-api2.prod.media.sg3.yahoo.com (ApacheTrafficServer [cMsSf ]), https/1.1 r04.ycpi.inc.yahoo.net (ApacheTrafficServer [cMsSf ])
    Server: ATS
    Connection: close

  20. 50 Posted by Graham on 20 May, 2017 11:05 AM

    Graham's Avatar

    I am having issues with updating quotes and exchange rates on MD v2017 running on a Mac. Updating of security prices from yahoo ceased on 13/4/17. I have updated the extension with the same result. The error message is "Response code 504 and message maximum"

  21. 51 Posted by sth on 20 May, 2017 02:25 PM

    sth's Avatar

    Same problem as Srini. Attaching my self to this thread for notifications of a resolution.

  22. 52 Posted by PC2MAC on 21 May, 2017 10:14 AM

    PC2MAC's Avatar

    Same problem on MD 2014.

  23. Support Staff 53 Posted by Tom Freeman on 22 May, 2017 02:53 PM

    Tom Freeman's Avatar

    We've located a thread on the Yahoo forum, where unfortunately a Yahoo support representative has confirmed that Yahoo Finance API has been discontinued.
    From the changes that have been made, it seems like Yahoo is trying to prevent people from automated downloading like Moneydance (and so many others) are doing.

    We are looking for other options. The advantage of the Yahoo was that it is free.

    I am sorry for the inconvenience.

    Tom Freeman
    Infinite Kind Support

  24. 54 Posted by Dave Rivers on 23 May, 2017 10:30 AM

    Dave Rivers's Avatar

    It appears that, as part of the merger with Verizon, things are changing at Yahoo.

    You can still download the stock quotes (slightly differently) but Yahoo is requiring
    a cookie that shows this is coming from a browser session.

    So, things have become a little more complicated, but still "doable", here's a link
    to some example source:

    https://github.com/dennislwy/YahooFinanceAPI

      - Dave Rivers -

  25. 55 Posted by momrahman on 18 Jun, 2017 01:54 AM

    momrahman's Avatar

    Sean, are you saying that the 2017 MD version works just fine to download historical stock prices?

  26. 56 Posted by sth on 18 Jun, 2017 03:11 PM

    sth's Avatar

    NO. The 2017 version has the same issue. It is a Yahoo change issue not an MD issue. the MD developers could fake it out by making MD look like a browser. But then the Yahoo folks will try to detect that non-approved use of their data and make it stop working and then MD will tweak their code to get around the Yahoo block and then Yahoo will block that .... rinse and repeat.

    The issue is that those who create and maintain a historical database of stock prices want to be paid for their effort. Yahoo has allowed this as a free service to attract traffic but it doesn't seem to have been a successful business model.

    TANSTAAFL

  27. System closed this discussion on 17 Sep, 2017 03:20 PM.

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