Yes.
1) make sure the ODBC plug-in is working with your SQL/dBase set-up. We've had
to adjust the original plug-in somewhat to achieve this, for example.
2) In the example below, I have a list of column-heading strings, some refer to
data contained in a table (view) with historic trailing fundamental data,
others to data in a table with historic estimate/forward looking data.
3) Those column-headings are then called in the odbcGetArray call to retrieve
the underlying time series.
The code below is now hopefully self-explanatory.
PS
ListFSDT="RI,PE,DY,BP,PC,MV,X(RI)~U$,MSDR,MSDY,MSND,MSNR,MSPB,MSPC,MSPE,MSRE,MSMV,FYE,A12NC,A12NE,A12M1C,A12M3C,A12M6C,A12DNC,A12UPC,A12DNE,A12UPE,A12GRO,A12FE,A12MKC,A12PE,A12SDC,A12TI,A12TE,A18NC,A18NE,A18M1C,A18M3C,A18M6C,A18DNC,A18UPC,A18DNE,A18UPE,A18GRO,A18FE,A18MKC,A18PE,A18SDC,A18TI,AF0DTE,AF0GRO,AF0PE,AF0TOT,AF0VAL,AF1NC,AF1NE,AF11MC,AF13MC,AF16MC,AF1GRO,AF1MN,AF1MKC,AF1PE,AF1SDC,AF1TOT,AF2NC,AF2NE,AF21MC,AF23MC,AF26MC,AF2GRO,AF2MN,AF2MKC,AF2PE,AF2SDC,AF2TOT,AF3NC,AF3NE,AF31MC,AF33MC,AF36MC,AF3GRO,AF3MN,AF3MKC,AF3PE,AF3SDC,AF3TOT,ADYNC,ADVYLD,AF1DNC,AF1UPC,AF1DNE,AF1UPE,AF2DNC,AF2UPC,AF2DNE,AF2UPE,AF3DNC,AF3UPC,AF3DNE,AF3UPE,AGBYLD,AHEPSG,ALTNC,ALTNE,ALT1MC,ALT3MC,ALT6MC,ALTDNC,ALTUPC,ALTDNE,ALTUPE,ALTMN,ALTMKC,ALTSDC";
ParList=ParamToggle("ParamList?","No|Yes");
if (ParList)
{
ChoiceDT=ParamList("DTList",ListFSDT);
Periode="Forward "+ChoiceDT;
if (StrLeft(Name(),6)=="MSEXUK") Naam = StrLeft(Name(),6)+"$";
else Naam = Name();
}
else
{
ChoiceDT=ParamList("DTList",ListFSDT,2);
Periode="Trailing "+ChoiceDT;
Naam = Name();
}
if (StrLeft(ChoiceDT,1)=="A") FACurr=odbcGetArray(EqIndIBESView,Naam,ChoiceDT);
else FACurr=odbcGetArray(EqIndTable,Naam,ChoiceDT);
//Plot(C,"C",1,1);
Ch=SetLinDateChart();
Plot(FACurr,Date()+"\n"+ChoiceDT+" = "+Periode+" "+FullName()+"
"+NumToStr(FACurr,1.3),1,4);
Plot (CumMeanFVB(FACurr),"\nMean "+ChoiceDT+" (visible period)",colorRed,1);
--- In [email protected], "dmcleod1981" <dmcleod1...@...> wrote:
>
> Is it possible to use other data from a database that is not open high low
> close data? I wanted to try and plot in AB some historical fundamental
> information but have not been able to figure out based on the samples given.
> Is this possible and does anyone have an example they would be willing to
> share?
>
> Thanks,
> DM
>
