How to get the latest commodity pricing in Google Sheet

Minhaz
CodeX
Published in
5 min readMay 31, 2022

--

Google sheet has easy macros to get price of US stocks and currency, but not for gold or silver. Here’s easy & free trick to get latest prices!

Screenshot of Google Sheet by Author using a custom hand written function.

I use Google Sheets for tracking my expenses, assets, and liabilities. Google Sheet has first-class support for querying the latest values of stocks on US-based exchanges like NASDAQ or NYSE. On the other hand, it doesn’t have…

--

--

Minhaz
CodeX

Senior Software Engineer @Google. Leading teams democratising On device AI for for masses. Writes about programming generics & specifics.