Re: Problems retrieving some transactions from Schwab

[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: Problems retrieving some transactions from Schwab posted by Mark on March 08, 2005 at 21:13:08:

Hi Mark,

I took at look at the file and indeed, only one of the sells order was there.

Few question regarding the transactions:

1. The returned file has <DTSTART>19910101<DTEND>20050309 even though it was requested on 3/10/2005 (this may explain why some of the transactions are not there yet). Is it possible to warn the user about partial info if the date of the returned transactions is in the past?

2. The returned file include a bunch of <INVBANKTRAN> transactions with things as interest payment. For some reason, FM does not show nor import them with results in incorrect totals. Is it possible to have these transactions as well.

3. I noticed that FM does not complain about importing duplicate transactions and leave the responsability to the user. This is very error prone. How about having automatic filtering of duplicate transactions. I spend several hours today cleaning the dupes, missing and mismatch transactions.

4. One of the difficulties I have is the need to sync between the cash and the stock transactions. Also, the terms used for cash investments are misleading. For example, I have a Schwab account that includes the 'cash' account. Now, if I buy stock X, I see two transactions, one for the cash and one for the stock and FM does not enforce consistency between the two side of the same transaction. Further more, in the cash account, a 'sell' transaction appears a 'buy' (of cash) which is confusing.

It would be great to have in FM portfolios that already include an implicit cash account, each transaction appears only once (without duplicating in the 'cash' investment) and FM will enforce consistency (that is, I cannot delete one side and leave the other). This is the paradigm that my Schwab account provide and I think it is more intuitive and easy to use.

Sorry for the long posting, hope it is clear. I spent today long hours to fix inconsistency in the data.

Thanks,

Kamtsa

: FM should be retrieving everything available on the OFX server. It may be that FM isn't importing correctly, or these transactions aren't being returned by the server for some reason. To check, take a look in the "ofxretr.txt" file right after a retrieve. If you'd like to email that to me, I can take a look, and help decipher what transactions are in there. This is the file returned from the OFX server, and contains all the transactions retrieved.

Replies:

• Re: Problems retrieving some transactions from Schwab Mark 09:51:05 03/10/05 (2)
  • Re: Problems retrieving some transactions from Schwab Kamtsa 10:53:28 03/10/05 (1)
    • Re: Problems retrieving some transactions from Schwab Mark 11:05:17 03/10/05 (0)