Re: Split is Retrieved as a purchase

[ Message Board ] [ Archives ] [ Search ]

Posted by Robert on May 10, 2007 at 20:10:53:

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

FYI:

1) I called Schwab Tech Support and created an 'enhancement
request' - "add a split record to OFX". Schwab have a process....

2) Schwab's current proxy for a 'split' record is actually an
'add shares' record, not a 'purchase' record (the difference
is additional cash debit in second case). MS Money & Quicken use 'add shares' as a flag, I'm told.

FM Enhancement request:
A) Flag (as an alert?) an 'add shares' with zero cost.
B) Transform the flagged record to a split record (optionally?).

Replies:

• Re: Split is Retrieved as a purchase Mark 20:55:49 05/10/07 (0)