Home → Investments →

Security Price/History Loader

• Edit

Mike Bray (Quote Loader Author)

13 May, 2018 11:08 AM

The two extensions above were originally written to help me load prices not available via the Quotes extension, i.e mostly UK prices.

Since the closing down of the Yahoo service my extensions have been used (along with hleofxquotes) as a replacement and I have made a number of changes to help accommodate different users.

Both extensions will load the following:

Securities assigned to an Investment Account for which there are registered holdings.
Securities assigned to an Investment Account for which there are no registered holdings.
Securities that are not assigned to an Investment Account but have the 'Show on Summary Page' flag ticked on the Security table.
Currency Exchange Rates for the Base Currency which have the 'Show on Summary Page' flag ticked on the Currency table.

No other prices can be loaded by these extensions.

Please read the extensions part of my Wiki at https://bitbucket.org/mikerb/moneydance-2015/wiki/Extensions for information about file structures and using the extensions.

Regards
Mike Bray

Showing page 2 out of 2. View the first page

1. 31 Posted by Mike Bray (Quot... on 28 Sep, 2018 06:44 AM

   

   Continue to use the Security History Loader for historical prices.
   Mike

   • Edit

2. 32 Posted by chad on 03 Nov, 2018 11:52 PM

   

   Would it be possible to include in the Security Price Loader an additional field for volume?

   • Edit

3. 33 Posted by Mike Bray (Quot... on 04 Nov, 2018 11:01 AM

   

   Chad

   The latest build (2041) does include volume. Just download the
   extension and reinstall.

   Mike

   • Edit

4. 34 Posted by hsmoliar on 10 Nov, 2018 02:29 PM

   

   Mike--In a post about someone with the same security in multiple instances, you said the following:

   If you really want to do what you ask I suggest that you give each copy of the investment different ticker ids, eg.FUSVX, FUSVX2 etc. When you have created the csv file from hleofxquotes, edit the csv file and duplicate the relevant rows changing the Ticker as appropriate. Not ideal but it should allow you to do what you want.

   How do I edit the csv file?
   Thanks very much
   H

   • Edit

5. 35 Posted by hleofxquotes on 10 Nov, 2018 04:18 PM

   

   Once you have the CVS file, for example mdQuotes-yahoo.csv. Just use a simple editor (Mac: textedit, Windows: notepad ...)

   • copy line with FUSVX
   • append and change FUSVX to FUSVX2

   From
   

   Price,Ticker_ISIN,Date
   "95.2700","FUSVX","11/09/2018"
   

   to
   

   Price,Ticker_ISIN,Date
   "95.2700","FUSVX","11/09/2018"
   "95.2700","FUSVX2","11/09/2018"
   

   • Edit

6. 36 Posted by Mike Bray (Quot... on 12 Nov, 2018 02:55 PM

   

   I am not sure what you wish to achieve with having two entries for the same security. If you have the same security in different investment accounts then you only need one price update. The same price is used by both accounts. E.g.

   Investment account one
   Security FUSVX

   Investment account two
   Security FUSVX

   When you load the price for FUSVX it will update both investment accounts.

   Mike

   • Edit

7. 37 Posted by hsmoliar on 12 Nov, 2018 03:13 PM

   

   My problem is that when I set up MD originally, I didn't understand the idea of different accounts for investments so that now I have for example the same security in four different listings and when I run your extension, it only updates one of them. I'm trying to find the .csv file that is alluded to above so that I can try what hleofxquotes said to do.
   Thanks
   H

   • Edit

8. 38 Posted by Mike Bray (Quot... on 12 Nov, 2018 03:42 PM

   

   Hi

   I understand. How did you create the csv file in the first instance?
   What name did you give it?

   Regards
   Mike

   For example if you downloaded

   • Edit

9. 39 Posted by hsmoliar on 12 Nov, 2018 04:06 PM

   

   I haven't created a .csv file. I thought that the quote loader creates one from the posts that I read. If I need a .csv file, please tell me what it should come from and how I should create it. Thanks H

   • Edit

10. 40 Posted by hleofxquotes on 12 Nov, 2018 05:57 PM

    

    .. please tell me what it should come from and how I should create it.

    Derek has a detail write-up on how to install and use the stand-alone tool here: http://help.infinitekind.com/discussions/investments/3036-third-par...

    A cheat-sheet version

    • Download: https://github.com/hleofxquotes/hleofxquotes/tree/master/dist
    • Install
    • Enter symbol: FUSVX
    • Click to Update prices
    • Save result to CSV file
    • Edit CSV file
    • Use Mike "Security Price Loader/Security History Loader" to import above CSV into MD.
    • Edit

11. 41 Posted by hsmoliar on 12 Nov, 2018 07:28 PM

    

    So would I have to do this every day? I'm looking for a way to have the four instances of the same security update daily.
    Thanks
    H

    • Edit

12. 42 Posted by -Kevin N. on 12 Nov, 2018 07:54 PM

    

    Hi H,

    Have you considered fixing the mistake that you made of creating 4 instances of the same security?

    It should be fairly easy to do, repetitive and time consuming probably but doable nonetheless.

    Make a backup or copy of your data file beforehand.

    You could rename 3 out of the 4 instances of FUSVX to 'GET RID OF THIS'.
    Add the actual instance of FUSVX to the 3 accounts that don't hold it.
    Change any transaction that displays 'GET RID OF THIS' in the 'Security' field to the actual instance of FUSVX.
    Finally, delete the 3 instances of 'GET RID OF THIS'.

    Again, make sure to have a working backup or copy of your data file before making drastic changes to your data file.

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

    • Edit

13. 43 Posted by hleofxquotes on 12 Nov, 2018 08:04 PM

    

    I second what Kevin suggested. Fix the original "issue" once and you are done. Better in the long run.

    But to answer your question

    Once:
    Step #1, #2, #3, you do once

    Daily:
    Step #4, #5, #6, #7 daily (or each time you want to update price)
    Step #6 to handle your special case

    A simple Python script can help to make #6 less manual: read the original CSV file and convert to include any extra lines

    • Edit

14. 44 Posted by Mike Bray (Quot... on 13 Nov, 2018 02:03 PM

    

    Hi H

    I didn't appreciate that you were talking about the Quote Loader as the discussion thread is about the Security Price Loader which is a different extension.

    As Kevin has indicated the best way forward is to correct the original error which was the creating of more than one security for the same stock. The Quote Loader can not cope with this as there is a direct relationship between Ticker in Moneydance and the Ticker on the web.

    Obviously I don't know your personal set up but I have the same security (Stocks and funds) in different investment accounts. When Quote Loader updates the prices it updates the prices of all accounts. I suggest you try and follow Kevin's process.

    Regards
    Mike

    • Edit

15. 45 Posted by hsmoliar on 13 Nov, 2018 02:32 PM

    

    Hi Mike
    I'm sorry that I got the two things confused. When I originally purchased MD, the stock prices just worked and it has been frustrating that they have gone about a year without fixing the problem. I do appreciate all of the work that you and the others have done to fill the gaps.

    I have now corrected the setup of my securities in MD but again my apologies.
    Best
    H

    • Edit

16. 46 Posted by -Kevin N. on 13 Nov, 2018 04:00 PM

    

    MD Support,

    Ideally, there should be a 'check' when a user enters the ticker symbol so as to not allow or to notify of duplication.

    -Kevin N.

    • Edit

17. 47 Posted by Mike Bray (Quot... on 22 Dec, 2018 10:38 AM

    

    Current versions may not work on 2019. Please download the new builds if you are testing Moneydance 2019. See https://bitbucket.org/mikerb/moneydance-2019/wiki/Home

    • Edit

18. System closed this discussion on 23 Mar, 2019 10:40 AM.