Google by its nature prevent numerous ImportXML function calls from taking place often.These were successful but over time not working very well efficiently.There are people with various implementations scraping price quotes from Yahoo, Bloomberg, Morningstar and Wallstreet Journal.Now the API is available but there is also a subscription cost based on usage When Yahoo was acquired by Verizon, Yahoo also pulled the API off.Google Finance will still work for markets like Hong Kong and the USA Google Finance supported Singapore SGD stocks but Google eventually does not wish to pay SGX for the price data feed.Here are a quick summary of the problems over the years: If not, Google spreadsheet has issues handling them. Over the years, various data sources have gone dead. The problem right now is that point #2 is not working so well. Problem: Google and Yahoo Finance Data Not Working This is the three big reasons people like about it. The spreadsheet data belongs to you and do not reside on a third-party server.This means that you do not have to keep updating the spreadsheet. The data source will depend on where you source them from. The spreadsheet auto-grab the prices from Google Finance, Yahoo Finance, Bloomberg.These transactions will aggregate in summary, and you can review your average cost and how much unrealised returns, realised returns, dividends earned. This spreadsheet allows you to input each buy, sell, dividend, stock split, capital reduction transaction. For example, you would buy the MSCI World ETF IWDA every quarterly. Very likely, you would buy a single share or bond over a period. It allows you to track your stocks, bonds or other assets based on transactions.This spreadsheet is different from others in that I am using this to monitor my portfolio for the past 7 years. My stock portfolio tracker is a free Google Spreadsheet that allows you to monitor and keep track of your investments.

Bloomberg excel add in disappeared