Re: Split is Retrieved as a purchase

[ Message Board ] [ Archives ] [ Search ]

Posted by Robert on May 10, 2007 at 16:01:19:

In Reply to: Re: Split is Retrieved as a purchase posted by Mark on May 09, 2007 at 23:13:47:

: : (thanks for your patience, I'm getting there)

: : I'm trying FM(PV), splits are retrieved as a purchase (as
: : shown by All Data), so the Cap Gain Report can then be incorrect. If a sale is a long gain, and the split occured
: : less than 1 year before the sale then that part of the sale
: : is incorrectly reported as a short gain with zero cost (so
: : a big gain).

: : I'm at a loss to understand how the program expects me
: : to deal with splits. Should I manually delete the incorrectly
: : labeled split, and hand edit the original transaction? How
: : would I know to perform this action? (It seems to me that the
: : program quietly added corrupted data.) Perhaps there is a better
: : way, is it documented any place?

: : I infer from a comment in the documentation under 'Yahoo(Historical)' that FM(Pro) does not relabel a split as
: : a purchase. Is this correct? Will the Cap Gains Report from
: : FM(Pro) be long only gain in the case above?

: Hi Robert,

: How did you retrieve this split, with the transaction retrieve, or using Yahoo (Historical)? I suspect it came from the transaction retrieve. FM just imports the data as supplied by your broker. You do get to preview it before it is imported. I have seen before that some brokers (for example, Schwab) handles splits by recording a purchase for the number of shares gained by the split. If this is the case, I would suggest deleting that artificial purchase, and recording a split transaction instead. You deal with splits by entering a split transaction. In the Data Register, go to the "Splits" data type, and enter a new split.

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

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!

Replies:

• Re: Split is Retrieved as a purchase Mark 17:34:08 05/10/07 (3)
  • Re: Split is Retrieved as a purchase Robert 20:29:08 05/10/07 (0)
  • Re: Split is Retrieved as a purchase Robert 20:10:53 05/10/07 (1)
    • Re: Split is Retrieved as a purchase Mark 20:55:49 05/10/07 (0)