Investment anomalies?

[Bob Ewart]

I've looked at the OFX documentation and couldn't find the reinvest 
transaction.

I took a quick look through the code and see that Ace Jones wrote the 
OFX importer plugin in 2005.  It seems to handle dividend reinvestments; 
mymoneystatement.cpp and mymoneystatementreader.cpp also.

Every brokerage has to handle dividend reinvestments.  If someone has 
had dividends reinvested and imported properly to KMM, I would very much 
like to see an anonymized copy of that OFX file.

Even if KMM doesn't handle the reinvestment,  it will be useful to see 
how the OFX looks from other brokers.

Bob

On 01/22/2016 10:14 AM, Jack Ostroff wrote:
> (I don't have good access this week, so I'm being pretty quiet.)  I've 
> never actually seen an OFX reinvest dividend transaction to use as a 
> model.  I do have the OFX definitions home someplace, so I should be 
> able to dig them out when I get home. One other thing to check is 
> whether libofx or the ofx handling of aqbanking can handle it and what 
> do they expect?
>
> Jack
>
> On 1/22/2016 10:01 AM, Bob Ewart wrote:
>> I checked ofxhome and found a post by Jack in 2010.  The only response
>> was to create a bug for KMM and let the developers fix it.
>>
>> I added some comments and asked for a description of the ofx for a
>> dividend reinvestment.
>> http://www.ofxhome.com/ofxforum/viewtopic.php?pid=108331#p108331
>>
>> We'll see what response I get
>>
>> In the mean time I'm going to go ahead with converting the three into
>> dividend and buy transactions.  To make life interesting, the equity I'm
>> looking at has an ordinary dividend, short-term and long-term dividends
>> all intermingled.
>>
>> Bob
>>
>> On 01/22/2016 06:53 AM, aga wrote:
>>> I've looked through the files I've collected, but there is none for
>>> Reinvested dividends, I'm afraid.
>>>
>>> Have you looked on http://www.ofxhome.com/?   Someone there might be
>>> able to help.
>>>
>>> Allan
>>>
>>> On 21/01/16 23:12, Bob Ewart wrote:
>>>> On 01/18/2016 08:25 PM, Jack wrote:
>>>>> <snip>
>>>>> Second issue - on the surface, ML does pretend to track whole shares
>>>>> only, with the occasional transaction (I've forgotten the term they
>>>>> use, and don't have time to go digging into a statement right now)
>>>>> where they add or remove a single share.  I used to try to do it that
>>>>> way in KMM.  However, there really is enough information in all the
>>>>> buy/sell/div-reinvest transactions to track shares at fractional
>>>>> amounts (often to four decimal places) and they actually do report
>>>>> that partial amount in the holdings list in the monthly statement. 
>>>>> The
>>>>> month I converted to actually tracking too some "creative"
>>>>> transactions, but now it's much easier to know what I actually have.
>>>>>
>>>>> Jack
>>>>>
>>>> When I first started using KMM, ML did report the fractional shares in
>>>> the memo. They don't do that now..  They do  have the name and memo
>>>> fields swapped.  At that time I wrote a little perl program fix the
>>>> fractional shares and the name/memo fields.
>>>>
>>>> Editing the account to fix the name/memo only appears when you're 
>>>> set up
>>>> for online banking.  It should be available for importing from a file.
>>>>
>>>> I did try the online fetch of the ofx data, but ML changed something.
>>>> It's easier to download the ofx file at the same time as my statement.
>>>>
>>>> I get a bunch of dividend-reinvestments every year in December. So I
>>>> thought I'd update my little fix program.  What should a
>>>> dividend-reinvestment look like in ofx?  I can't find an example
>>>> anywhere.
>>>>
>>>> The ofx is showing 3 transactions for each reinvestment.
>>>>
>>>> 1. An Income transaction which shows up in the ML account with the
>>>>     amount and no change in shares.  It appears in the brokerage 
>>>> account
>>>>     as income with the category of 'Investment Transaction'. That
>>>>     appears to be the '_Dividend' category.
>>>> 2. A transfer which shows the units and price.  Seems to be ignored.
>>>> 3. An INVBANKTRN which causes a payment in the brokerage account with
>>>>     no category assigned and not tied to the equity.
>>>>
>>>> My thought is to combine the 3 into two transactions.
>>>>
>>>> 1. An income transaction showing the dividend.  Not sure how to assign
>>>>     the category to short-term, long-term or ordinary dividend.
>>>> 2. A buy transaction showing the units and total cost (Do I need to
>>>>     specify the price/share?)
>>>>
>>>
>>>
>>
>
>