Home → Investments →

The new Quote Loader

• Edit

Mike Bray (Quote Loader Author)

01 Feb, 2020 07:22 AM

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 9 out of 9. View the first page

1. 241 Posted by derekkent23 on 11 May, 2022 09:33 PM

   

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

   You can remove QL 3047 and reinstall from EXTENSION – MANAGE EXTENSIONS as the signed version of QL 3047 has been released. Don’t forget to restart Moneydance.

   You can turn off Debug.

   Thanks for the errlog I will take a look.and I am sure Mike will as well.

   Stay Safe, Have Fun.

   • Edit

2. 242 Posted by derekkent23 on 11 May, 2022 09:43 PM

   

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

   Had a quick look at the errlog.txt and there appears to be no evidence that Quote Loader was run (GET PRICES) between opening and closing Moneydance.
   Can you try again with Debug set to Detailed

   • Edit

3. 243 Posted by dstephure on 11 May, 2022 10:52 PM

   

   Hi Derek,

   I have attached a screen shot after running Get Prices and the errlog.txt file generated. Hope this helps.

   • Screen_Shot_2022-05-11_at_4.44.55_PM.png 201 KB
   • errlog.txt 264 KB
   • Edit

4. 244 Posted by derekkent23 on 12 May, 2022 07:40 AM

   

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

   Thanks, that was a valid errlog.txt file. I have altered Mike and sent him a copy of my error.txt file where a price is returned for comparison.

   Mike thinks it may be a few days before I can look at it.

   Have Fun, Stay Safe.

   • Edit

