Re: Import data info from Waterhouse into FM OR from MoneyCentral (MSN)

[ Q4-Q1 00 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: Import data info from Waterhouse into FM OR from MoneyCentral (MSN) posted by Mark on March 11, 2000 at 09:36:29:

Mark,

I have TDW transactions as well. The only way I know to pick up these transactions are the following:

1) Via Web, using your TDW account, request history (90 or 180 day maximum), when list is displayed, you do a select on all fields. Then do a "copy".
Open Excel or Word, do a "paste". Check pasted entries. Sometimes you have to "paste" to word first, then save as excel format to get the columns to work. From Excel, you can export the file after prepping as a txt file for FM. If you had to use the Word middle step, check out the Excel import with powerful field definition.

Since 1 above will only capture the data for the 90 or 180 days TDW maintains online, you will have to do the following to capture the rest of 1999.

2) Assuming you have a scanner with text translation. Take your monthly report showing your buy/sell details. Scan in the buy/sells telling your text translator to capture the rows of trades. Depending on your software, you may be able to go to Word or Excel or text. Anyway, VERIFY the translation was 100% correct (0 and 9's for example may be misinterpreted).

All this sounds like a lot of work, but the bottom line is to capture to Excel each buy/sell detail transaction, then use Excel to "prep" as an input text file to FM.

If you want to know more, just email me at buckhead26@hotmail.com. I am looking at buying FM, just investigating, but looks good so far.

Buck

: : How can I Import data info from Waterhouse into FM OR from a MoneyCentral (MSN)
: : backup disk. ( The data is in the form of "OFX" ) .

: : TIA, Mitch S.

: Hi Mitch,
: I'm not sure what "OFX" format is... Is it a text file? FM can import
: transactions from either a QIF (Quicken Interchange Format) or a regular
: text file. See "File/Import/Transactions".

: Thanks,
: Mark
: --
: Mark Beiley
:
: Fund Manager for Windows 3.1x/95/98/NT
:
:

Replies: