|
|
Re: 2 Year Plus Data Import from TD Ameritrade[ Message Board ] [ Archives ] [ Search ] Posted by Steve on August 11, 2006 at 18:11:11: In Reply to: Re: 2 Year Plus Data Import from TD Ameritrade posted by Mark on August 11, 2006 at 17:46:56: 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. : : Well, I'm having trouble getting this data into Fund Manager. : : Thus far, here's what I'm doing. If possible, please show me where I'm making mistakes and how I may remedy the errors. : : I'm downloading the transactions onto my desktop in year-long increments. The files are dumped onto my desktop in csv format, but appear in the form of Excel spreadsheets. The data is organized with the following column headings: Date, Transaction, Description, Quantity, Symbol, Price, Commission, Amount, Sales, Fee. : : Upon setting up a subportfolio (I saw your suggestion of creating all new portfolios after starting, and will go ahead and do that after I finish here), I chose Import -> Transactions -> Generic. : : On the Generic Transaction Import window, I browse File to Import from the desktop to find the csv file with my client's name, and look for the import format that matches the above columns and it doesn't appear as one of the selections. What to do? : : On import destination, under portfolio choice I select the client's subportfolio (because each client's portfolio is handled by FM as a subportfolio)? : : I leave the Import All Transactions Into Specified Investment box blank. Is that ok? : : I check the Create New Investments as Needed box. Is that ok? : : Then, I receive notice that I must "either 'Specify' an investment, or have the 'SYMB' key in the format string." And that's as far as I've gotten, because what I've attempted to set up is illegal... : : I think you may not be downloading the correct file... Are you going through the TD Ameritrade institutional web site interface? You should be given the choice of what format to download in. Some of the choices you should see are "TD Waterhouse" and "Centerpiece". You should choose the "TD Waterhouse" format, and it should download straight to a .TRN file. The fact that you're seeing a .CSV file makes me think you are in a different area. You may also need to get this feature activated before you will see it. : I would suggest calling TD Ameritrade at 800-431-3500 option 3. Ask them for assistance in downling TD Waterhouse formatted transaction files for your portfolio management software program (Fund Manager). : Once you do have this .TRN file use the "File / Import / Transactions / TD Waterhouse..." menu command instead of the "Generic" one. You won't have to enter any format strings, Fund Manager knows the file format of these .TRN files. : Thanks,
|
| FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy |
| Copyright ©1993-2024 Beiley Software, Inc. All rights reserved. |