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!

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 as well support for other exchanges like SGX: Singapore Exchange.

To overcome this we are supposed to run awkward hacks like crawling yahoo finance pages.

In this article, I’ll share about how to write an AppScript code that will allow you to crawl such information from certain API repositories. Some of these API services only provide limited API call per month —so we shall look at the caching approach as well.

I’ll be using the example of

This can be easily extended to solve questions on how to get the latest gold prices in India or the latest price of Indian stocks or Singapore Exchange stocks.

There is a macro in Google Sheets, called =GOOGLEFINANCE(). You can use it to get latest price Microsoft stock listed on Nasdaq with =GOOGLEFINANCE("NASDAQ:MSFT"). Here are some more examples

Related posts:

Sounds like this video platform would save your time! It actually does… And understand how this works? The short-stories platform is a semi-melted cheese sandwich that you’d wish to taste with Warm…

untuk program sederhana, web mampu menyalakan kipas. untuk project ini LED dianggap kipas. berikut ini yang diperlukan: eksperimen dengan menggabungkan keduanya. web page akan menampilkan bacaan…

From the beginning of life, we have to face different type of problems but the main thing is that how we overcome these challenges?. How we behave when we have such type of problems? I have decided…