nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to track gold and silver - coins QWin (edit)

jasonpbyu

I found a few prior discussions but they're closed, otherwise I'd post in those. One of them is linked below.

If I have some silver coins that I want to track on the SPOT price, how do I set this up? I tried setting up a new offline "asset", but obviously it isn't asking for a symbol.

If I go to the investing tab, it shows all the various stocks and funds that I have through various investing accounts, but it doesn't let me add anything in here.

I've used quicken for checking, savings and credit cards for 15+ years but never for this.

https://community.quicken.com/discussion/7945759/new-gold-and-silver-price-download

Find more posts tagged with

Accepted answers

NotACPA

Set these up in an INVESTING account, and be SURE to use the ^ as the prefix … as discussed in the thread that you posted.

Non-investment accounts (i.e., other Asset accounts) can't download investments

All comments

Larry51

I'm on a Windows platform and would love to have this functionality also…

Seems like a few more queries when the stock prices are updated…

Chris_QPW

https://community.quicken.com/discussion/comment/20410230#Comment_20410230

And paying for that service. Quote services aren't free.

waylord Hamrock

after a recent update, Quicken now uses specific symbols to track the spot prices of gold and silver. The symbols are ^XAUUSD for Gold and ^XAGUSD for Silver 1. These symbols are used to automatically update the price of Gold and Silver as an investment in Quicken 1. However, the exact source of these spot prices is not explicitly mentioned in the Quicken documentation. Lookin oon line at any given time, you can see several different bid and ask prices. Can anyone tell us exactly what is the source of the spot gold and silver prices that Quicken downloads to update those values, and how often they are updated?

Ps56k2

here - I think those symbols are only avail starting with Release - R54.9 -

in new release R54.9 - notice the "^" prefix -

What's New

Enabled access to Gold and Silver price quotes,
making it easier for customers to obtain this information using the symbols
^XAUUSD for Gold
^XAGUSD for Silver

bear85

Folks- I still am having issues automatically updating the value of my gold coins. For each type of coin, i have set up as one does for securities and use ounces as the number of shares. I use ^XAUUSD as the symbol with no success in updating the current value. I manually entered a cost when I entered them, and no automatic updates are done with ^XAUUSD OR ^XAUTUSD. Any ideas on correcting this would be appreciated.

Ps56k2

I think there are still some lingering questions -
Here is the old thread - that was closed - have asked to have it re-opened to discuss…

https://community.quicken.com/discussion/comment/20418366#Comment_20418366

Ps56k2

don't know where Quicken is getting their pricing -
but the "XA" Security entries are not a stock, but rather a Forex - foreign exchange - you can see them all in the Add Security -
the gold spot vs US Dollar - XAU-USD
ie - https://www.tradingview.com/symbols/XAUUSD/

the silver spot vs US Dollar - XAG-USD
https://www.tradingview.com/symbols/XAGUSD/

xlnja

I added ^XAUUSD and ^XAGUSD on 1/19/2024. The initial price was downloaded, but the prices have not updated since. What is going on?

NotACPA

Set these up in an INVESTING account, and be SURE to use the ^ as the prefix … as discussed in the thread that you posted.

Non-investment accounts (i.e., other Asset accounts) can't download investments

jasonpbyu

That was the trick! Thank you! It pulled the current SPOT price for it very quickly. thanks.

Ps56k2

I just did this as a sample…. setup account as Offline - Other Investments -
Already had created the special security names for the Gold and Silver - as part of Watch List -
^XAUUSD for Gold - AU -→ USD
^XAGUSD for Silver - AG —> USD

and here are some test numbers just to see how things look - didn't enter any Cost Basis numbers - left it at zero -
and would use the "shares" as the number of coins or OZs purchased ….. but all have to be the 1oz weight/size basis -
Looks interesting - may have to actually add all my Gold/Silver Eagles - and some OZ silver bars.

Ps56k2

After I setup the test account - with both Gold & Silver - for my US American Eagles -
I decided to split them and created a 2nd account - one for Silver and one for Gold - still using the same "^XA" securities as coin proxy.
Then went thru my stack and added each purchase to the transaction register….

Now I have a Register of my coins - tnx for the idea -
still have to go back and edit the details for each Buy date & cost basis -
Also need to use some "Remove Shares" for those coins given away as presents.

NotACPA

https://community.quicken.com/discussion/comment/20427589#Comment_20427589

Do you actuallly hold a position in those metals? Q doesn't download quotes unless a position is either Held or on the Watch List.

You also need to verify that in your Security List (CTRL-Y) the "Download Quotes" box is checked for each.

Ps56k2

Tools —> Security List -

xlnja

https://community.quicken.com/discussion/comment/20430826#Comment_20430826

https://community.quicken.com/discussion/comment/20430827#Comment_20430827

I have positions in those metals and both are on the watch list. I also have "Download Quotes" and "Watch List" checked for the securities and have toggled the settings after updates to see if that would work. I've also run "Correct investing price history" in Validate and Repair. Nothing works.

From the security detail view when I click More → Download historical prices, neither Gold nor Silver are in the list of securities on the "Get Historical Prices" form. @NotACPA or @Ps56k2, do you see them in that form?

NotACPA

@xlnja Will you please show us a graphic, from your file, that corresponds to what @Ps56k2 posted on 4/23?

xlnja

https://community.quicken.com/discussion/comment/20431761#Comment_20431761

@NotACPA …

Security Detail View and "Get Historical Prices" are shown below…

Ps56k2

yeah - not seeing them either ….
Wonder if that is because they are not really a stock or an index - but a FOREX - as in Foreign Exchange rate
Should be listed between the Russell and 3COM -

Ps56k2

here -

https://www.tradingview.com/symbols/XAUUSD/

digibob261

Is there anyway to have Q update the value of my gold holdings by multiplying the current quote (which I have working) by the number of ounces I hold?

Jon

It might be time to take the Windows discussion back to the Windows forum, since it seems to have stopped having anything at all to do with how this feature might work in Quicken Mac.

Ps56k2

oops … it got so far down the road- didn’t realize we were in the QMAC section …

Have to go look for the other Gold/Silver prices discussion

Have requested the discussion be split over to the QWin area …

Ps56k2

https://community.quicken.com/discussion/comment/20431992#Comment_20431992

scroll up in the discussion to see exactly how we did the exact same thing