On Tue, Jan 26, 2016 at 6:16 AM, Christofer Bogaso <bogaso.christo...@gmail.com> wrote: > Hi dear, > > I was trying to download a Google TS data directly onto R from this link : > > https://www.google.com/finance?q=NSE%3ALIQUIDBEES&ei=xlGnVuiPJ9eDuQSZ05OICw > > Used following function, however R generates error. > >> library(quantmod) >> getSymbols(Symbols = "LIQUIDBEES", src = "google") > Error in download.file(paste(google.URL, "q=", Symbols.name, "&startdate=", : > cannot open URL > 'http://finance.google.com/finance/historical?q=LIQUIDBEES&startdate=Jan+01,+2007&enddate=Jan+26,+2016&output=csv' > In addition: Warning message: > In download.file(paste(google.URL, "q=", Symbols.name, "&startdate=", : > cannot open: HTTP status was '404 Not Found' > > Could you please guide me how can I download that data directly to R? > I have also tried with Yahoo finance data, but got the same error. > There's no data available for download. Compare with: https://www.google.com/finance/historical?q=NYSEARCA%3ASPY
That page has a "Download to spreadsheet" link. The page for LIQUIDBEES does not. So you have to scrape the data from the HTML. > Thanks for your help. > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. -- Joshua Ulrich | about.me/joshuaulrich FOSS Trading | www.fosstrading.com R/Finance 2016 | www.rinfinance.com ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
