Google Data Download
A representative Google URL is: http://www.google.com/finance/info?client=ig&q=LON:SSE,LON:LLOY,LON:NG which returns data like this:
// [ { "id": "3663351" ,"t" : "SSE" ,"e" : "LON" ,"l" : "1,551.00" ,"l_cur" : "GBX1,551.00" ,"s": "0" ,"ltt":"4:36PM GMT+1" ,"lt" : "Sep 13, 4:36PM GMT+1" ,"c" : "-3.00" ,"cp" : "-0.19" ,"ccol" : "chr" } ,{ "id": "8873270" ,"t" : "LLOY" ,"e" : "LON" ,"l" : "76.61" ,"l_cur" : "GBX76.61" ,"s": "0" ,"ltt":"4:35PM GMT+1" ,"lt" : "Sep 13, 4:35PM GMT+1" ,"c" : "+0.81" ,"cp" : "1.07" ,"ccol" : "chg" } ,{ "id": "688671" ,"t" : "NG" ,"e" : "LON" ,"l" : "741.50" ,"l_cur" : "GBX741.50" ,"s": "0" ,"ltt":"4:39PM GMT+1" ,"lt" : "Sep 13, 4:39PM GMT+1" ,"c" : "-1.50" ,"cp" : "-0.20" ,"ccol" : "chr" } ]
Data is returned in pseudo-JSON format (it would be true JSON but has leading // for some obscure reason). The Google URL is limited to 100 stock symbols.
Here is an Excel spreadsheet which includes a macro to show a representative way to download data.
I believe a JSON add-in is available for Excel, but did not want to force the user to download and install it, so I've decoded the JSON structure in the macro.
// [ { "id": "3663351" ,"t" : "SSE" ,"e" : "LON" ,"l" : "1,551.00" ,"l_cur" : "GBX1,551.00" ,"s": "0" ,"ltt":"4:36PM GMT+1" ,"lt" : "Sep 13, 4:36PM GMT+1" ,"c" : "-3.00" ,"cp" : "-0.19" ,"ccol" : "chr" } ,{ "id": "8873270" ,"t" : "LLOY" ,"e" : "LON" ,"l" : "76.61" ,"l_cur" : "GBX76.61" ,"s": "0" ,"ltt":"4:35PM GMT+1" ,"lt" : "Sep 13, 4:35PM GMT+1" ,"c" : "+0.81" ,"cp" : "1.07" ,"ccol" : "chg" } ,{ "id": "688671" ,"t" : "NG" ,"e" : "LON" ,"l" : "741.50" ,"l_cur" : "GBX741.50" ,"s": "0" ,"ltt":"4:39PM GMT+1" ,"lt" : "Sep 13, 4:39PM GMT+1" ,"c" : "-1.50" ,"cp" : "-0.20" ,"ccol" : "chr" } ]
Data is returned in pseudo-JSON format (it would be true JSON but has leading // for some obscure reason). The Google URL is limited to 100 stock symbols.
Here is an Excel spreadsheet which includes a macro to show a representative way to download data.
I believe a JSON add-in is available for Excel, but did not want to force the user to download and install it, so I've decoded the JSON structure in the macro.
googledatadownload.xls | |
File Size: | 53 kb |
File Type: | xls |
Data can also be imported from various sources to a Google Docs spreadsheet. Here is a discussion: http://boards.fool.co.uk/googledocs-version-12064381.aspx?sort=whole#12066131
Another interesting discussion and a portfolio tool is at: http://boards.fool.co.uk/portfolio-template-13170352.aspx?sort=whole#13170352
The Google Help for the GoogleFinance function is at: https://support.google.com/drive/answer/3093281
One problem with this Google Docs approach is that all data is updated when the spreadsheet is opened, which may take some time for a complex spreadsheet. There is no manual refresh capability
Another interesting discussion and a portfolio tool is at: http://boards.fool.co.uk/portfolio-template-13170352.aspx?sort=whole#13170352
The Google Help for the GoogleFinance function is at: https://support.google.com/drive/answer/3093281
One problem with this Google Docs approach is that all data is updated when the spreadsheet is opened, which may take some time for a complex spreadsheet. There is no manual refresh capability