|
PureBytes Links
Trading Reference Links
|
Tomasz
Sorry to have to say but the script did not work.
Followed instructions to the letter
AA went thru the motions but no change to the tickers after Refresh All or
exit AB and restart.
I must be missing something.
regards
Don
----- Original Message -----
From: "don" <donmac63@xxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Wednesday, September 03, 2003 9:27 PM
Subject: Re: [amibroker] Batch Ticker conversion
> Tomasz
>
> Thank you
> you have saved me a lot of time
>
> As with many other users of Amibroker I am very impressed with the support
> from you and the group members.
> I know I will learn a lot simply by following you all.
>
> The Amibroker Program is also very impressive.
> It is a very flexible and powerfull application limited only by my skill
but
> not my imagination.
>
> Best Regards
>
> Don
>
>
> ----- Original Message -----
> From: "Tomasz Janeczko" <amibroker@xxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Wednesday, September 03, 2003 8:52 PM
> Subject: Re: [amibroker] Batch Ticker conversion
>
>
> > 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/
> > >
> > >
> > >
> >
> >
> > 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/
|