|
PureBytes Links
Trading Reference Links
|
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 amibroker@xxxxxxxxxxxxxxx, "dmcleod1981" <dmcleod1981@xxx> 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
>
------------------------------------
**** 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/
|