Thank you Ricardogg and Arun. I don't know how I missed that. Too many
sleepless nights perhaps. Thank you.
--
View this message in context:
http://r.789695.n4.nabble.com/as-date-do-not-know-how-to-convert-mydata-1-to-class-Date-tp4638691p4638708.html
Sent from the R help mailing list archive
I have an object, which I pull in from a csv file here
http://r.789695.n4.nabble.com/file/n4638691/jan_2011.csv jan_2011.csv
mydata <- read.csv("jan_2011.csv", header=TRUE, sep=",")
> head(mydata)
Delivery.Date Hour.Ending Repeated.Hour.Flag Settlement.Point
Settlement.Point.Price
101/01
Hi Joshua,
THank you for showing me how to use getSymbols. I am trying to follow the
example you provided. However I am having some difficulty using the various
combination of functions you have used. I tried to execute one step at a
time as follows -
I have a ticker vector that looks like the f
Hi Joshua,
Thank you for showing me how to use the getSymbols function. So I tried the
following without success -
> tickers
[1] "SPY" "DIA" "IWM" "SMH" "OIH" "XLY" "XLP" "XLE" "XLI" "XLB" "XLK" "XLU"
"XLV"
[14] "QQQ"
> str(tickers)
chr [1:14] "SPY" "DIA" "IWM" "SMH" "OIH" "XLY" "XLP" "XLE" ..
I have 2 zoo objects -
1) Interest rate spread between 10-YR-US-Treasury and 2-YR-US-Treasury
(object name = sprd)
2) S&P 500 index (object name = spy)
> str(spy)
‘zoo’ series from 1976-06-01 to 2011-03-31
Data: num [1:8791] 99.8 100.2 100.1 99.2 98.6 ...
Index: Class 'Date' num [1:8791] 2
I have the following function
myGetstockdataMySQL <- function(startdate, enddate, ticker) {
con <- dbConnect(MySQL(), user="blahblah", password="blahblah",
dbname="blahblah",
host="localhost")
rs <- dbGetQuery(con, "SELECT price.close FROM price INNER JOIN stocks ON
stocks.stock_id=price.stock_
THanks Jim. Eventually I do want to store the records in a database... so
mySQL. But right now I want to run some analytics on the data so I'm looking
for a quick and dirty solution that can give me the flexibility to extract
data on various time periods. I think a perl script that uses Text:CSV_XS
Thanks Jim for the reply. The file has 1,183,318 rows and there are 20 such
files.
Too big for R to handle?
--
View this message in context:
http://r.789695.n4.nabble.com/read-file-part-way-through-based-on-start-and-end-date-first-column-tp3391769p3392005.html
Sent from the R help mailing lis
Hello folks - I have been trying to figure this out. I have a set of very
large files that are of this format
, , , ,
1/4/1999,9:31:00 AM,blah, blah, blah
1/4/1999,9:32:00 AM,blah, blah, blah
1/4/1999,9:33:00 AM,blah, blah, blah
I want to write R code that reads only that data between a start an
Thank you all. Your solutions work. I suppose it doesnt matter whether I use
coredata or not (at least for my current purposes). I have created a
user-defined function and have saved it in a ".R" file in my current working
directory. But now I'm not sure how to invoke this function. R complains
tha
Thanks David for the reply. I just tried the following with the same result:
>library(tseries)
>tickers <- read.csv("testticker.txt", header=FALSE, sep=",")
>tickers <- tickers[1]
V1
1 XOM
2 COP
3 PBR-A
4 FFIV
5SU
6 PBR-B
> tickers$V1 <- as.character(tickers$V1)
> tickers$V1
[1] "
I am new to R so I apologize if my question is trivial. I have not been able
to figure out whether what I want to do is even possible.
I have a data frame of stock ticker symbols which I store into R space from
a txt file as follows:
tickers <- read.csv("stocks.txt", header=FALSE, sep=",")
ticke
12 matches
Mail list logo
