Google Price
Many investors have their own spreadsheets for monitoring their investments. Getting prices for shares is usually the biggest problem. A number of tools exist to download share prices from Yahoo (mostly using Excel), and this is usually quite satisfactory most of the time. Occasionally, Yahoo does have problems which may last for several days, and the share prices may have doubtful validity. Share prices can usually be scraped from various alternative websites, but this is usually on a share-by-share basis and is not easy for those without significant programming skills.
Google can provide share price information for multiple shares but this is only available in Google Docs. The spreadsheet in Google Docs is very capable indeed, and is more than adequate for many people. However, Google Docs does not have the power and sophistication of spreadsheets such as Excel or LibreOffice.
This document describes a simple technique for automatically importing and refreshing share and index prices from Google Docs into Excel or LibreOffice spreadsheets, without requiring any great technical skill. Prices are automatically updated every few minutes.
Here's an example of a Google Doc which can be imported to Excel or LibreOffice:
Google can provide share price information for multiple shares but this is only available in Google Docs. The spreadsheet in Google Docs is very capable indeed, and is more than adequate for many people. However, Google Docs does not have the power and sophistication of spreadsheets such as Excel or LibreOffice.
This document describes a simple technique for automatically importing and refreshing share and index prices from Google Docs into Excel or LibreOffice spreadsheets, without requiring any great technical skill. Prices are automatically updated every few minutes.
Here's an example of a Google Doc which can be imported to Excel or LibreOffice:
This PDF document describes the process
|
|
An example using Excel
|
|
An example using LibreOffice
|
|