Tuesday, September 18, 2012

yogi_Import Spot Price Of Precious Metal Such As Gold Into Spreadsheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #760   Sep 18, 2012     www.energyefficientbuild.com.

user malthus101 said: (http://productforums.google.com/forum/?zx=xivi3b9su184#!search/spotprice/docs/-ohSz_gk1Wc/yyyK0EIXGSIJ)
Import fiance quote into spreadsheet?
Firefox/Windows 7
I need to get the spot price of gold imported into a cell in my spreadsheet.
I have searched the entire WWW and am going around in circles.
Best solution is import data from Yahoo finance (as Google finance can't do it)
The symbol is: XAUUSD=X
Please help.

following is a solution to a bit more generalized problem