Difference between revisions of "Stocks/add stock"

From GnuCash
Jump to: navigation, search
(Adding screenshots to Adding a Security)
(Use templates for gnucash-manual and gnucash-guide.)
 
(12 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Category:Usage]]
+
[[Category:Investment Management]]
  
 
== Overview ==
 
== Overview ==
Line 10: Line 10:
  
 
;For more information, see:  
 
;For more information, see:  
:[{{URL:docs}}C/gnucash-guide/chapter_invest.html Investments] in the '''Tutorial and Concepts Guide''' and
+
:[{{URL:docs:guide}}/chapter_invest.html Investments] in the ''Tutorial & Concepts Guide'' and
:[{{URL:docs}}C/gnucash-help/acct-create.html description of the dialogs] in the '''Manual'''.
+
:[{{URL:docs:manual}}/acct-create.html Creating a New Account] in the ''Manual''.
 
;See also: [[Online Quotes]]
 
;See also: [[Online Quotes]]
  
Line 26: Line 26:
 
[[File:SecurityEditor.png]]
 
[[File:SecurityEditor.png]]
  
* In the Securities dialog, click "Add"
+
* In the Securities dialog, click '''Add'''
  
[[File:SecurityAdd.png]]
+
:[[File:SecurityAdd.png]]
  
 
* In the New Security dialog, enter:
 
* In the New Security dialog, enter:
Line 35: Line 35:
 
** "NASDAQ" in ''Type''
 
** "NASDAQ" in ''Type''
  
[[File:NewSecurity.png]]
+
::[[File:NewSecurity.png]]
  
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.
+
At this point, GnuCash has enough information to add the security, and you can click '''OK''' 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::
+
;If you want to retrieve online prices, additionally fill in the following fields:  
  
** Check "Get Online Quotes"
+
* Check "Get Online Quotes"
** Select a preference for "Type of quote source" (Single|Multiple|Unknown)  
+
* Select a preference for "Type of quote source" (Single|Multiple|Unknown)  
** Choose the preferred [[#Online_Quotes|Finance Quote]] source (e.g., "Yahoo as JSON") from the dropdown list
+
* Choose the preferred [[#Online_Quotes|Finance Quote]] source (e.g., "Yahoo as JSON") from the dropdown list
  
[[File:OnlineQuote.png]]
+
:[[File:OnlineQuote.png]]
  
You retreive online quotes by opening the Price Editor (Tools->Price editor) and clicking "Get quotes". See [[Online Quotes]] for more information.
+
To retrieve online quotes, open the Price Editor (Tools->Price editor) and click '''Get quotes'''. See [[Online Quotes]] for more information.
  
 
== Adding an Account for the Security ==
 
== 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.
+
With the security added to the Securities list, you can create a new account to track your holdings. An account for a commodity is similar to other accounts in a GnuCash book, but has settings that identify the commodity in which the account is denominated.  
  
* Click New Account
+
To add an account for a security, go to the Chart of Accounts window and click '''New'''.
  
 
* In the New Account dialog, enter:
 
* In the New Account dialog, enter:
** "Amazon.com, Inc." (or whatever description you wish) in "Account name"
+
** ''Account name'' - this can be anything you choose
** Set Parent Account
+
** ''Parent Account'' - this is commonly an Asset account for the brokerage account
** "Stock" as account type
+
** ''Account Type'' - select "Stock"
** Click on the "Select" button for the "Security/Currency" field
+
 
** Choose "NASDAQ" as type and "(AMZN) Amazon" as security
+
: [[File:NewAccount.png]]
** Set Parent Account to an account in the Assets branch of your chart
+
 
* Click "Ok"
+
** ''Security/Currency'' - Click '''Select''' to open the dialog
 +
*** In the dialog, choose "NASDAQ" as type and "(AMZN) Amazon" as security
 +
 
 +
::: [[File:SelectSecurity.png]]
 +
 
 +
** Click '''OK'''
 +
 
 +
* Click '''OK'''
  
 
== Other Accounts for Stocks ==
 
== Other Accounts for Stocks ==
Line 69: Line 76:
  
 
Typically, accounts for commodity income and expense are useful for full accounting.  
 
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.
 
  
 +
For more information, see [{{URL:docs}}C/gnucash-guide/chapter_invest.html Investments] in the ''Tutorial & Concepts Guide''
  
 
==Stocks noted in foreign currency==
 
==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.
+
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 use the EUR account as the parent account for all commodities that should be valued in EUR.
  
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.
+
Alternatively you could start your first transaction from an EUR cash or bank account, but with the first approach everything is much clearer - also later if you forgot the nominal currency.

Latest revision as of 18:23, 6 April 2023


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 & Concepts Guide and
Creating a New Account 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

SecurityEditor.png

  • In the Securities dialog, click Add
SecurityAdd.png
  • In the New Security dialog, enter:
    • "Amazon.com, Inc." in Full Name
    • "AMZN" in Symbol/abbreviation
    • "NASDAQ" in Type
NewSecurity.png

At this point, GnuCash has enough information to add the security, and you can click OK 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
OnlineQuote.png

To retrieve online quotes, open the Price Editor (Tools->Price editor) and click Get quotes. See Online Quotes for more information.

Adding an Account for the Security

With the security added to the Securities list, you can create a new account to track your holdings. An account for a commodity is similar to other accounts in a GnuCash book, but has settings that identify the commodity in which the account is denominated.

To add an account for a security, go to the Chart of Accounts window and click New.

  • In the New Account dialog, enter:
    • Account name - this can be anything you choose
    • Parent Account - this is commonly an Asset account for the brokerage account
    • Account Type - select "Stock"
NewAccount.png
    • Security/Currency - Click Select to open the dialog
      • In the dialog, choose "NASDAQ" as type and "(AMZN) Amazon" as security
SelectSecurity.png
    • Click OK
  • 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.

For more information, see Investments in the Tutorial & Concepts Guide

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 use the EUR account as the parent account for all commodities that should be valued in EUR.

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