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

[amibroker] Re: problem of importing tick data



PureBytes Links

Trading Reference Links

Well , I figured it out
use excel, column F=column D/100, thus can delete the last two zero 
in column D.

of course , can also use fopen, fget, fput ,fclose to do the same 
job, but some coding is necessary

itmwh


--- In amibroker@xxxxxxxxxxxxxxx, "itmwh" <toxutao@xxx> wrote:
>
> The reason seems to be lying in the time format of the original 
data 
> file.  Is it possible to set up in Amibroker to neglect the last 
two 
> zero in "08450000" to make it as "084500" ?
> 
> 
> 
> 
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "itmwh" <toxutao@> wrote:
> >
> > Hi, I am trying to import some tick data with the following 
format:
> > 
> > ============================================================
> > 
> > 
> > 20070613   ,    FITX    ,    200706  ,    08450000  ,    
> > 8311     ,    372
> > 20070613   ,    FITX    ,    200706  ,    08450200  ,    
> > 8311     ,    30
> > 20070613   ,    FITX    ,    200706  ,    08450300  ,    
> > 8311     ,    8
> > 20070613   ,    FITX    ,    200706  ,    08450400  ,    
> > 8311     ,    2
> > 20070613   ,    FITX    ,    200706  ,    08450500  ,    
> > 8310     ,    16
> > 20070613   ,    FITX    ,    200706  ,    08450500  ,    
> > 8311     ,    24
> > 20070613   ,    FITX    ,    200706  ,    08450500  ,    
> > 8312     ,    6
> > 20070613   ,    FITX    ,    200706  ,    08450600  ,    
> > 8310     ,    18
> > 20070613   ,    FITX    ,    200706  ,    08450700  ,    
> > 8309     ,    2
> > 20070613   ,    FITX    ,    200706  ,    08450700  ,    
> > 8310     ,    10
> > 20070613   ,    FITX    ,    200706  ,    08450800  ,    
> > 8309     ,    44
> > 20070613   ,    FITX    ,    200706  ,    08450900  ,    
> > 8308     ,    12
> > 20070613   ,    FITX    ,    200706  ,    08450900  ,    
> > 8309     ,    6
> > 20070613   ,    FITX    ,    200706  ,    08451000  ,    
> > 8308     ,    8
> > 20070613   ,    FITX    ,    200706  ,    08451100  ,    
> > 8307     ,    8
> > 20070613   ,    FITX    ,    200706  ,    08451100  ,    
> > 8308     ,    38
> > 20070613   ,    FITX    ,    200706  ,    08451100  ,    
> > 8309     ,    4
> > 20070613   ,    FITX    ,    200706  ,    08451200  ,    
> > 8306     ,    4
> > 20070613   ,    FITX    ,    200706  ,    08451200  ,    
> > 8307     ,    2
> > 20070613   ,    FITX    ,    200706  ,    08451200  ,    
> > 8308     ,    6
> > 20070613   ,    FITX    ,    200706  ,    08451300  ,    
> > 8306     ,    16
> > 20070613   ,    FITX    ,    200706  ,    08451300  ,    
> > 8307     ,    2
> > 20070613   ,    FITX    ,    200706  ,    08451300  ,    
> > 8308     ,    2
> > 20070613   ,    FITX    ,    200706  ,    08451400  ,    
> > 8306     ,    2
> > 
> > ========================================================
> > 
> > In the data import wizard, I choose the  format as follows:
> > 
> > column1-YMD
> > column2-Ticker
> > column3-skip ( I do not need the month of the contract here)
> > column4-time
> > column5-close
> > column6-volumn
> > column7-skip  ( no data for column 7)
> > 
> > seperator--comma(,)
> > log errors--Yes
> > automatically add new symbol--Yes
> > calculate composite--Yes
> > no quotation data--No
> > all negative price--No
> > 
> > And then I import, the program reported no errors. But when I 
open 
> > the chart, there is no bar there, program says "Not enough data 
> > available"   I was confused.  What could be the possible reason 
> > here ?
> > 
> > Thanks for the help.
> > 
> > itmwh
> > 
> > 
> > "
> >
>




Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
 
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:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto: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/