Sync historical daily data from TOS or IB into Excel?

C

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.

Thanks.
 
You must log in or register to reply here.
Back
Top