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

Re: [amibroker] import EOD errors



PureBytes Links

Trading Reference Links




Hello,
 
You should remove spaces from the <FONT 
color=#ff0000>ticker entered in AMiBroker,
not from the data file. Removing from data file is not 
necessary because importer
removes spaces by itself.
 
Go to Symbol->Information
and check "Ticker" field. You will see that the symbols you 
have entered before
ARE DIFFERENT than auto-added.
 
Auto-added symbols do not have any spaces. Your manually added 
symbols - have spaces.
 
Best regards,Tomasz Janeczkoamibroker.com
<BLOCKQUOTE 
>
  ----- Original Message ----- 
  <DIV 
  >From: 
  Arthur 
  Sawilejskij 
  To: <A title=amibroker@xxxxxxxxxxxxxxx 
  href="">amibroker@xxxxxxxxxxxxxxx 
  Sent: Monday, April 28, 2003 1:27 
PM
  Subject: Re: [amibroker] import EOD 
  errors
  At 01:08 PM 28/04/2003 +0200, you wrote:: 
  
  Hello,<FONT 
    size=3> In short: you don't have given 
    symbol in the database. There must be a *difference* betweenthe symbol 
    you have entered and the contents of your ASCII file. 
  I have checked the data base and the symbols are 
  there.As I said in a subsequent post - I tried to do the import with a 
  file containing NO spaces at the end of the symbol and the same errors 
  occurred.
  Note that your data 
    file seems to contain SPACES at the end of the symbol. The 
    spacesare REMOVED by AmiBroker 
    during import so proper symbol is "AAC" not 
    "AAC      "<FONT 
    size=2>as you may have entered.<FONT 
    size=3> Double check or<FONT 
    size=3>mark "auto-add new stock" so AmiBroker could 
    add missing symbol.I did that and it imports the 
  data correctly - but what happens is that it adds stock that I don't want in 
  my database and because I have no historical data there really is nothing to 
  display.For stock that are already there - it added a second symbol 
  for each stock. :(It seems to relate to the fact of whether I have 
  auto add ticked or not - if it is ticked - it adds data but gives me 
  duplication for stock I already have and adds stock I don't want.If I 
  don't have auto add ticked - I get error, regardless of whether the import 
  file has trailing spaces or not.Arthur
  Best 
    regards,Tomasz Janeczkoamibroker.com 
    
      ----- Original Message ----- 
      From: Arthur 
      Sawilejskij 
      To: <A 
      href="">amibroker@xxxxxxxxxxxxxxx 
      Sent: Monday, April 28, 2003 12:56 PM 
      Subject: [amibroker] import EOD errors
      I'm trying to import some EOD data using the import wizard.
      I have data for about 200 stock but the list contains some 20,000 
      quotes - so I have unticked the option to automatically add new 
      stock.
      When I run the import - I get a bunch or errors and the log shows 
      "this stock/ticker does not exist in the database" for every tick - even 
      though it does - and none of the EOD data gets updated.
      The form of the data is below.
      AAC   ,030428,0.930,0.950,0.930,0.950,106803,0
      Does anyone have any suggestions as to why this doesn't import 
      correctly?
      Arthur 
      Send BUG REPORTS to bugs@xxxxxxxxxxxxx 
      Send SUGGESTIONS to suggest@xxxxxxxxxxxxx 
      ----------------------------------------- 
      Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
      (Web page: <A 
      href="">http://groups.yahoo.com/group/amiquote/messages/) 

      -------------------------------------------- 
      Check group FAQ at: <A 
      href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
      
      Your use of Yahoo! Groups is subject to the <A 
      href="">Yahoo! Terms of Service. 
      
    
      
      
        Yahoo! Groups 
          Sponsor
      
        <A 
          href=""><IMG 
          height=250 alt=156cdac5.jpg 
          src="jpg00138.jpg" width=300>
      
        <IMG height=1 alt=156cdb65.jpg 
          src="jpg00139.jpg" 
    width=1>Send BUG REPORTS to 
    bugs@xxxxxxxxxxxxxSend SUGGESTIONS to 
    suggest@xxxxxxxxxxxxx-----------------------------------------Post 
    AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: 
    <A 
    href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check 
    group FAQ at: <A 
    href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
    Your use of Yahoo! Groups is subject to the <A 
    href="">Yahoo! Terms of Service. 
  Send 
  BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to 
  suggest@xxxxxxxxxxxxx-----------------------------------------Post 
  AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A 
  href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check 
  group FAQ at: <A 
  href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
  Your use of Yahoo! Groups is subject to the <A 
  href="">Yahoo! Terms of Service. 







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.

Attachment: Description: ""

Attachment: Description: ""