[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] Export full ticker list



PureBytes Links

Trading Reference Links

Thanks William, exactly what I was looking for :)


On Mon, 28 Feb 2005 23:24:37 -0500, William Peters <william@xxxxxxxxxxx> wrote:
> 
> Graham,
> 
> This jscript will export all tickers to a file and exclude composites if
> desired. Save it as a file named "ExportTickers.js" and run the
> file from Windows explorer or from AmiBroker tools menu.
> AmiBroker must be started before attempting to run this file.
> 
> /*
> **              Sample Only
> ** File:        ExportTickers.js
> ** Purpose:     Export all tickers to a text file
> ** Language:    JScript (Windows Scripting Host)
> */
> var  True = 1;
> var False = 0;
> var ExcludeComposites = False;
> var Filename = "Tickers.txt";
> var oAB = WScript.CreateObject("Broker.Application");
> var fso = new ActiveXObject("Scripting.FileSystemObject");
> var oStocks = oAB.Stocks;
> var Qty = oStocks.Count;
> var Code;
> 
> WScript.Echo("Export of ticker list started." );
> f = fso.OpenTextFile( Filename, 2,  True );
> 
> for( i = 0; i < Qty; i++ )
> {
>        Code = oStocks(i).Ticker;
>        if ( Code.substr( 0, 1 ) == "~" & ExcludeComposites == True )
>        {
>                /* Do nothing*/
>        }
>        else
>        {
>                f.WriteLine( Code );
>        }
> 
> }
> 
> f.Close();
> WScript.Echo("Ticker Export finished" );
> 
> Regards,
> William Peters (AmiBroker Group Moderator)
> www.amitools.com
> 
> Monday, February 28, 2005, 8:35:01 PM, you wrote:
> G>    I want to export a full list of tickers from AB to a txt file.
> G>  Unfortunately if running from AFL only those tickers with quotes are
> G>  included
> G>  Does anyone know how I can do this.
> 
> G>  --
> G>  Cheers
> G>  Graham
> 
> 
> Check AmiBroker web page at:
> http://www.amibroker.com/
> 
> Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> Yahoo! Groups Links
> 
> 
> 
> 
> 


-- 
Cheers
Graham
http://e-wire.net.au/~eb_kavan/


------------------------ Yahoo! Groups Sponsor --------------------~--> 
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~-> 

Check AmiBroker web page at:
http://www.amibroker.com/

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/