stock adjustments

Steve Kelem steve at kelem.net
Sat May 12 01:34:19 EDT 2007


(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


More information about the gnucash-user mailing list