Securites Not Updating

Emilie's Avatar

Emilie

10 May, 2018 11:51 PM

Hello, I have added the Quotes and Exchange Rates extension and have followed the steps outlined. I've added a few securities (double checked that the symbol is correct) and when I click Test, I'm always getting a red X with No Data Found.
Most of the exchange rates seem to be updating without an issue, but the securities aren't working.
Have I done something wrong or is this feature not available anymore?
Thank You

  1. 1 Posted by sth on 11 May, 2018 03:54 AM

    sth's Avatar

    Do you have a recent version of MD (i.e. 2017.6 or later?)
    Do you have an Alphavantage key?

    Look in Help->Console Log for the downloading of the security prices it may help narrow down the problem?

    It always helps to try to debug these by getting the MD version and the OS and version.

  2. 2 Posted by derekkent23 on 11 May, 2018 06:50 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    Alpha Vantage does not support every type of securities. So can you provide say three symbols along with the names of the securities so they can be checked. This will help to pin down the problem to either Alpha Vantage or your setup.

  3. 3 Posted by Emilie on 11 May, 2018 04:52 PM

    Emilie's Avatar

    Hello sth,
    Yes, I have version 2017.7.1.
    Yes, I have the Alphavantage key and have it entered in the extension.
    And I'm using a Mac with OS 10.13.2.
    Thanks!

    derekkent23,
    Ok, thanks. Here are three examples that I am using.
    AX.UN ARTIS REIT
    RNW TRANSALTA RENEWABLES INC
    VFV VANGUARD S&P 500 INDEX ETF UN

  4. 4 Posted by derekkent23 on 11 May, 2018 06:22 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Hi Emilie

    Can you confirm the build of the Q & ER extension is v1015?

    For all three of your securities you need to select “Toronto Stock Exchange”

    Alpha Vantage supports, AX-UN and RNW as well as VFV all be it at the time of test VFV quote was dated 5/10/2018

    If you continue to have problems try an alternative free stand-alone program to obtain quotes and exchange rates and import them into Moneydance. See post 122 to download a PDF, how to, with links to download the program at http://help.infinitekind.com/discussions/investments/3036-third-par...

    I entered your 3 example symbols into the program and it returned up to day quotes including for VFV, see screen shot.

    Hope this helps

  5. 5 Posted by sth on 11 May, 2018 07:42 PM

    sth's Avatar

    Emile,
    I looked up those symbols but according to Yahoo they are all on the Toronto exchange. You will have to add the exchange to the symbol
    AX-UN.TO
    RNW.TO
    VFV.TO

    Will all work.
    -Scott

  6. 6 Posted by Emilie on 11 May, 2018 07:52 PM

    Emilie's Avatar

    Awesome! Adding the TO beside the symbol worked perfectly. Thank you both very much!

  7. System closed this discussion on 10 Aug, 2018 08:00 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