Henry on 18 Jul, 2017 03:23 PM
Thank you for contacting us.
A Yahoo support representative has confirmed that Yahoo Finance API has been discontinued.
From the changes that have been made, it seems like Yahoo is trying to prevent people from automated downloading like Moneydance (and so many others) are doing.
Our lead developer has mentioned that we may be able to make a change, that means the Moneydance connection will pose as a browser, rather than a program. This may allow the connection. However, it seems very likely that this will turn into a 'cat-and-mouse' game.
The current workaround is to navigate to Extensions and Select Quotes and Exchange Rates and change the Historical Security Prices to Google Finance. If certain prices are missing after that, you can download the quotes in a cvs file and import them by navigating to Tools > Securities > Edit then Import.
You can also update the current prices through the Security Price Entry extension in the Extensions menu.
We are looking into other services we can use instead to resume the automatic downloads.
on 19 Jul, 2017 10:59 AM
Thank you very much for your answer.
The change to Google Finance did not work at all.
Can you elaborate a little more on the import to Tools> Securities?
Has to be made to a single security at a time?
Or can I import all the securities in a fixed date?
The last option seems to be an easy way, but I think it is not possible.
Henry on 19 Jul, 2017 11:22 AM
Unfortunately Google Finance doesn't cover all of the Securities.
Regarding the manual import:
First, open the Securities Detail view and click History, click import, then select “Import from Transactions” and click “Import”. The information from your security transactions will be integrated into your security’s history.
You can still download the Historical data in a spreadsheet format from Yahoo and import it as instructed above.
And you are correct it has to be done a security at a time.
Regarding the last option for the current prices, it should work in a way where you check and paste the new prices in the new price window.
on 19 Jul, 2017 04:17 PM
Thanks again Henry.
In all the cases, even in the last option, ( check and paste ), you have to go a security at a time.
It is a pity that it is impossible to check and copy the full column of the new price in the Security Price Entry.
It is time consuming and avoids one of the big advantages of your program.
I imagine that could be easily corrected by your people.
The above third party web page also provides a link to the description of how the extension works.
The CSV file you need to create using a spread sheet program list all your security and there price for a given day. This data can be loaded into Moneydance in one go.
Ensure you have a ticker number to each security. Also add these ticker numbers to your CSV file. This is the only way for identify which price data relates to which security.
You don’t need to have all the field descried, in my case I only use three i.e. only three headers. See extract from my CSV file.
on 20 Jul, 2017 04:14 PM
Thank you very much Derek
Your option seems a very good aproach to help me.
Unfortunately I will not be at home until next 26th.
I will try it and report the result
I am already reading the wiki web .
Thank you again