Sync historical daily data from TOS or IB into Excel?

Discussion in 'Data Sets and Feeds' started by Cyrix, Aug 30, 2011.

  1. Cyrix


    I want to create an Excel spreadsheet with dates (from today going about a year back) in the first column and 10 tickers in the first row.

    I am looking for a way to make it so that everyday I open the spreadsheet the cells will automatically download the prices for the corresponding ticker and date and as a result I will have updated time series' of the 10 tickers.

    I have TOS and IB. Is there any link/programming tool/DDE that allow me to do this? I googled but could only find TOS DDE for last price but not historical prices.