AddRow() function (vrs. 5.91)

[fxshrat]

Official info at AmiBroker.com:
www.amibroker.com/guide/afl/addrow.html
www.amibroker.com/devlog/wp-content/uploads/2015/02/readme5910.html

One useful advantage of AddRow in comparison to AddColumn is that for example you can now output 3rd dimension of multi-dim array one below the other instead of side by side.

Example:

With AddColumn it would look like this for example
AddColumn table
So here each weekday output is 3rd dimension and it is only possible to output side by side which is not very friendly view since for example if you change to lower time frame than the columns number doubles, triples, and so on. So you have to scroll, scroll and scroll side ways.

Now thanks to AddRow function every "page" is one below the other one which provides better comparable view on top of that.
AddRow table

I hope that once Tomasz will have added color option to AddRow it will be possible to make it like this
AddRow table colored
which is more eye friendly (-> filtering infos via color) than just black on white.

[fxshrat]

Here is some info from AB in regards to AddRow:

1. If your formula output is solely based on using AddRow (no Addcolumn output) then you should set Filter to zero -> Filter = 0;
Otherwise you will get n-th null lines per symbol depending on set range.

2. For text columns use i.e.

AddTextColumn( "", "Symbol", 1, colorDefault, colorDefault, 70 );

and for numeric columns use i.e

AddColumn( Null, "Value", 1, colorDefault, colorDefault, 70 );

to set columns.

Examples can be found here amibrokerforum.proboards.com/thread/7/addrow-function-min-ab-vrs

[andwilson]

Hi fxshrat, thanks for sharing your ideas about AddRow, very interesting!

[fxshrat]

Here is another example showing what AddRow() could be used for and is supposed to be food for coding thoughts.
(Such output can not be done in similar way via AddColumn, so the pics show output solely based on Addrow. Addcolumn is used only for Column creation. So it means: Filter = 0;)

In that example there are being compared four indicators one below the other one.
As picture shows, first dimension is bar of array, second dimension is indicator period (columns), 3rd dimension is indicator version.
Main functions been used: VarSetText/VargetText, Matrix, Addrow/Addcolumn, indicator functions etc.
First loop iterating ma versions, second loop iterating mat columns, and two loops iterating partial array.

full postimg.org/image/3wyns0zeh/full/



Now, a little bit more trickier version adds another dimension -> multi time frames of the indicators being compared.
(Yes, picture is showing just one single result list output!)

AddRow is quite some fun, isn't it?

full postimg.org/image/frg0otkdr/full/

[fxshrat]

And another example on how one may present data via AddRow().
This time some ordinary bar pattern matrix (but it could be any condition output really!).


1st picture presenting time frame blocks



2nd picture sorting the same output by bar of base time interval.
You possibly ask yourself how to extract the time info from datetime (as seen in second picture below).
It is pretty simple:


timestr = DateTimeToStr( /*your datetime value here*/, mode = 2 );

Datetimestr provides an appropriate second argument where mode being set to 2 extracts the time info.
See www.amibroker.com/guide/afl/datetimetostr.html

[fxshrat]

Here is just a another output suggestion of getting volume at price histogram data of visible chart area to exploration.

[fxshrat]

Another example, output of calculated pivot tables (ALL calculations were done in AmiBroker of course).

i.imgur.com/GfORSFU.png


For comparison same source applied in Excel

i.imgur.com/I1HC4Qv.png

[edi]

Thanks fxshrat, thanks for sharing this post about AddRow, very useful , so many things to learn ..