Simple download for past daily data in R

Discussion in 'Data Sets and Feeds' started by jk90029, Sep 3, 2015.

  1. 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?
     
  2. 2rosy

    2rosy

    Quandl.com/help/api
     
  3. Just look up the relevant tickers on Yahoo Finance and use them --
    Code:
    > 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
    
     

  4. 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.
     
  5. 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")
     
  6. Yes, that's why I cut/pasted directly from an R session, so there would be no question it "works."

    Huh? Just look them up on the site.