AmiBroker - 5 Minute data format

#3
thanks...It not supposed to differ from hourly. But I think it should differ from daily as hourly data we have same date for multiple rows... The main intention i have to import yahoo data to amibroker..thanks
 
#4
Yahoo only have daily or by a trick have 1-minute data. Yahoo doesn't have 5-minute data as far as I know. But if you wanna mix daily data of Yahoo with your 5-minute data then got to your data base settings and click 'Intraday settings' and then click 'Allow mixed EOD/intraday data'
 
#5
Thank you detwo. I have changed it now. Now please look at today 5 minutes SBIN sample data. Here I would like add timestamp in it. How can i add it?



1,2015,2020,2010.35,2018,55232
2,2017.3,2020,2014,2015.65,26405
3,2022,2024,2017.2,2017.35,28244
4,2019,2022,2018.2,2022,20903
5,2018,2019.45,2014,2019.45,29113
6,2017.7,2022,2016.1,2018,14856
7,2021.45,2022,2017,2017.05,12189
7,2021,2024.95,2020.35,2021,17692

below is My daily format data which is working very fine. Now need to set for intradata..Thanks

3IINFOTECH,20120130,16.5,16.65,15.1,15.35,2600612
ABAN,20120130,443,456.5,438.25,441.5,965361
ABB,20120130,798,817.85,775.2,805.4,110570
ABBOTINDIA,20120130,1453.3,1469.45,1424,1437.7,1066
ABGSHIP,20120130,393.9,393.9,385.1,387.65,201693
ABIRLANUVO,20120130,837,852.9,799.3,802.3,136726
 
#6
Provide more info please. Did you import the 5 minute data from external file? Does the 5 minute data provide datetime info? Or is you data sample in your post taken from AA output? What is the AFL code looking like?
 
#7
Thank you. Please find the details below.

My actual data:

a1327894800,210.6,210.6,210.6,210.6,5512
2,207.6,210.4,207.5,209.6,287410
3,207.8,208.05,207.1,207.85,163131
4,208.5,208.7,207.75,207.85,153425
5,208.55,208.75,208.3,208.4,83292
6,208.9,209,208.05,208.55,103698
7,208.45,208.9,208.25,208.75,64356
8,208.6,208.8,208.15,208.45,81660
9,208.55,208.85,208.4,208.7,44222
10,208.5,208.7,208.05,208.55,58933

From the above data, I have added timestamp. Now data looks as below and this is 5 minute data. I would to import to amibroker...But i couldn't as chart looks very diff

Ticker,Date,Time,Open,high,low,close,volume

DLF,20120130,9:20 AM,209.6,210.4,207.5,207.6,287410
DLF,20120130,9:25 AM,207.85,208.05,207.1,207.8,163131
DLF,20120130,9:30 AM,207.85,208.7,207.75,208.5,153425
DLF,20120130,9:35 AM,208.4,208.75,208.3,208.55,83292
DLF,20120130,9:40 AM,208.55,209,208.05,208.9,103698
DLF,20120130,9:45 AM,208.75,208.9,208.25,208.45,64356
DLF,20120130,9:50 AM,208.45,208.8,208.15,208.6,81660
DLF,20120130,9:55 AM,208.7,208.85,208.4,208.55,44222
DLF,20120130,10:00 AM,208.55,208.7,208.05,208.5,58933

Please let me know if you need any further info
 
#8
Thank you. Please find the details below.

My actual data:

a1327894800,210.6,210.6,210.6,210.6,5512
2,207.6,210.4,207.5,209.6,287410
3,207.8,208.05,207.1,207.85,163131
4,208.5,208.7,207.75,207.85,153425
5,208.55,208.75,208.3,208.4,83292
6,208.9,209,208.05,208.55,103698
7,208.45,208.9,208.25,208.75,64356
8,208.6,208.8,208.15,208.45,81660
9,208.55,208.85,208.4,208.7,44222
10,208.5,208.7,208.05,208.55,58933
So this is from external csv or txt file right? Not from AA window of Amibroker?


Ticker,Date,Time,Open,high,low,close,volume

DLF,20120130,9:20 AM,209.6,210.4,207.5,207.6,287410
DLF,20120130,9:25 AM,207.85,208.05,207.1,207.8,163131
DLF,20120130,9:30 AM,207.85,208.7,207.75,208.5,153425
DLF,20120130,9:35 AM,208.4,208.75,208.3,208.55,83292
DLF,20120130,9:40 AM,208.55,209,208.05,208.9,103698
DLF,20120130,9:45 AM,208.75,208.9,208.25,208.45,64356
DLF,20120130,9:50 AM,208.45,208.8,208.15,208.6,81660
DLF,20120130,9:55 AM,208.7,208.85,208.4,208.55,44222
DLF,20120130,10:00 AM,208.55,208.7,208.05,208.5,58933
This is still taken from external csv or txt file but you added time and date manually into that file?

I would to import to amibroker...But i couldn't as chart looks very diff
What do you mean by "chart looks different"? Have you imported it? What is it looking different from?
 
#9
Thanks. I have created this file using the java application. Now the question is do we need to have two different database? Thanks
 

Similar threads