Unable to update stock prices

Keith B Ford's Avatar

Keith B Ford

16 Jun, 2018 09:25 PM

I have been running Moneydance version 2017.7.1 (1671).

Recently Quotes and Exchange Rates has not been updating.

Get message..no trusted certificate found. I suspect my API Key stopped working. I have uninstalled and reinstalled the key to no avail. I’m going on a couple of weeks now.

I need help.

Keith B Ford

  1. 1 Posted by Keith B Ford on 16 Jun, 2018 09:27 PM

    Keith B Ford's Avatar

    I've also emailed Alphavantage

  2. 2 Posted by derekkent23 on 17 Jun, 2018 07:24 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    Hi Keith B Ford

    “no trusted certificate found” normally means that your build of 2017 is out of date and you need to update to the latest release. But you seem to be running the latest build. Problems like this can be frustrating and time consuming.

    There is a free alternative that does not suffer from these issues, it a stand-alone program that was originally developed to help out users of MS Money when Microsoft stopped supporting that product. The developer is actively supporting this software and has adapted it to work with Moneydance. This current build very stable and the quotes very consistent. Two sources are available, not Alpha Vantage. No strange prices. It has a lot of useful features. These include obtaining quote for stocks & funds, from many stock exchanges US, Canada, UK, Europe and Australia to name but a few. Provide a means for importing all this data into Moneydance. You can also import exchange rates along with your security prices. The program is in java, like Moneydance and thus runs on Windows, Mac and Linux computers.
    Take a look at his thread and download the PDF outlining how to use the program and link to download the program. Post 190 in this thread. http://help.infinitekind.com/discussions/investments/3036-third-par...

    Let me know how you get on and if you have any questions.

    Hope this helps

  3. 3 Posted by Keith B Ford on 17 Jun, 2018 09:14 PM

    Keith B Ford's Avatar

    Thanks. I was having all sorts of issues with computer. Possibly NIC problem. I’m now using LAN hardware rather than wireless. And after a lot of issues did latest Mac OS update. And it’s working again. At least for now.

    Keith

    Sent from my iPhone

  4. 4 Posted by dpbirke on 21 Jun, 2018 01:33 AM

    dpbirke's Avatar

    Derek, I'm trying to use the app but I'm having a problem. I downloaded the app, entered the symbols for all of my investments and successfully downloaded all of the prices. I then right click in the Symbol column, go to MD--Save CSV. I then get the save dialogue box and then try to save. But nothing is ever saved. When I go the the Security Price Loader app and go to the folder in which I tried to save the prices, there is no saved file there.

    Any suggestions?

  5. 5 Posted by derekkent23 on 21 Jun, 2018 07:42 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    Hi Dennis

    Can you create a new folder in your document folder say called “Quotes”.
    Then using MD—Save CSV navigate into the new “Quotes” folder before clicking “Save”.

    Or try saving the CSV file to your Desktop.

    Using your file explorer/finder check the file has been created. mdQuotes-ft.csv or mdQuotes-yahoo.scv or the name you have saved it under.

    If you still have problems post again and include what operating system your computer is running.

    In any event let me know how you get on.

    Hope this helps

  6. 6 Posted by dpbirke on 21 Jun, 2018 01:00 PM

    dpbirke's Avatar

    Thanks for the suggestions, I created a new folder as you suggested, but nothing is saved.

    I'm using Windows 10.

    I'd appreciate any other suggestions you have,

  7. 7 Posted by dpbirke on 21 Jun, 2018 01:23 PM

    dpbirke's Avatar

    Never mind. It is now working. Thanks for your assistance.

  8. 8 Posted by derekkent23 on 21 Jun, 2018 09:08 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Hi Dennis

    Can you confirm you are now able to use the Security Price Loader to import the quotes into Moneydance?

    And if you have got the process sorted out how well does it work for you?

  9. 9 Posted by dpbirke on 22 Jun, 2018 06:20 PM

    dpbirke's Avatar

    Hi, yes it seems to downloading all of the prices I need and then loading them into Moneydance. So, thank you for the solution to my problem. I'll admit I found the instructions a bit daunting, and I had some difficulties getting everything downloaded and working properly, but I kept working at it and got it to work. Thank you very much for making this available to us. I like Moneydance a lot but the downloading of investment information is the program's Achilles heel. Your apps provide a nifty solution!

  10. 10 Posted by derekkent23 on 22 Jun, 2018 07:09 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Hi Dennis

    The credit for the stand-alone hleofxquotes Program goes to hleofxquotes and the Security/history loader extension to Mike Brake. I was responsible for the instructions which were bit daunting, sorry about that.

    The important thing is you persisted and now can take advantage of a great solution.

    HAVE FUN

  11. System closed this discussion on 21 Sep, 2018 07:10 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

Recent Discussions

17 Jun, 2024 11:18 PM
17 Jun, 2024 10:10 PM
17 Jun, 2024 09:48 PM
17 Jun, 2024 07:29 PM
17 Jun, 2024 07:00 PM