|
PureBytes Links
Trading Reference Links
|
Hi Um,
First of all, thank you very much for this tool. I think it's a great
addition.
Is there a way to retrieve a value of a specific cell once you've done a
sort?
Thanks,
Stewart
----- Original Message -----
From: <uenal.mutlu@xxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Monday, May 05, 2003 3:44 PM
Subject: [amibroker] Additions to ABtool v0.0.5 beta
> 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@xxxxxxxxxxx>
> > 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@xxxxxxxxxxx>
>
>
>
>
> 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/
>
>
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Make Money Online Auctions! Make $500.00 or We Will Give You Thirty Dollars for Trying!
http://us.click.yahoo.com/KXUxcA/fNtFAA/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/
|