Quote Loader Security/Currency price loader for Moneydance 2019

Mike Bray 's Avatar

Mike Bray

30 Dec, 2018 10:22 AM

The Infinite Kind has recently released a new version of Moneydance for testing/preview. It is called Moneydance 2019 and can be found at https://infinitekind.com/preview. It has a number of changes in particular in the storing of Security Prices. In addition the base version of Java used to run Moneydance has been updated from Java 1.8 to Java 11.

With this in mind I have released a new version of the Quote Loader extension. It can be found at https://bitbucket.org/mikerb/moneydance-2019/downloads/.

IMPORTANT Do not run the old versions of Quote Loader with Moneydance 2019. Do not run the new versions with Moneydance 2017.

You can find information about Quote Loader for Moneydance 2017 in this thread http://help.infinitekind.com/discussions/investments/3771-third-par...

Showing page 8 out of 9. View the first page

  1. 211 Posted by dave.polister on 23 Aug, 2019 09:28 PM

    dave.polister's Avatar

    Just learned about this extension. Loaded it per instructions in the PDF. Looks to be working GREAT Thank you for your hard work.

  2. 212 Posted by derekkent23 on 24 Aug, 2019 06:39 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    Thanks for the feedback.
    Glad Quote Loader is working for you.

    Have Fun.

  3. 213 Posted by James Khalaf on 24 Aug, 2019 08:33 PM

    James Khalaf's Avatar

    Hi Mike-
    How can I find out if the Quoteloader extensions are the latest version?

  4. 214 Posted by derekkent23 on 24 Aug, 2019 09:01 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Post 205 at https://infinitekind.tenderapp.com/discussions/investments/4039-quo... list the current builds that make up Quote Loader. When you run Quote Loader the builds are listed. Compare the two.

    Also, if under EXTENSIONS – MB EXTENSIONS INSTALLER you scroll down to the section covering Quote Loader it will check the build numbers, as listed and if you are out of date then the UPDATE button will be active, clicking it will update the builds.

    Hope this helps.

  5. 215 Posted by ramv on 02 Sep, 2019 05:18 PM

    ramv's Avatar

    Hi - I'm really sorry but this is all very technical and I don't have an MBE extender option in my version 2019 anyway. Is there a simple way to download and manage quotes for us non specialised users ? Thanks a lot

  6. 216 Posted by Jim Richmond on 11 Sep, 2019 12:48 PM

    Jim Richmond's Avatar

    A quick question for Mike Bray.

    I'm working on an extension and I'd like to include your MRBPreferences class, but the header on MRBPreferences.java doesn't say anything about copyright.

    I wanted to double check that it's ok to include a copy of this file in my repository.

    (I'll change strFileName to the name of my extension so there's no conflict)

    Thanks,

    Jim

  7. 217 Posted by James Khalaf on 11 Sep, 2019 01:04 PM

    James Khalaf's Avatar

    Trip Khalaf

    393 Apple Lane
    Lancaster, PA 17601
    USA
    +1 717 330 5590

    Bad Manors
    Sunset Beach
    Wemyss, Long Island
    Bahamas
     +1 242 338 8056

    [email blocked]

  8. 218 Posted by Mike Bray on 11 Sep, 2019 03:33 PM

    Mike Bray 's Avatar

    Jim

    Help yourself, effectively the copyright is:
    `

    /*

    • Copyright (c) 2018, Michael Bray. All rights reserved. *
    • Redistribution and use in source and binary forms, with or without
    • modification, are permitted provided that the following conditions
    • are met: *
    • - Redistributions of source code must retain the above copyright
    • notice, this list of conditions and the following disclaimer. *
    • - Redistributions in binary form must reproduce the above copyright
    • notice, this list of conditions and the following disclaimer in the
    • documentation and/or other materials provided with the distribution. *
    • - The name of the author may not used to endorse or promote products derived
    • from this software without specific prior written permission. *
    • THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
    • IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
    • THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
    • PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
    • CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
    • EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
    • PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
    • PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
    • LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
    • NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
    • SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
    • */ `
  9. 219 Posted by Jim Richmond on 11 Sep, 2019 07:34 PM

    Jim Richmond's Avatar

    Thanks Mike!

    Also thanks a ton for posting your code on bitbucket. It was enormously helpful to see so many real-code examples of the Moneydance API in use as I was trying to understand how to use it.

    Jim

  10. 220 Posted by tlist809 on 19 Sep, 2019 01:34 PM

    tlist809's Avatar

    Quote loader was removed by moneydance when the program went back to demo mode. I tried to reinstall the quote loader after re-registering the program. It runs manually but will not run by itself at the appointed time. I could not get the .jar program to install. I think I missed something on how to do this. Help please.

  11. 221 Posted by tlist809 on 19 Sep, 2019 02:15 PM

    tlist809's Avatar

    ref #220, windows 10, MD 2019.3. second time this happened in 3 months.

  12. 222 Posted by derekkent23 on 19 Sep, 2019 05:00 PM

    derekkent23's Avatar

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

    When you run Quote Loader across the top what are the three build numbers?
    To reinstall Quote Loader did you first install if not already installed MB EXTENSION INSTALLER as outlined in the PDF attached to post 205 at https://infinitekind.tenderapp.com/discussions/investments/4039-quo...

  13. 223 Posted by James Khalaf on 19 Sep, 2019 05:02 PM

    James Khalaf's Avatar

    Trip Khalaf

    393 Apple Lane
    Lancaster, PA 17601
    USA
    +1 717 330 5590

    Bad Manors
    Sunset Beach
    Wemyss, Long Island
    Bahamas
     +1 242 338 8056

    [email blocked]

  14. 224 Posted by tlist809 on 19 Sep, 2019 05:22 PM

    tlist809's Avatar

    When MoneyDance reverted to demo mode, the quote loader and the mb
    extension installer were taken out, so I downloaded the MB extension loader
    (Mike Bray extension loader 1). and imported it and then grabbed the quote
    loader from the MB extension loader.
    Quote loader says, MoneyDance Quote Loader 3016 - Rhumba 1058 -
    hleofxquotes 259.

    Did I skip a step? I could not find the file on my PC to go step by step.

  15. 225 Posted by derekkent23 on 19 Sep, 2019 05:55 PM

    derekkent23's Avatar

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

    As you have the correct Quote Loader builds installed it’s unlikely you missed a step during installation provided you restarted Moneydance when requested.

    The PDF attached to post 205 at https://infinitekind.tenderapp.com/discussions/investments/4039-quote-loader-securitycurrency-price-loader-for-moneydance-2019/page/7#comment_47493595
    Tells you everything you need to how about Quote Loader including the installation process.

    Can you post a screen shot to show the auto update settings, plus confirm that Moneydance is running at the time set for update and if you have the Quote Loader running at that time or not?
    Also, under the Quote Loader HELP button set TURN DEBUG ON/OFF to DETAILED.
    Close and reopen Moneydance. If Quote Loader does not update at set time post the Moneydance errlog.txt file.
    File can be found at C:\Users\user_name\.moneydance\

    Hope this helps.

  16. 226 Posted by tlist809 on 19 Sep, 2019 07:30 PM

    tlist809's Avatar

    [image: image.png]

    here is the screen shot. will try the rest tonight and see if it updates
    automatically. will try and make sure moneydance is up and running and the
    pc has not gone to sleep.

  17. 227 Posted by derekkent23 on 19 Sep, 2019 08:05 PM

    derekkent23's Avatar

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

    Your settings look OK.
    I set up a test using the same setting but 21:00 to suit local time. Auto update of prices was successful. Let us know if it worked for you.

  18. 228 Posted by tlist809 on 20 Sep, 2019 08:56 AM

    tlist809's Avatar

    It seems to work now. Maybe my pc was asleep. Now if MD will stop going to
    demo mode. It did that twice this month. Worked great since May. Will see
    what happens. Thanks for reassuring me.

    Tim.

  19. 229 Posted by dwg on 20 Sep, 2019 09:49 AM

    dwg's Avatar

    I'm a fellow user.

    For a Registered version of Moneydance to go back to demo mode will generally mean that something has happened to the file config.dic. On Windows at least this file is in the .moneydance folder that exists under your home directory

  20. 230 Posted by tlist809 on 20 Sep, 2019 11:34 AM

    tlist809's Avatar

    Thank you

  21. 231 Posted by James Khalaf on 20 Sep, 2019 11:52 AM

    James Khalaf's Avatar

    Trip Khalaf

    393 Apple Lane
    Lancaster, PA 17601
    USA
    +1 717 330 5590

    Bad Manors
    Sunset Beach
    Wemyss, Long Island
    Bahamas
     +1 242 338 8056

    [email blocked]

  22. 232 Posted by Melissa on 01 Oct, 2019 09:25 AM

    Melissa's Avatar

    Hi Mike

    Thank you for the extension. It is a huge help. I was wondering if you could add bond prices. FT or yahoo do not have bond price updates

  23. 233 Posted by derekkent23 on 01 Oct, 2019 09:43 AM

    derekkent23's Avatar

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

    Lets first check the ticker symbol you are using
    Post the ticker symbol along with the full name of the security.
    Provide say 2 or 3 examples.

  24. 234 Posted by Melissa elizald... on 01 Oct, 2019 10:32 AM

    Melissa elizalde's Avatar

    Yes isins correct

    Melissa Aboitiz Elizalde
    [email blocked]

  25. 235 Posted by derekkent23 on 01 Oct, 2019 11:25 AM

    derekkent23's Avatar

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

    If you can post a few example of tickers symbols along with full names of the Bonds I can test.
    Without this information I cant see a way to try and help..

  26. 236 Posted by Melissa elizald... on 01 Oct, 2019 11:45 AM

    Melissa elizalde's Avatar

    Okay will do. Thanks

    Melissa Aboitiz Elizalde
    [email blocked]

  27. 237 Posted by Melissa Aboitiz... on 01 Oct, 2019 11:28 PM

    Melissa Aboitiz Elizalde's Avatar

    INDO ENERGY FINANCE II B.V. 6.375 BOND 2013-24.01.2023 USN44525AA67
    ABJA INVESTMENT CO PTE LTD 4.85 BOND 2014-31.01.2020 XS1092182606
    NWD FINANCE (BVI) LTD 5.75 BOND 2016-PERPETUAL XS1497605805
    CHALCO HONG KONG INVESTMENT COMPANY LTD 4.25 BOND 2016-PERPETUAL
    XS1511610906
    STANDARD CHARTERED PLC 6.5 BOND 2015-PERPETUAL CONV SUBORD USG84228CE61
    PAKUWON PRIMA PTE LTD 5 BOND 2017-14.02.2024 XS1517977093
    WOORI BANK 5.25 BOND 2017-PERPETUAL CONV SUBORD US98105HAF73
    MARBLE II PTE. LTD. 5.3 BOND 2017-20.06.2022 USY57657AA90
    CHINA EVERGRANDE GROUP 7.5 BOND 2017-28.06.2023 XS1627599498
    SOFTBANK GROUP CORP. 6 BOND 2017-PERPETUAL SUBORD XS1642682410
    GREENKO DUTCH B.V. 5.25 BOND 2017-24.07.2024 USN3700LAB10
    VEDANTA RESOURCES PLC 6.125 BOND 2017-09.08.2024 USG9328DAP53
    POSTAL SAVINGS BANK OF CHINA 4.5 BOND 2017-PERPETUAL CONV SUBORD
    XS1684793018
    OVERSEAS CHINESE TOWN (ASIA) HOLDINGS LTD 4.3 BOND
    2017-PERPETUAL XS1692254359

  28. 238 Posted by Melissa elizald... on 02 Oct, 2019 12:28 AM

    Melissa elizalde's Avatar

    Hi. I sent the isins and security names. I also noticed in your load security trans there is no field for quantity

    Melissa Aboitiz Elizalde
    [email blocked]

  29. 239 Posted by derekkent23 on 02 Oct, 2019 07:22 AM

    derekkent23's Avatar

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

    Sorry you are correct, the two sources used by Quote Loader do not provide prices for the type of bonds you have listed. You can still enter the price of securities that are not returned into the Quote Loader after finding them from another source. This provides a convenient way of entering the data into Moneydance.

    If I am understanding your question correctly then Quote Loader returns the price per share. When you Save Selected Values the price in entered into the relevant Security Price History windows. The related Investment account register contains the holding of each security, number of shares, to enable Moneydance to calculate the value of the holdings from these two pieces of information. The value of security holdings is then available in a number of reports and in the Investment Account Portfolio and Security Detail windows.

    Hope this helps.

  30. 240 Posted by Melissa Aboitiz... on 03 Oct, 2019 01:32 AM

    Melissa Aboitiz Elizalde's Avatar

    Thank you. I was wondering if you could incorporate another source (like
    bondevalue for the bonds). Just wishful thinking!!!!

    For the Security Transaction Loader, I cannot seem to get it to work on my
    moneydance. I enter all the parameters, and hit load, but nothing happens.

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