CodeX
Published in

CodeX

How to get the latest commodity pricing in Google Sheet

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…

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Minhaz

Minhaz

4.2K Followers

Senior Software Engineer @Google. Leading team democratising computational photography for masses. Writes about programming generics & specifics.