Hi Ravinder, in the excel sheet, what is there in column p iin sheet 'yahoo' and 'previouse day' of highlow.rar file, I can update previous day data automatically, so pls tell me wht is there in column p.