[R-SIG-Finance] [R-sig-finance] Downloading data from specific website
Gabor Grothendieck
ggrothendieck at gmail.com
Sun Jun 21 17:32:43 CEST 2009
On the datasets page right click e2.dat and choose Copy Link Location
or Copy Shortcut depending on which browser you use. Then paste
that into your text editor.
On Sun, Jun 21, 2009 at 4:05 AM, Bogaso<bogaso.christofer at gmail.com> wrote:
>
> Thanks everyone it is working. However interested to know, how you define the
> URL i.e. "http://www.jmulti.de//download/datasets/e6.dat"?
>
> If I go 1st "http://www.jmulti.de" and then click on "Datasets" and then
> "Download data, 2nd link", I see no change in the address bar. What is the
> magic here? Can you please clarify me? If I choose to go with "Download
> data, 1st link" then what would be the strategy?
>
> Thanks and regards,
>
>
>
> Gabor Grothendieck wrote:
>>
>> Try this. First we read in the entire page line by line into Lines
>> and find the index, ix, of the line starting with <. st is its
>> value as a character string after stripping off junk. Then we
>> re-read the page from the text we already downloaded but this
>> time as a table skipping the first ix lines and finally we
>> convert it to zoo using as.yearqtr(st) as the start quarter.
>>
>>> library(zoo)
>>> URL <- "http://www.jmulti.de//download/datasets/e6.dat"
>>> Lines <- readLines(URL)
>>> ix <- grep("^<", Lines)
>>> st <- sub("[<> ]", "", Lines[ix])
>>> DF <- read.table(textConnection(Lines), skip = ix, header = TRUE)
>>> z <- zooreg(as.matrix(DF), start = as.yearqtr(st), freq = 4)
>>> head(z)
>> Dp R
>> 1972 Q2 -0.003132580 0.083
>> 1972 Q3 0.018871300 0.083
>> 1972 Q4 0.024803600 0.087
>> 1973 Q1 0.016277600 0.087
>> 1973 Q2 0.000289679 0.102
>> 1973 Q3 0.016829000 0.098
>>
>> On Thu, Jun 18, 2009 at 3:58 PM, Bogaso<bogaso.christofer at gmail.com>
>> wrote:
>>>
>>> Hi,
>>>
>>> I need to download some econometric data from http://www.jmulti.de/
>>> The path is :
>>> Datasets -> Download data (2nd link) -> e6.dat
>>>
>>> I prefer the downloaded data as a zoo object. How can I develop some R
>>> function to do that? Your help will be highly appreciated.
>>>
>>> Regards,
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Downloading-data-from-specific-website-tp24099586p24099586.html
>>> Sent from the Rmetrics mailing list archive at Nabble.com.
>>>
>>> _______________________________________________
>>> R-SIG-Finance at stat.math.ethz.ch mailing list
>>> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
>>> -- Subscriber-posting only.
>>> -- If you want to post, subscribe first.
>>>
>>
>> _______________________________________________
>> R-SIG-Finance at stat.math.ethz.ch mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
>> -- Subscriber-posting only.
>> -- If you want to post, subscribe first.
>>
>>
>
> --
> View this message in context: http://www.nabble.com/Downloading-data-from-specific-website-tp24099586p24132322.html
> Sent from the Rmetrics mailing list archive at Nabble.com.
>
> _______________________________________________
> R-SIG-Finance at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
> -- Subscriber-posting only.
> -- If you want to post, subscribe first.
>
More information about the R-SIG-Finance
mailing list