Is it possible to have data from Amibroker to Excel???

[krisha0503]

Hi everybody,

I have read somewhere that slop of ADX is very interesting and important rather than only levels...

To test this, I think, I need to have data of Amibroker's chart on EXCLE.. .

I do not know is it possible or not... If possible, how? Can anyone please guide? :sos:

Thanks and Regards... :thanx:

 

[detwo]

Hi everybody,

I have read somewhere that slop of ADX is very interesting and important rather than only levels...

To test this, I think, I need to have data of Amibroker's chart on EXCLE.. .

I do not know is it possible or not... If possible, how? Can anyone please guide? :sos:

Thanks and Regards... :thanx:

Yes it's possible. There is an example in Amibroker's library.
Butyou can use exploration or backtest instead. You don't need Excel.

 

[krisha0503]

Thanks DETWO for your quick replay...

The problems are:

Amibroker's library is accessible to only registered members now....

and

I am not much familiar with Amibroker a advance level... I can use it on 'basic levels'... so back testing or exploration will become a very tough task for me...

 

[krisha0503]

Basically I want to know how much adx rising or falling...

For excample,
TATA STEEL's data

ADX for 7/04/2012 is 33.54
ADX for 7/05/2012 is 36.82 (So rise of {33.54-36.82} 3.28)[this num will be -ve]
ADX for 7/06/2012 is 37.29 (So rise of {36.82-37.29} 0.47)[this num will be -ve]
ADX for 7/09/2012 is 34.38 (So fall of {37.29-34.38} 3.01)
ADX for 7/10/2012 is 30.93 (So fall of {34.38-30.93} 3.45)
ADX for 7/11/2012 is 28.39 (So fall of {30.93-28.39} 2.54)
ADX for 7/12/2012 is 26.21 (So fall of {28.39-26.21} 2.18)

I want this data along with the data of O, H, L, C.....

How to derive such data in back test or exploration? I do not know...

I feel this can be done only in excel... That's why I would like to have data of ami broker to excel...

If some one can give me the formula to calculate ADX in excel, this will also help me out...

 

[trash]

As already been mentioned you don't need Excel. Everything can be done in Amibroker. Why do you wanna be smarter than experienced users?

periodadx = Param("period ADX", 10, 1, 300, 1);
ADX_ = ADX(periodadx);
ADXdiff = ADX_ - Ref(ADX_, -1);

SetOption("NoDefaultColumns", True);
SetSortColumns( 2 );

format = 1.2;
width = 70;

AddTextColumn(Name(),"Ticker", 1.0, colorBlack, colorGold, width);
AddColumn(DateTime(), "Date/Time", formatDateTime, colorLightGrey, colorDarkGrey, 115);
AddColumn(O, "Open", format, colorLightGrey, colorDarkGrey, width);
AddColumn(H, "High", format, colorLightGrey, colorDarkGrey, width);
AddColumn(L, "Low", format, colorLightGrey, colorDarkGrey, width);
AddColumn(C, "Close", format, colorLightGrey, colorDarkGrey, width);
AddColumn(V, "Vol", 1, colorLightGrey, colorDarkGrey, width);
AddColumn(ADX_, "ADX(" + periodadx + ")", 1.2, colorLightGrey, colorDarkGrey, width);
AddColumn(ADXdiff, "ADXdiff(" + periodadx + ")", 1.2, colorLightGrey, IIf(adxdiff >0, colorDarkGreen, colorDarkRed), width);
AddSummaryRows( 30, 1.2);

Filter = 1;

 

[deepanshah13]

Thanks a lot for the code... It will be helpful with other indicators also....

 

[krisha0503]

As already been mentioned you don't need Excel. Everything can be done in Amibroker. Why do you wanna be smarter than experienced users?

periodadx = Param("period ADX", 10, 1, 300, 1);
ADX_ = ADX(periodadx);
ADXdiff = ADX_ - Ref(ADX_, -1);

SetOption("NoDefaultColumns", True);
SetSortColumns( 2 );

format = 1.2;
width = 70;

AddTextColumn(Name(),"Ticker", 1.0, colorBlack, colorGold, width);
AddColumn(DateTime(), "Date/Time", formatDateTime, colorLightGrey, colorDarkGrey, 115);
AddColumn(O, "Open", format, colorLightGrey, colorDarkGrey, width);
AddColumn(H, "High", format, colorLightGrey, colorDarkGrey, width);
AddColumn(L, "Low", format, colorLightGrey, colorDarkGrey, width);
AddColumn(C, "Close", format, colorLightGrey, colorDarkGrey, width);
AddColumn(V, "Vol", 1, colorLightGrey, colorDarkGrey, width);
AddColumn(ADX_, "ADX(" + periodadx + ")", 1.2, colorLightGrey, colorDarkGrey, width);
AddColumn(ADXdiff, "ADXdiff(" + periodadx + ")", 1.2, colorLightGrey, IIf(adxdiff >0, colorDarkGreen, colorDarkRed), width);
AddSummaryRows( 30, 1.2);

Filter = 1;

Thanks a lot dear Trash...

As I said, I can use Amibroker at it's basic level only, and that's why I do not know how to design such AFLs...

Anyways, thanks a lot again...

 

[trash]

No problem. The reason I asked why you wanna try to be smarter is because someone as already mentioned to you that it can all be done without Excel. Then you said "I feel this can be done only in excel". That makes no sense. Listen to what people with knowledge are trying to tell you and you will be guided to the light at the end of the tunnel.