Hello,
how could I transform this format of data:
<Date>, <Time>, <Open>, <High>, <Low>, <Close>, <Volume>
10/07/2008,5:39:00,1.5726,1.5726,1.5725,1.5725,0
in this one?:
<TICKER>,<PER>,<DTYYYYMMDD>,<TIME>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>,<OPENINT>
EUR.USD,1,20080710,53900,1.5726,1.5726,1.5725,1.5725,0,0
I thought in make a macro to create the new columns, but,
1)how could I fill easy thousand of rows in the first column with the content “EUR.USD”, or the second column with “1”?
2)How could I transform the date from “10/07/2008” to “20080710”?
3)How could I tranform the hour from “5:39:00” to “53900”?
Thank you very much for your help,
Caldera
Bookmarks