|
PureBytes Links
Trading Reference Links
|
Thanks again Stefan, Dingo already gave me the pointer to these
scripts; I think it'll make it :-)
Anyway, as you asked the question, i'll just try to explain a little
bit what I'm trying to do..
I have imported in AB many warrants; I don't want to put them in
their "real" industries and for... hum... probably bad reasons, I
can't let these stocks assigned to the default industry since some
of my customed indicators use this default industry for... ahem... a
reason I'm not sure to remember exactly quite now !!
Anyway, my idea was then to move all these warrant tickers from
default industry to a new 'Warrant' pseudo-industry. As simple as
that on the paper, more painful in reality ;-)
But, as there is always a benefit from any problem, this will force
me to take a deeper look at scripting with AB; this could be
probably very helpful in the future :)
Thanks again for your help :)
Regards,
Jean-Yves
--- In amibroker@xxxxxxxxxxxxxxx, "sgfuchs" <sgfuchs@xxxx> wrote:
> Jean-Yves,
>
> a question : what exactly are you trying to achieve - do you want
> simply a composite index or are these 250 French stocks really from
> only one real industry group ?
>
> If thats the case, the easiest way would of course be, to rename
your
> watchlist according to the industryname - :-) just kidding
>
> You could use i.e. the addtocomposite functions if you just need an
> average index.
>
> Recommended reading :
> http://www.amibroker.net/3rdparty/IntroToAtc.pdf
>
> Else maybe you find the following helpful from the AB helpfiles :
>
> "4 Tip of the week: : How to automate assigning stocks to
> sectors/industries ?
>
> Note: This functionality is available only in Windows version of
> AmiBroker
>
> In the first issue of AmiBroker Tips newsletter AmiBroker I
discussed
> using of AmiBroker's OLE automation interface for accessing stock
> data. In this article I will give you another example of
automation:
> assigning stocks to industries using simple JScript. For starters I
> recommend reading the first article before proceeding with this
one.
>
> First we should set up our sectors and industries using
> Stock->Categories window. The difference between a sector and an
> industry is that industries "belong" to sectors, for example: "Air
> Courier", "Airline", "Railroads", "Trucking" industries belong to
> "Transportation" sector. So an assignment to an industry implicts
> assignment to a sector. If you don't want to have detailed
industries
> you can just assign first 32 industries to 32 sectors on one-by-one
> basis.
>
> Now let's suppose that we have a text file that contains tickers,
full
> company names and a industry number. Industry number should
correspond
> our settings in Categories window. A sample file would look like
this:
>
> ELM,ELINK MEDIA LIMITED,0
> GCN,GOCONNECT LIMITED,0
> SGN,SINGLETON GROUP LIMITED,1
> AHH,AGRO HOLDINGS LIMITED,1
> ATP,ATLAS PACIFIC LIMITED,1
> AFF,AUSTRALIAN FOOD & FIBRE LIMITED,1
> ASR,AUSTRALIAN RURAL GROUP LIMITED,1
> ARP,ARB CORPORATION LIMITED,2
> ATL,AUTO ENTERPRISES LIMITED,2
> ALO,AUTO GROUP LIMITED,2
> BER,BERKLEE LIMITED,2
> ADB,ADELAIDE BANK LIMITED,3
> ANZ,AUSTRALIA & NEW ZEALAND BANKING GROUP LIMITED,3
> BOQ,BANK OF QUEENSLAND LIMITED.,3
> BWA,BANK OF WESTERN AUSTRALIA LIMITED,3
>
>
> and our Categories are set up so sectors and industires have
> one-to-one relationship with the following (zero-based) numbering
0 -
> "Advertising & Marketing", 1- "Agriculture & Related Services", 2-
> "Automotive & Related Services" and 3- "Banking".
>
> The script for importing the data file will look like this:
>
> /* change this line according to your data file name */
> var filename = "industry_data.txt";
>
> 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.IndustryID = parseInt( fields[ 2 ] );
>
>
> }
>
> /* refresh ticker list and windows */
> AmiBroker.RefreshAll();
>
> The whole thing is just reading the file line by line and assigning
> the fields to properties of stock automation object. It's so simple
> :-). The only thing that you might want to change is the name of
the
> file with a data - my example uses "Industry_data.txt" file name
but
> this can be changed according to your naming convention. A complete
> script could be found here and a sample data file is here.
>
> .... and that's all for this week - hope you enjoyed reading "
>
> regards
> Stefan
>
>
> --------------------------------------------------
> ------------------------------
>
>
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "Jean-Yves" <jean-
yves.casalis@xxxx>
> wrote:
> >
> > Thanks Jason and Stefan but... ;-)
> >
> > My problem is not to create my watch list, I already have it. It
> > contains more than 250 tickers and I want to assign
a "particular"
> > industry to all these (same industry for these 250 stocks).
> > You'll quickly understand that the manual assignment of this
> > industry one by one to each of the 250 stocks using the Edit
> > Properties is a nightmare (especially since I'd like to make the
> > same with two or three other watch lists containing also more
than
> > 200 stocks each !).
> >
> > As for the last idea, I'm not using US stocks, but french ones ;-
)
> >
> > So if anybody else has a better way than doing this one by one,
> he's
> > welcome :-)
> >
> >
> > Thanks again.
> >
> >
> > Regards,
> >
> > Jean-Yves
> >
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, "sgfuchs" <sgfuchs@xxxx> wrote:
> > >
> > > You can copy exploration results ( symbols ) directly into a
> > > watchlist. Just mark them and rightclick for the popup menu,
> > choose
> > > copy selected symbols to....
> > >
> > > No need to copy symbols from an exploration list to notepad
first
> !
> > >
> > > Industry assignments - if you use the US stocks database in
AB,
> > > assignments should already be in your system.
> > >
> > > Rightclick on a symbol and choose "information" . The window
> > popping
> > > up will inform you about any assignments.
> > >
> > > This information is stored in AB. Read the manual section
about
> > > working with Sectors and Industries / Database management.
> > >
> > > If you messed up your database
> > > you can read this :
> > > http://www.amibroker.com/docs/ab305.html
> > > and download an exe file USStocksdatabase. This is
selfextracing
> > and
> > > adds a new database to AB which can access via database
setting
> > > files.
> > >
> > > It's the same assignment database as used by Yahoo Finance /
> > Reuters
> > >
> > >
> > > best regards
> > > regards
> > > Stefan
> > > --- In amibroker@xxxxxxxxxxxxxxx, Jason Hart <jhart_1972@xxxx>
> > wrote:
> > > > Jean-Yves,
> > > >
> > > > Have you tried tinkering with the "organize assignments"?
If
> > that
> > > doesn't work a little more involved way would to be run an
> > > exploration on the industry you want, copy & save the
resulting
> > > tickers over to notepad - then from notepad import the results
> > into
> > > the watchlist under symbol --> watchlist --> import-->
> > > >
> > > > Jason
> > > >
> > > > Jean-Yves <jean-yves.casalis@xxxx> wrote:
> > > > Hello,
> > > >
> > > > Is there an easy and fast way to assign a given Industry to
a
> > > whole
> > > > Watch List ?
> > > >
> > > > Thanks !
> > > >
> > > >
> > > >
> > > >
> > > > Check AmiBroker web page at:
> > > > http://www.amibroker.com/
> > > >
> > > > Check group FAQ at:
> > > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > > >
> > > >
> > > > Yahoo! Groups SponsorADVERTISEMENT
> > > >
> > > >
> > > > ---------------------------------
> > > > 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 the Yahoo! Terms
of
> > > Service.
> > > >
> > > >
> > > >
> > > > ---------------------------------
> > > > Do you Yahoo!?
> > > > New and Improved Yahoo! Mail - Send 10MB messages!
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/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/
|