updating quotes and exchanges

trina's Avatar

trina

11 Jan, 2018 05:52 PM

hi, i can't seem to get this to update. can someone help me?

i have Moneydance version 2017.5 (1639)
i've installed the quotes and exchange rates updater v1012
for currency exchange rates and security prices, i selected Alphavantage
i've also created and entered an API

when i click update now, i get this error
Error while downloading currency exchange rates: sun.security.validator.validatorexception: no trusted certificate found
followed by a similar error for each security which ends with "No trusted certificate found"

  1. 1 Posted by -Kevin N. on 11 Jan, 2018 06:04 PM

    -Kevin N.'s Avatar

    Hi Trina,

    Thank you for providing your version of Moneydance. It makes this much easier. :)

    You need to be using MD 2017.6 (1656)
    You can d/l it here:
    http://infinitekind.com/download-moneydance-personal-finance-software

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

  2. 2 Posted by Trina Wong on 12 Jan, 2018 05:59 PM

    Trina Wong's Avatar

    thanks! it works now!

    ~~~~~~~~~
    Trina Wong

  3. 3 Posted by -Kevin N. on 12 Jan, 2018 07:01 PM

    -Kevin N.'s Avatar

    Hi Trina,

    I'm glad to hear that it worked.

    Thank you for reporting back with your results.

    -Kevin N.

  4. 4 Posted by mikeymark on 12 Jan, 2018 07:04 PM

    mikeymark's Avatar

    Hi,
    I just updated to MD 2017.6 (1656) from MD 2011 and updated the quotes updater extension to v.1012

    I can't get the quotes to download. It should be noted that I was not asked to select Alphavantage the first time I opened the extension. I tried removing and then reinstalling the extension but to no avail.

    Your help will be greatly appreciated.

    Mike

  5. 5 Posted by -Kevin N. on 12 Jan, 2018 07:29 PM

    -Kevin N.'s Avatar

    Hi Mike,

    The downloads will not work without the API key from AlphaVantage.

    First off, double check the version of MD. (Menu bar > Help > About Moneydance).
    Double check the version of the Q&ER updater. (Menu bar > Extensions > Manage Extensions).

    If and when you do get prompted for the API key, make sure that you select 'AlphaVantage' from the Q&ER's drop-down lists?

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

  6. 6 Posted by mikeymark on 12 Jan, 2018 08:08 PM

    mikeymark's Avatar

    Thank you for the fast response.

    Solved! I hadn't checked the drop down menu. Got the key and all is well.

    Thank you so much!!!

  7. 7 Posted by -Kevin N. on 12 Jan, 2018 09:35 PM

    -Kevin N.'s Avatar

    Hi Mike,

    I'm glad to hear that you were able to get it sorted.

    Thank you for reporting back with your results.

    -Kevin N.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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