so, i finally started playing with teh obdc and came to a quick problem
i am trying to plot my trades by selecting the data from the table
that holds my trade info.
price tradedatetime
39.50000 2009-02-26 16:31:48
i have a trade entered on 26 feb afterhours in nasdaq shorting rimm
on the daily chart , the plot marked it for 27 feb.
on the intraday chart, the plot marks it for all bars for 27 feb.
this behaviour seems to be odd.
_SECTION_BEGIN("Price");
SetChartOptions(0,chartShowArrows|chartShowDates);
Plot( C, "Close", ParamColor("Color", colorBlack ), styleNoTitle |
ParamStyle("Style") | GetPriceStyle() );
_SECTION_END();
odbcOpenDatabase("ODBC;DATABASE=dbTrader;DSN=dbtrader1;OPTION=0;PORT=0;UID=root;PWD=qazwsx123");
BuyPrice =odbcGetArraySQL("SELECT price,tradedatetime from rawdatas
where symbol='RIMM'");
SHAPE=IIf(BuyPrice>0,shapeUpArrow,shapeNone);
PlotShapes(SHAPE,colorGreen);
_TRACE("Errors" + odbcGetLastError()) ;
