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.