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?
DatabaseHow can I find my Norgate Data database?
How do I change the Database Location?
Do I need to keep a back-up copy of the Database?
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?
WatchList LibraryWhere are my Watchlist Library files stored?
How do I transfer the NDU Watchlists created on one machine to the Norgate Data database on another machine?
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?
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?
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 Database Download Method = 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).How can I find my Norgate Data database?
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.Do I need to keep a back-up copy of the Database?
Generally-speaking, you don't need to keep a back-up of the entire Database folder. If any database goes missing or becomes corrupt, you can click on the Database tab in NDU to download a replacement. However, you should keep a particular back-up of the "Watchlists" sub-folder to insure against accidental loss of files you have created in the Watchlist Library. See: "Where are my Watchlist Library files stored?".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 ...
Where are my Watchlist Library files stored?
The files are stored in binary format in the "Watchlists" folder under the Norgate Data database folder.How do I transfer the NDU Watchlists created on one machine to the Norgate Data database on another machine?
They are additionally stored as text files in the Watchlists\txt sub-folder.
Follow the instructions for "How can I find my Norgate Data database?" 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.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?
AmiBroker users will then also need to run database maintenance.
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.Why does the S&P 500 Watch List contain more than 500 tickers?
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).