|
PureBytes Links
Trading Reference Links
|
Thanks Again!!
----- Original Message -----
From: <uenal.mutlu@xxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Monday, May 05, 2003 8:53 PM
Subject: Re: [amibroker] Additions to ABtool v0.0.5 beta
> Hi Stewart,
> thx; just added that functionality.
> Just uploaded v0.0.6beta.
> UM
>
>
> ----- Original Message -----
> From: "Stewart" <stewart@xxxxxxxxxxxxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Monday, May 05, 2003 6:09 PM
> Subject: Re: [amibroker] Additions to ABtool v0.0.5 beta
>
>
> > 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 ---------------------~-->
Rent DVDs Online - Over 14,500 titles.
No Late Fees & Free Shipping.
Try Netflix for FREE!
http://us.click.yahoo.com/YoVfrB/XP.FAA/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/
|