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

RE: [amibroker] Re: TC2005

PureBytes Links

Trading Reference Links

Read the tutorial starting page 73 and page 62 in the Amibroker’s 4.70 userguide.  It is also a great idea to key in all the examples to learn how to more effectively use Amibroker if you have not done so already.   There is a lot of information to absorb in the userguide.    You are correct that TC2005 is an external database but a local database effectively copies (caches) the quotes in Amibroker’s database.  This access is reportedly faster as I am sure that Tomasz has optimized this aspect to death to keep the speed fast.  You may experience some time to close Amibroker when it seems to do some updating of the local database;  this is why I just use the plugin without the local database cache.  The local database is ALWAYS created to store certain information needed by AmiBroker;  contact support if you want more detailed information and/or better clarification of how this all works.   If you check the local database option in the dialog box below, you will then get the caching.  

 

-----Original Message-----
From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of MarketMonk777
Sent: Wednesday, April 05, 2006 10:10 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Re: TC2005

 

Thanks for the info.  Maybe I am missing something here.  TC2005 is an “external” database which therefore requires the plug-in.  Is there a way to make it a “local” database?

 

From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of RR
Sent: Wednesday, April 05, 2006 8:01 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Re: TC2005

 

Using the local database option is supposedly faster according to the AB documentation.  It takes about 4 minutes to process your query using a fairly low end computer with an Athlon XP 3000 chip socket A motherboard and the native plugin.   I do have 1.5 GB of RAM on this PC but windoze performance monitor shows a relatively small footprint of 600 MB so 1GB should be more than enough.   You can tune Amibroker’s caching parameters but do not ask me what to use; it is simply easier to buy RAM and forget about it.  I saw 512MB of good quality RAM for $20 on a special sale so it is pretty cheap to upgrade a desktop.   It appears that DDR RAM is being dumped now on the market to make way for the next upgrade of the Athlon chip which reportedly will use DDR2 RAM. 

 

Also, you may want to test your PC performance at www.pcpitstop.com  and do the anonymous testing to see how up to snuff your overall computer is performing. 

 

-----Original Message-----
From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of MarketMonk777
Sent: Wednesday, April 05, 2006 9:25 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Re: TC2005

 

Hi RR,

 

What do you mean by this statement --->

 

“I deliberately used the slower method of accessing data from TC2005” ????   Is there more than one way?

 

Dave

 

From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of RR
Sent: Wednesday, April 05, 2006 9:15 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Re: TC2005

 

I deliberately used the slower method of accessing data from TC2005.  The query executed in about 4 minutes for all quotes using these settings.

 

 

-----Original Message-----
From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Joe Landry
Sent: Wednesday, April 05, 2006 8:45 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Re: TC2005

 

Dave

You're right, I stand corrected.  It was a " harddrive"  option that you could take at one time vs something else

that was slower,...but that was a year or so before TC2005. 

 

Sorry couldn't help.  I've got a friend with TC2005 that I could ask to run that screen for you?

JOE  

----- Original Message -----

Sent: Wednesday, April 05, 2006 8:12 AM

Subject: RE: [amibroker] Re: TC2005

 

Hi Joe,

 

The new TC2005 database is now completely on my hard drive.  Not sure and doubt it if it gets loaded into RAM (if that is what you are asking).   My TC2005 software is lightning fast.  But that is it’s native DB and am sure it is optimized for displaying the pre-calculated results.  I say that because when you update (retrieve prices) the database it runs through and performs all of the calculations for all of my PCFs etc.

 

Dave

From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Joe Landry
Sent: Wednesday, April 05, 2006 5:48 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Re: TC2005

 

Dave

At one time when I subscribed to TC2000 a couple of years ago, there was an option in TC2000 to make the data,  memory based.  i.e. one could execute some process that moved the TC2000 data from disk to memory, so that at every  TC2000

start up it made that move, and the TC2000 screens were much faster.  I don't know if the recent versions still have that limitation, but I bet if  your access  every ticker array via the plug in from the disk you'll see slow access.  Key question ... how does your TC2000 installation behave when you perform a TC2000 screen?  You might check this out and ask TC help desk about this.

 

Joe  

 

----- Original Message -----

Sent: Tuesday, April 04, 2006 10:15 PM

Subject: Re: [amibroker] Re: TC2005

 

Dave,

That scan time does seems awfully long. I ran a simple scan of
C>=(Ref(C,-1)*1.20) and it took only about 2 minutes on an older Dell
Computer.
I am not sure how to keep all the data from loading as I have the same
issue with QP but there might be some other issues that are also
affecting your scan times.

You might check out Dan Clark's batch scripts or Fred's Batman to help
automate the task as well which might also save you some run time.

Regards,

Duke Jones, CMT

MarketMonk777 wrote:
> Hi Bill,
>
> It is taking about 9 minutes to run my simple exploration.  I have it
> applied to the "Stocks" group and set for looking at the last 1 day(s).
>
> My goal is to run multiple explorations back to back, with each one saving
> the results to a specific watchlist.
>
> If this is the way it is, so be it.  This software is 1000x better than
> TC2005 and all others out there.
>
> Dave
>
> -----Original Message-----
> From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf
> Of bvandyke
> Sent: Tuesday, April 04, 2006 4:29 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Re: TC2005
>
> Dave,
> I also use TC2005 and have noticed the same thing.  No matter how many
> days i set a backtest or exploration to....or what settings i use in
> File--->database as described in the Help files, i still note Amibroker
> apparently scans the #of bars in my TC2005 database.
>
> Maybe i'm missing something also.  After using what you've tried months
> ago and the File--> database settings , which take precedence over
> Preferences (which i also varied), i just gave up.  Maybe somebody
> knows something we don't.
>
> Bill
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "marketmonk777" <dlittner@xxx> wrote:
>  
>> Hi folks,
>>
>> I am using TC2005 database as my source for EOD data.  I was running a
>> simple exploration to look for all stocks that are up 20% over
>> yesterdays closing price.  Simple enough and it works.
>>
>> But what I noticed is that while scanning through my database it seems
>> to be loading all available bars.  When I really only need 2 bars.  Is
>> there a way to specific this?  It would speed up the exloration
>> significantly.
>>
>> Dave
>>
>>    
>
>
>
>
>
>
>
>
> 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 other support material please check also:
> http://www.amibroker.com/support.html
>
> 
> Yahoo! Groups Links
>
>
>
> 
>
>
>
>
>
> 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 other support material please check also:
> http://www.amibroker.com/support.html
>
> 
> Yahoo! Groups Links
>
>
>
> 
>
>
>
>
>
>  

 

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



SPONSORED LINKS
Investment management software Real estate investment software Investment property software
Software support Real estate investment analysis software Investment software

YAHOO! GROUPS LINKS