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

  1. 241 Posted by derekkent23 on 03 Oct, 2019 07:22 AM

    derekkent23's Avatar

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

    Mike Brays "Security Transaction Loader" is a completely different extension from Quote Loader. Its purpose is to Loads miscellaneous transactions for an investment account from a .csv file and can be configured to match the keys in the .csv file with Moneydance transaction types.

    The purpose of the Quote Loader, the subject of this thread, is to obtain security prices and load them into Moneydance.

    Can you explain further what you are trying to accomplish?

  2. 242 Posted by Melissa Aboitiz... on 03 Oct, 2019 07:35 AM

    Melissa Aboitiz Elizalde's Avatar

    Thanks. Yes. I know it is a different extension. I am trying to upload
    my investment transactions from the banks. They only provide csv files.
    I am sorry if I was not clear. I am actually trying to use both extensions

  3. 243 Posted by derekkent23 on 03 Oct, 2019 07:58 AM

    derekkent23's Avatar

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

    OK understood.

    Can you start a new discussion on the subject of the extension "Security Transaction Loader" explaining your issue and I will see if Mike can take a look.

    Hope this helps.

  4. 244 Posted by Mike Bray on 03 Oct, 2019 08:07 AM

    Mike Bray 's Avatar

    Hi Melissa
    As Derek has said and you have worked out the Security Transaction Loader extension is a separate extension. It's purpose is to load transactions to do with dividends, management fees, loyalty bonus etc. It does not load buys and sells. If, as Derek suggests, you raise a query either in this forum or the Extensions forum I can help you further.
    Regards
    Mike

  5. 245 Posted by Melissa elizald... on 03 Oct, 2019 09:16 AM

    Melissa elizalde's Avatar

    Will do

    Melissa Aboitiz Elizalde
    [email blocked]

  6. 246 Posted by Melissa on 09 Oct, 2019 11:28 AM

    Melissa 's Avatar

    Hi

    I am pow trying to update the security prices (the ones that are not available from yahoo or ft). I want to use a csv file. I tried to use the Security Price loader extension. It loads the csv file, but does nothing after that. Attached is my csv file

  7. 247 Posted by derekkent23 on 09 Oct, 2019 02:47 PM

    derekkent23's Avatar

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

    The issue seems to be with the way the CSV file is formatted.
    If you open the file in a Notepad ++ text editor you will see the data for each security instead of being on one line is split into three lines by two LF (line feeds). See screen shots. Note if you open the file in other types of text editor you may not see LF, but you should see each single line split into three.
    As a test I deleted all but the first three securities and edited these to remove the LF’s. see screen shot.
    I set up a test Moneydance data set and using Security Price Loader the edited CSV file imports correctly.
    I will ask Mike if there is a better way forward than having to edit the CSV file to get it into the correct format.

    Hope this helps

  8. 248 Posted by Mike Bray on 09 Oct, 2019 04:12 PM

    Mike Bray 's Avatar

    Hi Melissa
    Derek is correct the extension relies on there being one line per price. It reads a line at a time and tries to process it. I don't know of a quick way to change this.

    Regards
    mike

  9. 249 Posted by James Khalaf on 09 Oct, 2019 04:14 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]

  10. 250 Posted by -Kevin N. on 09 Oct, 2019 09:36 PM

    -Kevin N.'s Avatar

    Hi Melissa,

    I used Excel's 'Text to Columns' feature with your BondPositions_(1).csv file and was able to position each security on a separate line.

    I saved the file as BondPositions_(Edited).csv.

    If you want, give it a try. Be sure to use it on a copy or backup of your data file, just in case.

    -Kevin N. (not a member of MD support)

  11. 251 Posted by derekkent23 on 09 Oct, 2019 09:56 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Kevin, great call.

    Melisa that works!

  12. 252 Posted by James Khalaf on 09 Oct, 2019 09:58 PM

    James Khalaf's Avatar

    Please delete me from this thread.

  13. 253 Posted by derekkent23 on 09 Oct, 2019 10:08 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Hi James, only you can do that by clicking on UNSUBSCRIBE FROM UPDATES from top right of thread at https://infinitekind.tenderapp.com/discussions/investments/4039-quo...

    Hope this helps.

  14. 254 Posted by derekkent23 on 09 Oct, 2019 10:37 PM

    derekkent23's Avatar

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

    After testing Kevin’s method, the obvious occurred to me.

    When the CSV file is open in excel simply delete the “Instrument Description” column, column B and re-save under a new name, then use the Security Price Loader.

    Hope this helps.

  15. 255 Posted by Melissa elizald... on 09 Oct, 2019 11:37 PM

    Melissa elizalde's Avatar

    Thank you. I saved the file as csv on excel. How should I save the file?

    Melissa Aboitiz Elizalde
    [email blocked]

  16. 256 Posted by derekkent23 on 10 Oct, 2019 09:56 AM

    derekkent23's Avatar

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

    Take a look at this video

    Hope it helps

  17. 257 Posted by Melissa elizald... on 11 Oct, 2019 02:32 AM

    Melissa elizalde's Avatar

    Many thanks.

    Melissa Aboitiz Elizalde
    [email blocked]

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