You need to populate in datetime stamp increasing order. Therefore single EOD record (hour=15, min=31, tick=15) comes after intraday records for given day. And all that chronological by date. So:
<MONDAY_INTRADAY><MONDAY_EOD><TUESDAY_INTRADAY><TUESDAY_EOD><WEDNESDAY_INTRADAY><WEDNESDAY_EOD> and so on. Best regards, Tomasz Janeczko amibroker.com ----- Original Message ----- From: "ccr1der" <[email protected]> To: <[email protected]> Sent: Monday, March 30, 2009 9:48 AM Subject: [amibroker] Re: Populating MS SQL database with data from esignal - prob solved > OK, so after remming out that one line in the ODBC source code, a 1 min mixed > database now correctly displays both intraday and > daily candles. > At this point, there's a small gotcha whereby intraday data needs to be > populated first, followed by daily data, to prevent a > scenario where the populator takes consolidated 1m data, turns it into a > daily candle with a 9:30am timestamp, and trumps the > actual 1m candle 9:30 data. > > Basically preventing a somewhat corrupt database for intraday purposes. > > I can see I'm going to have to add some significant code to manage the > conversion/consolidation of intraday data into EOD data on > a regular basis, but it looks like I've got a working solution for the moment. > > My only dream would be if a better coder than I could add a "PutArray" and/or > "UpdateArray" function to the ODBC code. > > Thanks to all for enduring my rants on the topic, and to TJ and the gang for > such an awesomely extensible TA platform. > > -Dan > > > > > ------------------------------------ > > **** 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 > > >
