How to insert live spot silver price???

[daniel_the_doctor]

I am trying to manage my precious metals with excel, but when i go to insert a web query i get a script error. Anyone now how to fix this? Its quite urgent and i would appreciate any insight.

[mainemojo]

Look at this link. http://www.marketindex.com.au/yahoo-finance-api Using the web query button seems to have its own issues. Hopefully, this works for you! Look about half way down the page. They have an Excel file you can download, put in your ticker symbols, and it'll download the info directly from Yahoo finance.

[daniel_the_doctor]

thank you so much!