[Urgent!!!]How to get 1 Hr High and Low from Amibroker to Excel Sheet

DiwaliCrackers

Well-Known Member
#1
Hi Guys,

I have 1 min. data for 1 year in Amibroker data base, but to test some strategy, I need 1 hr data(High and Low) of 1 year data.

I don't want any data after 1 hr from opening for any day(Just want to filter out).

Please let me know if anybody have solution.

/Thanks
 
#2
Can you write afl code?
hh=highestsince(dayofyear() <> ref(dayofyear(),-1), h, 1);
ll=lowestsince(dayofyear() <> ref(dayofyear(),-1), l, 1);

// These 2 arrays hh & ll will contain Hi & Lo since the start of day.
// Write your code for opening a file in write mode.
// Use a for (i =0 ; i < BarCount ;i++ ) loop
// and write these values alongwith date & time if reqd to the
// file in the reqd format if the time equals to your 1hr time.
// for loop ends
// close the file.

// This file should be in your custom formula directory with the reqd data.
This is a basic idea with which you can expand.
Hope this helps. Sorry, I'm too occupied to write a code.
 

sumosanammain

Well-Known Member
#3
Hi Guys,

I have 1 min. data for 1 year in Amibroker data base, but to test some strategy, I need 1 hr data(High and Low) of 1 year data.

I don't want any data after 1 hr from opening for any day(Just want to filter out).

Please let me know if anybody have solution.

/Thanks
Make changes to your database settings---- intraday settings---- time..... and set it from and to as required
 

Similar threads