I try to import intraday data (15M) from *.csv using Import Wizard menu as figure shown in below.
Date Time column is like below.
The result of importing is unsuccessful, data in each bar become EOD instead of Intrady, I understand that the main problem is related to the format column, however, I don't sure which column format of this field is suitable.
Please kindly to fix this problem.
Thank you very much for the help.
As separator select "Comma or space" of Import wizard window.
Separator is ,
Date is able to import but Time is not.
I didn't found Format as DMY : HH:MM at all in column2
data is below , it should be 15m as my need.
Select Date and Time as separate columns and then select Comma or Space.
Please do it.
You should have 8 columns (9 columns if you include Open Interest).
I try but fail
Actually , I ever completed this task recently but today It is ugly import. What despite that fact that I follow as your recommended both @codejunkie or even @awilson .
What is the happen ????
@technqvi you are not reading what people have posted. @awilson gave you a screen shot and @codejunkie described exactly what to do, yet you have not followed their instructions. When you do, I suspect everything will work.
To everyone @mradtke, @codejunkie ,@awilson.
I am nervous a bit to read what you have posted. right now I can do it as your recommendation.
Always appreciated for truely great help.