tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/64331-foreign-currency-history-off-by-several-orders-of-magnitudeInfinite Kind: Discussion 2021-01-22T16:43:30Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-25T08:55:59Z2020-10-25T08:55:59ZForeign currency history off by several orders of magnitude<div><p>I am not support staff, just a user.<br>
Hi Brian</p>
<p>What version and build op Moneydance are you running? e.g. 2021(2007).</p>
<p>Within the extension Quote and Exchange Rate Updater you should be using the source European Central Bank not Alpha Vantage. If this does not help try the extension Quote Loader.</p>
<p>There are two methods within Moneydance for obtaining security prices and exchange rates automatically.</p>
<p>The extension “Quote and Exchange Rate Updater” found under EXTENSIONS – MANAGE EXTENSIONS. Check you are running the latest build v1024. For exchange rates use the source European Central Bank. Alpha Vantage covers the US as well as some securities outside the US, but is very, very slow. It’s my understanding that the source IEX Trading no longer works.</p>
<p>If the Quote and exchange rate updater does not work well for you try the extension Quote Loader under EXTENSIONS – MANAGE EXTENSION</p>
<p>For information see post 63 at<br>
<a href="https://infinitekind.tenderapp.com/discussions/investments/4914-the-new-quote-loader/page/3#comment_48442233">https://infinitekind.tenderapp.com/discussions/investments/4914-the...</a></p>
<p>Download the PDF attached to posts 63 and have a read.</p>
<p>To get an overview take a look at the YouTube videos by using the links on page 1 and 2 of the PDF.</p>
<p>Let us know how you get on or if you need help just post.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-26T21:18:47Z2020-10-26T21:18:49ZForeign currency history off by several orders of magnitude<div><p>I am running Moneydance 2021 build 2007. I'm unable to get the quote loader extension to download the exchange rate. I noticed that no matter how many times I update the currencies dialog, the next time I open it up, the Rate is always 0.003588. When I change it, the value on the summary page is updated correctly, but the next time I go into the currencies dialog, it shows 0.003588 again. Quitting out of that dialog actually updates the summary page to the 0.003588 value. That makes sense why this is only a problem when opening and closing that dialog box. Seems that is actually a bug in moneydance, not in the extension.</p></div>Briantag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-26T21:50:25Z2020-10-26T21:50:25ZForeign currency history off by several orders of magnitude<div><p>I am not support staff, just a user.<br>
Hi Brian</p>
<p>Is it only the Australian Dollar exchange rate you are having problems with?</p>
<p>As you can see from the screen shots of a test data set, I just set up in 2021(2007). I am not seeing any exchange rate issues.</p>
<p>When you say I'm unable to get the Quote Loader extension to download the exchange rate, do you mean Quote Loader is not performing as the first screen shot or do you mean when you click Save Selected Values they are not saving to the Currency/Security history window second screen shot.</p>
<p>Before you click Save Selected Values make sure you have removed incorrect data from the relevant Currency/Security history window.</p>
<p>Please provide more detail on why you think you are unable to get the Quote Loader extension to download the exchange rate.</p>
<p>If you look under TOOL – CURRENCIES do you see only one instance of the Australian Dollar?</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T01:42:34Z2020-10-27T01:42:35ZForeign currency history off by several orders of magnitude<div><p>As a test I removed all of the extensions and restarted Moneydance. Then I went into the currencies dialog and set the exchange rate manually to 0.9. The summary page changed with the rate set to 0.9, but when I re-opened the currencies dialog, it was again set to 0.003588. I think that part is a but in Moneydance itself, or something corrupted in my data, since it does that with no extensions.</p></div>Briantag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T01:44:45Z2020-10-27T01:44:46ZForeign currency history off by several orders of magnitude<div><p>Here is a screenshot of the currency list. There are only 2 entries, US and AU.</p></div>Briantag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T06:37:30Z2020-10-27T06:37:30ZForeign currency history off by several orders of magnitude<div><p>Can you screen shot the first page of each currency’s history?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T08:10:37Z2020-10-27T08:10:38ZForeign currency history off by several orders of magnitude<div><p>The history for "Australian Dollar" is empty. There is no history when double clicking on "US Dollar", just an edit dialog.</p></div>Briantag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T10:59:52Z2020-10-27T10:59:52ZForeign currency history off by several orders of magnitude<div><p>I am not support staff, just a user.<br>
Hi Brian</p>
<p>Unless you have deleted all the currencies under TOOL – CURRENCIES there should lots more than two, see screen shot. Did you delete all the others?</p>
<p>If you click on Australian Dollars under TOOL – CURRENCIES then edit does it look like my second screen shot? Does it have a ticker symbol of A$<br>
Is the SHOW ON SUMMARY PAGE box ticked?</p>
<p>If you double click on US Dollar as the Base currency you should not see a exchange rate history just the window in my third screen shot.</p>
<p>Post screen shots as I have.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T20:02:36Z2020-10-27T20:02:38ZForeign currency history off by several orders of magnitude<div><p>I remember deleting the others I wasn't using some time ago. Screenshots attached.</p></div>Briantag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T20:48:03Z2020-10-27T20:48:03ZForeign currency history off by several orders of magnitude<div><p>I am not support staff, just a user.<br>
Hi Brain</p>
<p>Open Quote Loader under extensions and set up as in first screen shot.<br>
Then click GET PRICES the result should be as seconds screen shot.<br>
Tick SELECT and click SAVE SELECTED PRICES - OK to give third screen shot.<br>
Now TOOLS – CURRENCIES, double click Australian Dollar the to give fourth screen shot.</p>
<p>Take screen shots at each stage a I have in case you have a problem and need to post them.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T21:01:08Z2020-10-27T21:01:09ZForeign currency history off by several orders of magnitude<div><p>Performing the steps you gave works, with the exception of the current Rate. That is still stuck at 0.003588.</p>
<p>Since the current rate is always stuck, even if the extensions are not installed, I really think it is a moneydance bug.</p></div>Briantag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T21:11:01Z2020-10-27T21:11:02ZForeign currency history off by several orders of magnitude<div><p>I tried renaming the old AUD entry and creating a new one, then it is no longer stuck at that value. However, I am unable to edit my existing accounts to change the currency (the currency cannot be changed in the edit account dialog). Additionally, whenever I open up my new AUD history, the current rate is subtracted by a small amount. If I keep opening up the history dialog and closing it, the Rate will keep decreasing (and this is also shown on the summary page).</p></div>Briantag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T21:32:26Z2020-10-27T21:32:26ZForeign currency history off by several orders of magnitude<div><p>I am not support staff, just a user.<br>
Hi Brian</p>
<p>Your last post was interesting. You seems to have created some typed of loop possible, subtracting 0.003588 each time he opens the exchange rate window. I can’t see the next step to advice, so I have posted a link to this discussion on Sean’s the Moneydance developers slack site in the hope he will take a look.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T22:05:49Z2020-10-27T22:05:49ZForeign currency history off by several orders of magnitude<div><p>Out of interest, on the currency you renamed (the ‘corrupt’) one, have you renamed both the ID and the name? Also have you checked that the new currency is not referencing / linked to the old currency?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T22:10:28Z2020-10-27T22:10:30ZForeign currency history off by several orders of magnitude<div><p>I have changed the Currency ID, Currency Name, and Value Prefix of the old one. The new one has the same values for these 3 fields as the old one.</p>
<p>Also, the amount that gets subtracted from the rate after closing/opening the currency history is not consistent. I think maybe it is getting divided by something, or perhaps something more complex.</p></div>Briantag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T22:18:33Z2020-10-27T22:18:34ZForeign currency history off by several orders of magnitude<div><p>Both of the australian dollar currencies only reference the us dollar.</p></div>Briantag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T22:29:30Z2020-10-27T22:30:14ZForeign currency history off by several orders of magnitude<div><p>Hi Brian,</p>
<p>The exchange rate should obviously be changing and staying changed when you adjust it in the currency window. Can you try displaying the console window (using the Help -> Console Window menu), keeping it open, and then trying to manually change the currency rate by clicking on the currency from the summary page or from the Tools->Currencies menu? Then can you send a copy of the console text to me or attach it to a message here? Hopefully that will show some kind of error message which hints at the root problem.</p>
<p>One other thing to try is to run the attached python script (which you'll have to unzip first). To run this can you open Moneydance, select the Window->Show MoneyBot Console, then click the Open Script button, select the unzipped python script (called reset_relative_currencies.py), and then select the "Run" button. Give it a few seconds to process and then can you send me a copy-and-paste of the text in the results text area at the bottom of that window?</p>
<p>Thanks,<br>
Sean</p>
<p>--<br>
Sean Reilly<br>
Developer, The Infinite Kind<br>
<a href="https://infinitekind.com">https://infinitekind.com</a></p></div>Sean Reillytag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T22:39:46Z2020-10-27T22:39:46ZForeign currency history off by several orders of magnitude<div><p>I started with clearing the log, then opening Tools -> Currencies -> Australian Dollar. I changed the rate and closed the window. Then I opened up Australian Dollar again and closed it without changing anything. The only thing that showed up in the console log was this:</p>
<p>logging txn; file: tiksync/out/20201027223144_582.txn-tmp<br>
logging txn; file: tiksync/out/20201027223214_586.txn-tmp</p>
<p>I checked but did not find those files in the ~/.moneydance directory.</p>
<p>I do not see a zip file on this page. I did try running the reset_relative_currencies.py script linked on <a href="https://infinitekind.tenderapp.com/discussions/suggestions/13441-please-allow-changing-the-currency-in-edit-account">https://infinitekind.tenderapp.com/discussions/suggestions/13441-pl...</a>, but it did not help. The md5sum of that script is ec6bd26de3dad6790e6829a0655e9b3e. I have attached the log from running that script.</p></div>Briantag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T22:48:05Z2020-10-27T22:48:05ZForeign currency history off by several orders of magnitude<div><p>A quick thought. Do you have syncing on? Try turning sync off and then correcting the currency. I wonder if you have a corrupt sync that’s redoing (wrong) changes?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T22:53:06Z2020-10-27T22:53:06ZForeign currency history off by several orders of magnitude<div><p>Which sync are you referring to? If it's related to the extensions, it shouldn't be related since the problem exists even with the extensions uninstalled.</p></div>Briantag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T23:11:48Z2020-10-27T23:11:48ZForeign currency history off by several orders of magnitude<div><p>Stuart is referring to Moneydance Syncing i.e. syncing information between Moneydance instances on different machines.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T23:21:10Z2020-10-27T23:21:10ZForeign currency history off by several orders of magnitude<div><p>No I only use it on this machine, there is no sync configured, and the ~/.moneydance directory is not on any type of filesystem that does sync under it.</p></div>Briantag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T23:31:17Z2020-10-27T23:31:17ZForeign currency history off by several orders of magnitude<div><p>Hi Brian,</p>
<p>Thanks for sending the log, and I'm pretty sure I know what the problem is now. Your base currency is USD, but apparently USD has a "rate" of 0.0035875600816215785 however because it is the base currency it should always have a rate of 1. I'm pretty sure this is a result of a bug that seems to only occur when the base currency is changed.</p>
<p>Anyway, I've attached a zipped python script which should fix this. It's a similar script to the one that you ran but with one extra bit to fix the non-1.0 base currency rates. That is, if I've remembered to attach it this time!</p>
<p>Can you please run this and let me know the results via copy-and-paste of the output text?</p>
<p>Thanks,<br>
Sean</p></div>Sean Reillytag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T23:39:47Z2020-10-27T23:39:47ZForeign currency history off by several orders of magnitude<div><p>Yes, that worked! Thanks so much! I have attached the log as requested.</p></div>Briantag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-27T23:46:17Z2020-10-27T23:46:17ZForeign currency history off by several orders of magnitude<div><p>Fantastic! Thanks for the confirmation as it showed the problem was what I had thought. It shouldn't be any more trouble now, and the exchange rate and security price updaters should all work properly now. Although to be honest I'd recommend using the European Central Bank source for exchange rates as those can all be retrieved in one shot, making them a lot faster than Alphavantage in general.</p>
<p>Thanks,<br>
Sean</p></div>Sean Reillytag:infinitekind.tenderapp.com,2009-01-14:Comment/487663652020-10-28T08:52:09Z2020-10-28T08:52:09ZForeign currency history off by several orders of magnitude<div><p>I am not support staff, just a user.<br>
Hi Brian</p>
<p>Glad to see Sean responded as I thought he would and fixed your issue.</p>
<p>Have Fun, Stay Safe.</p></div>derekkent23