Displaying 5 results from an estimated 5 matches for "algotr8d".
Did you mean:
algotr8der
2011 Mar 20
4
read file part way through based on start and end date (first column)
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 and an end
date (data is presented from oldest at the top of the file to the most
recent at the bottom
2012 Aug 01
4
as.date: do not know how to convert 'test[1]' to class "Date"
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
1 01/01/2011 01:00 N HB_BUSAVG
2011 Apr 03
1
R-project: plot 2 zoo objects (price series) that have some date mis-matches
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] 2343 2344 2345 2346 2349 ...
> str(sprd)
?zoo? series from 1976-06-01 to 2011-03-31
2011 Mar 12
3
pass character vector in instrument field of get.hist.quote function
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=",")
tickers <- tickers[1] / the tickers are stored in the first column
>
2011 Mar 23
1
using R variables in RMySQL query
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_ID
WHERE (price.date_holding BETWEEN