|
|
Re: 2 Year Plus Data Import from TD Ameritrade[ Message Board ] [ Archives ] [ Search ] Posted by Mark on August 11, 2006 at 19:11:53: In Reply to: Re: 2 Year Plus Data Import from TD Ameritrade posted by Steve on August 11, 2006 at 18:11:11: : I'm going through the TD Ameritrade Institutional website, which transfers me, upon request via html link, to their new website. It is here that I found the csv data. But as mentioned previously, TD Ameritrade's client services department is clueless about this data. Why don't I just use what's readily available? Because the importable data only goes back 30 days. : As mentioned, the data available, in csv format, goes back as far as I need. It's column headings are as follows: : The question is how I might get this successfully imported into FM. If I merely omit the .csv and change the file to end .TRN, it is not recognized by FM while attempting to import. Can I convert it to something else (QIF, for example)? There's got to be some way I can make use of the data... : Once again, how to convert this into a format that FM will accept.
You can import that data, but it will require some extra work on your part. You can leave it in a .CSV format for the generic import. Converting it to a .TRN or .QIF file would be very difficult. You will either need to have all the transactions for each account in its own CSV file, or add a new column for the sub-portfolio name. You will also probably need to change the transaction codes to the ones that Fund Manager understands. The generic import is flexible, but requires you to tell Fund Manager how your data is formatted. For help on this, just go to "File / Import / Transactions / Generic..." and then press the "Help..." button. If you have each account's transactions in a separate file, you don't need to use the "PORT" keyword. In this case you would need to manually create each account sub-portfolio before the import and then during the import specify which sub-portfolio you want all the transactions to go into. If you put all accounts in a single file, you would need to specify a portfolio name in a new column and then use the PORT keyword in your import format string. Fund Manager will create the sub-portfolio for you in this case, using the name from your importing data in the PORT field. There is quite a bit to using this command, so I'd suggest to read through the online help topic for this command, and if you have any questions email us your file as an attachment, and the format string you're using. I can help with the specifics. Thanks,
|
| FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy |
| Copyright ©1993-2024 Beiley Software, Inc. All rights reserved. |