I do not have time to think through this thoroughly due to some personal issues, but nevertheless this is my solution.įor those who are new to the Stock Portfolio Tracker, you can make a copy of the Google Spreadsheet to start using. So I decided to put a different implementation. I tried numerous ways and was not able to resolve it. This affects all the Yahoo Data Ref, Yahoo Data Ref USD, Yahoo Data Ref HKD sheets, which is where the stocks pull the prices from. You will get a Result was not expanded automatically, please insert more rows and columns Error. I have incorporate some tips from users to improve the robustness. If you really like the below implementation, you can go ahead and change it. At cell A2, instead of using in the formula, use instead. If you want it to be more robust, go to Yahoo Data Ref, Yahoo Data Ref USD, Yahoo Data Ref HKD. What you need to know is that, if you are using an existing spreadsheet, things will go back to normal. Update (2nd April 2016): As of today, I realize that it is partly a Google Spreadsheet issue, but also my implementation of Yahoo Finance issue.

Prices at Yahoo Finance does work, it is just that the ImportData() function in Google Spreadsheet is having an issue. Problem with Price Retrieval of Yahoo Finance

This means that you either have to rely on manually entering the prices on a frequent basis, or rely on Yahoo Finance. This affected many folks including myself who rely on GoogleFinance to pull latest stock prices.

The first thing is that SGX have stopped allowing investors to use GoogleFinance() to get update to date last trading price information of their stocks. There have been some developments recently, and I would like to update the people who are supporting this Google Spreadsheet. To use it, you can tune in to the instructions here.

Download yahoo my portfolio