How do I add the prices of commodities to my sheet?Last Updated: June 06, 2019
If you want to add the prices for common commodities (like Gold, Silver, Oil, Coffee, Sugar, etc.) you'll need to use specific tickers (found below) for each.
The tickers (in bold) for some of the most common commodities are:
- Crude Oil: CL=F
- Gold: GC=F
- Silver: SI=F
- Coffee: KC=F
- Sugar: SB=F
- Lumber: LBS=F
- Corn: C=F
If you do not see a ticker for a commodity above, it may still exist. Try searching the commodity on Yahoo! Finance then using the symbol that appears there.