Home → Investments →

Quotes and Exchange Rates stopped working.

• Edit

Christine

08 Sep, 2023 10:31 PM

When clicking on Download and Exchange Rates, I get this message for every stock that I own: "Unable to get rate from ...".
I really need this function so hoping that there will be an update to the Quotes and Exchange Rates extension.
Please let me know. Thank you.

1. 1 Posted by dwg on 08 Sep, 2023 10:47 PM

   

   I'm a fellow user.

   A couple of things, make sure you are using the latest version of Q & ER. Secondly if you are using AlphaVantage as the source try using Yahoo. The reliability of AlphaVantage is increasing questionable.

   I did just try the extension and it worked as expected.

   If you continue to have problems I would suggest you try using the alternative Quota Loader Extension:

   https://infinitekind.tenderapp.com/discussions/investments/7595-quo...

   • Edit

2. 2 Posted by Giselle Bouvoir on 09 Sep, 2023 06:29 PM

   

   Hi dwg,

   I appreciate your reply but it isn't helping.

   Just so you know, the Q & ER worked perfectly for me until September 2,
   just a week ago.

   I do have the latest version of Q & ER, I use Yahoo but also tried my
   old key for AlphaVantage in vain.

   I was running Moneydance 2022.5 and I upgraded to Moneydance 2023.1 but
   it didn't fix the issue.

   I run Mac OS 10.13.6.

   Maybe you are using a PC or a different operating system, or a different
   Moneydance version, and that's why it works for you but it definitely
   doesn't work for me anymore.

   I'd rather stick with Q & ER, which I've been using for years. I would
   like this extension to be updated so that it works once again.

   Over the years, there have been times when the extension stops working
   and then a solution comes. I hope that the Moneydance team can find a
   solution. After all, this is a big part of why I use this software.

   Sincerely,

   Christine

   • Edit

3. 3 Posted by Stuart Beesley ... on 09 Sep, 2023 06:37 PM

   

   Grab menu/help/console. Save to file. Upload that here.

   • Edit

