3

I recently started buying some stocks and track them with gnuCash. I used the gnuCash manual to get started. Basically I have Assets:Broker Account where I transfer money. From this account I buy stocks into Assets:Stocks:<SYMBOL>. The latter accounts are created as type "Stock" and each one uses a security called <SYMBOL>.

Clearly I would like to track the (current) value of my stocks. However, gnuCash shows an arbitrary Dollar amount in the stocks parent account (Assets:Stocks).

I do not only know how gnucash determines this value, I would also expect that this value reflects the sum of the currents stocks that exists underneath.

A picture says more than thousand words, so this is how it looks like:

GnuCash Ledger

The 1116.60$ looks arbitrary to me and it is clearly not the value of the stocks underneath! "1 GOOGL" alone was about 1050$ when I bought it! The number should be around 8000$.

What is going wrong here?

Flux
  • 17,301
  • 12
  • 74
  • 138
divB
  • 385
  • 4
  • 15

1 Answers1

3

GNUCash determines the value of stock in two ways:

  1. Implicitly - when you buy or sell a stock you tell GNUCash how many shares you purchased/sold and the total price paid/earned.
  2. Via updates in the 'price editor' tool which can be either manual or automatic if you've configured it to retrieve prices from the web.

For example, the AAPL stock you purchased: as of closing today it was selling for $177 a share. Your entry for purchasing it would thus look close to:

AAPL Purchase Screenshot

You had to enter the number of shares you purchased and the total purchase price - GNUCash then calculates the price per share. This price-per-share then get's logged into the price editor and remains the price of the stock a) permanently for the transaction and b) as the current price of the stock until a newer value is placed in the price-editor.

GNUCash then uses the number of shares of a stock times the price-per-share in the price-editor to determine the value of all stock. If the value does not look correct, even when the transactions do reflect the correct purchase price, it is likely that the price-editor has a wrong value for the stock price which supersedes the purchase price (i.e. is newer).

Andy
  • 1,458
  • 9
  • 13