|
PureBytes Links
Trading Reference Links
|
Hello, hoping someone can point me to an efficient way of dealing with databases. Right now I have an historical database of a dozen symbols, going back 10 years on each symbol (1-min data). The database is too large for auto trading, as it causes AB to crash on WinXP. So what I want to do is have a separate database of the 12 symbols, but only containing the latest 10 days or so of data.
Database 1: large historical database of 12 symbols going back 10 years
Database 2: small live database of 12 symbols with latest 10 days worth of data
I would use Database 1 for backtesting purposes, and Database 2 for live trading.
Creating Database 2 is easy. But what if I want to merge the two sets of databases every week, so that Database 1 is kept up to date with the latest data from Database2?
Is there an easy way to merge symbols across two different databases, and perhaps even do this in an automated fashion?
And what about trimming the data in Database 2 every week, so that it only ever contains a max of 10 days of data per symbol? Is there any easy way to "flush" data from the actual symbol? Would I simply use the Split option, or is there a more automated way of doing this?
__._,_.___
**** 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/
![]()
__,_._,___
|