4. 4 Posted by Giselle Bouvoir on 09 Sep, 2023 07:12 PM

   

   Here's a sample:

   non-success response for cookie/crumble request; code=400 msg=Invalid
   HTTP Request
   yahoo: set/updated cookie and/or crumble in 0.315 seconds
   Unable to get rate from ^Pluri Inc. to USD
   updating security: Take-Two Interactive Software, Inc. (Take-Two
   Interactive Software, Inc)
   yahoo: updating security: Take-Two Interactive Software, Inc
   java.net.URISyntaxException: Illegal character in path at index 40:
   https://finance.yahoo.com/quote/Take-Two Interactive Software,
   Inc/history?p=Take-Two Interactive Software, Inc
        at java.base/java.net.URI$Parser.fail(Unknown Source)
        at java.base/java.net.URI$Parser.checkChars(Unknown Source)
        at java.base/java.net.URI$Parser.parseHierarchical(Unknown Source)
        at java.base/java.net.URI$Parser.parse(Unknown Source)
        at java.base/java.net.URI.<init>(Unknown Source)
        at java.base/java.net.URL.toURI(Unknown Source)
        at
   com.moneydance.apps.md.controller.olb.HTTPURLConnectionHelper.urlToURI(HTTPURLConnectionHelper.java:300)
        at
   com.moneydance.apps.md.controller.olb.HTTPURLConnectionHelper.getURI(HTTPURLConnectionHelper.java:295)
        at
   com.moneydance.apps.md.controller.olb.HTTPURLConnectionHelper.addCookiesToRequestHeaders(HTTPURLConnectionHelper.java:336)
        at
   com.moneydance.apps.md.controller.olb.HTTPURLConnectionHelper.beginResponse(HTTPURLConnectionHelper.java:670)
        at
   com.moneydance.apps.md.controller.olb.HTTPURLConnectionHelper.getResponseCode(HTTPURLConnectionHelper.java:133)
        at
   com.moneydance.apps.md.controller.olb.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:93)
        at
   com.moneydance.modules.features.yahooqt.YahooConnection.setCookieAndCrumble(YahooConnection.java:371)
        at
   com.moneydance.modules.features.yahooqt.YahooConnection.updateSecurity(YahooConnection.java:297)
        at
   com.moneydance.modules.features.yahooqt.BaseConnection.updateSecurities(BaseConnection.java:124)
        at
   com.moneydance.modules.features.yahooqt.YahooConnection.updateSecurities(YahooConnection.java:279)
        at
   com.moneydance.modules.features.yahooqt.DownloadTask.downloadPrices(DownloadTask.java:211)
        at
   com.moneydance.modules.features.yahooqt.DownloadTask.call(DownloadTask.java:123)
        at
   com.moneydance.modules.features.yahooqt.DownloadTask.call(DownloadTask.java:21)
        at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
        at
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.base/java.lang.Thread.run(Unknown Source)
   java.net.URISyntaxException: Illegal character in path at index 40:
   https://finance.yahoo.com/quote/Take-Two Interactive Software,
   Inc/history?p=Take-Two Interactive Software, Inc
        at java.base/java.net.URI$Parser.fail(Unknown Source)
        at java.base/java.net.URI$Parser.checkChars(Unknown Source)
        at java.base/java.net.URI$Parser.parseHierarchical(Unknown Source)
        at java.base/java.net.URI$Parser.parse(Unknown Source)
        at java.base/java.net.URI.<init>(Unknown Source)
        at java.base/java.net.URL.toURI(Unknown Source)
        at
   com.moneydance.apps.md.controller.olb.HTTPURLConnectionHelper.urlToURI(HTTPURLConnectionHelper.java:300)
        at
   com.moneydance.apps.md.controller.olb.HTTPURLConnectionHelper.extractCookiesFromHeaders(HTTPURLConnectionHelper.java:890)
        at
   com.moneydance.apps.md.controller.olb.HTTPURLConnectionHelper.readResponseHeaders(HTTPURLConnectionHelper.java:653)
        at
   com.moneydance.apps.md.controller.olb.HTTPURLConnectionHelper.beginResponse(HTTPURLConnectionHelper.java:683)
        at
   com.moneydance.apps.md.controller.olb.HTTPURLConnectionHelper.getResponseCode(HTTPURLConnectionHelper.java:133)
        at
   com.moneydance.apps.md.controller.olb.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:93)
        at
   com.moneydance.modules.features.yahooqt.YahooConnection.setCookieAndCrumble(YahooConnection.java:371)
        at
   com.moneydance.modules.features.yahooqt.YahooConnection.updateSecurity(YahooConnection.java:297)
        at
   com.moneydance.modules.features.yahooqt.BaseConnection.updateSecurities(BaseConnection.java:124)
        at
   com.moneydance.modules.features.yahooqt.YahooConnection.updateSecurities(YahooConnection.java:279)
        at
   com.moneydance.modules.features.yahooqt.DownloadTask.downloadPrices(DownloadTask.java:211)
        at
   com.moneydance.modules.features.yahooqt.DownloadTask.call(DownloadTask.java:123)
        at
   com.moneydance.modules.features.yahooqt.DownloadTask.call(DownloadTask.java:21)
        at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
        at
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.base/java.lang.Thread.run(Unknown Source)
   non-success response for cookie/crumble request; code=400 msg=Invalid
   HTTP Request
   yahoo: set/updated cookie and/or crumble in 0.305 seconds
   Unable to get rate from ^Take-Two Interactive Software, Inc. to USD

   On 9/9/23 11:37 AM, Stuart Beesley (Mr Toolbox) wrote:

   • Edit

5. 5 Posted by derekkent23 on 10 Sep, 2023 07:42 AM

   

   I am not support staff, just a user.
   Hi Christine

   I was able to pick out two securities from the information you posted.
   Pluri Inc and Take-Two Interactive Software Inc

   These are traded on a number of stock exchanges in different currencies but I have assumed you are looking for US securities traded in US Dollars in the following screen shot of Quote Loader which successfully obtains prices. See screen shot.

   I know you seen to be reluctant to try new things but if you can’t get Q & ER to work then Quote Loader works and is available to you.

   So try the extension Quote Loader under EXTENSIONS – MANAGE EXTENSION
   For information on the features of this extension and how to use see post 64 at https://infinitekind.tenderapp.com/discussions/investments/7595-quote-loader-version-2#comment_59176232

   Download the PDF’s attached to post 64 and have a read.

   To get an overview take a look at the YouTube videos by using the links on page 1 and 2 of the PDF.

   The Quick Start Video is intended to give a quick overview so the user can see if Quite loader looks like it could work for them. The Short Video expands the user’s knowledge giving more detail. The Full Video goes even further but may be to wordy for some.

   The PDF reinforces what’s leaned in the videos, provides step by step instructions, a must read and provide answers on how to handle less obvious issues some users may come across.

   Hope this helps.

   • Giselle_Bouvoir.png 67.7 KB
   • Edit

6. System closed this discussion on 10 Dec, 2023 07:50 AM.