Home → Investments →

Quote Loader Security/Currency price loader for Moneydance 2019

• Edit

Mike Bray (Quote Loader Author)

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

   

   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?

   • Edit

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

   

   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

   • Edit

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

   

   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.

   • Edit

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

   

   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

   • Edit

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

   

   Will do

   Melissa Aboitiz Elizalde
   [email blocked]

   • Edit

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

   

   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

   • BondPositions_(1).csv 7.35 KB
   • Edit

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

   

   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

   • CSV_with_LF.PNG 27.2 KB
   • CSV_with_LF_removed.PNG 22.1 KB
   • Edit

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

   

   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

   • Edit

9. 249 Posted by James Khalaf on 09 Oct, 2019 04:14 PM

   

   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]

   • Edit

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

    

    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)

    • BondPositions_(Edited).csv 3.35 KB
    • Edit

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

    

    I am not support staff, just a user.

    Kevin, great call.

    Melisa that works!

    • Edit

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

    

    Please delete me from this thread.

    • Edit

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

    

    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.

    • Edit

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

    

    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.

    • Edit

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

    

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

    Melissa Aboitiz Elizalde
    [email blocked]

    • Edit

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

    

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

    Take a look at this video

    Hope it helps

    • Save_Bond_Prices.mp4 12.3 MB
    • Edit

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

    

    Many thanks.

    Melissa Aboitiz Elizalde
    [email blocked]

    • Edit

18. 258 Posted by feffer777 on 21 Oct, 2019 04:12 AM

    

    Browsed the info about Quote Loader. From what I've read, it seems that the system will only import the current day's security prices, but not past (historical) ones. Is that true?

    Since I use MD as a portfolio aggregator and only print out a quarterly report, it has some short-comings for me. Most days I do not open MD, so I would not create meaningful security price graphs. Also I would have to be careful not to miss opening MD on the last day of each quarter. Is there a non-manual way to get Quote Loader to import historical prices despite not opening it daily?

    In the past, I've used the Quotes and Exchange Rates extension with Alphavantage, but this no longer works consistently...many securities are skipped.

    • Edit

19. 259 Posted by Mike Bray (Quot... on 21 Oct, 2019 07:17 AM

    

    Hi

    You are quite right Quote Loader only imports current prices. You can
    import historical prices via my Security History Load extension but you
    will need to create a csv file of the prices. See
    https://bitbucket.org/mikerb/moneydance-2019/wiki/Extensions.

    Regards

    Mike

    • Edit

20. System closed this discussion on 20 Jan, 2020 07:20 AM.

21. Maddy re-opened this discussion on 19 Apr, 2023 09:53 AM

22. System closed this discussion on 19 Apr, 2023 10:00 AM.