How to Import Gold/Silver Spot Price Data into Google Sheets
3In this video, I show you the easiest way to import live gold and silver spot price data into your Google Sheets stock portfolio spreadsheets and trackers. This method utilizes HTML scrape formulas and does not require the need for using Google Chrome Addons or Plugins. This is the safest way to get the spot price data and protect yourself.
Gold Spot Price Formula:
=IMPORTXML("https://www.investing.com/currencies/xau-usd", "//div[@data-test='instrument-price-last']")
Silver Spot Price Formula:
=IMPORTXML("https://www.investing.com/currencies/xag-usd", "//div[@data-test='instrument-price-last']")
SUPPORT MY WORK
► Shop on Amazon: https://www.amazon.com/s?k=echo
► Coinbase: Get $10 Bitcoin FREE: https://coinbase.com/join/FUHQGL2?src=referral-link
► SwagBucks: Get $5 PayPal or Amazon FREE: https://www.swagbucks.com/profile/r_153250679?rp=1
► Robinhood: Get $5–$200 in stock FREE: https://join.robinhood.com/danielk-592e84
► Webull: Get 6-12 stocks FREE: https://a.webull.com/gzxterxUts7TssZ89U
SOCIAL LINKS
► Subscribe:
► Instagram: https://www.instagram.com/dkorecki
Finance Disclaimer:
►This is not financial advice. I am not a financial advisor. I am not suggesting or recommending you buy any of these stocks mentioned or shown in this video nor providing any financial advice of any kind. I am simply showcasing how to utilize Google Sheets more effectively. This video is meant for education and entertainment.
FTC DISCLAIMER
► Using any of my affiliate links listed above may allow me to receive a small commission.