Alphavantage not updating all securities

bschottmi's Avatar

bschottmi

23 Feb, 2020 02:05 AM

I'm using the Quotes and Exchange Rates extension and have it configured for Alphavantage. It works for nearly all securities, but not for all. One in particular is ASML Holdings NV (ticker: ASML, ID ^N07059210) When I run a test, it comes back with "Price shown in $" just like the ones that work OK.
Any ideas why this, and a few others, do not update? How to debug or investigate?

  1. 1 Posted by dwg on 23 Feb, 2020 02:16 AM

    dwg's Avatar

    I'm a fellow user.

    I'd suggest opening the console window menu item Help --> Show Console and then run AlphaVantage and see what messages you get.

  2. 2 Posted by derekkent23 on 23 Feb, 2020 08:55 AM

    derekkent23's Avatar

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

    If the Quote and exchange rate updater does not work well for you and you are running Moneydance 2019 try the extension Quote Loader under EXTENSIONS – MANAGE EXTENSION.

    I have tested your ticker symbol ASML and both sources in Quote Loader return an up to date price, see screen shot for the source Yahoo.
    Note: if you select FT as a source you need to select NASDAQ as the exchange under Exch Mod. The reason for this is ASML is traded on a number of exchanges in different currencies.

    For information see post 1 at https://infinitekind.tenderapp.com/discussions/investments/4914-the...

    Download the PDF attached to posts 1 and have a read. To get an overview take a look at the YouTube videos by using the links on page 1 and 2 of the PDF.

    Let us know how you get on or if you need help just post.

    Hope this helps.

  3. 3 Posted by derekkent23 on 23 Feb, 2020 08:56 AM

    derekkent23's Avatar

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

    Attached screen shot

  4. 4 Posted by bschottmi on 23 Feb, 2020 12:02 PM

    bschottmi's Avatar

    Thanks - I did that, but in the console log it says

    updating security: ASML HLDGS NV (ASML)
    alphavantage: getting history for ASML
    opening connection with no proxy:

    Just like all the others.

    Appreciate the idea!
    Bill

  5. 5 Posted by bschottmi on 23 Feb, 2020 12:04 PM

    bschottmi's Avatar

    I am on MD 2019 and saw some posts about Quote Loader, but it sounded like
    there were some securities it did not cover, like ETFs. I guess my next
    step is to remove Quote and Exchange rate Updater and give it a try.
    Thanks for the response!

    Bill

  6. 6 Posted by derekkent23 on 23 Feb, 2020 12:58 PM

    derekkent23's Avatar

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

    I think you will find that Quote Loader has great coverage for ETFs

    Give it a go.

  7. 7 Posted by mbrown305 on 23 Feb, 2020 02:29 PM

    mbrown305's Avatar

    I switched over to Quote Loader a couple of months ago. So far it's been working great without any issues. It's nice to have up to date accurate quotes again.

  8. 8 Posted by dwg on 23 Feb, 2020 08:30 PM

    dwg's Avatar

    I'm a fellow user.

    Coverage for EFTs should be similar as coverage for Shares as they are both traded on Stock Exchanges.

    Coverage of Mutual Funds will generally be spotty since they are not traded on any exchange and therefore there is often not a central source for data on them. Some are internal to a Financial Institution and some are wholesale funds and are thus only able to be purchased by other funds.

  9. 9 Posted by bschottmi on 23 Feb, 2020 10:09 PM

    bschottmi's Avatar

    Quote Loader installed and operational. Will monitor for a week and see
    how it does.
    Thanks!!
    Bill

  10. 10 Posted by derekkent23 on 24 Feb, 2020 07:52 AM

    derekkent23's Avatar

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

    Thanks for the feedback.
    Let us know you get on.

    Have Fun.

  11. 11 Posted by TRudolph on 11 Mar, 2020 08:01 PM

    TRudolph's Avatar

    Hello,

    I am a new user of MD.

    I have been using the Quotes and Exchange Rates Updater (QERU) extension and have noticed that it does not: 1) update all mutual funds and ETFs in the portfolio (which I see can happen with this extension) and 2) quit updating several after 2/21/20 (MFs, ETFs and stocks (e.g. most Fidelity funds in my portfolio and CSCO among others). The latter is puzzling even if the prior has been previously documented.

    Am wanting to try Quote Loader.

    Question: Must one remove QERU before installing Quote Loader?

    Thanks!

  12. 12 Posted by dwg on 11 Mar, 2020 08:09 PM

    dwg's Avatar

    I'm a fellow user.

    It is usually less confusing and removes the possibility of both trying to update prices if you do remove Q & ER. Strictly peaking it is not necessary however provided you set it not to update anything, Some of us that do testing will have both installed but will make sure one or both do not automatically run, but as we are using it with test files it probably does not matter much for us.

  13. 13 Posted by TRudolph on 11 Mar, 2020 08:27 PM

    TRudolph's Avatar

    Thanks. Appreciate the feedback. Will take a cautionary approach. Was thinking (hoping?) in the back of my mind that one may pick up some the other missed and vice-versa.

  14. 14 Posted by TRudolph on 11 Mar, 2020 08:35 PM

    TRudolph's Avatar

    Just switched them out. Have not checked every ticker yet, but it appears from spot checking all previously non-updated quotes that Quote Loader is working fine. Excellent!

  15. 15 Posted by dwg on 11 Mar, 2020 08:44 PM

    dwg's Avatar

    Err I think you had better shelve that thought, that one could get you into trouble.

    The closest you can currently get to doing this is using Quote Loader with its ability to set a quote source on a security by security basis. Overall I expect Quote Loader to offer the better coverage.

    In the long run there are discussions around bringing the two tools together and combining the best of both, but I think that is a ways of at this stage.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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