Getting the current price

jspitzer's Avatar

jspitzer

10 Dec, 2016 07:22 PM

I have an unusual problem. I have several stocks and funds that have no tickers. They are not publicly traded. I can go the the website(s) of the companies that provide these assets, where I can find closing prices and able to get them into a CSV file.

So, let's say once a week, I would like to update the prices of my assets in Moneydance with the closing prices on that day. Is there a way that I could import the prices from the CSV file? It is extremely tedious to enter the "current price" for each asset.
Ideas please?

  1. 1 Posted by -Kevin N. on 10 Dec, 2016 07:28 PM

    -Kevin N.'s Avatar

    Hi John,

    From the Moneydance Knowledge Base...

    Importing a file - Open the Securities Detail view and click History. Click the Import button. Select “Import from File” and click “Import”, then navigate to and select the file containing the security price history. You can import Comma or Tab delimited files.

    HTH -Kevin N.

  2. 2 Posted by jspitzer on 10 Dec, 2016 08:27 PM

    jspitzer's Avatar


    curren



    -Kevin N. wrote:
    pre { width: 92%; margin: 10px 2%; padding: 5px 2%; background: #efefef; border: 1px solid #d6d6d6 } blockquote { margin-left: 0; padding-left: 1em; border-left: 5px solid #ccc; }

    // Please reply above this line
    ==================================================

    From: -Kevin N.

    Hi John,

    From the Moneydance Knowledge Base...

    Importing a file - Open the Securities Detail view and click History. Click the Import button. Select “Import from File” and click “Import”, then navigate to and select the file containing the security price history. You can import Comma or Tab delimited files.

    HTH -Kevin N.

    On Sat, Dec 10 at 11:22 AM PST, John wrote:

    I have an unusual problem. I have several stocks and funds that have no tickers. They are not publicly traded. I can go the the website(s) of the companies that provide these assets, where I can find closing prices and able to get them into a CSV file.

    So, let's say once a week, I would like to update the prices of my assets in Moneydance with the closing prices on that day. Is there a way that I could import the prices from the CSV file? It is extremely tedious to enter the "current price" for each asset.
    Ideas please?

    Having trouble reading this? View this discussion online: Getting the current price.

    Reply with #ignore to stop receiving notifications for this discussion.


  3. 3 Posted by jspitzer on 11 Dec, 2016 11:30 AM

    jspitzer's Avatar

    Thanks for the reply. There are a couple of problems with this approach.
    1. I have to go to Security Detail view and History for each of my stocks/funds individually.
    2. The import function (may) update the price history, but it does not update the current price.

    If I am explaining this clearly, I can only do a price history update for one fund at a time and that update will not change the current price, which is what I really want to fix. I would need to be able to import a file that had the Security Name, date, and close.

  4. 4 Posted by -Kevin N. on 11 Dec, 2016 01:18 PM

    -Kevin N.'s Avatar

    Hi John,

    Your assessment is accurate.

    The only other option available is to try the 'Security Price Entry' extension which allows you to enter multiple security prices without having to go through the Securities Detail > History interface.

    It is available through the Moneydance menu bar > Extensions > Manage Extensions menu item.

    You can read up on how to use it at the developers website.
    https://sites.google.com/site/songlinesoftware/home/security-price-...

    HTH -Kevin N.

  5. 5 Posted by jspitzer on 11 Dec, 2016 01:59 PM

    jspitzer's Avatar

    Again thanks for the response. The extension is certainly a big improvement over the Security Detail > History approach.
    I can easily create a CSV file with Security Name, Date, Close price for all assets that I need to update. I do this once a week for a fair number of funds so the data entry is still tedious with the extension (although much less so than before you advised me of it!)
    Do you know of any way that my CSV file could be imported into the 'Security Price Entry' extension?

  6. 6 Posted by -Kevin N. on 11 Dec, 2016 02:16 PM

    -Kevin N.'s Avatar

    Hi John,

    Do you know of any way that my CSV file could be imported into the 'Security Price Entry' extension?

    I'm afraid not.

    -Kevin N.

  7. 7 Posted by dwg on 11 Dec, 2016 08:37 PM

    dwg's Avatar

    I suspect what you want to do would require a custom extension to be created, to do so requires a knowledge of Java however.

  8. 8 Posted by derekkent23 on 12 Dec, 2016 10:05 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    There is a free third party extension that allows a CSV file to be loaded and update the secuitry price history. See https://bitbucket.org/mikerb/moneydance-2015/wiki/Security%20Price%...
    I use this “Secuity Price Loader” at the end of each mouth.
    The above third party web page also provides a link to the description of how the extension works.
    In your case you would need to add a fictitious ticker number to each security. Also add these ticker numbers to your CSV file. This is the only way for identify which price data relates to which security.
    You don’t need to have all the field descried, in my case I only use three i.e. only three headers. See extract from my CSV file.
    The last has a fictitious ticker number that I added to the security in monydance.

    Hope this helps.

  9. 9 Posted by -Kevin N. on 12 Dec, 2016 01:19 PM

    -Kevin N.'s Avatar

    Hi Derek,

    Thanks for posting that - bookmarked.

    -Kevin N.

  10. 10 Posted by jspitzer on 12 Dec, 2016 08:53 PM

    jspitzer's Avatar


    derekkent23 wrote:
    pre { width: 92%; margin: 10px 2%; padding: 5px 2%; background: #efefef; border: 1px solid #d6d6d6 } blockquote { margin-left: 0; padding-left: 1em; border-left: 5px solid #ccc; }

    // Please reply above this line
    ==================================================

    From: derekkent23

    I am not support staff, just a user.

    There is a free third party extension that allows a CSV file to be loaded and update the secuitry price history. See https://bitbucket.org/mikerb/moneydance-2015/wiki/Security%20Price%...
    I use this “Secuity Price Loaded” at the end of each mouth.
    The above third party web page also provides a link to the description of how the extension works.
    In your case you would need to add a fictitious ticket number to each security. Also add these ticket numbers to your CSV file. This is the only way for identify which price data relates to which security.
    You don’t need to have all the field descried, in my case I only use three i.e. only three headers. See extract from my CSV file.
    The last has a fictitious ticket number that I added to the security in monydance.

    Hope this helps.

    On Sun, Dec 11 at 12:37 PM PST, dwg wrote:

    I suspect what you want to do would require a custom extension to be created, to do so requires a knowledge of Java however.

    Having trouble reading this? View this discussion online: Getting the current price.

    Reply with #ignore to stop receiving notifications for this discussion.


  11. 11 Posted by dwg on 12 Dec, 2016 09:04 PM

    dwg's Avatar

    Good one Derek, I had forgotten about Mike's extensions

  12. System closed this discussion on 13 Mar, 2017 09:10 PM.

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