Title: Re: [amibroker] Re: Splitting databases
Thanks Franz,
this sounds good but is rather complicated (for me). It seems that lately more and more people work with large DBs, I have seen quite of few posts on related issues. Perhaps I will post a suggestion on the feedback site. Right now I can't afford to get distracted from my main project. Unless someone has already done this i think I'll shelf it for now.
Thanks again,
herman
Friday, September 4, 2009, 9:03:18 AM, you wrote:
> Hi Herman,
> I had a similar question and solved it in steps.
> I had several databases and wanted to collect a number of tickers out of
> these databases into a new database only containing the tickers needed.
> Your second step would be to disregard a number of bars out of the history of each of these tickers.
> As input I use a txt file containing the names of the databases and the
> requested tickers there in. For me this is a portfolio related setup.
> You could write a number of routines in JScript:
> PrepareDestDatabase: clean it up by deleting all current symbols.
> FillDestDatabase: add the tickers to the now empty destination database.
> No data in there yet. Close dest database.
> CopyQuotes: simply copy the files from the source databases of which you have
> the name and the ticker name itself into the correct subdirectory of your dest database. Open the dest database.
> GetRidOfHistory: Your next step would be get rid of a number of quotes for each symbol.
> After having dealt with the system traded you just go back to the beginning
> and take the next entry from your system setup file.
> The whole process will be steered from a JScript script.
> So I'm certain it can be done automatically.
> Franz
> ------------------------------------
> **** 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/
> 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/
__._,_.___
**** 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/
![]()
__,_._,___
|