EOD Futures Data in Excel

Discussion in 'Data Sets and Feeds' started by GiantHogweed, Aug 31, 2014.

  1. Anyone know of an Excel add-in that will pull EOD data in with a function? XLQ will do this for stocks, as will Quandl, but Quandl does not always update quickly.

    The websites I use to get settlement prices from, tend to update around 7PM eastern every day. So I need a source that updates at that time and would just require me to open the excel file instead of manually typing in prices.
     
  2. Butterfly

    Butterfly

    There was one guy who built an Excel function to download all prices from yahoo, free.

    Let me see if I can find the URL of that guy blog website with the XLS file for price download
     
  3. Butterfly

    Butterfly

    I am assuming this is for US Equities, right ?
     
  4. Sorry, I am looking for US futures EOD data. XLQ already has equities and works well, but I am hoping that somebody has done the same for futures....
     
  5. Butterfly

    Butterfly

    if it has a ticker, could be available with Yahoo
     
  6. Here you can see how to download futures data directly into Excel without manually typing the prices day by day. The data on this site is not for free, however, it seems that there is a free demo available.