Quotes and Exchange rates

Claes's Avatar

Claes

18 Nov, 2016 07:55 AM

Since about one week, I have a problem with the "Quotes and Exchange rates" extension. My securities in US$, CHF and EUR are OK, but the quotes for my securities in SEK are a factor of 100 too high. It started to happen when I moved to Moneydance 2017, but I have now the same problem when I go back to Moneydance 2015. Any idea what causes the problem?

  1. 1 Posted by Claes on 19 Nov, 2016 11:42 AM

    Claes's Avatar

    As a follow-up to my problem with SEK "Quotes and Exchange rates", I now see that my budget manager is counting my Swedish assets 100 times too high (base currency in EUR), so it looks as the conversion within the program is not correct.

  2. 2 Posted by Claes on 19 Nov, 2016 09:53 PM

    Claes's Avatar

    The problem above where the budget manager was counting my Swedish assets 100 times too high, was due to the fact that my Swedish assets were attributed to a Category denominated in SEK, whereas my base currency is EUR. Must all categories be in the base currency?

  3. Support Staff 3 Posted by Tom Freeman on 02 Dec, 2016 03:07 PM

    Tom Freeman's Avatar

    Sorry for the late reply.

    Can you provide a few SEK ticker symbols I want to try and replicate the issue with the Q and E extesnion.

    Are these securities in the same investment account. What is the currency of that account.

    Tom Freeman
    Infinite Kind Support

  4. 4 Posted by Claes on 02 Dec, 2016 04:10 PM

    Claes's Avatar

    Here are a few examples of SEK ticker symbols: ELUX-B, ERIC-B and VOLV-B, all at the OMX Nordic Exchange – Stockholm.

     

    After having changed the category for the shares in question all is back to normal.

     

    Claes

  5. 5 Posted by Claes on 03 Dec, 2016 09:16 AM

    Claes's Avatar

    Further to my e-mail yesterday I now see that e.g. the total sums under the heading “Investment performance” are wrong (much too high).

    Apart from that everything I have looked at seems OK.

     

    Claes

     

    From: Claes [mailto:[email blocked]]
    Sent: 02 December 2016 17:10
    To: '[email blocked]'
    Subject: RE: Quotes and Exchange rates [Extension Development #1714]

     

    Here are a few examples of SEK ticker symbols: ELUX-B, ERIC-B and VOLV-B, all at the OMX Nordic Exchange – Stockholm.

     

    After having changed the category for the shares in question all is back to normal.

     

    Claes

  6. Support Staff 6 Posted by Tom Freeman on 07 Dec, 2016 07:47 PM

    Tom Freeman's Avatar

    Which version of MD are you using? Help > about MD

    Can you send me a screen shot illustrating the performance performance issue. I wonder if the old price issue is still being used to tabulate performance? Also could you send me a screen shot of your Quotes and exchange extension window.

    Currently the securities are held in the base currency of your data file then converted if the investment account or security is of a different currency. This is what caused the issue in the budget report.

    This has caused a few issuers and there is discussion to change this to allow the securities to be held in their own currency.

    Tom Freeman
    Infinite Kind Support

  7. 7 Posted by Claes on 08 Dec, 2016 08:28 PM

    Claes's Avatar

    I am using MD 2017.1 (1592).
    I haven't time just now to make screen shots or to do a systematic search of the problem. The only thing I can contribute at the moment is an observation from yesterday and this morning.
    Yesterday I made some changes (moving cash och shares) to both the EUR and SEK investment accounts and then closed the file without looking at the total sum of investments.
    This morning, when I opened the file, I saw that, in the sum of all investments accounts on the summary page, was completely wrong (all accounts were summed up as being in EUR, thus giving a much too high total, as 1 EUR is about 10 SEK).
    Then I ran the "Quotes and Exchange Rates" extension, and suddenly the sum of all investments accounts were correct again.
    Hope it given you some indication of were the problem is.

    Claes

  8. 8 Posted by Claes on 09 Dec, 2016 08:28 AM

    Claes's Avatar

    Same thing happened also this morning, although I didn't make any changes to my investments yesterday.
    The sum of all investments accounts on the summary page was wrong, but was corrected the moment the currency rates were updated.
    This problem only happens for me overnight. When I close and the open MD during the day, the problem doesn't occur.

  9. 9 Posted by greg-2012 on 21 Dec, 2016 11:31 PM

    greg-2012's Avatar

    This comment was split into a new private discussion: Quotes and Exchange rates

    Same problem here -- well kinda. Just recently my quotes went wild too. The amounts seem in my case to be a fraction of the proper price (about 60% -- so exchange rate was my immediate suspicious too).

    I also just updated to 2017, but can't confirm that problem was concurrent. It seems likely, however.

    I will post some screenshots. (Are screenshots private? Or do I need to obfuscate?)

  10. 10 Posted by greg-2012 on 22 Dec, 2016 01:09 AM

    greg-2012's Avatar

    Screenshot showing 'history' with correct prices, but current account value is wrong. (About $60 correct -- $34 is not correct).

    The base currency for this instance is CAD -- this account is USD.

  11. Support Staff 11 Posted by Tom Freeman on 23 Dec, 2016 10:15 PM

    Tom Freeman's Avatar

    @Clease

    Are you syncing MD between multiple devise or saving your data file in dropbox or another 3rd party storage service?

    Tom Freeman
    Infinite Kind Support

  12. 12 Posted by Claes on 24 Dec, 2016 09:32 AM

    Claes's Avatar

    No, I am not syncing between devices. I have MD only on my local PC running latest version of Windows 10.

     

    Claes

  13. 13 Posted by Claes on 31 Dec, 2016 10:06 AM

    Claes's Avatar

    There seem to be an inconsistency in the way MD translates secondary currencies into the base currency. I have noticed that some of my entries in SEK (my base currency is EUR) are wrongly translated into EUR by using the inverse exchange rate, e.g. SEK/EUR instead of EUR/SEK. I have not yet found any systematic trend that can help pinpoint the origin of the problem.

    Claes

  14. System closed this discussion on 01 Apr, 2017 10:10 AM.

Comments are currently closed for this discussion. You can start a new one.

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