The new Quote Loader
TIK has improved the security on the use of unsigned extensions. This is in build 1899 which is still in preview mode. Once it is released for general use you will see a warning message on the summary screen if you are using unverified extensions. This included all of my extensions. I have worked with TIK to get my extensions verified which includes Quote Loader. These are now available on my repository in https://bitbucket.org/mikerb/moneydance-2019/downloads/.
To verify an extension I have had to make my source code available to TIK. The author of the back end of Quote Loader (hleofxquotes) was not prepared to do this and thus I have redesigned Quote Loader to be standalone. I would like to thank hleofxquotes for his work and help in making Quote Loader an extension of choice.
I have asked TIK to add Quote Loader to the list of available extensions. This is being considered.
DerekKent23 has written/updated a PDF on how to install and set up Quote Loader. This is accompanied by a couple of videos. These assume Quote Loader has been added to the list of available extensions. Before that list is updated please download the file securityquoteload.mxt from my repository (https://bitbucket.org/mikerb/moneydance-2019/downloads/) and add it using the MD Extensions/Manage Extensions/Add from File. The updated PDF will be available shortly.
IT IS IMPORTANT THAT YOU FOLLOW THE INSTRUCTIONS ON MY WIKI (https://bitbucket.org/mikerb/moneydance-2019/wiki/Home) ABOUT UPGRADING FROM THE OLD VERSION OF QUOTE LOADER. YOU NEED TO REMOVE THE RHUMBA EXTENSION.
Showing page 13 out of 13. View the first page
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
361 Posted by derekkent23 on 21 Apr, 2024 07:10 AM
I am not support staff, just a user.
Hi Moneydanceuser4...
Glad you got it sorted.
Have Fun, Stay Safe
362 Posted by becker6146 on 26 Apr, 2024 01:48 PM
I just updated Quote Loader to version 3209, and it worked great with the "Yahoo" source. Thank you very much to everyone involved for getting this fix out so quickly.
363 Posted by derekkent23 on 26 Apr, 2024 04:03 PM
I am not support staff, just a user.
Hi becker6146
Thanks for taking the time to tell us QL 3209 is working for you.
Have Fun, Stay Safe.
364 Posted by aforkosh on 26 Apr, 2024 10:02 PM
I am trying to track about 200 securities. The new Quote Loader works fine for me using Yahoo and FT. Unfortunately, it fails using Yahoo HD. The first time I ran it, it quit reporting after 96 quotes from Yahoo HD. When I tried again about 40 minutes late, it failed after 57 quotes.
In a previous version, Mike modified Quote Loader to prevent this from happening for large sets of securities. Would that be possible for the current set? For now, I need to make sure to check daily.
Thanks again for your attention.
365 Posted by aforkosh on 26 Apr, 2024 10:07 PM
Following up on my request, I'm attaching the CSV file of quotes from y latest FT inquiry. This should give you a good list for testing:
366 Posted by Mike Bray (Quot... on 27 Apr, 2024 12:25 PM
@aforkosh I suspect that Yahoo HD is taking longer than before and the timers need tweaking
367 Posted by Mark Hackney on 29 May, 2024 10:17 PM
Well has Yahoo! Finance changed something again? QL 321008 is getting errors trying to retrieve History Data (Yahoo HD). I believe this just started today as I've quotes from yesterday (5/28/24). update: Yahoo works fine but Yahoo HD errors out.
368 Posted by dtd on 29 May, 2024 10:55 PM
Yahoo HD does not work for me (today) either. I'm hopeful its just "down", but given the past couple of months, who knows?
369 Posted by derekkent23 on 30 May, 2024 07:01 AM
I am not support staff, just a user.
Hi Mark
Just tested Quote Loader build 321008 with source Yahoo HD and it now seems OK.
So hopefully only a temporary down by Yahoo.
Have Fun, Stay Safe.
370 Posted by Mark Hackney on 30 May, 2024 12:41 PM
Thanks Derek!! it was a temporary issue with Yahoo! Unfounded panic on my part :)!!!!
371 Posted by Mark Hackney on 13 Jun, 2024 03:04 PM
Mike/Derek - I think Yahoo has done it again. I've about 107-110 securities to download priced (using YAHOO HD btw) and it stopped today (6/13) after about 70. And I just had not noticed so I was trying to fill in history, reason for HD. I'll check with just YAHOO.
YAHOO only loads all the current priced so it's the YAHOO HD that's limiting the load!
372 Posted by dwg on 13 Jun, 2024 10:05 PM
Yahoo have introduced throttling, for starters see
https://infinitekind.tenderapp.com/discussions/investments/7595-quote-loader-version-2#comment_62094982
373 Posted by derekkent23 on 14 Jun, 2024 07:01 AM
I am not support staff just a user.
Hi Mark
The problem you descried using Yahoo HD as a Quote Loader Source is a known issue.
Yahoo has imposed restrictions in that If you try to retrieve above a certain number of prices, in your case it seems to be about 70, they block access. If you are under the limit on your first run, running Quote Loader again dependant on your number of securities can invoke the block. The block remains in effect for some time before they remove it.
The Quote loader PDF attached to post 103 at
https://infinitekind.tenderapp.com/discussions/investments/7595-quo...
provides more information and some help in mitigating the issue. See page 14 section
YAHOO–FAILS TO RETURN SUPPORTED SECURITIES DUE TO RESTRICTIONS
The PDF also contains a link to a video that may also help.
Hope this helps.
374 Posted by Mark Hackney on 14 Jun, 2024 03:54 PM
dwg and derekkent23 - thanks Gents. I'd followed the throttling discussion prior, I just didn't relieve it was also some arbitrary limit Yahoo had put on the number of security requests. It would be nice to have a way in QL to do a certain batch of securities at a time, say 25 per batch and then submit those with some timer delta between batches. I know it would be a hassle for those with hundreds to do, but so is finding, and switching FUNDS accounts to FT and updating the ALT Ticker for any delta.
Happy Flag Day!
375 Posted by derekkent23 on 15 Jun, 2024 07:41 AM
I am not support staff, just a user.
Hi Mark
Remember, setting up an Alt Ticker to move a Fund from Yahoo HD to FT HD is a onetime setup. Not all Funds will require a different ticker for FT.
The Alt Ticker is still there if you switch back to Yahoo HD and then return to FT HD.
It available to users now.
Although setting up batches would also be a onetime set up I have not seen any figures on how long the Yahoo block lasts, so the delta time between batches may or may not turn out to be excessive.
If you are having problems finding alternative tickers for funds using FT HD take a look at post 103 at https://infinitekind.tenderapp.com/discussions/investments/7595-quo...
The PDF provides some help in mitigating the block issue. See page 14 section
YAHOO–FAILS TO RETURN SUPPORTED SECURITIES DUE TO RESTRICTIONS
The PDF also contains a link to a video that may also help.
Have Fun, Stay Safe.
System closed this discussion on 14 Sep, 2024 07:50 AM.