Quotes and Exchange Rates Loader has stopped working for Australian Securities Exchange

Rich W's Avatar

Rich W

23 May, 2020 06:18 PM

Hi I have set up my stock investments in MD which include mostly UK and one Australian Securities Exchange ASX stock for Commonwealth Bank of Australia (CBA). I set up Quotes and Exchange Rates linked to aplhavantage API as described and all was working perfectly until the 8th May when just the CBA Stock History prices have stopped updating. All other Stock prices and Exchange Rates including the Australia Dollar to GBP Rates are all updating fine - I now get a message "Unable to get Rate from to AUD".

Does Anyone have any ideas what I could try to get this working - I eventually resorted to Quote Loader to get a latest quote which did work when I added Yahoo/FT as the Load point, but it has no History which I would like, which is a drawback I am trying to resolve using the Quotes and Exchange Rates extension and it was working perfectly up to the 8th May as I say. Ive tried multiple combinations of CBA:ASX , CBA , ASX: CBA, CBA AX dependent on whether I think it may be reading from Google Finance or Yahoo Finance and nothing seems to work.

All advice would be appreciated.

  1. 1 Posted by derekkent23 on 23 May, 2020 07:34 PM

    derekkent23's Avatar

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

    I use Quote Loader to obtain quote but did a search to see if Commonwealth Bank of Australia was supported by Alpha Vantage. The following was the only match I could find from Alpha Vantage.
               “1. symbol: "CBAUF",
                "2. name": "Commonwealth Bank of Australia",
                "3. type": "Equity",
                "4. region": "United States",
                "5. marketOpen": "09:30",
                "6. marketClose": "16:00",
                "7. timezone": "UTC-05",
                "8. currency": "USD",

    However its not what you are looking for. Perhaps they have stopped supporting that security quoted on the Australian stock exchange.

    If Alpha Vantage was working, what symbol did you originally use? Was it just CBA on the Australian stock exchange?

  2. 2 Posted by dwg on 23 May, 2020 09:29 PM

    dwg's Avatar

    I would tend to suspect a problem with AlphaVantage.

    If AlphaVanaage stopped supporting CBA they might as well stop supporting the whole ASX. CBA is a major bank and one of the top listed companies on the exchange.

    I tested Westpac, Wesfarmers and Telstra as well and no price was returned for these either, and those are 4 stocks in the top 20 on the exchange.

  3. 3 Posted by Rich W on 24 May, 2020 01:16 PM

    Rich W's Avatar

    Hi derek
    Yes I use CBA.

    So what is the conclusion guys - is there a way to contact AlphaVantage to ask them as I am not a premium user so I doubt they will respond to me.

    How do you recommend we proceed?

  4. 4 Posted by derekkent23 on 24 May, 2020 01:30 PM

    derekkent23's Avatar

    Hi Rick

    If CBA was supported by Alpha Vantage then they have either dropped support for that security or it’s a temporary problem that only they can fix.

    Unless support is resumed then you should use Quote Loader at the end of each trading day if you want to build a complete price history going forward.

    Have Fun, stay safe.

  5. 5 Posted by Rich W on 24 May, 2020 08:27 PM

    Rich W's Avatar

    Sadly I am not at my PC every day to do that but I get the jist of what you are saying. Basically there is nothing I can do so I have to use the Quotes Loader as the only below par option. I may as well just use google and add them in myself.
    Not your fault I know but will continue to hope that AlphaVantage pull their finger out.
    Let’s hope someone comes up with something better or I will continue as we say I’ll have to.

  6. 6 Posted by dwg on 24 May, 2020 09:25 PM

    dwg's Avatar

    People from these forums have tried to contact AlphaVantage in the past, from responses I have seen they appear to be unresponsive.

    I would not call Quote Loader a "below par" option I think that is doing the extension a disservice. It is interacting with the websites data stream so it is only able to pull the current price, it also means it does not require anything special from the site, apart from a usable stream, which is not always the case. Q&ER is downloading a time series file which is much more uncommon with the free services.

  7. 7 Posted by derekkent23 on 24 May, 2020 09:48 PM

    derekkent23's Avatar

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

    Some user who cannot do a manual Quote Loader run, set up auto run, Quote Loader window closed, Moneydance running and just leave their computer on. Only solution I can see at the moment.

  8. 8 Posted by Rich W on 25 May, 2020 12:21 PM

    Rich W's Avatar

    Hi dwg
    I apologise that was a poor choice of words. I should say it is not the solution I am looking for.

    Hi Derek
    Thanks for your suggestion- I’ll look to see if I can work out how to do that.

  9. 9 Posted by derekkent23 on 25 May, 2020 01:21 PM

    derekkent23's Avatar

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

    For information see post 29 at

    Download the PDF attached to posts 29 and have a read from page 7.

    Auto Update is also covered at the end of the Full Video, YouTube link on page 2 of the PDF.

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

    Hope this helps.

  10. 10 Posted by Rich W on 25 May, 2020 05:05 PM

    Rich W's Avatar

    Thanks Derek. I’ll look at it over the next few days

  11. 11 Posted by faye.connors on 28 May, 2020 06:55 AM

    faye.connors's Avatar

    Hi Rich, All my stocks are on ASX, & yes Alphadvantage has stopped working for all ASX. If you only have 1 stock on ASX you can use yahoo (one security at a time) to download historical prices for a date range then upload via Securities Detail/history button/import/ import from file/.
    I recently did my entire portfolio one by one the other day.!!

    Hopefully, Moneydance folks sort it out.

  12. 12 Posted by Rich W on 28 May, 2020 07:57 PM

    Rich W's Avatar

    Thanks Faye. I will research this option at the weekend. Hopefully at some point AlphaVantage may fix it. As was previously suggested no one from AlphaVantage has responded to my request for support.

  13. 13 Posted by DIB on 06 Jun, 2020 06:42 AM

    DIB's Avatar

    I was also affected by AlphaVantage ceasing to provide quotes from the ASX so I installed Mike Bray's Quote Loader and it works a treat. Thanks Mike.

  14. 14 Posted by Rich W on 15 Jul, 2020 03:31 PM

    Rich W's Avatar

    Hi I am now using Quoteloader and running the autorun at startup of Moneydance. It works and loads the current price each day I run it. I have set the source to FT and it looks right with the prices.

  15. 15 Posted by derekkent23 on 15 Jul, 2020 03:48 PM

    derekkent23's Avatar

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

    In case you are not aware a new feature was added in Quote Loader since your original post in this discussion so the current build can now be set to retrieve historical prices, no need to run Quote Loader every day.

    See release notes for build 3026 post 63 at https://infinitekind.tenderapp.com/discussions/investments/4914-the...

    and more importantly download the attached PDF to how the new feature works.

    Hope this helps.

  16. 16 Posted by Rich W on 15 Jul, 2020 04:03 PM

    Rich W's Avatar

    Hi Derek
    No I wasn’t aware of this option. How do I arrange that to happen please as I can’t see an option?
    How do I download this new version?

  17. 17 Posted by Rich W on 15 Jul, 2020 04:10 PM

    Rich W's Avatar

    Hi Derek
    Sorry it’s the retrieve missed prices option. I found it - I was using FT not FT HD hence why it wasn’t working. Testing it now.

  18. 18 Posted by Rich W on 15 Jul, 2020 04:32 PM

    Rich W's Avatar

    OK so I tried with Centrica - A UK based company. I removed all prices back to the 19th June, set the Quote Loader to FT HD and restarted Moneydance - it errors "Errors Found on Automatic Run.. (See Screen shots). - Theres a star after the price as well ?

    I then changed it to yahoo HD and the Historical prices load but are wrong - in the FT its around 0.41 ish, in Yahoo its 25.26 ish (definitely wrong but I don't know why)

    Should I create a new thread for this type of question do you think?

  19. 19 Posted by derekkent23 on 15 Jul, 2020 05:08 PM

    derekkent23's Avatar

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

    Quote Loader is working as you would expect.

    As explained in the PDF the source FT HD does not support historical data for Equities, only ETFs, nor does it support Exchange Rates.

    However, Yahoo HD does support all three.

    Also as explained in the PDF Ticker Symbols are unique within an exchange, but are not unique across all exchanges. CNA is the ticker for CNA Financial Corporation traded in the US in US Dollars hence the price you were getting. You need to tell Yahoo that the security you are interested in is traded on the London Stock Exchange.

    See screen shot were for the Ticker CNA the Exch Mod has been set to LSE.

    Hope this helps.

  20. 20 Posted by Rich W on 16 Jul, 2020 08:10 AM

    Rich W's Avatar

    Hi Derek
    You are a super hero. You may only be a "User not Support staff", but you really should work for the company. Your answers are spot on, concise easy to follow and the greatest thing .. they work. Thank you for all your help. Its perfect - exactly what I was hoping for and better still saves me running it every day. I am now uninstalling the other extension Quotes and Exchange Rates as Quotes Loader is perfect for my needs.

    Thanks again Derek.

  21. Rich W closed this discussion on 16 Jul, 2020 08:10 AM.

  22. derekkent23 re-opened this discussion on 16 Jul, 2020 08:21 AM

  23. 21 Posted by derekkent23 on 16 Jul, 2020 08:21 AM

    derekkent23's Avatar

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

    Really glad you have got the hang of Quote Loader and it is now working well for you.

    Have Fun, Stay Safe.

  24. Rich W closed this discussion on 16 Jul, 2020 09:07 AM.

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