Extension - Quotes and Exchange Rates

ed.fischer's Avatar

ed.fischer

30 Apr, 2022 06:26 PM

Updating security prices fails using this extension. The messages are "Unable to get rate from (Security ID) to USD."

This is the same whether "Currency Exchange Rates" is set to "--- DO NOT UPDATE ---" or "Alphavantage".

I've tried the "Security Prices" settings of "Alphavantage" and what I normally use "Yahoo! Finance - USA". Both provide the same message "Unable to get rate from (Security ID) to USD."

The last time I ran an update was 4/23/2022 and it was successful. That was using 2022-2 (4060).

Attempted today 4/30/2022 and it failed. I then updated MD to 2022-3 (4077) and tried again. Problem remains.

Thanks,
Ed

  1. 1 Posted by derekkent23 on 01 May, 2022 08:04 AM

    derekkent23's Avatar

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

    Try the extension Quote Loader under EXTENSIONS – MANAGE EXTENSION

    For information on the features of this extension and how to use see post 210 at
    https://infinitekind.tenderapp.com/discussions/investments/4914-the...

    Download the PDF’s attached to post 210 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.

    Let us know how you get on or if you need help just post.

    Hope this helps.

  2. 2 Posted by cookie87 on 01 May, 2022 11:07 AM

    cookie87's Avatar

    I have NOT updated my version. This extension has simply stopped working, whether using Alphavantage or Yahoo. My last successful quotes download was on 4/14.

  3. 3 Posted by SeanS on 02 May, 2022 03:06 AM

    SeanS's Avatar

    I'm seeing the same problem. It was working a week ago with 2022.2-4060; as soon as I upgraded to 2022.3-4077 it stopped working.

  4. 4 Posted by SeanS on 02 May, 2022 03:13 AM

    SeanS's Avatar

    Here's a sample of the problem from my errorlog.txt file:

    updating security: Coinbase Global (COIN)
    yahoo: updating security: COIN
    yahoo: set/updated cookie and/or crumble in 0.712 seconds
    Unable to get rate from Coinbase Global to USD

  5. 5 Posted by dwg on 02 May, 2022 03:34 AM

    dwg's Avatar

    The developer has been made aware of this problem.

  6. 6 Posted by Stuart Beesley ... on 02 May, 2022 05:56 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I just tested Alphavantage and this works fine for me on 4077

  7. 7 Posted by dwg on 02 May, 2022 06:04 AM

    dwg's Avatar

    I believe AV dropped their, at least free, support for the Australian market.

  8. 8 Posted by Stuart Beesley ... on 02 May, 2022 06:04 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    OK, I think something has changed with Yahoo (not MD)...

  9. 9 Posted by dwg on 02 May, 2022 06:34 AM

    dwg's Avatar

    Yes I was thinking of just some detail change in Yahoo that has thrown the extension.

  10. 10 Posted by Stuart Beesley ... on 02 May, 2022 06:43 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Yes, I think I see references to URLs that I cannot reach.....

  11. 11 Posted by derekkent23 on 02 May, 2022 06:58 AM

    derekkent23's Avatar

    I am not support staff, just a user,
    Hi SeanS

    If you need to get prices for Coinbase Global, Inc. then the Extension Quote Loader can do that for you, see screen shot.

    Hope this helps.

  12. 12 Posted by ed.fischer on 02 May, 2022 04:38 PM

    ed.fischer's Avatar

    Thanks Stuart. I tried Alphavantage and as I recall it did update the
    current price and may have added data for the most recent date but it
    didn't add history from the last downloaded record. From your test did
    Alphavantage download all missing dates or merely update the current
    price?
    For example the way I normally use this extension is to update on
    Saturday retrieving data for the prior week using Yahoo Finance - USA
    as the "method" to retrieve the security prices and this as worked well
    until this week.
    I see on another email you and user DWG mentioned something may have
    changed with Yahoo, which is very possible. As a note I wrote a script
    last year to download historical data using python and the
    pandas_datareader package which is using the data source of yahoo and
    this still works as designed. However, not knowing what tools this
    extension uses and how the data is actually extracted it's entirely
    possible yahoo is the issue.
    User DWG mentioned the developer has been made aware, so hopefully a
    fix is imminent as this extension does exactly what I want it to do.

    On Mon, 2022-05-02 at 05:56 +0000, Stuart Beesley (Mr Toolbox) wrote:

  13. 13 Posted by Stuart Beesley ... on 02 May, 2022 04:57 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    The problem has now (supposedly) been fixed in 1032 of the extension... It's available to update...

  14. 14 Posted by SeanS on 02 May, 2022 05:28 PM

    SeanS's Avatar

    Version 1032 does fix the problem. My thanks to the developer for the quick solution.

  15. 15 Posted by ed.fischer on 02 May, 2022 05:56 PM

    ed.fischer's Avatar

    Great!
    I've updated and initial tests are OK as the extension did update securities with current intraday market pricing. I had previously updated historical security prices semi-manually for last week. I’ll run next Saturday as normal but anticipate all to be working as expected.

    Thanks everyone for the input and thanks to the developer for the speedy update!

  16. 16 Posted by CharlesO on 03 May, 2022 11:00 AM

    CharlesO's Avatar

    The Quotes and Exchange Rates extension is not working properly for me.
    I'm getting the "unable.." message, as mentioned above.
    I have updated Moneydance to 2022.23 (4077), and the extension to 1032.
    However, it did pickup two or three stock prices, just for today.
    Currency rates only got to yesterday.
    It was working at 31st March.
    Help!

  17. Support Staff 17 Posted by Maddy on 03 May, 2022 04:22 PM

    Maddy's Avatar

    @Charles

    Upgrading to the latest preview version should hopefully fix the problem for you.
    Moneydance 2022.4 (4078) is now available to download from this page.

    For a full list of improvements in the preview version, please refer to this page.

    I hope this information is helpful. Please let us know if you have further questions or need more assistance.

    --
    Maddy, Infinite Kind Support

  18. 18 Posted by ed.fischer on 09 May, 2022 05:48 PM

    ed.fischer's Avatar

    Maddy,
    Thanks for informing me of the 2022.4 (4078) update available. However this issue seems to be resolved with Quotes and Exchange Rates" extension update 1032. I have not upgraded to 4078 and will wait until an official release unless further issues arise.

  19. Support Staff 19 Posted by Maddy on 10 May, 2022 09:41 AM

    Maddy's Avatar

    Of course, Ed!

    Thank you for reporting back. I'm glad to hear that the issue seems to be resolved after updating the Quotes and Exchange Rates" extension.

    --
    Maddy, Infinite Kind Support

  20. System closed this discussion on 09 Aug, 2022 09:50 AM.

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

Recent Discussions

27 Sep, 2022 02:26 PM
27 Sep, 2022 12:37 PM
27 Sep, 2022 12:23 PM
27 Sep, 2022 10:40 AM
27 Sep, 2022 07:22 AM