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

Re: [amibroker] Re: Populating MS SQL database with data from esignal - prob solved



PureBytes Links

Trading Reference Links

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" <dan@xxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
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
>
>
>



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

**** 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/