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