5. 245 Posted by Mike Bray (Quot... on 13 May, 2022 11:07 AM

   

   Hi

   I have not found the reason but Yahoo is returning a zero price, so it does not get updated. Please could you do the following:

   1. Download securityquoteload3048.mxt from https://bitbucket.org/mikerb/moneydance-2019/downloads/
      
   2. Rename it to securityquoteload.mxt
      
   3. Start MD and select Extensions/Manage
      
   4. Remove Quote Loader from the installed extensions
      
   5. Add extension from file and select the file just downloaded, click on OK when it displays a warning
      
   6. Restart MD
      
   7. Select Extensions/Quote Loader
      
   8. CLick on Help
      
   9. Click on Turn Debug On/Off, select "Detailed"
      
   10. Right click on the Source Header in the table, select 'Set All to Do Not Load
       

   11. Select TD-PFL.TO and set the source to Yahoo HD. (Do not click on Save Parameters as this will override your normal settings)

   12. Click on 'Get Prices'

   13. Close QL and then MD

   14. Post the errlog.txt as before

   Thanks, I have put some more debug lines into QL to help me understand what is going on
   Regards
   Mike

   • Edit

6. 246 Posted by dstephure on 13 May, 2022 02:39 PM

   

   Hi Mike,

   The generated errlog.txt file. is attached. Thanks for your detailed instructions to a non computer programmer. :wink:

   Hope this helps.

   David

   • errlog.txt 22.7 KB
   • Edit

7. 247 Posted by dstephure on 13 May, 2022 02:56 PM

   

   Sorry Mike,

   Please disregard Post 246 above where the ticker had been set to TD.PF.L for FT. I forgot to reset the ticker to TD-PFL for YahooHD. I have corrected this and attach the new errlog.txt file. Interestingly enough ... The update worked this time. See attachment #2.

   David

   • errlog.txt 23.3 KB
   • Screen_Shot_2022-05-13_at_8.49.22_AM.png 225 KB
   • Edit

8. 248 Posted by derekkent23 on 13 May, 2022 06:02 PM

   

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

   In your last post it looks like all the other securities are set Source Do not load. Can’t you repeat Mikes steps exactly as you did but with all the other securities source set as you normally would. So instead of only the one price being returned QL is trying to return all your price as it would normally attempt to do.

   • Edit

9. 249 Posted by dstephure on 13 May, 2022 10:22 PM

   

   Hi Derek and Mike,

   Okay, here is the latest attempt using QL3048 with all of my usual securities selected for price updates. This time TD-PFL on the TSX using YahooHD as the data source does not update correctly. See screen shot. I attach the errlog.txt file compiled immediately after completing the Get Prices request. Hope this helps.

   • Screen_Shot_2022-05-13_at_4.11.55_PM.png 242 KB
   • errlog.txt 804 KB
   • Edit

10. 250 Posted by Mike Bray (Quot... on 14 May, 2022 09:51 AM

    

    Hi

    This is an interesting one, if I run QL with ticker TD-PFL.TO it works. If you run it with only that ticker it works. If you run it with all of your other securities it fails. I need to put more trace items in the code to see what is happening. I know it is telling me it has found a price but then it sends 0.00 back to update MD which QL ignores. If you wish to take this off-line can we use Slack (infinitekind-public.slack.com) where you can private message me (@mike B)

    • Edit

11. 251 Posted by Mike Bray (Quot... on 14 May, 2022 01:50 PM

    

    I have recreated the error and am investigating. It returns an empty history price table when it is executed with other securities, when run on its own it works.

    • Edit

12. 252 Posted by dstephure on 14 May, 2022 04:04 PM

    

    Hi Mike & Derek,

    I have made an interesting observation which may or may not help in your sleuthing about the Toronto-Dominion PFD Series 22 share price update problem. When I run Quote Loader 3048 for all of my securities using the settings TD-PFL and Yahoo, the update works correctly for all securities including TD-PFL. See screen shot #1. However, if I change Yahoo to Yahoo HD and repeat the process, the update for TD-PFL fails but still works correctly for my other securities. See Screen Shot #2. The same thing happens using TD.PF.L with FT or FT HD. Hope this helps narrow down the problem.

    The good news is that Quote Loader 3048 updates work correctly with TD-PFL and Yahoo or with TD.PF.L and FT.

    • Screen_Shot_2022-05-14_at_9.49.00_AM.png 234 KB
    • Screen_Shot_2022-05-14_at_9.51.46_AM.png 239 KB
    • Edit

13. 253 Posted by dwg on 14 May, 2022 09:50 PM

    

    I'm a fellow user.

    It is not that unusual for a security to return a price with Yahoo yet fail on Yahoo HD.

    It was noted some years ago that Yahoo do not always maintain the historical data for some securities but will hold the latest price. Why they do this who knows.

    • Edit

14. 254 Posted by derekkent23 on 14 May, 2022 10:10 PM

    

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

    FT HD only supports historical data for Funds, not Stocks, so no surprise TD.PF.L fails to return a price from FT HD.
    On the other hand, Yahoo HD should work even when for some strange reason Toronto-Dominion PFD Series 22 seems to be an exception in that Yahoo HD isn’t actually listing historical data, it just lists one entry in the historical data list, the last trading day. When I first tested, I thought it was just a hiccup on Yahoo’s part and the historical data list would return, but it’s been some time now and there is still only one entry in the historical data table instead of the normal one years’ worth. So there seems nothing to be gained in using Yahoo HD over Yahoo. Still, none of this explains why in some situations why Yahoo HD does not return at least one Price. At one point I thought it may be something to do with the date format used for the one entry as its different from normal, but I ruled that out as Yahoo HD does return a price in some situations. Let’s see what Mike comes up with.

    • Edit

15. 255 Posted by Mike Bray (Quot... on 15 May, 2022 12:06 PM

    

    The actual issue is that TD-PFL only has one entry on historical data,
    the page returned by Yahoo HD is a different structure than if it had 2
    entries.  I need to disect the source from Yahoo HD to work out what is
    happening and how to overcome.
    Mike

    • Edit

16. 256 Posted by Mike Bray (Quot... on 16 May, 2022 12:19 PM

    

    I have investigated and get inconsistent results from Yahoo, some times it works, sometimes it doesn't, so it is unlikely I can correct this. I suggest you change the source to Yahoo. The history only has one entry so it should have a large effect.
    Regards
    Mike

    • Edit

17. 257 Posted by dstephure on 16 May, 2022 03:26 PM

    

    Good morning Derek and Mike.

    The good news is that we found a work around. Thanks to both of you for your work and patience on this.

    David

    • Edit

18. 258 Posted by derekkent23 on 16 May, 2022 05:00 PM

    

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

    Go with what works.

    Have Fun, Stay Safe.

    • Edit

19. 259 Posted by derekkent23 on 15 Jun, 2022 10:40 AM

    

    Third-party Quote Loader Extension, Moneydance 2019 to 2022 ONLY.

    I am not support staff, just a user.

    Quote Loader is a third-party extension that has been reviewed and signed by Infinite Kind (Moneydance).

    For Moneydance 2019 to 2022 latest Quote Loader build is 3048.

    UPDATE

    • Fix issue that prevented Quote Loader from obtaining FT prices in some geographical regions due the change to Java 17 used by resent builds of Moneydance.

    As a signed extension Quote Loader can be found under EXTENSIONS – MANAGE EXTENSIONS.
    Simply click EXTENSIONS – MANAGE EXTENSIONS – AVAILABLE tab, find Quote Loader and click install or update.
    Once installed re-start Moneydance - installation complete.

    For users of Quote Loader builds lower than 3021. REMOVE (uninstall) all Extensions under EXTENSIONS – MB EXTENSION INSTALLER, lastly removing (uninstalling) MB EXTENSION INSTALLER itself by using the REMOVE buttons. The background folder “.rhumba” is redundant, expert user can if they so wish delete the “.rhumba” folder with Moneydance closed. On installing the latest Quote Loader, a new replacement folder “.qlmeta” is created. MB Extension Installer is no longer required to install Quote Loader.

    Quote Loader was developed and is supported by Mike Bray.

    PDF’s and Videos by Derek Kent.

    The system provides an end to end solution, obtaining quotes from a choice of sources and entering them into the relevant Currency/Security History window, all from a single window within Moneydance. The system can obtain Security Prices, Exchange Rates, Market Indices, Cryptocurrency Rates and prices for Cryptocurrency Investments. The system provides quotes from many stock exchanges, US, Canada, UK, Europe and Australia to name but a few. The process of obtaining quotes from the selected source is fast and error free.

    Download the attached PDF, follow the instructions on how to use Quote Loader.
    The PDF also contains links to a Quick Start Video Guide, a Short Tutorial Video and a Full Tutorial Video, all on YouTube.

    The second PDF covers the creation and importing of Cryptocurrencies and Market Indices into Moneydance.

    Please keep this thread to this subject on how to use Quote Loader.
    Please try this approach and if you find it useful please take the time to post comments and outline any problems you may find.
    To receive email notification to updates on this thread, click the SUBSCRIBE button in the box at the top right of the forum page.

    Hope this helps.

    • Quote_Loader_Extension_by_Mike_Bray_Moneydance_2019_to_2022_V9.7.pdf 1.5 MB
    • Quote_Loader_Extension_Moneydance_2019_to_2022_Handling_Cryptocurrencies_and_Market_Indices___Futures__V4.4.pdf 1.13 MB
    • Edit

20. System closed this discussion on 14 Sep, 2022 10:40 AM.