Transaction Report Calculation Error?

[Derek Atkins]

Hi,

On Mon, April 7, 2014 3:37 pm, Richard Lindgren wrote:
> Derek
>
> That worked, but why? What did I do wrong?

Like I implied, the report is not reporting on your transaction but is,
instead, pulling in the price from the PriceDB and using that to compute
the value of your transaction.  You had a PriceDB entry for that day that
caused the report to compute 143.5 instead of 150.

I cannot answer why the report does this, and does not have an option to
change the behavior.

>
> Richard

-derek

>
> On Mon, Apr 7, 2014 at 3:31, Derek Atkins <derek at ihtfp.com> wrote:
>
>> Hi,
>>
>> On Mon, April 7, 2014 3:22 pm, Richard Lindgren wrote:
>> > Derek
>> >
>> > I went to tools and Price editor and could only find 36.21 as the
>> closet
>> > price for that date as well as the number itself.
>>
>> Well, that *could* be the issue.  Try removing that?
>> Or changing it to 37.9171?
>>
>> > Richard
>>
>> -derek
>>
>> >
>> >
>> > On Mon, Apr 7, 2014 at 3:08 PM, Derek Atkins <derek at ihtfp.com> wrote:
>> >
>> >> Hi,
>> >>
>> >> On Mon, April 7, 2014 2:47 pm, Richard Lindgren wrote:
>> >> > Derek
>> >> >
>> >> > I looked in the options and I do not see an option for choosing the
>> >> quote
>> >> > source.
>> >> >
>> >> > Please direct me to the place for choosing the quote source.
>> >>
>> >> Strange.  neither do I.
>> >>
>> >> So, how about this -- let's go into the PriceDB and see if you have
>> any
>> >> entries for your stock?  In particular, is there an entry for
>> $36.2740?
>> >>
>> >> > Thanks.
>> >> >
>> >> > Richard
>> >>
>> >> -derek
>> >>
>> >> >
>> >> > On Mon, Apr 7, 2014 at 2:42 PM, Derek Atkins <derek at ihtfp.com>
>> wrote:
>> >> >
>> >> >> Hi,
>> >> >>
>> >> >> On Mon, April 7, 2014 2:22 pm, Richard Lindgren wrote:
>> >> >> > Derek
>> >> >> >
>> >> >> > I generated the report from:
>> >> >> > -Reports
>> >> >> > -Transaction Report
>> >> >> > - ( I chose the account to Report from my Asset Account )
>> >> >> > -Asset
>> >> >> > -Investment
>> >> >> > -The account SMVAX
>> >> >> >
>> >> >> > To further illustrate the transaction, I ignored the commission,
>> >> and
>> >> >> that
>> >> >> > transaction is shown below:
>> >> >> >
>> >> >> > [image: Inline image 1]
>> >> >> >
>> >> >> > The amount of shares shown is correct and the money spent is
>> >> correct.
>> >> >> > However, I apparently chose the wrong Transaction report???
>> >> >>
>> >> >> Well, there are two.  There's the "Transaction Report" and the
>> >> "Account
>> >> >> Transaction Report".
>> >> >>
>> >> >> > That Transaction Report for the above transaction is shown
>> below:
>> >> >> >
>> >> >> > [image: Inline image 2]
>> >> >> >
>> >> >> > What am I doing wrong?
>> >> >>
>> >> >> Check your report options -- what do you have set for your Quote
>> >> Source?
>> >> >> My guess is that the report is pulling in a PriceDB entry and
>> >> ignoring
>> >> >> your actual entry.  That's the only way I can think to explain the
>> >> >> 143.25.
>> >> >>
>> >> >> > I appreciate your help here.
>> >> >> >
>> >> >> > Thanks again.
>> >> >> >
>> >> >> > Richard
>> >> >>
>> >> >> -derek
>> >> >>
>> >> >> >
>> >> >> > On Mon, Apr 7, 2014 at 1:55 PM, Derek Atkins <derek at ihtfp.com>
>> >> wrote:
>> >> >> >
>> >> >> >> Hi,
>> >> >> >>
>> >> >> >> On Mon, April 7, 2014 1:30 pm, Richard Lindgren wrote:
>> >> >> >> > Derek
>> >> >> >> >
>> >> >> >> > That's why I was asking if I have made an error in my
>> entering
>> >> the
>> >> >> >> stock
>> >> >> >> > purchase. I invested $150.00 total. $7.50 went toward the
>> >> >> commission
>> >> >> >> and
>> >> >> >> > $142.5 went toward the actual stock purchase.
>> >> >> >>
>> >> >> >> If you spent $150 on stock, and $7.50 went to commissions, then
>> >> you
>> >> >> did
>> >> >> >> not get 3.9596 shares at $37.9171.  So yes, you have your data
>> >> >> entered
>> >> >> >> incorrectly.
>> >> >> >>
>> >> >> >> So...  how much money left your Bank account?
>> >> >> >> How much of that went to commissions?
>> >> >> >> The *rest* is your actual purchase..  Do you know how many
>> shares
>> >> you
>> >> >> >> got?
>> >> >> >>
>> >> >> >> > When I request a Transaction report showing no commission
>> with
>> >> the
>> >> >> >> total
>> >> >> >> > of
>> >> >> >> > $150.00 for the stock purchase, it is still incorrect.
>> >> >> >> >
>> >> >> >> > [image: Inline image 1]
>> >> >> >>
>> >> >> >> What report are you using to actually compute this?  You say
>> >> >> >> "transaction
>> >> >> >> report" but I don't understand how you are creating a
>> transaction
>> >> >> report
>> >> >> >> but showing no commissions?  Exactly which report is it?
>> >> >> >>
>> >> >> >> It is possibel that the report is not showing the actual
>> >> transaction
>> >> >> but
>> >> >> >> is, instead, applying a price quote from your PriceDB.  But
>> that
>> >> >> would
>> >> >> >> depend on what report you're actually running.  I cannot tell
>> from
>> >> >> your
>> >> >> >> picture.
>> >> >> >>
>> >> >> >> > Again, Maybe I'm doing something wrong, but I don't know what
>> it
>> >> >> might
>> >> >> >> be.
>> >> >> >> >
>> >> >> >> > [image: Inline image 2]
>> >> >> >> >
>> >> >> >> > The above is the Transaction I show without any commission.
>> >> >> >> >
>> >> >> >> > Any help here will certainly be appreciated.
>> >> >> >> >
>> >> >> >> > Thank you in advance for your help.
>> >> >> >> >
>> >> >> >> > Richard
>> >> >> >>
>> >> >> >> I think your transaction input is incorrect.
>> >> >> >>
>> >> >> >> -derek
>> >> >> >>
>> >> >> >> >
>> >> >> >> > On Mon, Apr 7, 2014 at 12:54 PM, Derek Atkins
>> <warlord at mit.edu>
>> >> >> wrote:
>> >> >> >> >
>> >> >> >> >> hi,
>> >> >> >> >>
>> >> >> >> >> Richard Lindgren <rlindgren74 at gmail.com> writes:
>> >> >> >> >>
>> >> >> >> >> > Here is copy of my actual transaction. Maybe I am in
>> error?
>> >> >> >> >> >
>> >> >> >> >> > Inline image 1
>> >> >> >> >> >
>> >> >> >> >> > Thank you in advance for your help.
>> >> >> >> >>
>> >> >> >> >> The report and the transaction are different.  There appears
>> to
>> >> be
>> >> >> a
>> >> >> >> $1
>> >> >> >> >> split in the report that I don't see in the transaction.  I
>> >> don't
>> >> >> >> know
>> >> >> >> >> where that is coming from?
>> >> >> >> >>
>> >> >> >> >> > Richard
>> >> >> >> >>
>> >> >> >> >> -derek
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media
>> Laboratory
>> >> >> >> >>        Member, MIT Student Information Processing Board
>> (SIPB)
>> >> >> >> >>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA
>> N1NWH
>> >> >> >> >>        warlord at MIT.EDU                        PGP key
>> available
>> >> >> >> >>
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >>        Derek Atkins                 617-623-3745
>> >> >> >>        derek at ihtfp.com             www.ihtfp.com
>> >> >> >>        Computer and Internet Security Consultant
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >>
>> >> >>
>> >> >> --
>> >> >>        Derek Atkins                 617-623-3745
>> >> >>        derek at ihtfp.com             www.ihtfp.com
>> >> >>        Computer and Internet Security Consultant
>> >> >>
>> >> >>
>> >> >
>> >>
>> >>
>> >> --
>> >>        Derek Atkins                 617-623-3745
>> >>        derek at ihtfp.com             www.ihtfp.com
>> >>        Computer and Internet Security Consultant
>> >>
>> >>
>> >
>>
>>
>> --
>>        Derek Atkins                 617-623-3745
>>        derek at ihtfp.com             www.ihtfp.com
>>        Computer and Internet Security Consultant
>>
>>
>


-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant