Import Price History

Uffe's Avatar

Uffe

17 Jun, 2016 07:22 PM

I have create a security for Axis Bank GDR. As you can see from the attached picture the security was set up with currency USD as that is the currency it is listed in on the London Stock Exchange. My base currency in Moneydance is DKK, as I am living in Denmark.

On finance.yahoo.com the prices are listed in cents so I had to adjust for that the text file with the prices I want to upload (see text file).

When I then upload the prices via the import function in moneydance it does not upload the prices as USD as one could expect.

The price for today according to the text file is 38,65 but the price history shows a price of 5,8516084. It seems that moneydance has taken the price in the text file and divided all the prices with the exchange rate between USD and DKK.

This is clearly a design flaw. You cannot expect the user to upload all security prices in base currency. That would limit me as a user to only invest in domestic securities. This might work if I would be an American only investing in US securities but as soon as you also have foreign securities this will not work.

Uffe

  1. 1 Posted by Tom Freeman on 04 Jul, 2016 09:15 PM

    Tom Freeman's Avatar

    Sorry for the late reply.

    Is the investment account in DKK as well? I want to pass this on to the developers and i need the full parameters of the account. What I want to suggest to them that price imports not have currency conversions assuming most users would be importing prices in the currency of the security.

    Tom Freeman
    Infinite Kind Support

  2. 2 Posted by Uffe on 05 Jul, 2016 04:22 PM

    Uffe's Avatar

    Hi Tom,

    Yes, the investment account is also in DKK.

    I totally agree, the main rule should be that the importing prices of a security should be in the currency of the security and not the currency of the investment account etc.

    It might be a good think if I as a user could choose if I wanted one thing or the other. I could see the situation where I cannot find the correct price on Yahoo or Google and then I have to take the price from my stockbroker which might only supply the price in the currency of the investment account.

    I hope this helps.

    Uffe

  3. System closed this discussion on 04 Oct, 2016 11:13 PM.

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