Hi
Does anyone knows where to get free End-of-Day stock's data for US markets. I would like to download it some analysis.
Thanks in advance
Xwong
Thanks JafSlow for the link. I've downloaded the software and its pretty cool. However would like to be able to have the EOD data downloaded into Excel or csv format for my study and analysis. Chartnexus will charge a fee for using their ExpertTrader module
Do you know of any other sites where US EOD data can be downloaded to csv or text format ?
Best rgds
Xwong
require(quantmod)
# symbolName <- "DJIA"
symbolName <- "SPY"
z <- get( getSymbols( symbolName, from="1900-01-01" ) )
names(z) <- c("Open", "High", "Low", "Close", "Volume", "Adjusted")
#
ahead <- 60
ord_start <- 200
ord_end <- 300
ord_step <- 50
histrows <- 180
ylow_gap <- 0.1
yhigh_gap <- 0.1
#####################
xmin <- nrow(z)-histrows
xmax <- nrow(z)
#
ords <- seq(ord_start, ord_end, ord_step)
colors <- colors()[10:(10+length(ords))]
#
plothist <- c(z[,"Close"][xmin:xmax])
plotmin <- min(plothist)-ylow_gap
plotmax <- max(plothist)+yhigh_gap
#
plot.zoo(plothist, xlim=c(time(first(plothist)), time(last(plothist)) + ahead), ylim=c(plotmin,plotmax) )
#
grid(nx=10, ny=0.05)
abline(v=last(time(z)))
abline(h=last(z[,"Close"]))
lines(z[,"Close"], col="black")
legend("topleft", legend=ords, lty=c(1,1), lwd=c(2.5,2.5), col=colors)
title(symbolName)
#
# One line for each AR-Order
#
j <- 1
for(i in ords ){
model <- ar(z[,"Close"], method='ols', aic=FALSE, order.max=i)
pred <- predict(model, n.ahead=ahead)$pred
lines(data.frame(seq(time(last(plothist)), time(last(plothist))+ahead-1, 1), pred), col=colors[j])
j <- j + 1
}
> tail(z)
Open High Low Close Volume Adjusted
2013-04-09 156.50 157.32 155.98 156.75 100805700 156.75
2013-04-10 157.17 158.87 157.13 158.67 135157000 158.67
2013-04-11 158.70 159.71 158.54 159.19 110046600 159.19
2013-04-12 158.68 159.04 157.92 158.80 116342000 158.80
2013-04-15 158.00 158.13 155.10 155.12 216691600 155.12
2013-04-16 156.29 157.49 155.91 157.41 147290700 157.41
>
Thanks nlenz ! That's exactly what I wanted !
Best rgds
Xwong
You also might want to install "R" from hiere:You must be registered for see links
After installing this software you are able to query EOD-Data from yahoo, google etc. and to implement some more or less sophisticated forecasts based on that data.
For starters here's an AR() forecast of the SPY based on EOD-Data made in R:
...
Edit: As I assume that you're interested in backtesting and strategies as well you also might want to install the "TTR" package. ( install.packages("TTR") from the R console )
That's interesting. I wonder if applying statistics to markets will give good predictions.
I read about the integration of R into MT4 by prof7bit(*) and I wondered too.
And when I finally started to do some things in R then I saw, that most of all things which I conceived as "new" were already thought of, experimented on and nicely packaged in R.
Here's for example a guy who replicates an analysis of the frequency of the log-returns to build an indicator.
You must be registered for see links
And here's the original analysis:
You must be registered for see links
(*)You must be registered for see links
World Wide Invest was established in 2009 with a vision: To provide unmatched online trading solutions to a broad range of traders and investors group around the world.