Security Price/History Loader

Mike Bray 's Avatar

Mike Bray

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 on 28 Sep, 2018 06:44 AM

    Mike Bray 's Avatar

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

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

    chad's Avatar

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

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

    Mike Bray 's Avatar

    Chad

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

    Mike

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

    hsmoliar's Avatar

    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

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

    hleofxquotes's Avatar

    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"
    
  6. 36 Posted by Mike Bray on 12 Nov, 2018 02:55 PM

    Mike Bray 's Avatar

    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

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

    hsmoliar's Avatar

    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

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

    Mike Bray 's Avatar

    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

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

    hsmoliar's Avatar

    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

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

    hleofxquotes's Avatar

    .. 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

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

    hsmoliar's Avatar

    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

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

    -Kevin N.'s Avatar

    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)

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

    hleofxquotes's Avatar

    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

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

    Mike Bray 's Avatar

    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

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

    hsmoliar's Avatar

    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

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

    -Kevin N.'s Avatar

    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.

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