DIET ODIN to EXCEL contd .......
13> If ODIN is not giving Last Traded Time also, then we have to use your system time to record the quotes. Type =NOW() in the "Last Traded Time" column against each scrip. That will bring system time in the excel sheet.
Select the Column for time (Column B) and Right Click, Format Cells and set format to Custom HH:MM:SS as shown in this link -
http://www.traderji.com/data-feeds/69109-free-data-nsenow-amibroker-via-excel-12.html#post676943
Find the following lines in MakeCSV subroutine -
For r = 7 To Range("A65536").End(xlUp).Row
s = Date & ","
c = 1
While Not IsEmpty(Cells(r, c))
CellValue = Cells(r, c).Value '
s = s & CellValue & "," 'Add contents of current cell to string 's' and a comma
c = c + 1
Wend
a.writeline s 'write contents of String S to the csv file.
Next r 'go to next row
Change the line in italics to
If c = 2 Then ' If it is cell in column B
CellValue = TimeValue(Now()) ' CellValue = Current time
Else
CellValue = Cells(r, c).Value 'Add contents of current cell to the variable- CellValue
End If
That will push the current system time into AmiBroker. I shall upload another excel file with necessary changes in couple of days.