Can you post a screen shot of the Currency/Security History window for Euro found under TOOLS – CURRENCIES – EURO similar to screen shot 2 as well as Edit Currency/Exchange Rates window under EDIT screen shot 3.
Yes, they were the screen shots I wanted to check and they look OK.
Try RESTORE FROM BACKUP using the attached file.
It simply has one security Volkswagen AG
On my computer it looks to be working OK, see how it works for you.
You will need to unzip the file to get to PaulF-20200812-1838.moneydancearchive
Many thanks. This file works so it looks like my file has become corrupted in some way. I will experiment in creating a new Euro2 currency and will see if that works. If I set the FX rate as 1 Euro to what looks like a valid Euro history file. Will that then pick up the right FX rate historically and from QL going forward? I could then redenominate my Euro investments as Euro2... Any thoughts on if this will solve this?
If more than on Currency or for that matter Security has the same ticker symbol the Quote Loader will only display/update one of them.
If I add Euro2 as a currency to the test data set then as it happens Quote Loader displays/updates Euro2 and Euro is ignored. When the Volkswagen AG currency is set to Euro2 the price for Volkswagen AG updates correctly.
Is Volkswagen AG the only Euro Security you have or are there other and do they work?
I should do a EXPORT BACKUP before you try any fix.
Not tried this so make sure you have a backup.
Once you have converted everything to Euro2 delete Euro as a Currency and then rename Euro2 to Euro.
Hi Derek I am testing this solution and it seems to work. My only question is the effect of deleting the Euro as a currency. I seem to remember that MD book FX transactions at the spot rate and then does not change them when the rate is changed. Eg if I booked A Euro transaction in 2010 at the 2010 rate, this will not be affected if the 2010 rate is deleted. My thought is that the only effect will be the Balance translation of accounts denominated in Euros and that this would be corrected once the new Euro FX rates were input. BTW is there an easy way to export the MD historic Euro rates so that I can import them into my new Euro account? I will continue testing.... Alo on rereading the Guidance Notes to QL I realise that you are the author - it is really useful. Many thanks for your help.
No harm in testing theories provided at each stage you do an EXPORT BACKUP so you can find your way back.
As far as I know there is no way to export Euro Exchange Rates, they are not even included in a QIF export or any of the reports.
You can import exchange rates, but not export them.
Hi, Does (or will) the Quote Loader support the new 2020 version of Moneydance?
I think I am in your target audience - just need today's quotes (as I open MD almost daily) and QER tool is way too slow. Thanks