8

I am an avid Quicken user, and I have pretty much every account, investment, liability, and asset tracked in it. I recently started purchasing gold and silver as an alternative, "backup" investment, and I'm not really sure how to track that in Quicken. Is there an official way to do such a thing?

When I try to add a new investment, the only options are:

  • Standard Brokerage
  • IRA or Keogh Plan
  • 401(k) or 403(b)
  • 529 Plan

I don't think any of these fit the bill for a commodity investment. None of the other account types, such as a normal savings account, really seem to have an adequate way to track the value of the commodity and adjust the balance of the account. I'm not really sure if a commodity investment works as an asset?

Is there an official way to track commodity investments in Quicken? If not, what would the best approach be?

UPDATE:

Here is more specifically what I would like to do. As I understand it, gold can be viewed as any other "stock" or "index", wherein you have shares, value, and a cost basis. I would like to create a "gold investment" account, wherein I can track the value of my gold "shares"...i.e. the actual amounts of gold I have in weight by ounces, as well as the cash value cost basis of the account. I've been trying to do this with a "standard brokerage" investment, however I have not had much luck yet (which is partly due to the fact that I can't seem to find a decent index that tracks the "USD value" of gold in ounces.) I don't need 100% accuracy, however I would like to have some basic, automatic tracking of my gold and silver investments based on an index of some kind.

One of the indexes I have looked at is the Kitco Gold Index (KGX), which aims to provide a more real-world "actual value" index of gold per ounce. This index doesn't seem to be tracked via the KGX ticker on anything that Quicken has access to, though. The normal GLD ticker does not seem to directly reflect the USD value of gold.

jrista
  • 626
  • 1
  • 6
  • 13

4 Answers4

5

I would track it using a regular asset account. The same way I would track the value of a house, a car, or any other personal asset.

ETA:

If you want automatic tracking, you could set it up as a stock portfolio holding shares of the GLD ETF. One share of GLD represents 1/10 ounce of gold. So, if you have 5 ounces of gold, you would set that up in Quicken as 50 shares of GLD.

Eric Petroelje
  • 2,842
  • 1
  • 21
  • 19
2

You don't need to use a real stock like GLD. You can just create a "stock" called something like "1 oz Gold" and buy and sell them as if they were shares. It won't auto-update the price like GLD, but that's not a big deal to update manually once a month or so. I prefer to have accurate data that is correct at a particular point in time to having data that is 2-3% off, or that requires entering the ounces as 10x reality. YMMV.

This is very similar to how you track US Savings Bonds in Quicken (and might be described in the help under that topic.)

Scott McIntyre
  • 714
  • 4
  • 7
1

If you don't need 100% accuracy then GLD and SLV will work fine. Over the long-term these converge quite nicely with the price of the metal.

Jim
  • 178
  • 1
  • 8
0

I was able to find a fairly decent index that trades very close to 1/10th the actual price of gold by the ounce. The difference may be accounted to the indexes operating cost, as it is very low, about 0.1%. The index is the ETFS Gold Trust index (SGOL).

By using the SGOL index, along with a Standard Brokerage investment account, I was able to set up an investment that appropriately tracked my gold "shares" as 10x their weight in ounces, the share cost as 1/10th the value of a gold ounce at the time of purchase, and the original cost at time of purchase as the cost basis. There tends to be a 0.1% loss every time I enter a transaction, I'm assuming due to the index value difference against the actual spot value of the price of gold for any day, probably due to their operating costs.

This solution should work pretty well, as this particular index closely follows the gold price, and should reflect an investment in gold over a long term very well. It is not 100% accurate, but it is accurate enough that you don't lose 2-3% every time you enter a new transaction, which would skew long-term results with regular purchases by a fair amount.

jrista
  • 626
  • 1
  • 6
  • 13