|
PureBytes Links
Trading Reference Links
|
Don,
You can easily and completely automatically append ".AX" extension to
all symbols in your database in a few seconds
using this very simple SCAN script:
EnableScript("jscript");
ticker = Name();
<%
ticker = AFL("ticker");
AB = AFL.CreateObject("Broker.Application");
AB.Stocks( ticker ).Ticker = ticker + ".AX";
%>
Buy=0;
Use: Automatic Analysis, Scan, apply to all stocks.
Reverse process is also possible:
EnableScript("jscript");
ticker = Name();
noext = StrLeft( ticker, StrLen( ticker ) - 3 );
<%
ticker = AFL("ticker");
AB = AFL.CreateObject("Broker.Application");
AB.Stocks( ticker ).Ticker = AFL("noext");
%>
Buy=0;
Make sure to use View->Refresh ALL
to refresh ticker list after processing.
Hope this helps.
Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message -----
From: "don" <donmac63@xxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Wednesday, September 03, 2003 2:06 PM
Subject: Re: [amibroker] Batch Ticker conversion
> Thanks Graham,
>
> I have tried that and ended up with double the number of tickers, one with
> and one without the extension. I would then have to re-map the industries
> and sector information and then delete the redundant tickers (the ones
> without the extension) from the database.
>
> Yes Amibroker does have facilities to edit stock information and mapping but
> not in a batch mode, not that I'm aware of anyway.
> It would be less time consuming to edit each ticker manually although it
> would take a few + a few hours.
>
> If I can find a way to change the tickers already in the database then the
> mapped information will be retained and save a lot of time.
>
> again thanks for your reply
>
> Best regards
>
> Don
>
>
> ----- Original Message -----
> From: "Graham" <gkavanagh@xxxxxxxxxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Wednesday, September 03, 2003 7:34 PM
> Subject: RE: [amibroker] Batch Ticker conversion
>
>
> > I use excel for that, although I believe there is capability in AB to
> change
> > the ticker name and I think was recently discussed.
> > I exported all the tickers and using excel added the extension
> > Say column A has the ticker, then column B would have this formula
> =A1&".AX"
> > The new column can then be copy and pasted into text editor like Notepad
> and
> > saved as text file, then imported into AB database
> >
> >
> >
> > Cheers,
> > Graham
> > http://groups.msn.com/ASXShareTrading
> > http://groups.msn.com/FMSAustralia
> > -----Original Message-----
> > From: don [mailto:donmac63@xxxxxxxxxxxx]
> > Sent: Wednesday, 3 September 2003 7:22 PM
> > To: amibroker@xxxxxxxxxxxxxxx
> > Subject: [amibroker] Batch Ticker conversion
> >
> >
> > New Amibroker User
> >
> >
> > I am interested to know if anyone has created a script to change multiple
> > ticker symbols in a native Amibroker Database?
> >
> > I need to add ".AX " to all the ticker symbols in the ASX Setup Database
> to
> > allow the collection of Yahoo data thru amiquote.
> >
> > eg: TLS ----> TLS.AX
> > LLC -----> LLC.AX
> > I don't mind having to manually edit index symbols back to their correct
> > format , ( ^AXJO ^AORD etc), but 1000's of stock symbols will take a
> > lllllloooonnggg time.
> >
> > Or, is it possable to setup Amiquote to append .AX to the ticker symbols?
> >
> > any help or ideas will be greatly appreciated.
> >
> > Thankyou in advance for any help.
> >
> > Best Regards
> >
> > Don
> >
> > Yahoo! Groups Sponsor
> >
> >
> >
> > 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 the Yahoo! Terms of Service.
> >
> >
> >
> > 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/
> >
> >
> >
>
>
>
> 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/
>
>
>
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/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/
|