|
PureBytes Links
Trading Reference Links
|
Hi,
Does the 2nd instance of AB use a daily or intraday database? If it is
intraday it looks for time as well.
Also notice that you may end up having the same records many times in your
database tables. There is no logic in your code to select only the "new
bars".
Y
--------------------------------------------------
From: "ccr1der" <dan@xxxxxxxxxxx>
Sent: Sunday, March 29, 2009 12:44 PM
To: <amibroker@xxxxxxxxxxxxxxx>
Subject: [amibroker] Populating MS SQL database with data from esignal
> Working on creating a script that updates a local SQL database with data
> from ESignal data feed. I'm using the ODBC plugin, and I successfully
> have data writing to the database from what I call "instance 1", and
> another instance (#2) of AB configured to read that database. Instance 2
> of AB is configured to display only trading hours, while instance 1 (the
> data feeder/SQL populator) is set to display 24 hours(weekends filtered).
>
> The issue I'm having, given the code below, seems to be related to
> timestamping. Instance 1 shows daily candles from the esignal feed, with
> local database storage enabled, without "Show 24 hours trading" enabled.
> There seems to be only dates, and not times associated with these daily
> candles (when viewing a daily chart) on that machine. The crosshairs
> don't show any time... just date and barnumber. When I hit the
> paramtrigger in my code below, it writes the array to the database with a
> timestamp of YYYY-MM-DD 00:00:00.000
> As a result, AB instance 2, if I don't enable "Show 24 hours trading", I
> don't see any daily candles, because it thinks the price occured at
> midnight(off trading hours).
>
> In all of this, obviously, I'm mixing intraday (1m) and EOD data in the
> same table.
>
> The question is, what do I have to put in the database for AB to know that
> it's a daily candle data? Do I have to add something to blank out the
> 00:00:00 timestamp in my datetime string? Will the DB accept a blank
> timestamp? Is that the way to go? or is there another flag stored with
> the daily data in the AB database that I need to consider in my SQL
> database?
>
> Any help would be greatly appreciated.
>
> -Dan
>
> Below is my code:
>
> _SECTION_BEGIN("DATABASE");
> if (ParamTrigger("write to DB","*"))
> {
>
> odbcOpenDatabase("ODBC;DSN=DBONE;UID=Administrator;Trusted_Connection=Yes;APP=AmiBroker
> for Win32;WSID=SERVER;Network=DBMSSOCN;DRIVER={SQL Native
> Client};SERVER=SERVER");
> odbcDisplayErrors( False );
> DT=DateTime();
> for( i = 0; i < ( BarCount - 1 ); i++ )
> {
> if( NOT odbcExecuteSQL("INSERT INTO TestTable ([SYMBOL],[DATE], [OPEN],
> HIGH, [LOW], [CLOSE], VOLUME, OPENINT) VALUES ('"
> +
> Name()+"','"+DateTimeToStr(DT[i])+"',"+Open[i]+","+High[i]+","+Low[i]+","+Close[i]+","+Volume[i]+","+OpenInt[i]+");"))
>
> {
> _TRACE("INSERT failed with following message : " +odbcGetLastError() );
> }
> }
> }
> _SECTION_END();
>
>
>
>
> ------------------------------------
>
> **** 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/
|