Problem getting stock price quote for investment transactions download from Quicken through .qif

Wayne's Avatar

Wayne

17 Oct, 2020 06:50 PM

I try to import investment transactions from my quicken account by exporting .qif file including the security list. On MoneyDance, I added the Quotes and Exchange Rates extension. When importing the .qif file to MD, MD downloaded stock quotes for the stocks of my security list. When import completed, I see in the MD's Security list, there are two entries created, Take Alibaba stock as an example, see attached files, entry1 (BABA1.png and BABA1Detail.png) has quote up to day. But entry2 (BABA2.png and BABA2Detail.png) contains only quotes that recorded in my Quicken account. The imported transactions uses entry 2. How can I update the transactions to use entry1? More important, how can this security association be done right when importing the transactions to MD? Can we avoid the 2nd entry to be created?

  1. 1 Posted by derekkent23 on 18 Oct, 2020 08:49 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Wayne

    The issue results from the data in the QIF file.

    Moneydance see the two Alibaba stocks as different securities.
    It looks like the ticker symbol in the QIF file are different. One being correct (BABA1Detail.png) as BABA the other incorrect (BABA2Detail.png) as ALIBABA GROUP HLDG LTD. The other data in the QIF file that populates these EDIT SECURITY window should also be the same.
    Moneydance can’t return prices for a ticker symbol ALIBABA GROUP HLDG LTD, it’s not valid.

    Even if you manually edited the ticker symbol in BABA2Detail.png to be correct Moneydance does not like two instances of the same Security to be listed under TOOLS – SECURITIES. Only one of these will be updated using Quotes and Exchange Rates extension or for that matter the better and faster alternative extension Quote Loader.

    You need to fix the source of the QIF file or edit the incorrect security then merge the two securities into one. There is a process that can do this but dependant on the number of transactions involved with these securities can be labour intensive.

    If you are not importing a QIF file as a one-time process but hope to regularly import a QIF file then you need to fix the file.

    Hope this helps.

  2. 2 Posted by Wayne on 09 Nov, 2020 02:01 AM

    Wayne's Avatar

    Hi, Derek,
    Thank you for the information!

    I finally figured it out: The problem was caused by the way I import data from quicken. I creates multiple quicken export one per quicken account. Importing the first account to MD is fine. But for other accounts, MD is not to associate the securities that has been imported by the earlier imports.

    The way that works is to create only one Quicken export file with all the account, then all the data are imported to MD successfully.

    Weian

  3. 3 Posted by derekkent23 on 09 Nov, 2020 08:30 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Wayne

    Glad you got it sorted.

    Have Fun, Stay Safe.

  4. Melissa closed this discussion on 25 Nov, 2020 08:50 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