|
PureBytes Links
Trading Reference Links
|
Uenal,
Will the addition of the TABLE related commands allow tables to be
built in memory with symbol or stocknum along one access and datetime
along the other and then filling the cells with scoring or ranking
information for each member of the watchlist ?
If this were the case this would allow for in memory scoring and
ranking bar by bar which one could then sort and use a test for
driving buy/sell signals.
I assume this is not what can be done given how the AFL processor
works and that in order to do what I am suggesting one would need to
write the results out to a file in one pice of AFL and then read it
back in another.
I Look forward to your comments ...
Fred
--- In amibroker@xxxxxxxxxxxxxxx, uenal.mutlu@xxxx wrote
> Hi all,
> the recent additions to ABtool.dll include among other also
> the mentioned Table functions. Below is also an example
> on how to use the Table functions.
> UM
>
> ...
> STRING QuoteCRC32(STRING ticker, STRING fieldid,
> NUMBER sYear, NUMBER sMonth, NUMBER sDay,
> NUMBER eYear, NUMBER eMonth, NUMBER eDay);
> FieldId:
> D Date
> O Open
> H High
> L Low
> C Close
> V Volume
> I Open Interest
> Return value: CRC32 value as Hex-String, or "Error"
> Example: this calculates the CRC32 for DELL's Close prices
for
> the given date range:
> crcStr = QuoteCRC32("DELL", "C", 2000,1,1,
2003,5,2);
> Remerks: There must be at least 1 quote in the specified
date range,
> otherwise "Error" will be returned.
> Using this the quote data of a stock can be tested
for equality
> among users and databases.
>
>
> VARIANT StockPropertyGet(STRING ticker, STRING property,
NUMBER arg = 0)
> Get property type information about any ticker
> Returns: either NUMBER or STRING depending in the type of
the returned data
> (use VarGetLastType() to determine the type)
> Args:
> property can be one of the following:
> FullName
> IsIndex
> IsFavourite
> IsContinuous
> IndustryID
> MarketID
> GroupID
> WatchListBits0to15
> WatchListBits16to31
> WatchListBits32to47
> WatchListBits48to63
> Code
> Issue
> BookValue
> NominalValue
> Address
> Alias
> WebID
> FinanceYear (pass the quarter in the optional 3rd
param)
> FinanceIncome (pass the quarter in the optional 3rd
param)
> FinanceEBT (pass the quarter in the optional 3rd
param)
> FinanceEAT (pass the quarter in the optional 3rd
param)
> IsDirty
> DataSource
> DataLocalMode
> MarginDeposit
> PointValue
> RoundLotSize
> TickSize
> See ABtool_Examples.txt for an example usage.
>
> NUMBER VarGetLastType()
> Returns the type of the data returned by the last
StockPropertyGet() call as follows:
> 0 Type unknown or uninitialized yet
> 1 Number
> 2 Array (of Numbers)
> 3 String
> 4 ?
> Usually StockPropertyGet() uses only types 1 (number) and
3 (string).
> Attention: you can call this only once after each
StockPropertyGet() call.
> See ABtool_Examples.txt for an example usage.
>
>
> NUMBER TableCreate()
> Returns a table handle >= 0, else error
> This handle is required in for all operations on this table
> See TableXXX.afl for demo application.
>
> NUMBER TableColumnAdd(STRING colname, NUMBER coltype, NUMBER
tablehandle, NUMBER size = 0)
> Appends a column definition to the table definition
> ColType:
> 1 float (the default numeric data type in AB)
> 3 String (pass the size in the last optional param;
default is 128 bytes)
> 14 Int32 (signed 32 bit integer)
> more data types will soon be added
>
> NUMBER TableDataAddStr(STRING val, NUMBER row, NUMBER col,
NUMBER tablehandle)
> The cell at position row,col will be filled with the passed
string value
>
> NUMBER TableDataAddFloat(NUMBER val, NUMBER row, NUMBER col,
NUMBER tablehandle);
> The cell at position row,col will be filled with the passed
floating point value
>
> NUMBER TableDataAddInt32(NUMBER val, NUMBER row, NUMBER col,
NUMBER tablehandle);
> The cell at position row,col will be filled with the int32
representation
> of the passed floating point value (AFL does not have int32,
but float can be used)
>
> NUMBER TableExport(STRING filename, STRING seperator, NUMBER
tablehandle, NUMBER fHdrline = true)
> Seperator is the field seperator (usually the comma ",");
> fHdrLine controls whether a hdr line containing the field
names will be written to file
>
> NUMBER TableDelete(NUMBER tablehandle);
> Deletes the table from memory.
> Passing -1 deletes all tables (if any)
>
> NUMBER TableGetRowsCount(NUMBER tablehandle)
> Gets the highest filled row number
>
> NUMBER TableGetColumnCount(NUMBER tablehandle);
> Gets the number of defined columns
>
> NUMBER TableSort(NUMBER tablehandle, NUMBER col, NUMBER
fAscending = 1, NUMBER fIgnoreStrCase = 1);
> Sorts a table
>
>
> //------------------------------------------------------------------
--------
> // TableXXX.afl
>
> Filter = 1;
> AddColumn(C, "dummy");
>
> //--------------------------------------------------------------
------------------
> // TableXXX operations from within AFL:
> //
> // The table is "in-memory" only yet (visualizing will maybe
come sometime later).
> // The table can also be sorted and also be exported to a CSV
file. Excel can
> // be used to view such CSV files, or any texteditor.
> //
> // The main purpose of the TableXXX functions is for doing fast
table operations
> // programamatically from within native AFL.
> //
> // You need to save the TableHandle returned by TableCreate()
for any
> // subsequent TableXXX calls on this table.
> //
> // Column types: 1=float, 3=string, 14=int32 (more to come)
> //
> // Rows and Columns start with 0 (ZERO based)
> //
>
> // table1:
> th1 = TableCreate(); // you need to save the
returned table handle
> TableColumnAdd("A", 1, th1); // column 0 is of type float
(default type in AFL)
> TableColumnAdd("B", 3, th1); // column 1 is of type string
> TableColumnAdd("MyCol", 14, th1); // column 2 is of type int32
and has name "MyCol"
> for (i = 0; i < 10; i++) // fill the first 10 rows
> {
> flVal = 123.456 * i; // testvalue as float
>
> TableDataAddFloat(flVal, i, 0, th1); // fill cell i,0
> TableDataAddStr("Wow!", i, 1, th1); // fill cell i,1
> TableDataAddInt32(flVal, i, 2, th1); // fill cell i,2 (in
table it will become an int32)
> }
> // export table1 to a CSV file (in AB directory):
> // (omitting a hdrline is possible with the last optional param)
> TableExport("Table_Test_1a.csv", ",", th1, true);
>
>
> // table2: another table but with different field order
> th2 = TableCreate(); // you need to save the
returned table handle
> TableColumnAdd("1st col", 3, th2); // column 0 is of type
string and has name "1st col"
> TableColumnAdd("2nd", 14, th2); // column 1 is of type
int32
> TableColumnAdd("3rd", 1, th2); // column 2 is of type float
> for (i = 0; i < 25; i++) // fill the first 25 rows
> {
> flVal = 456.789 * i; // testvalue as float
>
> rc = TableDataAddStr( "bla", i, 0, th2); // fill cell i,0
> rc = TableDataAddInt32(flVal, i, 1, th2); // fill cell i,1
(in table it will become an int32)
> rc = TableDataAddFloat(flVal, i, 2, th2); // fill cell i,2
> }
> // export table2 to a CSV file (in AB directory):
> TableExport("Table_Test_2a.csv", ",", th2);
>
>
> // sorting table1 in descending order on column 2 (ie. 3rd
column; remember zero based!):
> TableSort(th1, 2, false);
> TableExport("Table_Test_1b.csv", ",", th1);
>
> // sorting table2 in descending order on column 1:
> TableSort(th2, 1, false);
> TableExport("Table_Test_2b.csv", ",", th2);
>
> // sorting table1 in ascending order on column 2:
> TableSort(th1, 2, true);
> TableExport("Table_Test_1c.csv", ",", th1);
>
> // sorting table2 in ascending order on column 1:
> TableSort(th2, 1, true);
> TableExport("Table_Test_2c.csv", ",", th2);
>
>
> // clean up:
> TableDelete(th1);
> TableDelete(th2);
> // TableDelete(-1); // deletes all tables (if any)
> //------------------------------------------------------------------
--------
>
>
> ----- Original Message -----
> From: <amibroker@xxxxxxxxxxxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Monday, May 05, 2003 3:23 PM
> Subject: [amibroker] New file uploaded to amibroker
>
>
> >
> > Hello,
> >
> > This email message is a notification to let you know that
> > a file has been uploaded to the Files area of the amibroker
> > group.
> >
> > File : /ABtool/ABtool_dll_v0_0_5_beta.zip
> > Uploaded by : anty3de <uenal.mutlu@xxxx>
> > Description : ABtool.dll AFL plugin v0.0.5 beta
> >
> > You can access this file at the URL
> >
> >
http://groups.yahoo.com/group/amibroker/files/ABtool/ABtool_dll_v0_0_5
_beta.zip
> >
> > To learn more about file sharing for your group, please visit
> >
> > http://help.yahoo.com/help/us/groups/files
> >
> > Regards,
> >
> > anty3de <uenal.mutlu@xxxx>
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get A Free Psychic Reading!
Your Online Answer To Life's Important Questions.
http://us.click.yahoo.com/cjB9SD/od7FAA/uetFAA/GHeqlB/TM
---------------------------------------------------------------------~->
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|