security name change
My institution has decided to Change the name of he Yackmann Fund. They are doing this by SelXfr with the old name and a BuyXrf with the new name. If I just accept everything and *pick none of the above" see below. This causes the cost basis to be zero for the new name.
MoneyDance appears to be letting me try and match the old fund with the new fund since I get a dialog box that says "Please choose the security that matches the information below ..." And there is a drop down box listing all the securities except for the Yackman Fund which should be a the bottom of the list. At the bottom of the list is "None of the above". It looks like "None of the above" may have overwritten the Yackmann Fund.
Thoughts
Any ideas
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 Jul 01, 2012 @ 09:46 PM
Hi David,
A possible easier way to accomplish this would be to just rename the old fund to the name of the new fund.
Menu bar > Tools > Securities > Select the name of the old fund > Edit
In the resulting form, click the 'Edit' button up at the top.
In the next form you can change the name of the fund and change the ticker symbol if necessary.
You would probably then ignore the SellXfr / BuyXfr txns. You may want to make a notation in the account's properties of the name change and of the date that it occurred.
HTH -Kevin N.
2 Posted by dehusk on Jul 08, 2012 @ 08:31 PM
Well I tried the above suggestion and changed the name to exactly what the new ID will be before importing the data (Same name, Security ID and Value Suffix etc). Doing that generates two Yackman Funds entries with everything the same and I still can't delete the new one since MoneyDance says it is in use.
I also tried adding a dummy security so that the Yackman fund is not at the bottom of the list of securities. I still can't select the Yackman Fund when MoneyDance asks me to "Please choose the security that matches the information below ..." because the Yackman fund still doesn't show up in the list??!?
Any other ideas?
3 Posted by -Kevin N. on Jul 08, 2012 @ 09:57 PM
Hi David,
Sorry to hear that it didn't work. If you go back to Plan A, you should be able to set the SellXfr and BuyXfr txns to reflect the current cost basis. You will lose the performance history though.
I'd be curious to hear from other users or MD support as to how best to handle this.
Sorry I couldn't help.
-Kevin N.
4 Posted by dehusk on Jul 15, 2012 @ 09:57 PM
Any other ideas?
5 Posted by sth on Jul 19, 2012 @ 01:43 AM
I have the same problem with the same fund.
After you remove all the transactions on the new fund. Then go to the account that has the fund in it and remove that new fund from the account.
Then rename the old fund to the new fund name
ie Yacktman Select Fund to Yacktman Focused Fund
I deleted the buy/sel transactions and made sure that the new name was not used. I deleted the new fund name and renamed the old fund and the old id number and symbol to the new fund name/id/symbol.
But every time I download from my financial institution it recreates the stock. It does not update the prices since it is sure that I have zero shares. I use the Toos->Securites to delete it but it pops right back.
The only difference is the capitalization of the fund names. Possibly MD does a case sensitive name compare? I will test this and report back.
Very annoying issue to have this security with zero holdings keep showing up.
6 Posted by sth on Jul 19, 2012 @ 02:06 AM
Well, changing it to all capitals doesn't get it to recognize as a security I already have. It should match the securities by symbol in this case YAFFX. The security ID is listed as ^561709445 (which is what is shown below except for the spurious ^ symbol which both the existing and new security have as identical.
Since it is merely a name change of a security I would like to keep history, performance, yadda, yadda, yadda.
The console shows that the data downloaded is below. The only weirdness is that even though it gives todays date as the price date, the price is yesterdays value. But it should match it to the existing security! There is nothing in the console log that shows that it tried to match to existing.
<MFINFO>
<SECINFO>
<SECID>
<UNIQUEID>561709445
<UNIQUEIDTYPE>CUSIP
</SECID>
<SECNAME>YACKTMAN FOCUSED SERVICE CLASS
<TICKER>YAFFX
<UNITPRICE>19.8900000
<DTASOF>20120718033018.000[-4:EDT]
<CURRENCY>
<CURRATE>1.000
<CURSYM>USD
</CURRENCY>
</SECINFO>
<MFTYPE>OTHER
<DTYIELDASOF>20120718033018.000[-4:EDT]
</MFINFO>
7 Posted by Jon Hoover on Jul 30, 2012 @ 07:29 PM
Hi,
I'd like to look into this further. Would any of you be able to send me a data file from before and after this name change so I could mess around with it? My email is Jon at Moneydance dot com and I would be sure to delete it once I am done with it.
Sincerely,
Jon Hoover, Moneydance Support
8 Posted by sth on Aug 01, 2012 @ 12:26 AM
Jon,
That is a lot to ask for. Is it ok if I remove 98% of the file? It will take awhile to strip down the file.
I can just strip the file to have that one security. I can delete the extra security and then update the file which will bring it back. Would those two files do it for you?
9 Posted by Jon Hoover on Aug 02, 2012 @ 02:35 PM
Hi,
Stripping it down would be fine, just enough to demonstrate the issue. Thanks for helping out with this.
Sincerely,
Jon Hoover, Moneydance Support
10 Posted by sth on Aug 04, 2012 @ 03:00 AM
Jon,
You should have a severely stripped down version. Let us know if you find the problem! Of course be aware that I will ask for a nightly build as soon as you fix that!! :-) The nightly builds are about 3 months out of date.
11 Posted by dehusk on Aug 16, 2012 @ 06:23 PM
I've been tied up and just got back to this.
Has any progress been made?
Thanks
12 Posted by sth on Aug 16, 2012 @ 07:35 PM
I have sent some data to Jon and he has tried various fixes so activity has happened. There is not a resolution at the moment. I still have two securities that reappear every time I download from two different financial institutions.
13 Posted by Jon Hoover on Aug 20, 2012 @ 02:45 PM
Hi,
There is a bug ticket for this that I have attached to this thread. Unfortunately, there is at present no fix we can offer. How Moneydance handles CUSIPs (which is the id that securities have associated with them) needs to be changed such that you can link or merge securities with different CUSIPS.
Sorry for the inconvenience.
Sincerely,
Jon Hoover, Moneydance Support
14 Posted by sth on Aug 21, 2012 @ 01:29 AM
Thanks for the update. Let us know when a fix is in a nightly build. I am not averse to testing nightly builds.
15 Posted by Jon Hoover on Sep 06, 2012 @ 03:49 PM
STH,
The first time you downloaded the data with the new security in it, were you presented with the "which security does this CUSIP refer to" window? And if so could you associate it with an older security?
Sincerely,
Jon Hoover, Moneydance Support
16 Posted by sth on Sep 06, 2012 @ 05:19 PM
Yes, I was presented with a message asking if this was one of a pop down list of securities. If I delete the security (which is not in any accounts) I get the message with a new download from my financial institution.
No the popdown menu only allows association with securities that have no SYMBOL. I have several retirement securities and some others that have no symbol and they are on that pop down list (some are from discontinued securities, etc.).
I also had this problem in listing some Call Options I recently purchased. I entered them and then a day later or so, they came up on this list as well and kept reappearing under a slightly different name though they should have had the same id and everything. This has stopped since I sold the Calls.
The both of these additional securities do not update since they have zero holdings in any of my accounts.
17 Posted by Tom Freeman on Sep 10, 2012 @ 02:55 PM
We have put in a feature request ticket for a merge security utility which should address this issue.
My understanding is that the name change creates a new security id and for all intents and purposes this is seen as a new security. This doesn't help when trying to maintain performance ratios. The utility request is for some method of batch changing security satisfactions to the new security with no change in pricing.
tom
18 Posted by Jon Hoover on Sep 12, 2012 @ 02:32 PM
Hi,
I just spoke to the developers about this. They are planning on putting a batch change option in for securities. This will probably not be in Moneydance 2012, which is coming out soon. But in Moneydance 2013 which is coming out later this year hopefully we should have this feature implemented. The batch change option should allow you to transfer your old securities transactions into the new one that gets created when you download it for the first time.
Thanks for your patience.
Sincerely,
Jon Hoover, Moneydance Support
19 Posted by atwood.t on Dec 03, 2012 @ 12:00 AM
I have a similar problem. I transferred in some securities that I had not created before to Moneydance created a random number for the security name. I have gone into the Tools>Securities to try and add in the correct security information and that goes o.k. However, I have gone back the original transaction to assigned the correct security name and security system and it does not work. The transaction refuses to change to the correct security information. The names of the correct securities do not appear in the "Security" pull down menu. I cannot delete the incorrect security names because they "are in use". I can edit the incorrect security names but the edits are not saved. Basically, the edit securities does not work at all if the security has at least one transaction. This is a major bug that means that if I transfer in a new security and some of the information is incorrect I can never change it. Major program FAiL!
20 Posted by sth on Dec 03, 2012 @ 12:10 AM
zwood,
This should work and it has for many of us. You may be editing a security that is not in the account you are looking at.
Try the following, go to the account with the security in it and open the "Security Detail" tab. You should find your security in the pull down list. This may be the one with the random number. Open the "history" from the button on this page.
At the top of the history window is a button "Edit" next to the security name. Use this to edit the security name (not the ID). That should change the security in the account to the correct name.
21 Posted by macalves1 on Nov 13, 2013 @ 07:59 PM
Actually, you don't need to be in the account with the security name in it.
From the Menu > Tools > Securities you will access all securities in the data file. Just select the security from the list and click the "Edit..." button.
22 Posted by TB on Jan 31, 2015 @ 02:27 PM
OK, so here we are in 2015 and I'm having the same problem dealing with a simple name change for a specific security. Was a fix ever put in place, and if so could someone please provide some updated guidance? Thanks!
23 Posted by sth on Jan 31, 2015 @ 02:55 PM
Wow, 3 years and even this discussion is lost on the new boards.
Unless there is a fix in MD 2015, the answer is no. Now I haven't seen a blog post on the update to 2015 and the features/fixes included.
24 Posted by Tom Freeman on Mar 22, 2015 @ 03:44 PM
The issue is that from time to time the dynamics of certain securities and funds change and they have a new cusip. As described by the OP many institutions deal with this as a sell xfer/buyxfer. The problem with this is that you lose a lot of the performance history of this particular investment.
The developers have been resistant to a simple security edit function to edit a cusip as it could lead to a number of unintended issues. Especially as change of cusip is infrequent and unique.
There is an FAQ for fixing a mismatched security download that could be used as a fix for this. Here is a link to that faq: https://infinitekind.zendesk.com/hc/en-us/articles/202421269-Fixing-mismatched-securities-from-downloads-in-investment-accounts
25 Posted by -Kevin N. on Mar 22, 2015 @ 03:59 PM
Hi Tom,
The link that you provided is broken due to the (:) that is appended to the beginning of (https).
-Kevin N.
26 Posted by dwg on Mar 22, 2015 @ 08:54 PM
A change in cusip implies a change of security, but I do not think in these sorts of instances that doing a sell and a buy is a correct approach to handling the transfer, as has been said you lose your performance history.
I believe what is required in Moneydance s a stock for stock acquisition transaction type. In this case it would probably be on a 1 for 1 basis, but such a transaction type could be also used for company mergers & acquisition where you receive stock in the new company on the basis of a certain ratio (so you have to allow for ratios of other than1:1) The software would have to recalculate the cost price based on this ratio thus preserving your history (it should also allow for the choice of moving over share price history to the new ticker symbol).
This would remove the need for a security edit function of the type described.
Such a transaction type can handle a rename of stock, it can also handle a change a share type e.g. if a company converts preference shares into ordinary shares as sometimes happens.
Des
27 Posted by NanooGeek on Apr 06, 2015 @ 03:07 AM
In MD 2015, there is No Edit button in the Securities list (at least in trial mode).
Have just begun investigating how feasible it will be to switch Investment accounts from Quicken. The license terms for a household are much more attractive than Intuit's terms for Quicken. However, Quicken is able to deal with name or ticker (haven't tried CUSIP) changes for a security, and asks if price history should be copied if the ticker is changed.
28 Posted by NanooGeek on Apr 06, 2015 @ 03:14 AM
The lack of an Edit button in the Securities list was observed under Win 7. Have also been trying MD 2015 out under Win 8.1, but not likely an Edit button will be available there either.
29 Posted by Scott Meehan on Apr 06, 2015 @ 01:31 PM
Hi NanooGeek,
You can edit a security in Moneydance 2015 by double clicking the security.
Scott Meehan
Infinite Kind Support
System closed this discussion on Mar 19, 2016 @ 04:56 AM.