Updating investment account register with unit details and obtaining subsequent price updates

Alan Charles's Avatar

Alan Charles

14 Dec, 2019 04:17 PM

I am a new user having just purchased the Moneydance software. Within the investment account I have created I can see that all five of the new securities I have created are listed. In order to input the unit information, your notes state to go to the "securities detail" tab and then click "add security". When I do so, no securities are listed in the drop down option box. I am also unclear what I need to enter in the register. I have set up the quotes and exchange rates update and have obtained my API key. Having chosen "advanced" and tested the update, nothing seems to have happened. For whatever reason, the securities I have created are not listed. I have, of course, ensured that "alphavantage" have been chosen in the drop down menu for exchange rates and prices information. I have used Yahoo! Finance UK for the ticker reference for each of the five securities. Finally, each security has a security ID. What am I required to enter in this field? Many thanks.

  1. 1 Posted by derekkent23 on 15 Dec, 2019 09:10 AM

    derekkent23's Avatar

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

    Before trying to sort out your issue, an outline of the process is:

    1. Set up an investment account under ACCOUNT – NEW ACCOUNT - INVESTMENT - NEXT.
    2. Set up securities under TOOLS – SECURITIES – “+”
    3. Add securities to the investment account. Click on Summary in the side bar, list on left, then your investment account name. If this is the first security to be added to the investment account you usually get the message “No security are associated with this account. Would you like to add one now?” if you click YES you should get the ACCOUNT INFO screen which lets you select and add the first security to the investment account.
    4. If this does not happen or you are past this stage click on Security Detail tab in your investment account.
    5. Click ADD SECURITY and you should see the Account Info screen with a security dropdown, see screen shot. Dropdown clicked in screen shot.

    I understand this is the step you are having problems with?

    1. Once you have got past the issue of adding securities to the investment account click on the dropdown in the Security Detail window to confirm the securities are now in the investment account, see screen shot.
    2. Click on the REGISTER tab, then NEW TRANSACTION button to start a Buy or BuyXfr transaction.

    As a first step in sorting things out can you post a screen shot of one of your securities under TOOLS – SECURITIES and double click on one of them then EDIT to give Edit Security windows, see screen shot. I use the security name as the Security ID as you can see in the screen shot.

    It sounds like you are in the UK, as am I.

    The quotes and exchange rates update does not really support UK funds or funds outside the US.

    Fortunately, there is the free third-party Quote Loader. Both of the sources in the Quote Loader (Yahoo and FT) have good coverage of worldwide securities including the UK.

    See post 205 at https://infinitekind.tenderapp.com/discussions/investments/4039-quo...

    Download the PDF attached to posts 205 and have a read.

    To get an overview take a look at the YouTube video by using the link on page 1 of the PDF.

    Hope this helps.

  2. 2 Posted by Alan Charles on 15 Dec, 2019 12:15 PM

    Alan Charles's Avatar

    Hi Derek

    Many thanks for your very helpful response; it is really appreciated!

    I have been able to add all five securities to the investment account and have ensured that the correct security ticker symbol has been inserted (in all five cases this is the ISIN). I have also taken your advice and installed the Quote Loader, having firstly uninstalled the quotes and exchange rates updater extension.

    However, I'm still stuck on two things. Firstly, the securities I have added to the investment account do not appear in the quote loader tool. Is this because I have described them as mutual funds instead of stocks? I can't see any other reason why they are not listed. The currency updater is working fine and I've selected daily updates. Secondly, with regard to entering a transaction in the register, I am not able to select the relevant security or input the number of units. The only input field available to me is for a monetary amount. All I really wish to do is input the current number of units and manually update them from time to time (i.e. I don't intend to input each and every transaction).

    I hope you can help. It takes some getting use to but I'm sure it'll be worth it in the end! Thanks again.

    P.S. Yes, I am in the UK.

  3. 3 Posted by derekkent23 on 15 Dec, 2019 01:51 PM

    derekkent23's Avatar

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

    Quote Loader. Securities will not normally appear in the Quote Loader window if you have not performed a Buy or BuyXfr transaction in the investment account register on these securities, see screen shot of investment register. You may have noticed an INCLUDE ZERO ACCOUNT tick box. If this is ticked securities that are not held in an investment account will be included.

    Almost all of my securities are mutual funds and are described as such and have an ISIN ticker symbol. See example Royal London FT350 Tracker Fd Class Z Inc, ticker GB00B523R000 in on of the screen shots in my earlier post.
    If you post some of your ticker symbols, I can test to confirm they are supported by Quote Loader.

    All your issues stem from the fact you have not yet done a Buy or BuyXfr transaction in Investment Account Register tab.

    A Buy is when the money for the purchase comes from a cash account of the investment account. Money is transferred from the Investment Account Bank Register tab. You can fund this account by transferring money from a normal bank account.

    A BuyXfr is where the money is transferred direct from another normal bank account to fund the buy.

    I don’t fully track all my transaction details, dividends etc, so I set up fictious Bank account “Fix Investments” as a work around. And use BuyXfr.

    When you are trying to purchase securities are you using the Investment Account the Register tab or the Bank Register tab, it should be the Register tab as my screen shot.

    If you are still having problem can you post a screen shots equivalent to my 3 in the earlier post.

    Hope this help

  4. 4 Posted by Alan Charles on 15 Dec, 2019 02:08 PM

    Alan Charles's Avatar

    Hi Derek

    I'm pleased to say that I have resolved my queries. The issue I was having with the register was that I was using the default of "Xfr" instead of "BuyXfr". As soon as I realised that, the rest fell into place. Price updates are coming through fine.

    Thanks again for help and have a great Christmas!!


  5. 5 Posted by Alan Charles on 15 Dec, 2019 02:10 PM

    Alan Charles's Avatar

    Hi Derek

    Just read your latest post which crossed with my own!

    Really, really helpful. Thank you so much!

  6. 6 Posted by derekkent23 on 15 Dec, 2019 02:19 PM

    derekkent23's Avatar

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

    Glad I was able to help and that Quote Loader is now working for you.

    Have Fun.

  7. System closed this discussion on 15 Mar, 2020 02:20 PM.

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

Keyboard shortcuts


? 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