|
PureBytes Links
Trading Reference Links
|
save as makeyourownname.js
This is a text file that can run under windows script.
Just remember to change the path and file name within the script to
match the CSV data file
var filename = "C:\\Program Files\\Amibroker\\Scripts\\Industries.csv";
On 6/13/05, Dennis And Lisa <dennisandlisa@xxxxxxxxxxxxx> wrote:
> Thank you Graham.....if I copy the file below to MS Notepad, under
> what file type and extension do I save it. And after I save it, will
> it be automatically executable?
>
> thank you
> -Dennis
>
>
>
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, Graham <kavemanperth@xxxx> wrote:
> > you could write a format file like the ascii import files and import
> > the data that way
> > See AB subdirectory "\formats" and in help screens - Reference Guide -
> > Ascii Import Reference and Automation Object Model
> > Just set up a format file and try importing via ascii import
> > Else write a script file based on the Industry import JS file and
> > include the other information
> >
> > Something like this changed from the industries import JS file to
> > include markets and groups. The sectors-industries arrangement should
> > be set with the broker.industry and broker.sector files.
> > The JS file below runs from windows with your AB databse open. CSV
> > file as per this has each row with :
> > Ticker,FullName,Market,Group,Industry
> >
> > I have not tested this file below, so may have type or syntax errors.
> > but should be enough for a start. As it turns out I have been thinking
> > along lines of this for setting level 3 subindustires into the groups
> > as the sector only allows single level industry.
> >
> >
> > /* change this line according to your data file name */
> > var filename = "C:\\Program Files\\Amibroker\\Scripts\\Industries.csv";
> > var fso, f, r;
> > var ForReading = 1;
> > var AmiBroker;
> > var fields;
> > var stock;
> > /* Create AmiBroker app object */
> > AmiBroker = new ActiveXObject( "Broker.Application" );
> > /* ... and file system object */
> > fso = new ActiveXObject( "Scripting.FileSystemObject" );
> > /* open ASCII file */
> > f = fso.OpenTextFile( filename, ForReading);
> > /* read the file line by line */
> > while ( !f.AtEndOfStream )
> > {
> > r = f.ReadLine();
> > /* split the lines using comma as a separator */
> > fields = r.split(",");
> > /* add a ticker - this is safe operation, in case that */
> > /* ticker already exists, AmiBroker returns existing one */
> >
> >
> > stock = AmiBroker.Stocks.Add( fields[ 0 ] );
> > stock.FullName = fields[ 1 ];
> > stock.MarketID = parseInt( fields[ 2 ] );
> > stock.GroupID = parseInt( fields[ 3 ] );
> > stock.IndustryID = parseInt( fields[ 4 ] );
> > }
> > /* refresh ticker list and windows */
> > AmiBroker.RefreshAll();
> > WScript.Echo("Industry Setup Finished" );
> >
> >
> >
> >
> > On 6/13/05, Dennis And Lisa <dennisandlisa@xxxx> wrote:
> > > Is there a way I can get the most current stock info containing
> > > MARKET, SECTOR, INDUSTRY, GROUP info in the CSV file to be read by the
> > > java script "Industries" and imported into Amibroker. I have the most
> > > current version of Amibroker, and I use Yahoo for quotes that go into
> > > my US Stocks folder. My Categories are as follows:
> > >
> > > Market :
> > > 0 = Undefined
> > > 1=NYSE
> > > 2=AMEX
> > > 3=Nasdaq
> > > 4=OTC
> > > 5=Mutual Funds
> > >
> > > Groups:
> > > 0=undefined
> > > 1=stocks
> > > 2=mutual funds
> > > 3=futures(cash)
> > > 4=futures(commodity)
> > > 5=indecies
> > >
> > > Sectors:
> > > 0=undefined
> > > 1=capital goods and services
> > > 2=consumer cyclical
> > > 3=consumer staples
> > > 4=energy
> > > 5=financial
> > > 6=health care
> > > 7=information
> > > 8=internet
> > > 9=materials
> > > 10=retail
> > > 11=transportation
> > > 12=utilities
> > > 15=medai
> > > 16=banks and finance
> > > 17=insurance
> > > 18=telecommunications
> > > 19=investemt and finance services
> > > 20=property trusts
> > > 21=healthcare and biotechnology
> > > 22 =miscellaneous inductries
> > > 23=diversified industries
> > > 24=tourism and leisure
> > > 25=debt issuer
> > >
> > > Industries:
> > > 0= undefined
> > > 1=aerospace-defence
> > > 2=aerospace defence eqp+
> > > 3=bus-serv-education+
> > > etc,etc,etc
> > >
> > > Please help and thank you
> > > Dennis
> > >
> > >
> > >
> > >
> > >
> > >
> > > Please note that this group is for discussion between users only.
> > >
> > > To get support from AmiBroker please send an e-mail directly to
> > > SUPPORT {at} amibroker.com
> > >
> > > For other support material please check also:
> > > http://www.amibroker.com/support.html
> > >
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> > --
> > Cheers
> > Graham
> > http://e-wire.net.au/~eb_kavan/
>
>
>
>
>
> Please note that this group is for discussion between users only.
>
> To get support from AmiBroker please send an e-mail directly to
> SUPPORT {at} amibroker.com
>
> For other support material please check also:
> http://www.amibroker.com/support.html
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
--
Cheers
Graham
http://e-wire.net.au/~eb_kavan/
------------------------ Yahoo! Groups Sponsor --------------------~-->
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~->
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For other support material please check also:
http://www.amibroker.com/support.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/
|