![]() ![]() =GOOGLEFINANCE("NYSE:ABT") -> for Abbot laborartories =GOOGLEFINANCE("NASDAQ:AAPL") -> for Apple =GOOGLEFINANCE("NASDAQ:GOOG") -> for Google =GOOGLEFINANCE("NASDAQ:MSFT") -> for Microsoft This is very helpful in getting the latest values of some NASDAQ or NYSE listed stocks. ![]() Some existing approaches Using GOOGLEFINANCE function, example: =GOOGLEFINANCE(“NASDAQ:MSFT”) This can be easily extended to solve questions on how to get the latest gold prices in India in Google Sheet or the latest price of Indian stocks or Singapore Exchange stocks. I’ll be using the example of how to get the latest gold price, silver price, and platinum price in USD in Google Sheet. In this article, I’ll be writing about how to write an AppScript that will allow you to crawl such information from some API repository and mildly mention the option to cache some data if there is a limited API call per month. To overcome this we are supposed to run awkward hacks like crawling yahoo finance pages. On the other hand, it doesn’t have as well support for other exchanges like SGX: Singapore Exchange. Google Sheet has first-class support for querying the latest values of stocks on US-based exchanges like NASDAQ or NYSE. I use Google Sheets for tracking my expenses, assets, and liabilities. Create a new script called metalsApi.gs and create a stub function.Using GOOGLEFINANCE function, example: =GOOGLEFINANCE(“NASDAQ:MSFT”). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |