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

[amibroker] routine to change symbol names



PureBytes Links

Trading Reference Links

I wrote a simple routine to change existing symbols so I dont loose
old data 

go=ParamTrigger("GO","OK");
if (go)
{
 AB = CreateObject("Broker.Application");
 sts = AB.Stocks();
 Qty = sts.Count;
 for( i = 0; i < Qty-1; i ++ )
 {
  st = sts.Item( i );
  Ticker = st.Ticker;
  Fil=StrFind(ticker, "-TSE") ;  
  if (fil) 
  {
	st.Ticker+="-CAD";
  }  
 }

}

Is this what u mean?

Thanks anyway

--- In amibroker@xxxxxxxxxxxxxxx, "Barry Scarborough" <razzbarry@xxx>
wrote:
>
> I noticed a change and started getting an error that says I don't 
> subscribe to ARCA. That is happening on many, if not all, of the ETFs 
> I follow. If that seems to be your problem add a new symbol using the 
> format symbol-ISLAND-STK, e.g. IWM is now IWM-ISLAND-STK. If you want 
> to dump the data for the old symbol I have a export program in the 
> AFL library that will dump all the symbols to a csv file. It detects 
> the period of the chart and can be used for eod or intraday. If you 
> dump intraday make sure you set AA to the period you want, like 1 
> minute. You will need to use Excel or some other spreadsheet program 
> to change the symbol name before you import the historical data to 
> the new symbol.
> 
> Barry
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <groups@> 
> wrote:
> >
> > "Query returned no data" means IB historical data server does
> > not offer historical data for given symbol.
> > Either symbol you are using is invalid or IB does not have data for 
> that symbol.
> > 
> > You need to tell the SYMBOL you are using in order to help you.
> > 
> > Also I repeat it over and over again: SUPPORT at amibroker.com is 
> correct channel to receive technical support.
> > This group is NOT tech support.
> > 
> > Best regards,
> > Tomasz Janeczko
> > amibroker.com
> > ----- Original Message ----- 
> > From: "loveyourenemynow" <loveyourenemynow@>
> > To: <amibroker@xxxxxxxxxxxxxxx>
> > Sent: Monday, November 24, 2008 1:57 PM
> > Subject: [amibroker] Re: Interactive Brokers plugin 1.8.2 - a 
> problem back filling
> > 
> > 
> > Thanks,
> > 
> > I installed 1.8.4 but I keep getting error 162: HDMS query returned 
> no
> > data.
> > 
> > Regards
> > 
> > Ly
> > 
> > --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <groups@> wrote:
> > >
> > > Hello,
> > >
> > > The latest plugin is 1.8.4 (not 1.8.2)
> > > http://www.amibroker.com/ib.html
> > >
> > > Best regards,
> > > Tomasz Janeczko
> > > amibroker.com
> > > ----- Original Message ----- 
> > > From: "loveyourenemynow" <loveyourenemynow@>
> > > To: <amibroker@xxxxxxxxxxxxxxx>
> > > Sent: Monday, November 24, 2008 12:51 PM
> > > Subject: [amibroker] Re: Interactive Brokers plugin 1.8.2 - a
> > problem back filling
> > >
> > >
> > > I also upgraded TWS, but I keep getting error 162.
> > > Symbols are ok, since I can get real time data.
> > >
> > > Please let me know ASAP if you know something
> > >
> > >
> > > thanks
> > >
> > > LY
> > >
> > >
> > > --- In amibroker@xxxxxxxxxxxxxxx, "loveyourenemynow"
> > > <loveyourenemynow@> wrote:
> > > >
> > > > Hello again,
> > > >
> > > > I have upgraded both IB plugin and AB to the last version.
> > > > Using new symbol conventions I can get real time data but no 
> backfill,
> > > > msg 8,162 no historical data ....
> > > >
> > > > Problems started only yesterday.
> > > > Since I can get real time data I exclude it is a problem with
> > symbology.
> > > > Backfill using TWS charts works.
> > > >
> > > >
> > > > Any suggestions?
> > > >
> > > > Thanks
> > > >
> > > > LY
> > > >  --- In amibroker@xxxxxxxxxxxxxxx, "loveyourenemynow"
> > > > <loveyourenemynow@> wrote:
> > > > >
> > > > > Hello,
> > > > >
> > > > > I was able to backfill until yesterday using an old IB plugin.
> > > > > NOw I cannot bakcfill any symbol,usor european,even 
> specifying the
> > > > > currency.
> > > > > I have upgraded to the new plugin.
> > > > >
> > > > > I added the currency from the symbol information, but of 
> USfuture I
> > > > > should not need it correct?
> > > > >
> > > > > After adding the currency symbols are seen as " bu the 
> plugin ...
> > > > >
> > > > > What is this?
> > > > >
> > > > > Thanks
> > > > >
> > > > > Ly
> > > > > --- In amibroker@xxxxxxxxxxxxxxx, Rick Osborn <ricko@> wrote:
> > > > > >
> > > > > >
> > > > > > Tomasz
> > > > > > To add TD (TD Bank) US quotes to real time database all I 
> need
> > to do
> > > > > is add it as "TD" (without quotes, of course)
> > > > > > How would I add TD - Canadian data? (All combinations I 
> tried
> > don't
> > > > > seem to work) Using IB plugin 1.8.2
> > > > > > Rick
> > > > > >
> > > > > >
> > > > > >
> > > > > > ----- Original Message ----
> > > > > > From: Tomasz Janeczko <groups@>
> > > > > > To: amibroker@xxxxxxxxxxxxxxx
> > > > > > Sent: Thursday, October 23, 2008 4:46:31 AM
> > > > > > Subject: Re: [amibroker] Re: Interactive Brokers plugin 
> 1.8.1 - a
> > > > > problem back filling
> > > > > >
> > > > > >
> > > > > > Hello,
> > > > > >
> > > > > > Did you read the release notice?
> > > > > >
> > > > > > If you are using ANY non-US dollar denominated
> > > > > > symbols you need to specify the currency.
> > > > > > This is so because IB now REQUIRES to specify currency to 
> resolve
> > > > > ambuiguity
> > > > > > between same symbols traded with different currencies.
> > > > > > If you don't specify currency, the US DOLLAR will be 
> automatically
> > > > > used by the plugin.
> > > > > >
> > > > > > If you are using any EURO or other non-US currency you need 
> to
> > > > > specify it.
> > > > > >
> > > > > > If you provide symbols you have problems with I will tell 
> you how
> > > > > you should amend
> > > > > > the symbols to specify currency.
> > > > > >
> > > > > > Best regards,
> > > > > > Tomasz Janeczko
> > > > > > amibroker.com
> > > > > > ----- Original Message ----- 
> > > > > > From: "reinsley" <reinsley@xxxxxx fr>
> > > > > > To: <amibroker@xxxxxxxxx ps.com>
> > > > > > Sent: Thursday, October 23, 2008 10:16 AM
> > > > > > Subject: Re: [amibroker] Re: Interactive Brokers plugin 
> 1.8.1 - a
> > > > > problem back filling
> > > > > >
> > > > > > >
> > > > > > > Hello,
> > > > > > >
> > > > > > >
> > > > > > > Yesterday after the session, I upgraded from 1.8.0 to 
> 1.8.1
> > > > > > >
> > > > > > > This morning, v1.8.1 can't backfill and says that my 
> indice and
> > > > future
> > > > > > > symbols are incorrect.
> > > > > > >
> > > > > > > I downgraded to 1.8.0 and it's working fine...
> > > > > > >
> > > > > > > Best regards
> > > > > > >
> > > > > > > Tomasz Janeczko a écrit :
> > > > > > >>
> > > > > > >> *Here is exact link from Interactive Brokers site that 
> lists
> > > > current
> > > > > > >> limitations: *
> > > > > > >> http://www.interact ivebrokers. com/php/apiUsers
> > Guide/apiguide/
> > > > > api/historical_ data_limitations .htm#HT_historic aldata
> > > > > > >> <http://www.interact ivebrokers. com/php/apiUsers
> > Guide/apiguide/
> > > > > api/historical_ data_limitations .htm#HT_historic aldata>
> > > > > > >>
> > > > > > >> Note that they are adding new limitations. Previously 
> there was
> > > > only
> > > > > > >> 60 request per 10 minutes limit that I mentioned below 
> but now
> > > > as you
> > > > > > >> can see there are more limits.
> > > > > > >>
> > > > > > >> Best regards,
> > > > > > >> Tomasz Janeczko
> > > > > > >> amibroker.com
> > > > > > >>
> > > > > > >> ----- Original Message -----
> > > > > > >> *From:* Tomasz Janeczko <mailto:groups@xxxxxxxxx. com>
> > > > > > >> *To:* amibroker@xxxxxxxxx ps.com 
> <mailto:amibroker@xxxxxxxxx
> > > > ps.com>
> > > > > > >> *Sent:* Thursday, October 23, 2008 1:32 AM
> > > > > > >> *Subject:* Re: [amibroker] Re: Interactive Brokers plugin
> > 1.8.1 -
> > > > > > >> a problem back filling
> > > > > > >>
> > > > > > >> *Backfill throttling is a LIMITATION IMPLEMENTED BY 
> INTERACTIVE
> > > > > > >> BROKERS inside TWS.*
> > > > > > >> *=========== ========= ========= ========= ========= 
> =========
> > > > > ========= ======*
> > > > > > >>
> > > > > > >> Interactive Brokers allows the following MAXIMUM amount 
> of
> > > > backfill:
> > > > > > >> *Sixty 5-day segments per any 10 minutes period.*
> > > > > > >>
> > > > > > >> If you download say 30 days for every symbol it equals 
> SIX
> > 5-day
> > > > > > >> segments
> > > > > > >> per symbol, effectivelly leading to only 10 symbols 
> (30days
> > each)
> > > > > > >> during any 10 minute period.
> > > > > > >>
> > > > > > >> If you reach the limit Interactive Brokers will send 
> error 162
> > > > > > >> (MAXIMUM limit reached - Throttling),
> > > > > > >> until 10 minute segment passes without allowing any 
> subsequent
> > > > > > >> backfill.
> > > > > > >>
> > > > > > >> Only AFTER 10 minutes you will be allowed to backfill 
> again.
> > > > > > >>
> > > > > > >> It is really NOT mine invention - it is Interactive 
> Brokers
> > > policy
> > > > > > >> - please complain to them.
> > > > > > >> There are zillions of
> > > > > > >>
> > > > > > >> Best regards,
> > > > > > >> Tomasz Janeczko
> > > > > > >> amibroker.com
> > > > > > >> ----- Original Message -----
> > > > > > >> From: "Barry Scarborough" <razzbarry@xxxxxxxxx .us
> > > > > > >> <mailto:razzbarry@xxxxxxxxx .us>>
> > > > > > >> To: <amibroker@xxxxxxxxx ps.com 
> <mailto:amibroker@xxxxxxxxx
> > > > ps.com>>
> > > > > > >> Sent: Thursday, October 23, 2008 1:23 AM
> > > > > > >> Subject: [amibroker] Re: Interactive Brokers plugin 
> 1.8.1 - a
> > > > > > >> problem back filling
> > > > > > >>
> > > > > > >> >I use the real time quote window and I have 60 symbols 
> in it.
> > > > When I
> > > > > > >> > back fill I get through a number of then and get a 
> throttling
> > > > > > >> error.
> > > > > > >> > When the timeout completes I get a window to start 
> receiving
> > > > > > >> data and
> > > > > > >> > immediately get the throttling error again and the 
> time out
> > > > starts
> > > > > > >> > again. Is this what I should expect or is there another
> > > problem?
> > > > > > >> >
> > > > > > >> > Thanks,
> > > > > > >> > Barry
> > > > > > >> >
> > > > > > >> > --- In amibroker@xxxxxxxxx ps.com
> > > > > > >> <mailto:amibroker@xxxxxxxxx ps.com>, "Tomasz Janeczko"
> > <groups@>
> > > > > > >> > wrote:
> > > > > > >> >>
> > > > > > >> >> Hello,
> > > > > > >> >>
> > > > > > >> >> New version of Interactive Brokers plugin is released 
> now:
> > > > > > >> >>
> > > > > > >> http://www.amibroke r.com/devlog/ 2008/10/22/ 
> interactive-
> > > > > brokers-tws
> > > > > > >> <http://www.amibroke r.com/devlog/ 2008/10/22/ 
> interactive-
> > > > > brokers-tws>-
> > > > > > >> > plugin-version- 181/
> > > > > > >> >>
> > > > > > >> >> This is recommended upgrade for anyone using any 
> earlier
> > > > version.
> > > > > > >> >>
> > > > > > >> >> Best regards,
> > > > > > >> >> Tomasz Janeczko
> > > > > > >> >> amibroker.com
> > > > > > >> >>
> > > > > > >> >
> > > > > > >> >
> > > > > > >> >
> > > > > > >> > ------------ --------- --------- ------
> > > > > > >> >
> > > > > > >> > **** IMPORTANT ****
> > > > > > >> > This group is for the discussion between users only.
> > > > > > >> > This is *NOT* technical support channel.
> > > > > > >> >
> > > > > > >> > ************ *********
> > > > > > >> > TO GET TECHNICAL 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.amibroke r.com/devlog/ <http://www.amibroke
> > > > > r.com/devlog/>
> > > > > > >> >
> > > > > > >> > For other support material please check also:
> > > > > > >> > http://www.amibroke r.com/support. html
> > > > > > >> <http://www.amibroke r.com/support. html>
> > > > > > >> >
> > > > > > >> > ************ ********* ********* ***
> > > > > > >> > Yahoo! Groups Links
> > > > > > >> >
> > > > > > >> >
> > > > > > >> > (Yahoo! ID required)
> > > > > > >> >
> > > > > > >> > mailto:amibroker-fullfeatu red@xxxxxxxxxxxx com
> > > > > > >> <mailto:amibroker-fullfeatu red@xxxxxxxxxxxx com>
> > > > > > >> >
> > > > > > >> >
> > > > > > >> >
> > > > > > >>
> > > > > > >>
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > ------------ --------- --------- ------
> > > > > > >
> > > > > > > **** IMPORTANT ****
> > > > > > > This group is for the discussion between users only.
> > > > > > > This is *NOT* technical support channel.
> > > > > > >
> > > > > > > ************ *********
> > > > > > > TO GET TECHNICAL 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.amibroke r.com/devlog/
> > > > > > >
> > > > > > > For other support material please check also:
> > > > > > > http://www.amibroke r.com/support. html
> > > > > > >
> > > > > > > ************ ********* ********* ***
> > > > > > > Yahoo! Groups Links
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > **** IMPORTANT ****
> > > This group is for the discussion between users only.
> > > This is *NOT* technical support channel.
> > >
> > > *********************
> > > TO GET TECHNICAL 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
> > >
> > 
> > 
> > 
> > ------------------------------------
> > 
> > **** IMPORTANT ****
> > This group is for the discussion between users only.
> > This is *NOT* technical support channel.
> > 
> > *********************
> > TO GET TECHNICAL 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
> >
>



------------------------------------

**** IMPORTANT ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

*********************
TO GET TECHNICAL 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/