Stocks/add stock

From GnuCash
Revision as of 05:56, 12 October 2022 by Sunfish62 (talk | contribs) (Updating to include clearer background and steps)
Jump to: navigation, search


Overview

GnuCash can track holdings of various types of investments, including stocks and mutual funds. This page describes how to add such investments to your portfolio, with detailed instruction on the settings to use.

Stocks and mutual funds are types of commodities, and in GnuCash, accounts for these investments are set up slightly differently from checking or savings accounts. Most prominently, a stock account is denominated in shares of stock, rather than in a currency. In order to track your holdings, you need to provide details of that commodity to GnuCash.

Adding a commodity to your books is a two-step process: first, you must create an entry for the commodity in the Securities list in your books. Then, you add a commodity account in your Chart of Accounts to track your particular holdings.

For more information, see
Investments in the Tutorial and Concepts Guide and
description of the dialogs in the Manual.
See also
Online Quotes

Adding a Security to GnuCash

In the first step, you provide GnuCash with general information about the commodity to allow internal tracking of that commodity.

Take the stock Amazon (AMZN) as an example. Amazon is traded on the NASDAQ.

To add Amazon as a security
  • Go to Tools->Security Editor
  • Click "Add"
  • In the Add Security dialog, enter:
    • "Amazon.com, Inc." in the "Full Name" field
    • "AMZN" in the "Symbol/Abbreviation" and optionally "Display symbol" fields - for other stocks: the symbol depends on the source of your online quotes.
    • "NASDAQ" in the Type field.

At this point, GnuCash has enough information to add the security, and you can click Save to add it. Once saved, this security can be used to create an account to track your holdings.

If you want to retrieve online prices, additionally fill in the following fields
    • Check "Get Online Quotes"
    • Select a preference for "Type of quote source" (Single|Multiple|Unknown)
    • Choose the preferred Finance Quote source (e.g., "Yahoo as JSON") from the dropdown list

You retreive online quotes by opening the Price Editor (Tools->Price editor) and clicking "Get quotes". See Online Quotes for more information.

Adding an Account for the Security

With the security added to the Securities list, you must create a new account to track your holdings, go to the Chart of Accounts window.

  • Click New Account
  • In the New Account dialog, enter:
    • "Amazon.com, Inc." (or whatever description you wish) in "Account name"
    • Set Parent Account
    • "Stock" as account type
    • Click on the "Select" button for the "Security/Currency" field
    • Choose "NASDAQ" as type and "(AMZN) Amazon" as security
    • Set Parent Account to an account in the Assets branch of your chart
  • Click "Ok"

Other Accounts for Stocks

While GnuCash only requires a commodity definition and a commodity account to track investment holdings, most users will find that additional accounts are needed to track commodities.

Typically, accounts for commodity income and expense are useful for full accounting. Optionally, you can add related income and expense accounts to track dividends and expenses associated with this stock.


Stocks noted in foreign currency

If you start your first (buy) transaction from your stock account, the currency of the parent account will be used. Assuming your default currency is USD and you wish to buy stocks in EUR, then you should first create a normal asset account of currency EUR and below this your stock accounts.

Alternatively you could start your first transaction from you EUR cash or bank account, but with the first approach everything is much clearer - also later if you forgot the nominal currency.