Currency problems with Money Dance

WILL_SGD's Avatar

WILL_SGD

16 Oct, 2021 11:19 PM

Hello,

I run multi currency accounts on Monday Dance and I am encountering issues when setting currencies. First of all the "Quotes and Currency Exchange Rates Updater" plug in (supposedly updating currencies from Yahoo and Google simply doesn't work. It ends up just plugging in random exchange rates (ie random 4 digit exchange rates when it's only 2 digits, which results in inaccurate dashboard and Net worth balances), which is why I endedup disabling the plug in completely.

But the problem now is when I try to update exchange rates manually, no matter what number i try to put in, it always seems to persist on it's own number it decides on its own.

For example, when i try to set 1 USD = 50.71 PHP (the TRUE rate), it always decides the exchange rate is 1 (when it is simply not true)
or when I try to set 1 SGD = 37.62 PHP (the TRUE rate), it always decides the rate is 0.741866 (when it is not). Pls find attached screen shots for both.

Hope someone can shed some light on how to fix this, because when it's time to pull up the Net worth reports, it ends up being grossly inaccurate as it relies on these exchange rates.

Thank you...

  1. 1 Posted by sth on 16 Oct, 2021 11:39 PM

    sth's Avatar

    What version of MD are you running and on what OS? (Mac right?)

    What is your "Base Currency"?

    Are those history windows from Tools->Currency? I get a slightly different window and I am not sure why. (MD 2021.2 3035)

  2. 2 Posted by WILL_SGD on 16 Oct, 2021 11:43 PM

    WILL_SGD's Avatar

    Hello,

    I'm using Ver 2020.1 (1928), don't see any further updates on the App Store.
    Running on MacOS BigSur

    My "base currency" I switch between SGD, PHP and USD depending on which currency I want to produce report for...

  3. 3 Posted by WILL_SGD on 16 Oct, 2021 11:47 PM

    WILL_SGD's Avatar

    As a side note, here's a screen shot of the currency exchange between THB to PHP (Thai bhat to philippine peso), with PHP as the base rate.. Real exchange rate is 1.52 but if u look at the history it's just waaaaay out there... :-(

  4. 4 Posted by WILL_SGD on 17 Oct, 2021 12:09 AM

    WILL_SGD's Avatar

    When you try to override any of the rates and close the window (or even restart the app) next time you go in, it will revert back to the currency rate it decides. Like that first screen shot, USD > PHP. It will always decide that it's "1" despite me going in to try to change it to 52.

  5. 5 Posted by sth on 17 Oct, 2021 02:22 AM

    sth's Avatar

    Will,
    First Moneydance 2021.1 (2010) is the minimum version for Big Sur so I suggest an upgrade to the most recent 2021 version as a first step. There are issues with older versions.

    The Apple App store lags in versions available to the users. It is easier to navigate upgrades when you buy directly from IK IMHO. It looks like IK hasn't updated the Apple App Store version in about a year. Big Sur had not been released at that time!

    I can see where constantly changing the base currency might confuse the system. But that is just a guess.

    Scott (NOT IK support, just a user)

  6. 6 Posted by Stuart Beesley ... on 17 Oct, 2021 05:18 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    My guess is that you have a currency corruption of some kind.. There was a bug in the rate field which was finally fixed in build 3089. The rate defaulting to 1 is a sign that this could be it.... The Toolbox extension can fix this issue but you need to be on at least build 3056 for this.....

    I may not be correct of course.... This is my 'guess'.

    Options:

    1/ Download Toolbox as a script (toolbox.py) from this link (file, save-as, select page source) and save as toolbox.py . Then in MD, Window, Show Moneybot Console, Open Script, Select this file, then Run:
    https://github.com/yogi1967/MoneydancePythonScripts/raw/master/sour...
    Once loaded, Menu Currency and Security Tools, then Diagnose then Fix Currencies. Hopefully this will run within an AppleStore version...

    2/ upgrade to to latest with the bug fix - MD2022. But that may mean buying directly, rather than Apple Store. Longer term this is a better approach, as the latest versions get to the web site much quicker...

    3/ run the script 'reset_relative_currencies.py' which support should provide to you.

    4/ temporarily install MD2021.1(3069) in a separate location, install Toolbox extension, run toolbox, Currency Menu, Diagnose, then Fix Currencies... Then exit and relaunch your normal version... (I don't exactly know how you do this when running an apple store version.. I would normally rename the app in Applications first, and then rename back afterwards): https://infinitekind.com/download_2021

    With any option, BACKUP FIRST (File/Export/Backup)

    (not support, just a fellow user)

  7. 7 Posted by sth on 17 Oct, 2021 11:50 AM

    sth's Avatar

    I would say that Stuart's guess is even better than mine!

  8. Support Staff 8 Posted by Sean Reilly on 18 Oct, 2021 06:33 PM

    Sean Reilly's Avatar

    Hello,

    I wouldn't worry about the version you have being compatible with Big Sur. However there were some bugs related to changing base currencies that were fixed in Moneydance 2022. We expect to be releasing Moneydance 2022 on the Mac App Store soon, however if you'd like to get up and running sooner you can download and run Moneydance 2022 from our web site (infinitekind.com/download) and we can send you a license key that works with it. Please let us know, and we'll get you going again!

    Also, I should say that changing the base currency in any version of Moneydance is a pretty heavyweight operation. Even without bugs, I'd recommend against it. If there is something else we can change to prevent the need for changing the base currency, please let us know. I'd prefer to add a currency setting to many reports than asking you to keep changing the base currency unnecessarily.

    Thanks,
    Sean

    --
    Sean Reilly
    Developer, The Infinite Kind
    https://infinitekind.com

  9. 9 Posted by WILL_SGD on 18 Oct, 2021 11:39 PM

    WILL_SGD's Avatar

    Hi Sean,

    Thank would be great! Please could you let me know the steps on how to do it?    (I’m not very tech inclined unfortunately)

    Thanks so much
    Will.

  10. 10 Posted by Stuart Beesley ... on 19 Oct, 2021 09:19 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    This is the download link for MD2022
    https://infinitekind.com/download-moneydance-personal-finance-software

    Sean will have to email you a key....

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • Screen_Shot_2021-10-17_at_7.14.30_AM.png 408 KB
  • Screen_Shot_2021-10-17_at_7.16.40_AM.png 578 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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