Simple way to get daily data for roughly 400 equities?

Discussion in 'Data Sets and Feeds' started by jk90029, Apr 26, 2015.

  1. jk90029

    jk90029

    Dear-

    There are many ways to retrieve historical data, e.g. yahoo.com or google.com.

    I wonder if we can make OUTPUT file of last 1200 days and 400 equities, with 1200 rows and 400 columns, given the INPUT file (symbols of TAB format) as attached below.

    Therefore the TAB text with name dataC.txt will dimension 1200 rows and 400 columns(symbols can be changed by any trader) with first row for yesterday

    Likewise, dataO.txt has daily open, dataH.txt has daily high and dataL.txt has daily low.

    PS) Please do NOT recommend me time-consuming 400 typings in each chart separately.

    PS) IB API / Python / R might be OK as well as Excel.
     
    Last edited: Apr 26, 2015
    #1     Apr 26, 2015
    Share
  2. abattia

    abattia

    NinjaTrader ( www.ninjatrader.com ) + coding in "ninjascript"(i.e. C#) + Yahoo or Google finance ...
     
    #2     Apr 27, 2015
    Share
  3. 2rosy

    2rosy

    You can get the data from quandl. They have a few apis available
     
    #3     May 5, 2015
    Share
  4. jk90029

    jk90029

    Thanx for both.
     
    #4     May 5, 2015
    Share