Premium Data Products Support Corporate
Introduction
- The Service
- The Software

Market Coverage
» Australian Market Data
» US Market Data
» World Indices

US Market Data
- Overview
- Layout & Security Types
- Subscription Options
- Historical Database
> Database Maintenance
- Custom Folders
- Update Schedule: March
- Update Schedule: April to September
- Update Schedule: October
- Update Schedule: November to February

Getting Started
- Price
- Subscribe
- Free Trial

DATABASE MAINTENANCE

"Database Maintenance" is the process by which your US Stocks database is automatically kept "tidy" with respect to new listings, de-listings, symbol and name changes and price adjustments made to account for splits, reverse splits and other "capital events".

The following actions are performed as part of the daily database maintenance:

  • Historical equity prices are adjusted for changes to a company's capital base.
  • De-listed securities and associated trading instruments are moved from the main database to a "Delisted Securities" folder.
  • Securities that have undergone a name or code change are refreshed to reflect the new name or code.
  • New securities that have been added to the database are assigned their full names.
  • Securities that have changed their listing "location" (e.g. have moved from NYSE to NASDAQ or from NASDAQ to OTC) are automatically transferred to the appropriate folder with full trading history intact.

Can't I just use free data from the internet and do the maintenance myself?

It's theoretically possible, but a huge task in practice. Why spend all your time maintaining your database when you should be looking for trading opportunities? The table below shows the number of corporate actions that Premium Data processes in a typical year:

  Average Maintenance Actions Per Year
Exchange Capital Adjustments (e.g. splits & reverse splits) Company Name Changes Symbol / Company Name Changes Symbol / Company Name
& Exchange Changes
Delistings
AMEX 18 114 30 30 84
NASDAQ 342 168 600 432 342
NYSE 210 492 66 96 96
OTC 360 450 6228 60 456
TOTAL 930 1224 6924 618 978