Issues with Quote Loader

timfetner's Avatar

timfetner

06 Mar, 2020 06:36 PM

I have the latest version of Quote Loader running on MD 2019.3 (1880), and over the past week I have noticed that only about half of the securities pricing is updating. The securities that won't update show a new price of "0.0" and are highlighted in red. I know that I can manually enter in the updated pricing, but I have around 150 different active securities so I'd like to avoid the manual process. Thanks.

  1. 1 Posted by bschottmi on 07 Mar, 2020 01:59 AM

    bschottmi's Avatar

    I am having this same problem. I installed Quote Loader on one mac and it worked great. But I had to move to a Macbook due to traveling and now it loads about 2/3rds and stops. Yesterday it was stopping at the M's, today at the L's. And you cannot check a box to select these since they have no price!
    MD Console extract attached.
    Help!

  2. 2 Posted by timfetner on 07 Mar, 2020 03:50 AM

    timfetner's Avatar

    Just ran the Quote Loader this evening and all securities updated. Wondering if there was an issue with Yahoo in providing pricing.

  3. 3 Posted by derekkent23 on 07 Mar, 2020 07:16 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi

    There appears to have been an issue with the Yahoo server, hopefully Yahoo have replaced the rubber band as it seems to be working again.

    During this problem period some users fixed the issue by switching, were possible, to FT as the source, reducing the load on Yahoo.

    Hope this helps

  4. 4 Posted by timfetner on 07 Mar, 2020 07:20 PM

    timfetner's Avatar

    Thanks Derek,

    I did notice that the issues started a day or two after the market went off the rails. I'm guessing Yahoo servers were overwhelmed with manual and electronic requests for securities pricing.

  5. 5 Posted by bschottmi on 07 Mar, 2020 07:31 PM

    bschottmi's Avatar

    Thanks - switching to FT helped a lot, but it skipped MSFT and stopped
    before trying the last 5 securities.
    I'll keep checking on it.
    Note: Just tried it again and changed MSFT and a few others back to Yahoo
    and it worked!

    Bill

  6. 6 Posted by bschottmi on 18 Mar, 2020 12:59 AM

    bschottmi's Avatar

    Quote Loaded is behaving a bit unusual. The Trade date shows 3/17, but the Price date column does not change from 3/13. I wonder if the new prices are being loaded over the 3/13 date. Also it is schedule to run daily at 1900, but the Next run date remains in the past. Why is the Price date not being updated?

  7. 7 Posted by dantdavis on 18 Mar, 2020 06:00 AM

    dantdavis's Avatar

    Yeah, Yahoo might be a problem tonight - can't get any current prices.

  8. 8 Posted by derekkent23 on 18 Mar, 2020 02:31 PM

    derekkent23's Avatar

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

    You can always leave the Quote Loader window open whilst you look into a security price history window, TOOLS – SECURITIES – Subject security to confirm the data entered is as indicated in the Last Price and Price Date column.

    Can you provide some background?
    1. Have you been running Auto Update for some time? Or have you just set it up or made some changes to the settings.
    2. After making changes to the settings did you remember to click the “Reset Auto Run” Button.
    3. When you set up the Next dates were they in the future, not the past, related to the Time of Run setting?
    4. Was the Quote Loader window open at the Time of Run?
    5. In a situation as shown in the screen shot new prices and Trade Date available, if you select the securities to be saved and then click Save Selected Values are the new values entered.

    If you still think there is an Auto Update issue. Under HELP – set Debug to Detailed. Set thing up again, take a screen shoot of your Quote Loader Auto setting, close Moneydance. Just before the Time of Run open Moneydance. Don’t do anything else. Watch the status bar at the bottom of Moneydance to see if data is collected. On completion of the update open Quote Loader and take a screen shot. Close Moneydance and post your comments, screen shots and the errlog.txt file.

    Hope this helps.

  9. 9 Posted by derekkent23 on 18 Mar, 2020 02:34 PM

    derekkent23's Avatar

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

    Not returning prices, prices zero and red, that you know are supported by Yahoo, I think is a different issue than is the subject of bschottmi post, maybe wrong.

    It’s possible in these strange times that the Yahoo’ server is being overwhelmed by requests for prices from many sources and Quote Loader is suffering the consequences. Switch as many of your security, if supported to FT to reduce the load on Yahoo. When using FT you sometimes need to set a Exchange under Exch Mod if the ticker symbol represents different securities on different exchanges. See PDF for more information.

    Hope this helps.

  10. 10 Posted by cdr on 18 Mar, 2020 08:19 PM

    cdr's Avatar

    Has anyone had problems updating prices of the indexes with Quote Loader, i.e. DJI, SP500 & Nasdaq on Yahoo. All my stocks update with no problem but not the indexes? This started about a week or two ago.
    I have been updating these manually.

  11. 11 Posted by derekkent23 on 19 Mar, 2020 11:04 AM

    derekkent23's Avatar

    I am not support staff just a user.
    Hi cdr

    This is in fact an issue with Quote Loader build 3023 not Yahoo.

    I have reported this to Mike Bray the Quote Loader developer and once he returns from his foreign travels, I am sure he will take a look.

    In the mean time you could change the source for obtaining indices from Yahoo to FT, that works. See screen shot.

    Unfortunately Yahoo and FT use different Ticker symbols so you would need to edit them under TOOL – SECURITIES subject indices.

    .Dow Jones Industrial Average from “^DJI” to “DJI:DJI”

    .Nasdaq Composite from “^IXIC” to “COMP:NAS”

    .S & P 500 from ^GSPC to INX:IOM

    As per the PDF “Quote Loader Extension, Moneydance 2019 Handling Cryptocurrencies and Market Indices V3.0” table page 8.

    Hope this helps.

  12. 12 Posted by cdr on 19 Mar, 2020 12:52 PM

    cdr's Avatar

    Thanks Dekek,
    That did the trick, many thanks,
    Dave

  13. 13 Posted by derekkent23 on 19 Mar, 2020 01:01 PM

    derekkent23's Avatar

    I am not support staff just a user.
    Hi Dave

    Glad I was able to help.

    Look for a new build of Quote Loader in the weeks to come.

    Have Fun.

  14. Maddy closed this discussion on 20 Mar, 2020 01:00 PM.

  15. bschottmi re-opened this discussion on 22 Mar, 2020 02:18 PM

  16. 14 Posted by bschottmi on 22 Mar, 2020 02:18 PM

    bschottmi's Avatar

    Thanks! Now that I am home and not using the secondary Mac, I have changed
    so most symbols use FT instead of Yahoo and did the "Reset Auto Run" all
    appears to be working OK. I had a few symbols that did not work using FT
    so I've changed them back to Yahoo and they are working OK.

    Thanks, Derekkent23!!

  17. 15 Posted by derekkent23 on 22 Mar, 2020 02:50 PM

    derekkent23's Avatar

    I am not support staff just a user.
    Hi bschottmi

    Glad I was able to help.

    Have Fun.

  18. Maddy closed this discussion on 23 Mar, 2020 01:16 AM.

  19. derekkent23 re-opened this discussion on 03 Apr, 2020 08:34 AM

  20. 16 Posted by derekkent23 on 03 Apr, 2020 08:34 AM

    derekkent23's Avatar

    I am not support staff just a user.
    Hi cdr

    The issue you found regarding Quote Loader build 3023 not returning indices from Yahoo has now been fixed by Mike Bray in release build 3024.
    Check release notes https://infinitekind.tenderapp.com/discussions/investments/4914-the...

    Have Fun

  21. 17 Posted by bschottmi on 03 Apr, 2020 10:47 AM

    bschottmi's Avatar

    Thanks! Updated this morning

  22. 18 Posted by cdr on 04 Apr, 2020 02:06 PM

    cdr's Avatar

    Thanks Derek.

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