Another Advanced Portfoio update

[Gregory Gincley]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hey there, it's very possible I'm misunderstanding the definition or
purpose of the cost basis calculation in this report, but I'm not
understanding how it's arriving at the value it does for the small set
of transactions below.

Using Gnucash 2.6.2

Given the report options:

Effective Date: 10/6/2011
Price Source: Nearest in Time (Transaction preference, using the price
list has the same result)
Basis Calculation Method: FIFO

Transactions:

Buy:  07/29/11 110.65 at 36.15   $4000
Buy:  08/12/11 47.259 at 31.74   $1500
Sell: 10/04/11 -0.165 at 29.697  $4.90
Sell: 10/04/11 -0.661 at 29.6823 $19.62


The Advanced Portfolio report shows a basis of $5473.06
I guess I'm expecting it to show $5470.14 instead.

((110.65-(0.165+0.661))*36.15)+1500


There are transaction prior to this date, but 7/29/11 is the first
transaction after a zero balance.

Again maybe I'm going about my calculation incorrectly? Any insight
would be appreciated - Thanks,
Greg


On 02/23/2014 01:02 AM, Mike Alexander wrote:
> I've added comments below.  They are a bit brief, but maybe they 
> will help some.
> 
> --On February 23, 2014 11:19:35 AM +1100 Chris Good 
> <chris.good at ozemail.com.au> wrote:
> 
>> If you could perhaps add some details, (or correct) what I've put
>> together below, I'll try to update the documentation.
>> 
>> Account:        Stock Account Symbol: Ticker Symbol/Abbreviation 
>> as defined in the Security Editor. There is a report option to 
>> suppress this column. Listing:                Type as defined in 
>> the Security Editor. There is a report option to suppress this 
>> column. Shares:         Number of shares (quantity). There is a 
>> report option to set how many decimal places to show. There is a 
>> report option to suppress this column. Price:          Unit 
>> market price as at report date. There is a report option to 
>> suppress this column. Basis:          Cost of shares purchased + 
>> cost of shares acquired as part of a Dividend Re-Investment Plan 
>> (DRP).
> 
> Cost of all shares acquired by any means, including brokerage fees 
> if the option to include them is selected.
> 
>> Report option 'Basis calculation method' can be set to Average, 
>> LIFO or FIFO. Value:          Number of shares * Unit market 
>> price as at report date
> 
> There is an option to select whether price is af of the report
> date or the latest price
> 
>> Money In: Sum of  the cost of stock purchased, excluding stock 
>> acquired as part of a DRP.
> 
> Yes, external money used to purchase shares.
> 
>> Money Out:              ???
> 
> Money from selling shares or a spin off transaction.
> 
>> Realized Gain:          ???
> 
> Money received for selling shares minus basis for shares sold, 
> minus brokerage fees for the sale if option to include them in 
> basis is selected.
> 
>> Unrealized Gain:        Value less Basis for unsold shares Total 
>> Gain:             Realized Gain + Unrealized Gain Rate of Gain: 
>> Total Gain / Money In * 100 (From GnuCash 2.6.1 onwards) Income: 
>> Total of all income transactions associated with a stock account.
>> To include income from dividends which are not reinvested, ensure
>> there is a dummy transaction split to the stock account with
>> quantity 0 value 0 in the dividend transaction. You can just
>> enter the dummy stock split with no values in the Dividend
>> account and it will create the transaction with price 1 even
>> though you cannot see the Price column in that register.
>> Brokerage Fees: Brokerage Fees if not included in Basis
> 
> They are included in this column even if they are also in the 
> basis.
> 
>> Total Return:           Total Gain + Income Rate of Return: Total
>> Return / Money In * 100
>> 
>> What does option 'Set preference for price list data' do?
> 
> It tells the report to use price list data (if selected, which is 
> the default) or to get prices from stock transactions (if not 
> selected). If there is no relevant price list data it will use 
> transaction prices and wanr you
> 
>> 
>> General question: Should documentation refer to Shares or Stocks 
>> or Securities? I guess Shares as that sort of includes Funds?
> 
> Good question.  Shares may be best, but I don't really know 
> either.
> 
>> I seem to remember this mentioned somewhere, but is it possible 
>> for the headings for numeric fields to be right aligned to make 
>> the report easier to read?
> 
> I don't know.  This is a general question for all reports.  There 
> is nothing special about this report in that regard.
> 
> Mike
> 
> 
> 
> _______________________________________________ gnucash-user 
> mailing list gnucash-user at gnucash.org 
> https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- 
> Please remember to CC this list on all your replies. You can do 
> this by using Reply-To-List or Reply-All.
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)

iQEcBAEBAgAGBQJTL5lOAAoJEODkk8hTyydzYHkH/i2W4j1ayW16qCjem7Vnkw5X
9IheijpA1bagHRNNgHpiB9T1dPRX3EQ0JjZPErMdXRrT0RaEYK/yplqaR3x6PsZY
IfEuVb9aCMiDZqHxkqh8TQOSnOf3MfWpsQFpi07z0blOgvn9JvX69m4QguYD0Ma1
dOIZRDI1Nchx4zSmAHHL7V8bjLlzzemoUidBIIUfcOf3hYE9hGb6Hzxiv9+f20L5
aWKxmHZ9h/jzGE6Ih+pzTI6jEgmr0sC5zLttlU3WcOHP6bcZjT/IjNNcFNPGkGPI
8Gc5iBslWCr7oAKyNiRf3z82bqjgOEKniAronFN+25zSrxoXl/qSvDaHRFGjJzI=
=ZzlX
-----END PGP SIGNATURE-----