Quote Loader Extension stopped updating unit trust prices

spswiftsteve's Avatar

spswiftsteve

29 Dec, 2020 01:42 AM

I have used the Quote loader extension successfully for a few months with no issues. Now since 21st December the prices are flagged as as error as they do not update. The exchange rates continue to update properly. Does anyone know what may have happened and how I can fix this?

  1. 1 Posted by derekkent23 on 29 Dec, 2020 08:29 AM

    derekkent23's Avatar

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

    Quote Loader is returning fund prices for me so some further investigation is required.

    What version/build of Moneydance are you running, e.g. 2021(3032)
    What is your computer operating system.
    What build of Quote Loader are you running, e.g.3027.
    List a number of Ticker Symbols and there fund names along with the source you are using, FT, FT HD, Yahoo. Yahoo HD and I will test.

  2. 2 Posted by spswiftsteve on 29 Dec, 2020 10:08 AM

    spswiftsteve's Avatar

    Thanks for coming back so soon. The answers are shown next to your questions in red

  3. 3 Posted by Stuart Beesley ... on 29 Dec, 2020 10:17 AM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    (FYI - You can’t email a reply and edit below the line, your edits will get / have been lost. You should reply above the line or click the link and comment in the online form)

  4. 4 Posted by spswiftsteve on 29 Dec, 2020 10:22 AM

    spswiftsteve's Avatar

    What version/build of Moneydance are you running, e.g. 2021(3032) 2021 (2006)
    What is your computer operating system.  Mac Big Sur Version 11.1
    What build of Quote Loader are you running, e.g.3027. 3027
    List a number of Ticker Symbols and there fund names along with the source you are using, FT, FT HD, Yahoo. Yahoo HD and I will test. I have taken a screenshot of the Quote loader - you can see all of the quotes (except the one for the Societe Generale share price, which is updating) are stuck on 21/12/2020. I have never got the funds that have a code starting with HK to load. I guess that these are not supported.



    On 29 Dec 2020, at 16:29, derekkent23 <[email blocked]> wrote:

    // Please reply above this line 
    ================================================== 

    From: derekkent23

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

    Quote Loader is returning fund prices for me so some further investigation is required.

    What version/build of Moneydance are you running, e.g. 2021(3032)
    What is your computer operating system.
    What build of Quote Loader are you running, e.g.3027.
    List a number of Ticker Symbols and there fund names along with the source you are using, FT, FT HD, Yahoo. Yahoo HD and I will test.

    On Mon, Dec 28 at 05:42 PM PST, spswiftsteve wrote:

    I have used the Quote loader extension successfully for a few months with no issues. Now since 21st December the prices are flagged as as error as they do not update. The exchange rates continue to update properly. Does anyone know what may have happened and how I can fix this?

    Having trouble reading this? View this discussion online: Quote Loader Extension stopped updating unit trust prices.

    To unsubscribe and stop receiving emails from https://infinitekind.tenderapp.com, visit this page


  5. 5 Posted by derekkent23 on 29 Dec, 2020 10:57 AM

    derekkent23's Avatar

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

    The screen shot shows a test I ran on a number of your securities returning current prices.
    Tested on Windows 10 Moneydance 2021(3032) Quote Loader 3027.

    First thing to try update Moneydance to 2021(3032) at https://infinitekind.com/preview
    Most people don’t get as far as running Quote Loader on 2021(2006) with Mac Big Sur

    You should also in your computers system Preferences, General section, the option "Prefer tabs [always] when opening documents" should be changed from "always" to never or "in full screen"

    After update report back.

    Hope this helps.

  6. 6 Posted by spswiftsteve on 29 Dec, 2020 02:42 PM

    spswiftsteve's Avatar

    Hello. I have done the update. I also checked and the Preference was already set at in full screen. Unfortunately I got the same result. No prices and just the one individual stock (Societe Generale) and the currencies that updated.

  7. 7 Posted by derekkent23 on 29 Dec, 2020 03:11 PM

    derekkent23's Avatar

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

    OK let’s investigate further.

    With Quote Loader open click Quote Loader HELP – TURN DEBUG ON/OFF selected DETAILED.

    Close then re-open Moneydance and open Quote Loader and click GET PRICES.
    When the run is complete close Moneydance and post the Moneydance errlog.txt file.

    Mac OS, it should be located at one of these locations within your Home folder:
    ~/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/errlog.txt or:
    ~/Library/Application Support/Moneydance/errlog.txt

    If you have any trouble finding your Home Library folder you can open Finder and hold down the option key while selecting the Go menu and the Library folder option should occur or you can open Finder and select Go -> Go to Folder and copy and paste in the following:
    ~/Library

    This should pull up your local Library folder.

    Post the errlog.txt file

  8. 8 Posted by derekkent23 on 29 Dec, 2020 10:58 PM

    derekkent23's Avatar

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

    I think I see what the issue is.
    You have set the Exch Mod to LSE for the Tickers starting with LU
    If you take a look at my post that included the test of some of your Ticker you will see I left Exch Mod blank.
    Try that.

    Hope this helps.

  9. 9 Posted by spswiftsteve on 30 Dec, 2020 01:43 AM

    spswiftsteve's Avatar

    It worked. Thank you so much. It has been a great help. The strange thing is that the LSE EXCH MOD was set like that from the beginning and it did work until 21st December. Any way - as long as it works….

    Could I ask one final question: I have some funds that start with HK in their identifier. They have never loaded and still do not. Is it because there is no price at FT for them? I suspect that they are listed in Hong Kong. I have given four examples.

  10. 10 Posted by derekkent23 on 30 Dec, 2020 09:03 AM

    derekkent23's Avatar

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

    If you read my PDF attached to the Quote Loader release notes at https://infinitekind.tenderapp.com/discussions/investments/4914-the...

    You will note that in the last paragraph on page 6 talks about what you should select for the Exch Mod when the ticker is a ISIN code such as you are using, e.g. LU0053903380

    If you have not read this PDF take a look to ensure you are getting the best out of Quote Loader. By the way the first two characters defines the country code, in the case of LU Luxenberg.

    The only explanation I have on how it worked before is that back in June build 3025 was released correcting a error in that in earlier builds with the source FT selected the London Stock Exchange (LSE) did not add the extension :LSE to the ticker which is sometimes needed for non-ISIN tickers. So for FT selecting LSE before build 3025 would have added a blank extension.

    As for your HK (Hong Kong) tickers as far as I can see they are not supported.

    Hope this helps.

  11. 11 Posted by spswiftsteve on 31 Dec, 2020 02:36 AM

    spswiftsteve's Avatar

    Thanks so much. Problem sorted.

  12. 12 Posted by derekkent23 on 31 Dec, 2020 01:09 PM

    derekkent23's Avatar

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

    Glad I was able to help.

    Have Fun, Stay Safe.

  13. Melissa closed this discussion on 27 Jan, 2021 02:02 AM.

  14. spswiftsteve re-opened this discussion on 06 Feb, 2021 02:00 AM

  15. 13 Posted by spswiftsteve on 06 Feb, 2021 02:00 AM

    spswiftsteve's Avatar

    Hello again. I now seem to have a similar problem but just for one unit trust price (BlackRock European Special Situations fund) It worked perfectly until about a week ago. I have attached a screenshot that shows the issue and one that shows the details that I have entered for it. . Do you have any tips on sorting this out?

    Thank you

  16. 14 Posted by Mike Bray on 06 Feb, 2021 06:52 AM

    Mike Bray 's Avatar

    The ticker you are using does not exist any more there is a ticker for
    this fund but it is LU0154234636:EUR.  This could be because of Brexit,
    but who knows.

  17. 15 Posted by derekkent23 on 06 Feb, 2021 10:03 AM

    derekkent23's Avatar

    I am not support staff, just a user
    Hi spswiftsteve

    It appears that the BlackRock European Special Situations fund A2 is traded in two currencies one being LU0121276677 in US Dollars. For some reason FT seems to have removed this fund from its listing, maybe be it will return, who knows, although it is still quoted on other sites e.g. https://www.fundsquare.net/security/summary?idInstr=6302

    and by Blackrock itself at

    https://www.blackrock.com/sg/en/products/229662/blackrock-european-...

    As Mike Suggests the other currencies it is traded in is Euros using ticket LU0154234636
    The dropdown on the Blackrock site confirms this.

    One option is to change the ticker to LU0154234636 and ensure you also use Quote Loader to download US Dollar/Euro exchange rates so although QL will download in Euros it will convert the returned price to US Dollars before storing the values in the Security History window.

    Suggest you do an EXPORT BACKUP then try this out.
    1. Change ticker symbol from LU0121276677 to LU0154234636
    2. Ensure under TOOLS – CURRENCIES – double click on EURO – EDIT that SHOW ON SUMMARY PAGE is ticked.
    3. Set up QL as screen shot.
    4. Click GET EXCHANGE RATES and save the returned Euro exchange rate.
    5. Click GET PRICES and note the BlackRock fund is returned in Euros (Traded Currency) but converted to US Dollars (New Price).

    As QL is doing a currency conversion it needs an up to date exchange rate before it downloads the Blackrock price see page 5 of PDF 106 at https://infinitekind.tenderapp.com/discussions/investments/4914-the...

    Closing price 5 fed 2021
    QL LU0154234636 price is 55.72 Euros
    Using the returned exchange rate QL converts to a rounded 66.68 US Dollars.
    Comparing this with the Blackrock site for LU0121276677 it gives a price of 66.97 US Dollars, small difference probably due to exchanged rate used. Can you live with that small error? If not you will need to load the price manually into QL.

    Hope this helps.

  18. 16 Posted by spswiftsteve on 06 Feb, 2021 10:41 AM

    spswiftsteve's Avatar

    Thank you very much. I have changed it to the EUR ticker and it seems to produce a result in USD that is close enough.

    Thank you for your help.

  19. 17 Posted by derekkent23 on 06 Feb, 2021 03:57 PM

    derekkent23's Avatar

    I am not support staff, just a user
    Hi spswiftsteve

    Glad we were able to help.

    Have Fun, Stay Safe.

  20. 18 Posted by davidvernonlong on 23 Feb, 2021 09:57 AM

    davidvernonlong's Avatar

    Hi, I have exactly the same problem with version 3027 that my unit trust prices will not load, whereas the old version worked perfectly. So I am going to try the above.
    I noticed spswiftsteve saus he cannot load Hong Kong quotes, but I have always been able to do that, fot example:
    Exchange HKEX
    Ticker 700
    Source FT
    Just the number for the Ticker, no letters

  21. 19 Posted by derekkent23 on 23 Feb, 2021 10:13 AM

    derekkent23's Avatar

    I am not support staff, just a user
    Hi davidvernonlong

    Can you post the name of the security plus its current price so I can take a look.

  22. 20 Posted by derekkent23 on 23 Feb, 2021 10:54 AM

    derekkent23's Avatar

    I am not support staff, just a user
    Hi davidvernonlong

    Also you base currency MD is set to.

  23. 21 Posted by derekkent23 on 23 Feb, 2021 11:08 AM

    derekkent23's Avatar

    I am not support staff, just a user
    Hi davidvernonlong

    A guess.

    Hope it helps

  24. 22 Posted by davidvernonlong on 23 Feb, 2021 01:31 PM

    davidvernonlong's Avatar

    Hi,
    So I changed I changed the source from FT to Yahoo, and in most cases that worked, even though I can see the prices correctly quoted on the FT site itself. The exception is LU0895806098:GBP , Jupiter Global Fund - Jupiter Dynamic Bond Class D GBP Acc HSC, Price (GBP)14.40Today's Change-0.06 / -0.41%.
    This did not work even with Yahoo as the source.
    I have an older version of Quoteloader on another PC which I hardly use (3016). Guess what? When I ran it all the prices downloaded perfectly.
    An example of a fund which on 3027 with FT as a source did not lownload, but with Yahoo as a source did download, and downloaded correctly with 3026 in both cases is Baillie Gifford International Fund B AccumulationGB0005941272:GBX.
    All in this cattegory had a ticker starting with GB00
    I will send you privately a screen shot of the showing the failed downloads on 3027 if you wish

  25. 23 Posted by davidvernonlong on 23 Feb, 2021 01:37 PM

    davidvernonlong's Avatar

    On the Hong Kong security. Yes I agree that works and is correct, as I pointed out in my message trying to help spswiftsteve. I have no problem with Hong Kong securities. The Ticker should be numeric only with no leading or trailing HK

  26. 24 Posted by derekkent23 on 23 Feb, 2021 01:57 PM

    derekkent23's Avatar

    I am not support staff, just a user
    Hi davidvernonlong

    Take a lock at screen shot.

    Hope this helps

  27. 25 Posted by davidvernonlong on 23 Feb, 2021 04:13 PM

    davidvernonlong's Avatar

    Hi
    Yes, that works for you and for me on my old PC that uses the old Quote Load extension. I am only using that PC to check if it works correctly. However on my current PC it no longer works for some securities, whereas it always did in the past. I have compared the settings in your screen shot with my settings, and nothing untoward. The only thing I have done recently is added a new currency- Bitcoin- but I did not change the base currency.
    Maybe I should re-install Quote Loader extension

    Here is a screen shot of Quote Loader with all the reds.

    David

  28. 26 Posted by derekkent23 on 23 Feb, 2021 04:26 PM

    derekkent23's Avatar

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

    On all ISIN Tickers symbols (GB00 &LU) don’t set an Exchange (Exch Mod), set them to blank.
    Also on ticker CNX1 set Exch Mod to blank.

    Hope this helps.

  29. 27 Posted by davidvernonlong on 23 Feb, 2021 04:38 PM

    davidvernonlong's Avatar

    Thanks, it worked. Aplogies if I missed that in one of your previous responses.

  30. 28 Posted by derekkent23 on 23 Feb, 2021 04:54 PM

    derekkent23's Avatar

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

    The build of Quote loader on your old computer must be before 3025.
    Build 3025 add exchange extension “:LSE” to FT Ticker symbols when London Stock Exchange is selected under Exch Mod. Before this build this exchange extension was incorrectly omitted (blank). It just happens it worked against you on build 3027.

    Have Fun, Stay Safe.

  31. Melissa closed this discussion on 23 Feb, 2021 09:40 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