Re: Split is Retrieved as a purchase

[ Message Board ] [ Archives ] [ Search ]

Posted by Robert on May 10, 2007 at 20:29:08:

In Reply to: Re: Split is Retrieved as a purchase posted by Mark on May 10, 2007 at 17:34:08:

: : Yes this data is from Schwab, I see the imported 'split' tagged as a 'buy' with price = 0.0 & fee = 0.0 . I understand your
: : manual instructions, though data mining with eye balls to find this case is non-trivial.

: : Given these condidtions and knowing the number of shares I own,
: : is there any way for me to automatically convert the data tag
: : from 'buy' to 'split'?

: : Btw Schwab web site stock history data tags the transaction as
: : "type: STOCK SPLIT", so those guys know!

: Hi Robert,

: I agree, Schwab must know, but for some reason they code this as a purchase in the downloaded OFX transaction file, instead of as a split. You can look in the log files created after a retrieve to see this. For info on these logs, look at the bottom of this page:

: http://www.fundmanagersoftware.com/tintrtv.html

: There is no way to automatically convert these, it is corrected manually. For example, say you owned 100 shares, and then had a 2:1 split. Schwab will send down a purchase of 100 more shares. To fix this, delete that purchase, and record a 2:1 split instead. I realize this isn't ideal, but the best solution is for Schwab to correctly code these as splits instead of $0 purchases. You might take a look at your log files, and call up Schwab to bring this to their attention. Maybe they will fix it...

: Thanks,
: Mark
: --
: Fund Manager - Portfolio Management Software

I almost forgot: I am told the other programs get their
split records from Yahoo (or wherever) rather than Schwab.
Users then delete the flagged 'add shares' record from Schwab.
Not ideal, but a practical solution.

Replies: