Transaction Report Calculation Error?

[Derek Atkins]

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