Re: account number change

[ Message Board ] [ Archives ] [ Search ]

Posted by Nick Fichter on October 01, 2007 at 12:37:45:

In Reply to: Re: account number change posted by Mark on October 01, 2007 at 11:49:28:

: : Hi I downoaded the advisor version yesterday to try out and have a few questions right off.

: : 1) is there some clever way to deal with account number changes such that you can end up with just the new account number with full history? Specific case is that TD Ameritrade just changed all their account numbers, so I have two account histories 501xxxxx that for example starts at 1/1/06 and runs to 5/20/07, and 901xxxxx0 (new number same account) that runs from 5/21/07 to present, would like to see the whole history end up in 901xxxxx0. Would be willing to jump throgh a few hoops to get this.

: : 2) Is there a way to generate a securities cross reference - i.e., for each security, a list of all accounts that own some of it - this is a standard thing that gets requested when an advisor gets audited by the regulators.

: : 3) What kind of luck have people had downloading 401k (or similar account - e.g., 403b) data in to FM - does this rarely work, sometimes, often, usually???

: : Thanks.

: Hi Nick,

: 1) I assume you're importing from TD Ameritrade *.TRN files? If so, just do the import in 2 steps. Import all your .TRN files up through 5/20/07, then change the account numbers, and import a second time after 5/20. (BTW, the information we were given said this conversion took place over the weekend of 5/12/2007?)

: We released a special version of Fund Manager that will convert all these account numbers for you. You would want to use this after doing the first import. You can also modify the account numbers manually, but if you have a lot to do, this special version will help. See:

: http://www.fundmanagersoftware.com/TDAmeritrade_conversion.html

: 2) Yes, create a report, and list by "Investment", and click on the "Filter..." button, and filter by "Symbol", and pick the symbol you want to see. Only investments with this symbol will be listed.

: 3) It depends on the account. If the account is holding securities/funds that have a daily price, this usually works fine. Some 401k accounts have holdings that are only valued monthly or quarterly. In these cases you can track these investments like cash accounts, and just record their gains/losses monthly or quarterly.

: Thanks,
: Mark
: --
: Fund Manager - Portfolio Management Software

Hi Mark,
Thanks for your answers - some follow-up below:
1) Great, and nice to see you provided an automatic way to deal with the acct number change. Related question - I have accts at Schwab that I will be xferring to TD Ameritrade soon - again, would love to keep the history in one stream - can I do this? Change acct numbers and move from Schwab sub portfolio to TD Ameritrade sub portfolio???

2) One time I was required to provide a complete cross reference as a printout - for every security, who owns some. Would I have to just crank through your suggested method security by security, printing out each "by security" report? Seems quite laborious - is there a really easy way? Is there some way to export and then "invert" the matrix, say in Excel?

3) Do you find that, for companies that have 401k plans that use all mutual funds (this is mostly what I encounter with clients) that they mostly provide a workable download facility (those .ofx files or whatever they are called, or some other workable pathway)?

Replies:

• Re: account number change Mark 14:50:34 10/01/07 (0)