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

Re: [amibroker] OT - Copying ticker list txt files to excel



PureBytes Links

Trading Reference Links

Hi Graham,

I dont know if I well understand the question.
I am not fluent in enghish.
Translate tableau to table maybe.
Tableau is the french word.

If I have to do the job you are trying to do, I process this way.

Open Word.
Copy your files in Word.
Choose : Edit / Select all.
Choose : Tableau / Convert  / Text to Tableau
Then choose the right separator to you.

Choose : Edit / Select all.
Choose : Edit / Copy

Open Excel
Choose one cell
Choose : Edit / Past

Tintin92



----- Original Message ----- 
From: "Graham" <kavemanperth@xxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Friday, February 18, 2005 2:24 AM
Subject: [amibroker] OT - Copying ticker list txt files to excel


> 
> I am wanting to pull lists from separate txt files into columns in
> excel. The txt files are separate files for each industry ticker list.
> Unfortunately I am not yet proficient at excel macros or scripts to be
> able to do this and was hoping someone would be able to help. I was
> able to record a macro to do this but it is clumsy and not exactly
> what I wanted.
> Once in Excel I can organise them into a full industry list for
> importing to AB sectors.
> 
> -- 
> Cheers
> Graham
> http://e-wire.net.au/~eb_kavan/
> 



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~-> 

Check AmiBroker web page at:
http://www.amibroker.com/

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/