AmiBroker with Norgate Data, Limited to 1985

Hi,

I have an active Norgate Premium subscription for US Stocks. Using NDU to download and the AmiBroker plugin to access the data in an exploration. AmiBroker v6.40.4 and NDU v4.2.2.1.

When I run an Exploration for $SPX that includes "All quotes" it only runs from Jan 31, 1985 to date. In NDU, I can see clearly that $SPX has data going back to 1928. Also in a Python app, I can pull up a time series from 1928 forward. No amount of playing with AmiBroker database settings or Exploration parameters has caused it to go back further than 1985.

The same problem applies for IBM, for which Norgate provides data since 1950. Yet the Exploration only runs from 1985 forward... Hmmm.. I'd like to run the AmiBroker exploration for the full available data. It's got to be an AmiBroker or plug-in setting, but it escapes me.

Any idea what I might be missing?

Below is the code that I am running:

===

//
// Set the destination folder here
//
folder = "D:\\CSVData\\";
fmkdir (folder);

//
// Write price data to CSV, one symbol per file
//
fh = fopen(folder + Name() + ".csv", "w" );
if (fh) {
    fputs( "Ticker,Date,Open,High,Low,Close,Volume\n", fh );	// Header row

    // Loop for all bars and export prices
    dt = DateTime();											// Array of dates
    for ( i = 0; i < BarCount; i++ ) {
        fputs( Name() + "," , fh );								// Symbol name
        fputs( DateTimeToStr( dt[ i ], 3) + ",", fh );			// Date
        qs = StrFormat( "%g,%g,%g,%g,%g\n", O[ i ], H[ i ], L[ i ], C[ i ], V[ i ] );
        fputs( qs, fh );										// Price and volume data
    }
    fclose( fh );
}


//
// Write a header row to the symbols list, once on the first symbol
//
if (status("stocknum") == 0) {
	fh = fopen(folder + "_SymbolsList.csv", "w", True);
	if (fh) {
		fputs( "Symbol,Name\n", fh );
		fclose( fh );
	}
}


//
// Append current symbol to the symbols list
//
fh = fopen(folder + "_SymbolsList.csv", "a" , True);
if (fh) {
    fputs( StrTrim(Name()     ,"") + "," , fh );
    fputs( StrTrim(FullName() ,"") + "\n", fh );
    fclose( fh );
}


Buy = Sell = Filter = False;

===

https://norgatedata.com/amibroker-faq.php#limitedresults

3 Likes

"Method 2" did indeed solve my problem. I was missing that in a US market you need to set $DJI as the baseline symbol.

This topic was automatically closed 100 days after the last reply. New replies are no longer allowed.