How to monitor your portfolio with Google Docs - Investing Sidekick: If neither Yahoo or Google can provide the stock price you need then there are other ways to get stock prices. Any website can theoretically be called to get a price. The formula below for example will get the stock price from Bloomberg. This has the widest range of coverage that I have found.
=ImportXml(“http://www.bloomberg.com/quote/ARGO:LN”;”//div[@class=’price’]”)
Do this for each stock, putting the share prices in another column in the same row as the number of shares. If it doesn’t work, make sure you got the ticker from the same website (Yahoo/Google) as you are using in the formula.
Friday, January 13, 2017
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment