|
PureBytes Links
Trading Reference Links
|
Hi Tomasz,
I used the first script as below in "Automatic Analysis"
EnableScript("jscript");
ticker = Name();
<%
ticker = AFL("ticker");
AB = AFL.CreateObject("Broker.Application");
AB.Stocks( ticker ).Ticker = ticker + ".AX";
%>
Buy=0;
Apply to "all stocks " selected "scan" and then "refresh all"
but for some reason did not work.
The progress bar indicates that AA is scanning but the symbols in the
workspace symbols tree remains unchanged after applying "refresh all".
??
Regards
Don
----- Original Message -----
From: "Tomasz Janeczko" <amibroker@xxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Thursday, September 04, 2003 12:05 AM
Subject: Re: [amibroker] Batch Ticker conversion
> 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/
> >
> >
> >
>
>
> 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/
|