stock adjustments

[David T.]

Steve--

IANAA, but my experience with commodities is that the two numbers I care about
are the Number of shares transacted, and the amount of money that leaves/enters
my possession. Price is simply a number that converts one to the other.

When I enter transactions in one of these accounts, I enter the number of
shares bought/sold, the amount of money on my end, and when GC asks which to
adjust, I tell it to change the price. You keep telling GC that you have spent
.01, that you purchased .001 shares, but that the shares cost 9.65449 each.
These numbers just don't add up (.001 * 9.65449 = .00965449 -- not .01). That's
why GC keeps changing the price to 10. If you're just trying to fudge the
numbers, why worry what price goes in, anyway? 

I think you could straighten this all out, though, if you go back to your
transactions and focus on the asset change in your account (i.e., how much you
paid), and the shares involved, and ignore the numbers in the price column.
This would also make your reconciliations much simpler.

The differences in price are going to have a negligible effect on the ultimate
cost basis, and shouldn't be of concern.

David

--- Steve Kelem <steve at kelem.net> wrote:

> (Nope. No freedom to move, only not to invest.)
> 
> So....I've tried to add a fudge amount in one of my commodities so that I can
> reconcile that (sub)account. Gnucash keeps changing the commodity price.
> The transaction is entered as:
> 				Shares Price	Buy	Sell
> <date> Fudge ING Stock fund 	0.001		0.001
> 	Assets:Invest:...	0.001	9.65449	0.01
> 	Equity:Opening Balances			0.01
> 
> When I'm entering the transaction, GC enters default shares, price, and Buy
> amounts.  I type over the #shares and price. Then GC asks which column I want
> to adjust. The choices are Shares, Price, and Value.  I want to change Buy,
> so I select Value.  The transaction then is changed to look like:
> 
> <date> Fudge ING Stock fund 	0.001		0.001
> 	Assets:Invest:..:A468	0.001	10	0.01
> 	Equity:Opening Balances			0.01
> 	Orphan-USD
> 					1		0.02
> 					1
> I've tried changing the price to 9.65449, but GC keeps changing it back to
> 10.
> 
> Any idea why I can't enter the correct price?
> Also, what are the extra lines at the end of the transaction?
> 
> Thanks,
> Steve
> 
> Derek Atkins said the following on 05/01/2007 10:48 AM:
> > Hi,
> > 
> > Quoting Steve Kelem <steve at kelem.net>:
> > 
> >> After several long talks with ING, I found that only one of the three
> >> numbers is accurate: how much money I put in.  The price is rounded,
> >> as are the number of shares.
> > 
> > That's..... unfortunate.  That means you have to guess, which is still
> > probably better than trying to make adjustments.  But it's really bogus
> > of ING to do this to you.  I'd recommend you move your funds somewhere
> > else and boycott them for not providing you accurate numbers.   (Assuming
> > you have the freedom to do this).
> > 
> >> What is "SCU"?
> > 
> > The denominator.  I'm trying to find an expansion of the acronym
> > but I'm failing.   I think it's something like "Smallest Commodity Unit".
> > 
> >> Thanks,
> >> Steve
> > 
> > -derek
> > 
> >> Derek Atkins said the following on 04/30/2007 03:03 PM:
> >>> rlu53417 at earthlink.net writes:
> >>>
> >>>> What stops you from doing your own share calculation up front instead
> >>>> of relying on their bad numbers?
> >>>>
> >>>> On Sat, Apr 21, 2007 at 10:45:30PM -0700, Steve Kelem wrote:
> >>>>> The problem is that for ING Retirement accounts, the # shares in
> >>>>> transactions don't add up to the amount
> >>>>> in their summary lines.  One of the ING reps said it's because
> >>>>> internally they compute # shares to 6 decimal points, but tell
> >>>>> their customers about only 3 of those decimals, so the numbers "may
> >>>>> not add up."  For example, the sum of # shares in transactions
> >>>>> comes to 73.003 shares, but the ING summary shows 73.000 or 73.006
> >>>>> shares.
> >>>>>
> >>>>> So that I can reconcile my Gnucash representation of this account,
> >>>>> I need to add dummy transactions.
> >>>>> My question is "What's the best form for this dummy transaction?"
> >>>
> >>> Yeah, I'd go back and try to recompute the actual share amounts
> >>> instead of trying to "fudge" it later.  You can even set gnucash to
> >>> use 6 digits, but then you might need to guess exactly how many shares
> >>> you're getting.  Are the PRICES accurate?  You only need two of the
> >>> three values to be accurate:  #shares, price, $value.  The third can
> >>> be computed.   But note that GnuCash only stores #shares and $value,
> >>> so you should change the commodity SCU to increase it to 6 decimal
> >>> places if you choose this route.  But this is the route I suggest.
> >>>
> >>> -derek
> _______________________________________________
> 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.
> 



 
____________________________________________________________________________________
We won't tell. Get more on shows you hate to love 
(and love to hate): Yahoo! TV's Guilty Pleasures list.
http://tv.yahoo.com/collections/265