|
|
Re: 2 Year Plus Data Import from TD Ameritrade[ Message Board ] [ Archives ] [ Search ] Posted by Steve on August 11, 2006 at 14:30:28: In Reply to: Re: 2 Year Plus Data Import from TD Ameritrade posted by Steve on August 11, 2006 at 14:03:24: Mark, 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...
|
| FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy |
| Copyright ©1993-2024 Beiley Software, Inc. All rights reserved. |