Home > Tools of the Trade > Data Sets and Feeds > Sync historical daily data from TOS or IB into Excel?

Sync historical daily data from TOS or IB into Excel?

  1. 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.

    Thanks.