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.

  8. 8 Posted by Ken Broomfield on 01 Mar, 2018 10:19 AM

    Ken Broomfield's Avatar

    Quotes download but problem persists that some of them are wrong because decimal point in wrong place. Error varies from day to day.

  9. 9 Posted by derekkent23 on 01 Mar, 2018 12:59 PM

    derekkent23's Avatar

    I am not Support Staff, just a user.

    Hi Ken, still having the same problems. Can you give say three examples of problem symbols.

    The best solution to the issue, as I recommended to you before, is to use the stand-along program, give it a go. see http://help.infinitekind.com/discussions/investments/3036-third-par...

    Hope this helps

  10. 10 Posted by KEN BROOMFIELD on 01 Mar, 2018 06:01 PM

    KEN BROOMFIELD's Avatar

    Hello Derek
    The securities normally start with the letter H but it can vary from day to day. Included are Henderson UK Index Class Acc and Hansa A Non Voting
    Some days everything is correct.
    Ken

    On 1 Mar 2018, at 12:59 pm, derekkent23 <[email blocked]<mailto:[email blocked]>> wrote:

  11. 11 Posted by derekkent23 on 01 Mar, 2018 06:45 PM

    derekkent23's Avatar

    I am not support staff just a user.

    Are you talking about Janus Henderson UK Index Fund A Acc GB0032897653
    And Hansa Trust A Shares HANA:LSE

    If so this is what the stand-alone program returns. Try it for yourself.

    Hope this helps.

  12. 12 Posted by KEN BROOMFIELD on 01 Mar, 2018 06:50 PM

    KEN BROOMFIELD's Avatar

    Yes you are correct. Thanks for your advice.
    Ken

    On 1 Mar 2018, at 6:45 pm, derekkent23 <[email blocked]<mailto:[email blocked]>> wrote:

  13. System closed this discussion on 31 May, 2018 06:50 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