|
PureBytes Links
Trading Reference Links
|
Joe,
I want to thank you on this effort. I have been trying to get some
scripts/pluggin to simply read in or write out to text file within
AB. ABtool was overkill and now it's commercially available.
One question for you. Is newLine (\n) the default row seperator in
CSV file?
TIA
--- In amibroker@xxxxxxxxxxxxxxx, "joerosaka" <joerosaka@xxxx> wrote:
> Hi,
>
> As a way of saying thank you to Tomasz I decided to release
> completely free my plugin that provides table functions.
> This software is free and remain free forever.
>
> http://www.amibroker.net/3rdparty/OSAKA_103s.zip
>
> Joe R. Osaka
>
>
> OSAKA plugin read me.
> ======================
>
> OSAKA is a FREE application kit for AmiBroker.
>
>
> This FREE, OPEN SOURCE plugin provides additional functionality
to
> AmiBroker community.
>
> THE SOURCE FILES ARE AVAILABLE FROM AMIBROKER-DLL GROUP.
>
> This is FREE software and will remain FREE forever .
> Authors of FREE, open source products may use this source freely.
> Using any part of this code in any commercial product *except
> AmiBroker itself*
> IS STRICTLY PROHIBITED.
>
> AGAIN: Commercial use is PROHIBITED.
> The only exception is eventual inclusion of functions written by
me
> in AmiBroker itself
> (as a way of saying THANK YOU TOMASZ)
>
>
> Copyright (C)2003 Joe R. Osaka, Osaka developers group
>
> ================
> Version 1.0.0 - INITIAL RELEASE
> Version 1.0.1 - BUG FIX
> * bug fix in osInitialize
> * made it faster by removing extra safety checks (you can get back
> by undefining MAX_SPEED in globals.cpp)
> Version 1.0.2 - Added
> NUMBER osTabImport(STRING filename, STRING separator, NUMBER
> tableid, SkipHeader = True, MaxRows = -1 );
> - Imports table from CSV file format.
> Version 1.0.3 - Added
> // NUMBER osTabSort( NUMBER tableid, NUMBER Col1, Number Asc1 =
> TRUE, NUMBER Col2 = Null, NUMBER Asc2 = TRUE, NUMBER Col3 = Null,
> NUMBER Asc3 = TRUE, NUMBER Col4 = Null, NUMBER Asc4 = TRUE, NUMBER
> Col5 = Null, NUMBER Asc5 = TRUE )
> // Sorts table by multiple columns (from 1 to 5)
> // numeric columns are sorted numerically, strings are storted
> alphabetically (case insensitive)
>
>
> FUNCTIONS AVAILABLE
>
>
> NUMBER osInitialize()
> - initializes OSAKA plugin. You need to call it at the beginning
> of your AFL formula using OSAKA plugin
>
> NUMBER osTabCreate()
> - creates a table. Returns tableid that is used with all
> other osTab*** operations
>
> NUMBER osTabDelete( tableid )
> - deletes a table and frees memory allocated by it.
> Gets tableid as returned by osTableCreate.
>
> NUMBER osTabAddColumn(STRING colname, NUMBER coltype, NUMBER
> tableid, NUMBER strSize=10);
> - adds a column of 'colname' name and 'coltype' type
> supported types right now are: 1 - FLOAT (NUMBER) and 2 - STRING
> strSize optional parameter is used for strings only (specifies
> max. length of text field)
>
>
> NUMBER osTabSetString(STRING val, NUMBER row, NUMBER col, NUMBER
> tableid);
> - sets the value of the cell at given 'row' and 'col' to 'val'
> string value
>
> NUMBER osTabSetNumber(NUMBER val, NUMBER row, NUMBER col, NUMBER
> tableid);
> - sets the value of the cell at given 'row' and 'col' to 'val'
> number value
>
> VARIANT osTabGet(NUMBER row, NUMBER col, NUMBER tableid);
> - retrieves value of the cell at position row,col
> returns NUMBER or STRING depending on type of the column
>
>
> VARIANT osTabLoad(STRING filename, NUMBER tableid);
> - Loads binary image of the table
> File name if given without path will be stored in AmiBroker
working
> directory.
> Relative paths also refer to AmiBroker working directory
>
> VARIANT osTabSave(STRING filename, NUMBER tableid);
> - Saves binary image of the table
> File name if given without path will be stored in AmiBroker
working
> directory.
> Relative paths also refer to AmiBroker working directory
>
> NUMBER osTabExport(STRING filename, STRING separator, NUMBER
> tableid, IncludeHeader = True, MaxRows = -1, Append = False);
> - Exports table into CSV file format.
>
> NUMBER osTabImport(STRING filename, STRING separator, NUMBER
> tableid, SkipHeader = True, MaxRows = -1 );
> - Imports table from CSV file format.
>
> Note that you have to create table first and define columns via
> osTabAddColumn
> PRIOR to calling osTabImport.
> Each row of CSV file represents one row in the table.
> Data imported by osTabImport are appended to existing data
> Function returns the number of rows successfully imported
>
> NUMBER osTabSort( NUMBER tableid, NUMBER Col1, Number Asc1 = TRUE,
> NUMBER Col2 = Null, NUMBER Asc2 = TRUE, NUMBER Col3 = Null, NUMBER
> Asc3 = TRUE, NUMBER Col4 = Null, NUMBER Asc4 = TRUE, NUMBER Col5 =
> Null, NUMBER Asc5 = TRUE )
> // Sorts table by multiple columns (from 1 to 5)
> // numeric columns are sorted numerically, strings are storted
> alphabetically (case insensitive)
>
>
> ====
>
> SAMPLE CODE (for Commentary window);
>
> osInitialize();
>
> table = osTabCreate();
> osTabAddColumn( "my first column", 1, table );
> osTabAddColumn( "my second column2", 2, table, 30 );
>
> for( i = 0; i < 100; i++ )
> {
> osTabSetNumber( 200*LastValue( Random() ), i, 0, table );
> osTabSetString( "Test string (" + WriteVal(i) +") ", i, 1,
table );
> }
>
> Output = "";
> for( i = 0; i < 100; i++ )
> {
> Output = Output + osTabGet( i, 0, table ) + ", " + osTabGet( i,
> 1 , table ) + "\n";
> }
>
> Output;
>
> osTabDelete( table );
>
> "SAVE/LOAD -----";
> table2 = osTabCreate();
>
> Output = "";
> for( i = 0; i < 100; i++ )
> {
> Output = Output + osTabGet( i, 0, table2 ) + ", " + osTabGet(
i,
> 1 , table2 ) + "\n";
> }
>
> Output;
>
> "EXPORT/IMPORT/SORT -----";
> osTabExport( "test.txt", ",", table2 );
> osTabDelete( table2 );
>
> // MUST create and define columns in
> // the table prior to importing !
> table3 = osTabCreate();
> osTabAddColumn( "my first column", 1, table3 );
> osTabAddColumn( "my second column2", 2, table3, 30 );
> osTabImport("test.txt", ",", table3 );
>
> osTabSort(table3,0 ); // SORT BY FIRST COLUMN
> Output = "";
> for( i = 0; i < 100; i++ )
> {
> Output = Output + osTabGet( i, 0, table3 ) + ", " + osTabGet(
i,
> 1 , table3 ) + "\n";
> }
>
> Output;
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges & Refill Kits for Your Epson at Myinks.com
Free shipping on orders $50 or more to the US and Canada.
http://www.c1tracking.com/l.asp?cid=5705&lp=home/epson.asp
http://us.click.yahoo.com/brYXfA/_xWGAA/ySSFAA/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/
|