Simple download for past daily data in R

[jk90029]

Dear-

We know that a simplest way to download daily OHLC of MSFT, using R

install.packages("quantmod")
library(quantmod)

NY <- new.env()
tickerNY <-c("ABT" , "ABBV" , "MSFT" , "ZION" , "ZTS")
getSymbols(tickerNY, src="yahoo" , env=NY , from="2015-01-01")
NY$MSFT[,4]

will show close of MSFT.

1) Is there any other alternative way to download as above, other than R?
2) To download DowJones, SnP500, GermanDAX, FrenchCAC, what symbol is used instead of MSFT?

 

[2rosy]

Quandl.com/help/api

 

[debitspread]

2) To download DowJones, SnP500, GermanDAX, FrenchCAC, what symbol is used

Just look up the relevant tickers on Yahoo Finance and use them --

> tickers <-c("^DJI","^GSPC","^GDAXI","^FCHI")
> getSymbols(tickers,from="2015-09-01")
[1] "DJI"   "GSPC"  "GDAXI" "FCHI"
> DJI;GSPC;GDAXI;FCHI
           DJI.Open DJI.High  DJI.Low DJI.Close DJI.Volume DJI.Adjusted
2015-09-01 16528.03 16528.03 15979.95  16058.35  171390000     16058.35
2015-09-02 16058.35 16352.58 16058.35  16351.38  133480000     16351.38
           GSPC.Open GSPC.High GSPC.Low GSPC.Close GSPC.Volume GSPC.Adjusted
2015-09-01   1970.09   1970.09  1903.07    1913.85  4371850000       1913.85
2015-09-02   1916.52   1948.91  1916.52    1948.86  3742620000       1948.86
           GDAXI.Open GDAXI.High GDAXI.Low GDAXI.Close GDAXI.Volume GDAXI.Adjusted
2015-09-01   10073.74   10119.53   9928.65    10015.57    115785700       10015.57
2015-09-02   10060.31   10122.27   9962.25    10048.05     89542900       10048.05
           FCHI.Open FCHI.High FCHI.Low FCHI.Close FCHI.Volume FCHI.Adjusted
2015-09-01   4586.33   4599.23  4499.49    4541.16   138326600       4541.16
2015-09-02   4558.00   4599.76  4517.81    4554.92   103217500       4554.92

 

[jk90029]

Just look up the relevant tickers on Yahoo Finance and use them --

> tickers <-c("^DJI","^GSPC","^GDAXI","^FCHI")
> getSymbols(tickers,from="2015-09-01")
[1] "DJI"   "GSPC"  "GDAXI" "FCHI"
> DJI;GSPC;GDAXI;FCHI
           DJI.Open DJI.High  DJI.Low DJI.Close DJI.Volume DJI.Adjusted
2015-09-01 16528.03 16528.03 15979.95  16058.35  171390000     16058.35
2015-09-02 16058.35 16352.58 16058.35  16351.38  133480000     16351.38
           GSPC.Open GSPC.High GSPC.Low GSPC.Close GSPC.Volume GSPC.Adjusted
2015-09-01   1970.09   1970.09  1903.07    1913.85  4371850000       1913.85
2015-09-02   1916.52   1948.91  1916.52    1948.86  3742620000       1948.86
           GDAXI.Open GDAXI.High GDAXI.Low GDAXI.Close GDAXI.Volume GDAXI.Adjusted
2015-09-01   10073.74   10119.53   9928.65    10015.57    115785700       10015.57
2015-09-02   10060.31   10122.27   9962.25    10048.05     89542900       10048.05
           FCHI.Open FCHI.High FCHI.Low FCHI.Close FCHI.Volume FCHI.Adjusted
2015-09-01   4586.33   4599.23  4499.49    4541.16   138326600       4541.16
2015-09-02   4558.00   4599.76  4517.81    4554.92   103217500       4554.92

Thanks for the reply. It works fine.

Furthermore, would you show me exact URL address for the "relevant tickers on Yahoo Finance"?
Appreciated in advance.

 

[jk90029]

Furthermore, interested in how to get past daily data

SONY listed in Japan
Alibaba listed in China
AirFrance in France

as SamSungElectronics in
tickers <- c("005930.KS")

 

[debitspread]

It works fine.

Yes, that's why I cut/pasted directly from an R session, so there would be no question it "works."

Furthermore, would you show me exact URL address for the "relevant tickers on Yahoo Finance"?

Huh? Just look them up on the site.