mate, I am not sure why you have to use excel and how the real time data was feed into excel. there is no free program for this check metastock they have real data pacakge for you however cost you XXX to get it. If you don't care then you find the solution.