Norgate Data Updater FAQ
GeneralHow can I improve the update speed?
NDU started to download an historical database and then stopped. What could the problem be?
I've stopped updating from one of my two computers, so why am I prevented from installing on another?
DatabaseWhat does it mean if a symbol has a prefix?
How are symbol overlaps between AU and US stocks handled?
How can I find my Norgate Data database?
How do I change the Database Location?
I have installed the NDU database on d: drive. Why am I getting a pop-up warning about free disk space on c: drive?
Is the NDU database static with regard to historical data?
Watch List LibraryMy Watchlist Library includes watchlists for "Current & Past" index constituents. To avoid "survivorship bias", do I simply reference such a watchlist in a back-test?
When a symbol in a watchlist for "Current & Past" has a date suffix - like XYZ-201506 - does the suffix indicate when the stock was removed from the index?
How do I transfer the NDU Watchlists created on one machine to the Norgate Data database on another machine?
Why does the S&P 500 Watch List contain more than 500 tickers?
How can I improve the update speed?
- Exclude your NDU database folder from real-time antivirus scans. To find the location of your NDU database see How can I find my Norgate Data database?
- Store your database on an SSD drive (you can either replace your main system drive or purchase an SSD as an additional drive). Solid State Drives increase performance significantly.
This is typically due to a low quality internet connection failing to support a multithreaded download. Go to NDU > Settings > Connection and select Connection Type = Single to see if that helps.I've stopped updating from one of my two computers, so why am I prevented from installing on another?
We don't track individual machines - instead we keep count of the total number of machines that have logged in. If you want to abandon one of two existing installations, and install on a new machine, the process is to notify us so that we can re-start the count. Ask us to "reset my hardware keys" or "restart my machine count". As soon as 2 machines have logged in again, the limit has been reached again (we don't care which ones they are).What does it mean if a symbol has a prefix?
Symbol prefixes are used to identify items in the database that aren't exchange-traded.
The following conventions apply -
$ = Index # = Economic or Market Indicator % = Interest Rate @ = Cash Commodity & = Continuous Futures ContractHow are symbol overlaps between AU and US stocks handled?
By way of the country suffix ".au".
If a subscription to AU Stocks exists on its own, then the symbols have no suffix.
However, if a subscription to US Stocks is also current, then the AU stock symbols are given the country suffix ".au" to distinguish them - e.g. CBA.au.
US stock symbols are never given a suffix.
You can find the location of your database by opening NDU and clicking on the Database tab or on Settings > Database Location. To open the folder, go Settings > Database Location and click "View Database folder contents".
Please note that the default database folder "c:\ProgramData\Norgate Data" might be hidden by Windows and therefore not shown in Windows Explorer.
See the instructions provided here.I have installed the NDU database on d: drive. Why am I getting a pop-up warning about free disk space on c: drive?
"Temp files" are typically directed to a Windows folder on c: drive by default.
After NDU has been installed, it requires a minimum of 500 MBs of free disk space on c: drive to keep functioning.
We provide a facility to give "advance warning" about current space on c: drive (Settings > Notifications). You can either untick the facility or set the threshold to suit yourself.
No. Corrections come through to us from our primary upstream suppliers and these are transmitted automatically.
Other errors and omissions are corrected by us as soon as they are discovered.
For stock market data, corrections may apply to any number of things, including:
- Trade corrections/cancellations
- Index prices and volumes
- Record status (i.e. information relating to suspensions)
- Delisting status
- Dividend type
- Dividend ex-date
- Sector/Industry classification
- Surviving entity determination (mergers & acquisitions)
And so on ...
My Watchlist Library includes watchlists for "Current & Past" index constituents.
To avoid "survivorship bias", do I simply reference such a watchlist in a back-test?
No. A watchlist for "Current & Past" is a collection of all stocks that were ever members of an index - but the watchlist itself conveys no information about when any stock was in the index. To access this information, please see Making Use of Historical Index Constituents.When a symbol in a watchlist for "Current & Past" has a date suffix - like XYZ-201506 - does the suffix indicate when the stock was removed from the index?
No. The date suffix distinguishes delisted stocks from currently-listed, with the suffix indicating the year and month that the stock was last traded. Past members of an index can still be currently-listed.How do I transfer the NDU Watchlists created on one machine to the Norgate Data database on another machine?
Follow the instructions above to open the NDU database folder. Copy the entire Watchlists sub-folder to the 2nd machine. If you already have some Watchlists on the destination machine then you may need to "merge" the contents when pasting. Once finished do an update in NDU.Why does the S&P 500 Watch List contain more than 500 tickers?
AmiBroker users will then also need to run database maintenance.
In 2014, separate share class lines were added for Discovery Communications and Google Inc to bring the total number of constituents to 502. Further such additions brought the total to 505 after the September 2015 re-balance. However, in July 2017, S&P Dow Jones Indices announced that it would no longer add companies with multiple share class structures to the S&P Composite 1500 or its component indices (the existing constituents were excused from the methodology change).