Moving Intraday data from one database to another database

Hi,

I had one Manshi intraday database and it has some six months' data.
Later on I switched over to some other provider and I now only have the
latest intraday data, in another database of Amibroker.

Now, my problem is I need to get all that Manshi data into my latest
database. For this, I extracted 1-min data for a single scrip, put it in
Excel and then changed it to Amibroker format in Excel and finally made
one csv file.

The csv file's format is like this:
CAIRN,20120601,331,334.1,329.1,331.05,46963,9:15

I tried to import this file into Amibroker (by adding one more field "Time" at the
end).. the importing seems to have been done, but this data is not reflected when
I see this particular scrip's chart.

I feel that either my date or time format is wrong. Can you suggest something?

Or, is there any other easier method to import all the scrips' data in one go?

Thanks for any suggestions..

Hi Murthy,

the time field must contain the date literal as well. and not just the time!
Amibroker wont know to which day that 9:15 belong to? it would only understand if you tell it the entire information in the format
....the ones in braces are optional if your data is snapshot data of 1 minute or multiples of it.

you can try your hands on the afl link posted by Taurus in this post.

save the files in your defined directory and then re-import in your desired DB.

It is recommended to have a backup of both DBs first to avoid data loss due to any mishap.

Sudris,

Thank you very much for your help. I will verify the link given by you and post
back here, in case I get any problem.