[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [amibroker] Batch Ticker conversion



PureBytes Links

Trading Reference Links

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. 


------------------------ 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/