Hi all,
I'm interested in obtaining EOD closing prices for daily data on the S&P 500 index. Living in Europe, I have a different setup than in the US, such that any downloads from a US site seems to put all the data in one column.
I can fix this in Excel by converting the data and changing system settings, but it's out of the question to be doing that all the time and I haven't yet found a more elegant solution.
Any ideas or pointers?
Thanks in advance.
I'm interested in obtaining EOD closing prices for daily data on the S&P 500 index. Living in Europe, I have a different setup than in the US, such that any downloads from a US site seems to put all the data in one column.
I can fix this in Excel by converting the data and changing system settings, but it's out of the question to be doing that all the time and I haven't yet found a more elegant solution.
Any ideas or pointers?

Thanks in advance.