security price download for some funds

lists5040's Avatar

lists5040

16 Jan, 2022 09:06 PM

I used MD until 2 years ago; I am now returning as I don't like what I switched to. I have spent many hours bringing MD up to date, but am having a problem with getting some of the security prices. I have been using Quote Loader, which works for most of the stocks and some of the Funds. However, there are some funds which either wont update, or are inconsistent as to the price. For instance, one fund - NOAZX - gives the correct price on the Security History page, but not on the security detail page from the portfolio and in the portfolio view. The Quote Loader usually loads the fund with the price of a dollar. I have the same problem with several other funds. I have searched how they are named, checked their symbols, tried both FT and Yahoo, all to no avail. I would like the investment total to be accurate for my funds. (I am using Big Sur on a Mac - with MD 2022.2 (4060). )

  1. 1 Posted by derekkent23 on 16 Jan, 2022 10:09 PM

    derekkent23's Avatar

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

    My first thought is the Ticker symbol NOAZX has been used in one or more duplicated securities under TOOL – SECURITIES

    First check that NORTHERN ARIZONA TAX EXEMPT is not listed more than one under TOOLS – SECURITIES.

    Moneydance does not like ticker symbols to be duplicated and Quote Loader will only return prices for one instance of a given ticker symbol.

    The fact that the Currency/Security History window in your screen shot is correctly populated with prices yet an instance of the security in the Security Detail window has the wrong price strongly suggest this security is a duplicate.

    One way to users fall into this trap is when they set up the same security to use in different Investment Accounts.

    Anyway, check to see if securities have been duplicated.

    Hope this helps.

  2. 2 Posted by lists5040 on 17 Jan, 2022 02:34 AM

    lists5040's Avatar

    Thank you for your reply.

    Almost all of my securities are duplicated - some more than 2 instances. I have tried deleting some of them but was told I couldn’t (even after deleting one transaction that it had) because the currency was in use. I can see in some of them the correct transaction but don’t know how to connect that with the quote loader to have that symbol be the one used. In other cases, the symbol in quote loader is not the symbol that is in the security when I call up the security. In one case, the ticker symbol is AZML. but that doesn’t connect with the actual security which is ASML holdings ... I don’t know how to change them to agree.

    One last thing, I can’t pull up a price for SPY. Quote loader says the price is always under 1 dollar.

    Nancy

  3. 3 Posted by derekkent23 on 17 Jan, 2022 10:08 AM

    derekkent23's Avatar

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

    If my guess is wrong for the following two securities can you post there related full name plus a price so I can trace them.

    I don’t know if it is a typing error but for ASML holdings whose ticker is ASML you have typed AZML in your post. For that security under TOOLS -SECURITIES - ASML holdings – EDIT change the Ticker to ASML. Ticker symbols are unique within an exchange, but are not unique across all exchanges. See Quote Loader PDF page 6 FINDING AND USING THE CORRECT SECURITY TICKER SYMBOL attached to post 202 at https://infinitekind.tenderapp.com/discussions/investments/4914-the...
    ASML holdings requires the Exch Mod NASDAQ GLO, See screen shot.
    Ticker SPA. Could it be SPDR S&P 500 ETF if so try the source Yahoo, see screen shot. FT supports the same security but under the ticker SPY:PCQ:USD

    Duplicate Securities.
    If you attempt the solutions below do a Moneydance EXPORT BACKUP first.
    I put together the following process which a number have uses have used to fix the issue of duplicate securities.
    In situations where you have a security in two investment accounts, but only one updates when you run Quote Loader, you have set things up incorrectly.

    Under TOOLS – SECURITIES you have set up two instances of the same security, using the same ticker symbol, this is the reason for the problem.

    You should only ever set up one instance of a security with a given ticker symbol under TOOLS – SECURITIES. You can then add this security to more than one investment account using the ADD SECURITY button in the Investment Security Detail window.

    If you have more than two investment accounts and have thus set up more than two versions of the same security the process principle is the same you are working towards having only one version of the subject security in all your accounts resulting in the subject security being listed only once under TOOLS – SECURITIES.
    To correct this situation, proceed as follows:

    First do a FILE (MONEYDANCE on Mac) – EXPORT BACKUP in case you make a mistake.

    You will need to perform this process for each duplicated Security.

    Determine which of the investment accounts has the least transactions related to the subject security

    1. In the investment account SECURITY DETAIL tab use the drop down to select the subject security. Click HISTORY then EDIT and change the name of the Security to CHANGE ME.

    2. Then in the same investment account SECURITY DETAIL tab, click ADD SECURITY and add the subject security to the account.

    3. Now click on the REGISTER tab and select the transactions that contain CHANGE ME in the SECURITY field using the dropdown to select the subject security. You need to do this everywhere a transaction contains CHANGE ME.

    4. Back in the SECURITY DETAIL tab click on REMOVE SECURITY and select CHANGE ME in the dropdown. Then click OK and YES.

    Done, now when you check under TOOLS – SECURITIES there is only one subject security and when you use Quote Loader both investment accounts are updated.

    Another user had the same issue. In his case he had the security “Vanguard Short-Term Bond Index Fund ETF Shares” duplicated under TOOLS – SECURITIES.
    I put together a YouTube video that showed the corrective action I had laid out for him. Take a look it will help you to understand the corrective process. Use this link to go to a YouTube video. https://youtu.be/Mulo9XkklAY

    Hope this helps

  4. 4 Posted by lists5040 on 20 Jan, 2022 03:03 AM

    lists5040's Avatar

    Thank you very much for your detailed replies. I’m sorry that I haven’t answered sooner, but have had no time to sit down and digest what you said.

    Saying AZML instead of ASML was a typo - it was ASML in the ticker symbol. Changing the security exchange did the trick. I had read the Post 202 on using the correct ticker symbol, and tried using SPY:PCQ:USD but it did not result in any prices. Using Yahoo worked (which I thought that I had tried before, to no avail,). Now those two have the correct price downloaded.

    Almost all of my security are listed 2 and 3 times. (Some CD’s and a couple of securities that I no longer own, are listed 10 to 12 times.) This was totally caused by importing my investment accounts from another financial program. I used Moneydance for many years, but 2 years ago, when there was a problem getting accurate security prices, I decided to change to Banktivity. I hated it, and much preferred MD, so I switched back this year. I have spent around 50 to 60 hours trying to accurately bring the last two years’ data over, but none of it went smoothly, as the two different programs use different terminology, some of the deposit transactions carried over as negative ones. etc. I Imported our investment accounts (some with the same security, either presently or in the past), and each import must have added the security automatically.

    I understand what you conveyed in terms of duplicates being in different investment accounts, but that is not (usually) the case here. I watched the you tube video and understand the process if they are in different accounts.

    So the duplicates are almost always in the same account; some of them have no transactions (I deleted them, as I only care about accurate data starting on Jan1), and some had no data at all. I still can’t delete them as I am told that their currency is still in use. Unfortunately, in the case of NOAZX, the one with the least amount of data is the one that is connected with it’s proper investment account and is the one not communicating the security price on quote loader. If I choose the other entry in Tools/Securities, that is the one with the most data, and is the one that updates its price on Auto Loader. Using your suggestion I slightly changed the name of one of the duplicates so I could tell it from the other, and added to the proper investment account. I can now choose either of them in the portfolio view. However the one that doesn’t connect with quote loader had the correct number of shares. The one that connects with Quote loader has 0 shares. How can I reconcile this?

    Thank you so much for taking the time to help me - I appreciate it.

    Nancy

  5. 5 Posted by derekkent23 on 20 Jan, 2022 09:28 AM

    derekkent23's Avatar

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

    It sounds like you have chosen the security you want to keep, lets call it the original, and altered the name of all duplicate securities so they can be identified in the process I outlined in my last post. I now understand that not only have you duplicates in different investment accounts but also in the same account. The principle of the solution I described still holds.

    If when you click REMOVE SECURITY in a SECURITY DETAIL window and have used the dropdown to select the duplicate security you want to remove, click OK, you get the message SECURITY ACCOUNTS THAT ARE REFERENCED BY TRANSACTIONS OR REMINDERS CANNOT BE DELETED, it means what is says. There must be one or more transaction using the duplicate security still listed under the REGISTER tab for the same investment account. The fact that the duplicate security has zero shares does not change this. You need to change the duplicate in the SECURITY field to the one you intend to remain, the original. No transaction must use the duplicate security. Then when you use the process REMOVE SECURITY the duplicate security will be removed from that investment account. However, it will only be removed from under TOOLS – SECURITY when you have used this process to remove the duplicate from all investment accounts.

    Knowing the above see if you can eliminate duplicate securities.

    If you still have problems detail what they are and in doing so use the wording used in Moneydance e.g., in messages, in tab titles etc, so I understand the issue.

    If we can’t resolve this problem using the current approach there is another possible solution. It not as clean but it may be easier to implement and so work better for you.

    Again making a EXTORT BACK before you try things is your friend.

    Hope this helps.

  6. 6 Posted by lists5040 on 24 Jan, 2022 07:17 PM

    lists5040's Avatar

    Hi derekent23,

    Thank you very much for your help. I have removed the duplicate securities for the securities that were not putting a price on the accounts they were in. All the securities that I own are now inserting the correct price in their respective accounts. I have many other duplicates in my security list, many that I don’t own any more. Again, they were imported from another program into MD. I also have CD’s listed in my securities, each listed dozens of times - apparently, when the interest was added each month, they were imported as separate securities.I no longer own the CD’s. Hopefully it will not create problems (other than having a huge long list of securities) in the future if I don’t take the time to go through and change them all to one CD. The same thing happened with importing dividends of stocks - they are listed as a separate security with each dividend. (Most of these I no longer own.)

    I am having several other problems.
    - A problem with one particular security. It is listed in the securities under Tools, and it accurately gets its price from Quote Loader. It was purchased in one Fidelity account and later transferred to another. I cannot list it in the register when I purchased it. It is not in the drop-down list allowing me to chose it. You can see the description “You bought Global X FD ...” in the register, but you can see that it is not in the security list to chose. How can that be?

    Yet here it is in the securities list under Tools:

    A second problem,

    I purchased a number of securities in one Fidelity Account and then transferred them to another. (I decided to separate fixed income funds (bond funds) from my stock funds, so I made a separate account for them.). In the account there they are now, their cost basis is $0, If I put in the actual cost basis (that was actually in a different account), that will obviously mess up the amount of cash in that account, as the cash was not there to purchase them. Is there a way around this problem?

    I really appreciate the time you have taken to help me. I never realized the large number of problems I would encounter in transferring my data from another program into MD.

    Nancy

  7. 7 Posted by derekkent23 on 24 Jan, 2022 08:15 PM

    derekkent23's Avatar

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

    If you still have duplicate securities but hold no share in then I should just forget about them. As far as I know they should create no problems, other than being in the list of securities.

    Problem 1
    If I am reading you correctly when you create a transaction in the Investment account register the security you wish to work with is not in the dropdown list in the SECURITY field? Try going first to the SECURITY DETAIL tab and adding the security to the investment account by clicking ADD SECURITY button and selecting from the dropdown.

    Problem 2
    Not sure fully understand this one. However, you can highlight an investment account, in the Side Bar, list on left and click ACCOUNT – EDIT ACCOUNT and add an INITIAL BALANCE which appears in the BANK REGISTER tab. In a transaction the ACTION Buy uses the cash in the BANK REGISTER for the purchase. This is opposed to BuyXfr which draws cash from a bank type account specified in the TRANSFER field of the transaction.

    Hope this helps.

  8. System closed this discussion on 25 Apr, 2022 08:20 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