Getting the current price
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?
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
1 Posted by -Kevin N. on 10 Dec, 2016 07:28 PM
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 Posted by jspitzer on 10 Dec, 2016 08:27 PM
curren
3 Posted by jspitzer on 11 Dec, 2016 11:30 AM
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 Posted by -Kevin N. on 11 Dec, 2016 01:18 PM
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 Posted by jspitzer on 11 Dec, 2016 01:59 PM
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 Posted by -Kevin N. on 11 Dec, 2016 02:16 PM
Hi John,
I'm afraid not.
-Kevin N.
7 Posted by dwg on 11 Dec, 2016 08:37 PM
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 Posted by derekkent23 on 12 Dec, 2016 10:05 AM
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 Posted by -Kevin N. on 12 Dec, 2016 01:19 PM
Hi Derek,
Thanks for posting that - bookmarked.
-Kevin N.
10 Posted by jspitzer on 12 Dec, 2016 08:53 PM
11 Posted by dwg on 12 Dec, 2016 09:04 PM
Good one Derek, I had forgotten about Mike's extensions
System closed this discussion on 13 Mar, 2017 09:10 PM.