Berkeley Options Data Base Extraction

You can use this form to extract data from the Berkeley Options Data Base. All users are encouraged to read the User's Guide before extracting data. Please make your selections below: be sure to fill in all fields. Due to the very large size of these files, you are limited to:

• Extracting one record type at a time.
  Note: not all record types exist for all tickers or in all years.
• Extracting data from one year at a time.
• Output file sizes of no more than 1G (which is over 24 million records).
• Not using more than 5G total for all extract files on the server.
• All files older than three days will be automatically deleted.

On the bright side, you can extract as many tickers as you like, and the job can take as long as necessary.

Tickers are entered in a file included in the form submission. This file must have the following format:

• It must be a plain text file - NOT a MS Word or Excel file.
• There must be one and only one ticker on each line of the file.
• All tickers must be in UPPER CASE letters.
• There should be no leading or trailing blanks.

Once the job has completed, you will be sent email with instructions on how to access the file. If you want to analyze the data in Stata you will need the dictionary and the do file. If you want to analyze the data in SAS, then you will need a program for UNIX or one for either Windows or UNIX