|
PureBytes Links
Trading Reference Links
|
Very Simple -
Save your file as .csv rather than excel.
Then to to AmiBroker>File>Import Wizard and follow the steps.
Suggest flipping the Ticker and Date columns so Ticker is first - and be sure that you pick the correct date format - and check the box to ignore 1 row so it doesn't try to load the headers as a quote.
At most a few minutes.
Good luck.
Mike
--- In amibroker@xxxxxxxxxxxxxxx, "ford7k" <ford7k@xxx> wrote:
>
>
> Hi Experts
>
> A friend sent me a eod data file in excel for optionscall s.
> It has date ticker o h l c volume etc columns
>
> This is end of day data.
> Is there any utility to help read this data into amibroker?
>
> My friend told me
> first I have to create a new database.
> with time setting of end of day
> then he says the excel file has to be given a short name and
> it can be linked to amibroker.
>
> please help.
>
> many cilly doubts come to mind
> like
>
> what format amibroker reads? I think it is ASCII
> How can we link excel file to amibroker.
>
> thanks for time and effort
> regards
> ford
>
------------------------------------
**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/amibroker/join
(Yahoo! ID required)
<*> To change settings via email:
amibroker-digest@xxxxxxxxxxxxxxx
amibroker-fullfeatured@xxxxxxxxxxxxxxx
<*> 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/
|