Transaction Report Calculation Error?

[Richard Lindgren]

Derek

That worked, but why? What did I do wrong?

Richard


On Mon, Apr 7, 2014 at 3:31 PM, 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
>
>