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

Re: [amibroker] Export full ticker list



PureBytes Links

Trading Reference Links

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

    
  



------------------------ 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/