|
PureBytes Links
Trading Reference Links
|
Don,
Script works. I DO check scripts that I sent out.
Which script did you use (first or second)?
Did you select "Apply to: ALL STOCKS" ?
Did you use "SCAN".
Did you select View->Refresh ALL ***AFTER*** scan ?
Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message -----
From: "don" <donmac63@xxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Wednesday, September 03, 2003 4:41 PM
Subject: Re: [amibroker] Batch Ticker conversion
> 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/
> >
> >
> >
>
>
>
> 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/
|