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.

Click the 'Save Alert' button to finish.Ĭlick the 'Download' link on your portfolio page to receive an electronic document containing all of your portfolio information.To use it, you can tune in to the instructions here. Click an option such as 'Email' or 'Yahoo Messenger' to specify how you want to receive this notification.

Enter a stock symbol and a condition, such as a high or low target price, in the applicable fields. For instance, enter the amount of shares you have, the price you paid and the commission paid in the corresponding fields for each stock of interest.Ĭlick the 'Set Alerts' link on your portfolio page to watch stocks of interest you. Click the drop-down menus to add and remove fields, such as 'Symbol' and 'Currency,' and order them on your portfolio page as you prefer.Ĭlick the 'Add and Edit Holdings' link to add new stocks or edit the details of existing stocks in your portfolio. Click the 'Reorder' link and use the resulting menus to manage the order in which the stock and market indices are displayed in the list.Ĭlick the 'Add Custom View' button to customize the fields displayed on your portfolio page. Click the 'My Portfolios' tab, then click your portfolio page to display it.

Download yahoo my portfolio