Quote Loader v3046 (M Bray) not loading quotes consistently in latest beta builds v4078

Bob B's Avatar

Bob B

06 May, 2022 04:54 PM

I installed MD v4078 and I noticed that Quote Loader(3046) was not loading a significant number of quotes (the number loaded varied but at least 30-50%. I tried beta v4077, v4074 with the same results.

When I reverted to v4073, everything worked again and all quotes were being loaded again.

I reinstalled 4078 and the errors returned. Log files shows dozens of entries similar to :

Quote Load>INFOT:09:51:02-pool-6-thread-4(GetQuoteTask,call) Processing  MAXR URI:https://finance.yahoo.com/quote/MAXR/history?p=MAXR
Quote Load>INFO:09:51:08-pool-6-thread-2(GetQuoteTask,call) error returned 503
Quote Load>INFO:09:51:08-AWT-EventQueue-0(loadPricesWindow,failedQuote) URI errorQuote?tid=6d83ec8d-c9e2-4ed3-b9d6-6878ec5a9f26&s=ALA.TO
Quote Load>INFOT:09:51:08-pool-6-thread-2(GetQuoteTask,call) Processing  MGP URI:https://finance.yahoo.com/quote/MGP/history?p=MGP
Quote Load>INFO:09:51:09-pool-6-thread-3(GetQuoteTask,call) error returned 503
Quote Load>INFO:09:51:09-AWT-EventQueue-0(loadPricesWindow,failedQuote) URI errorQuote?tid=6d83ec8d-c9e2-4ed3-b9d6-6878ec5a9f26&s=BAM
Quote Load>INFOT:09:51:09-pool-6-thread-3(GetQuoteTask,call) Processing  IYR URI:https://finance.yahoo.com/quote/IYR/history?p=IYR
Quote Load>INFO:09:51:13-AWT-EventQueue-0(loadPricesWindow,updatePrices) URI loadPrice?tid=6d83ec8d-c9e2-4ed3-b9d6-6878ec5a9f26&s=L.TO&p=111.94999695&d=2022-05-06T12:50:54&c=CAD&ht=114.06999969482422&lt=111.69999694824219&v=301560
Quote Load>INFOT:09:51:13-pool-6-thread-1(GetQuoteTask,call) Processing  ANRG.TO URI:https://finance.yahoo.com/quote/ANRG.TO/history?p=ANRG.TO
Quote Load>INFO:09:51:16-pool-6-thread-4(GetQuoteTask,call) error returned 503
Quote Load>INFO:09:51:16-AWT-EventQueue-0(loadPricesWindow,failedQuote) URI errorQuote?tid=6d83ec8d-c9e2-4ed3-b9d6-6878ec5a9f26&s=MAXR
Quote Load>INFOT:09:51:16-pool-6-thread-4(GetQuoteTask,call) Processing  PKI.TO URI:https://finance.yahoo.com/quote/PKI.TO/history?p=PKI.TO
Quote Load>INFO:09:51:21-pool-6-thread-2(GetQuoteTask,call) error returned 503
Quote Load>INFO:09:51:21-AWT-EventQueue-0(loadPricesWindow,failedQuote) URI errorQuote?tid=6d83ec8d-c9e2-4ed3-b9d6-6878ec5a9f26&s=MGP

The errors are mostly with Canadian Traded stock but there are quite a few for US stocks as well.

  1. 1 Posted by derekkent23 on 06 May, 2022 06:27 PM

    derekkent23's Avatar

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

    How many securities do you have?

    Mike Bray the Quote Loader developer has update Quote Loader for another user who reported that some of his 198 securities were not being returned. Build 3047 is awaiting signing by Infinite Kind (Moneydance) but if you want to try it out its available on Mike’s site https://bitbucket.org/mikerb/moneydance-2019/downloads/
    Download securityquoteload3047.mxt. Rename it to securityquoteload.mxt. In Moneydance go to Extensions/Manage Extensions and click on 'Add From File' (bottom left). Click on Yes to the warning, click on Install for the Add Extension. Restart Moneydance. Then try it out and let us know if this works.

    If you still have issue it would help diagnose the issue if you could send a copy of all your securities. This is simple to do as follows:

    The following instruction creates a simple spread sheet which contains all your Security Names and Ticker symbols, nothing else.
    The instruction is based on using Excel, but other spread sheet applications should work as well but some of the instruction may be slightly different.

    Exporting data to excel.
    1. In Moneydance in the Side Bar click on the report “Portfolio”.
    2. Click Edit, Reset, OK and then Copy to Clipboard.
    Import into excel.
    1. Open excel and in the top left-hand cell click paste.
    2. Delete all columns except the columns containing Security Names and Symbols.
    3. Delete all rows that do not contain Symbols, including the row containing the word “Ticker”.
    4. You should now be left with a list of Security Names and their associated Ticker Symbols.
    5. Save file as a CSV file type and compress it to a ZIP file and post.
    I will then create a test Data Set with all your securities and pass it on to Mike.

    Hope this helps.

  2. 2 Posted by Mike Bray (Quot... on 07 May, 2022 06:32 AM

    Mike Bray (Quote Loader Author)'s Avatar

    Hi Bob, error 503 is 'the server is not ready to handle the request'. This looks like a problem with the source rather than MD or Quote Loader. Can you run it again. If it still fails please let me have the excel sheet as indicated by Derek.
    Thanks
    Mike

  3. 3 Posted by Bob B on 07 May, 2022 05:00 PM

    Bob B's Avatar

    On retest, it looks like the MD version number makes no difference. I've attached logs from 4073 and 4078. Both had 21 errors (displayed on the screen on completion of the run).

    Also attached Ticker Symbols and quote load parameters.

  4. 4 Posted by Bob B on 07 May, 2022 05:13 PM

    Bob B's Avatar

    Also downloaded QL 4037 and tested against MD 4078. Only 1 error for a security that previously loaded OK (SLF: TSX)

  5. 5 Posted by derekkent23 on 07 May, 2022 05:51 PM

    derekkent23's Avatar

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

    I was just looking at your csv file, it looks like you have 527 securities.

    That would take some time for me to import into a test data set.

    But if I am reading you last post correctly using QL 4073 only give you one error , Sun Life Financial Inc where you are using the Tinker SLF:TSX . However, in the error log it looks like you are using SLF.T

    Try changing the ticker for Sun Life Financial Inc to just SLF

    Hope this helps

  6. 6 Posted by derekkent23 on 07 May, 2022 06:06 PM

    derekkent23's Avatar

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

    Or if its the Sun Life Financial Inc is traded on the Toronto exchange change to SLF.TO

    Hope this helps

  7. 7 Posted by derekkent23 on 10 May, 2022 08:35 AM

    derekkent23's Avatar

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

    Did you resolve the issue with Sun Life Financial Inc?

  8. 8 Posted by Bob B on 10 May, 2022 04:05 PM

    Bob B's Avatar

    Yes sorry forgot to post. It was my error, I had mistakenly assigned the wrong exchange (Tokyo instead of Toronto). So all is good now with the Quote Loader 4037 release.

  9. Bob B closed this discussion on 10 May, 2022 04:08 PM.

  10. derekkent23 re-opened this discussion on 10 May, 2022 04:30 PM

  11. 9 Posted by derekkent23 on 10 May, 2022 04:30 PM

    derekkent23's Avatar

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

    Great. Thanks for the feed back

    Have Fun, Stay Safe.

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