|
PureBytes Links
Trading Reference Links
|
Hi Tom,
Other than application-controlling scripts or macros, I don't know how to do
this.
-john
----- Original Message -----
From: "trb0428" <trbrowne@xxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Wednesday, August 04, 2004 7:39 PM
Subject: [amibroker] Re: importing quote data?
Thanks John.
I quess I should have been a little clearer....I am looking for a
way to import directly from excel into AB without having to go
through the intermediate "save as" step. I have a large excel
workbook setup with 215 seperate worksheets containg ticker, name,
industry, etc. and would like to try to import directly if possible
as it will save me the need to touch each of the 215
worksheets.....any ideas?
Thanks,
Tom
--- In amibroker@xxxxxxxxxxxxxxx, "john gibb" <jgibb1@xxxx> wrote:
> Hi,
>
> Yes. You will need to do a 'Save As...' in Excel and choose the CSV
> (comma-separated value) file type, and then use Amibroker's
importing
> capability. (Try the Import Wizard first; it will usually handle
what you
> want. If not, you may need the more complicated Import Ascii
feature.)
>
> For example, I had this 1-minute Dow data sent to me in a CSV
file, which I
> imported with the Wizard.
>
> 6/10/2004
> 8:20
> 10379
> 10387
> 10379
> 10381
> 71
>
> 6/10/2004
> 8:21
> 10380
> 10380
> 10380
> 10380
> 38
>
>
> ...
> 7/23/2004
> 16:13
> 9946
> 9951
> 9946
> 9951
> 133
>
> 7/23/2004
> 16:14
> 9951
> 9956
> 9951
> 9952
> 515
>
>
>
> -john
> ----- Original Message -----
> From: "trb0428" <trbrowne@xxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Wednesday, August 04, 2004 3:38 PM
> Subject: [amibroker] importing quote data?
>
>
> Is it possible to import quote data into AB from excel
spreadsheets?
>
>
>
>
> 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
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
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/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/
|