I developped an Amibroker data plugin which let AB users access QUANDL ‘ s data It is FREE!
Download setup of 32 bits version – AWQU009.exe
Download setup of 64 bits version – AWQU64009.exe
When you execute one of the above setups, the DLL is copied to Amibroker plugins folder and the folder
“C:\Users\USERNAME\Documents\AndersonWilson\QUANDL” is created. In this folder you find plugin log with errors/warnings and a AWQU.ini file with plugin configuration and symbolformat.txt file used to define special formats. Second video below expain how you define symbols with special formats.
QUANDL does not have a fixed format for data. The plugin assumes default formats, depending on number of columns returned from Quandl (read comments below for more detail). You can also define special formats for symbols or entire dataset (see second video below).
Video of installation and usage of plugin
Video explaning how to define special formats
QUANDL does not have a fixed format for data, so this plugin make some assumptions.
– First column must be date (YYYY-MM-DD)
– if data has only 2 columns, the format DATE,CLOSE is assumed
– if data has 3 or 4 columns, the format DATE,CLOSE,VOLUME,skip is assumed
– if data has 5 columns, the format DATE,OPEN,HIGH,LOW,CLOSE is assumed
– if data has 6 or more columns, the format DATE,OPEN,HIGH,LOW,CLOSE,VOLUME,skip is assumed
This plugin exports GetExtraData(“fIsWaitingQuotes”)
It return true when quotes are being validated/updated
AFL below will change chart background color to warn you
pR = Param("Red",230,0,255,1);
pG = Param("Green",230,0,255,1);
pB = Param("Blue",230,0,255,1);
if( GetExtraData("fIsWaitingQuotes") )
SetChartBkColor( ColorRGB(pR,pG,pB) );
What is the best way to refresh all the securities to the latest EOD, before I can save the database and process the data? As it is, when I just scroll down through the securities, I can see that the green status turns to yellow (too many Pending requests).
DO a simple explorer with all securities, range= 1 recent bar, and make sure you have
ENABLED Wait for backfill option in Analysys