Everything I read indicated issues with netty & SSL were common for older versions of Jython. None worked reliably, but error messages were more descriptive using requests and made Jython version issues clearly the problem. To work around the issues, I tried accessing the APIs using different libraries: urrlib2, requests. ("can't connect, reason: ", SSLError(1, u'Received fatal alert: internal_error')) Python scripts would run fine and retrieve security information through both AlphaVantage and Intrinio APIs when run outside Moneydance, but when running through the Python interpreter in Moneydance they would fail with a variety of connectivity errors usually SSL related. In testing various script solutions, I realized the current version of jython in Moneydance 2017 has issues with SSL. The script could be better designed to support a number of the free services, if anyone is so inclined. I also used Intrinio ( ) which requires basic authentication, but went with AlphaVantage due to ease of implementation and support for both currency rates and securities. This script uses the free API provided by AlphaVantage ( You sign up and they provide an apikey that can be passed on command-line, no additional authentication required. The goal was a quick solution, not a finely designed application with a front-end. Using the Moneydance Developer API and shamelessly "borrowing" published coding ideas from a variety of individuals, this is the ugly Python script I pulled together to update Moneydance securities AND currency rates. I take no responsibility for any damage to your data through the use, or mis-use of these instructions and published scripts. I am sharing my solution for anyone brave enough to try it. Tired of waiting for the update from the Moneydance team to address issues with Yahoo finance API being terminated, I embarked on a means to update this myself.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |