Blog2Blog Maak je eigen Blog2Blog | Gratis je eigen blog c.q weblog op internet Blog.nl Blog2Blog
loans
Financial Databases and Research
Financial Databases and Research

Doing searches in LexisNexis source Edgar online

Posted in LexisNexis

 

In the past I mentioned that EDGAR Online was also available in LexisNexis (with information going back to 1993/1994 !). The source grouping where it can be found has undergone a name change. The location for finding EDGAR Online through LexisNexis (Academic) is now:

 

English group names:

Main Group: Company Information - incl. D&B, M&A, bankruptcy
Subgroup: All Company Information (excluding Investext)

 

 

Dutch group names:
Groep: Bedrijfsinformatie - incl. D&B, F&O, Faillissementen, etc.
Subgroep: Bedrijfsinformatie (excl Investext en D&B)

 

 

In another post I mentioned that it was possible to do a search in this database using the name of the company or it's CIK number in combination with the name "Edgar Online" and the name of a SEC Filing form. An example of a specific search would look as follows:

 

"Edgar Online" W/10 KELLOGG AND "FORM TYPE: 10-K"

 

A search using the CIK number of the Kellog Company would look like:

"Edgar Online" W/10 0000055067 AND "FORM TYPE: 10-K"

 

Using a CIK number to search for information does not work nearly as well as a search using (part of) the actual company name. LexisNexis does not handle zero's very well if these appear in front of a string. These zero's will be automatically deleted and LexisNexis will search instead for the number 55067 instead of a string of characters like 0000055067. Placing the CIK number between quotation marks unfortunately does not work. The best way to search for company information in Edgar online (through LexisNexis) is therefore using the name of a company.

 

Author information: LinkedIn

 

12:48 PM - 17 March 2010


LexisNexis source: EDGAR Online

Posted in LexisNexis

 

The EDGAR Online database (Electronic Data Gathering Analysis and Retrieval) contains the filings of companies to the Security and Exchange Commission in America. Specific filings are necessary for specific corporate changes or reports. The companies that deposit filings are US companies as well as foreign companies or multinationals that are required by US Law to do so.

 

Examples of filing forms and their codes are:

  • S-1: This filing is a pre-effective registration statement submitted when acompany decides to go public. Commonly referred to as an "IPO" (Initial PublicOffering) filing.
  • S-8: This filing is required when securities are to be offered to employees pursuant to employee benefit plans.
  • N-1A: Registration statement for Mutual Funds.
  • DEF 14A: Provides official notification to designated classes of shareholders of matters to be brought to a vote at a shareholders meeting. This form is commonly refered to as a "Proxy".
  • 10-Q: A quarterly report which provides a continuing view of a company's financial position during the year. The filing is due 45 days after each of the first three fiscal quarters. No filing is due for the fourth quarter.
  • 10-K: An annual report which provides a comprehensive overview of the company for the past year.
  • 20-F: Annual and transition report of foreign private issuers filed pursuant to sections 13 or 15 (d) of the Securities Exchange Act.

A comprehensive list of the filing types covered by Edgar Online can be found at the website of EDGAR Online: filing list.

 

EDGAR online is available in LexisNexis (covering 1994 to now) through the SUBGroup: All Company information (Excl. D&B) [= Bedrijfsinformatie (Excl Investext en D&B)].
A limited version of EDGAR online is freely available through the
EDGAR onlne website.

 

Author information: LinkedIn

 

04:04 PM - 5 April 2009


LexisNexis and executive compensation information

Posted in LexisNexis

 

These days, when the Credit crunch is all over the news, there is also talk of executives receiving salaries and bonuses that are excessive. Newspapers also report on negative results due to exceedingly large compensations which sometimes caused executives to take actions that were good in the short term for themselves or the shareholders but may have worsened company stability and performance in the long run. With all the increased attention on executive compensation there is also a lot of interest in sources that offer information on this.

There are few sources that have information on executive compensation. Two of these sources I mentioned earlier in this blog: Compustat ExecuComp and Hoover's Company Records. LexisNexis also sometimes has some limited information in some of the company sources.

 

Two particular sources offer much more than brief information on executives of US companies:

  • EDGAR Online
    This report source contains full-text company reports from the US Securities and Exchange Commission from 1994 to now and is
    updated daily. Edgar is available through the SUBGroup: All Company information (Excl. D&B) [= Bedrijfsinformatie (Excl Investext en D&B)]
  • U.S. Executive Compensation Database
    CoreData's U.S. Executive Compensation database provides executive compensation and auditor fees, as reported in the Annual
    Meeting Proxy Statements or Form 10-K, filed with the U.S. Securities and Exchange Commission. The source offers information that goes back 5 years and it is updated weekly. This source is available through SUBGroup: US Company Reports of the section US Company Reports [= Bedrijfsinformatie - V.S. ondernemingen]

If you want to look for reports on executive compensation in both sources you can use either the company names or CIK identification codes in combination with the string "DEF 14A". If you use this string literally between quotes you will get these specific reports. For Edgar Online reports in the SUBgroup All Company information (Excl. D&B) you need to add the name of this source between quotes as well: "Edgar Online".

 

For EDGAR Online a search in the SUBGroup on the company Adobe Systems INc would look like:

- Example 1: "Edgar Online" AND "DEF 14A" AND 0000796343

- Example 2: "Edgar Online" AND "DEF 14A" AND "Adobe Systems"

 

For U.S. Executive Compensation Database a search in the SUBGroup on the company Adobe Systems INc would look like:
- Example 1: "DEF 14A" AND 0000796343
- Example 2: "DEF 14A" AND "Adobe Systems"

 

Author information: LinkedIn

 

 

12:05 AM - 27 February 2009


Three new Dutch company sources in LexisNexis

Posted in LexisNexis

 

The following new sources have recently been added and are now available through the Company module of LexisNexis:

 

Dutch Company Information Mergers & Acquisitions
Description: A database with M&A deals, where at least one Dutch party was involved in. All phases of a transaction (intention, draft agreement, deal, ...) are represented, offering a chronological insight in Dutch M&A activities.
Coverage: From January 08, 1992 through current
Updates: Weekly
Language: Dutch

 

Curatoren.nl
Description: Curatoren.nl is an up-to-date database, containing public reports and other public information on bankruptcy,
payment postponements and debt redevelopment.
Coverage: From August 17, 2007 through current
Updates: Daily
Language: Dutch

 

Dutch Company Information Ownership Structures
Description: A database with company ownership information, containing several degrees of relationships (e.g. shareholders of shareholders; affiliates of affiliates) for the major Dutch companies, both public and private. Both majority and minority shares are displayed, and searchable. This database is maintained by the editorial team of LexisNexis in the Netherlands and is updated on a weekly basis. Various sources are used: company annual reports, press releases, AFM filings, questionnaires, ... Main data items covered per company: shareholder name, shareholder country, shareholder percentage, affiliate name, affiliate
country, affiliate percentage. This data also contains hyperlinks to highly detailed company reports (BIORG)
Coverage: From 2007 through current
Updates: Weekly
Language: Dutch

 

Author information: LinkedIn

 

11:28 PM - 27 January 2009


Company information in LexisNexis

Posted in LexisNexis

If you have access to the company module of the provider LexisNexis some valuable company information sources are available. Most of the sources offer plain text basic information and some more extensive financial data. Most of the reports that have financial information cover just 1-5 years of financial data. Some of the more interesting sources with financial data are: Thomson Extel Cards, WorldScope and Hoovers.

Several specific sources have information on subsidiaries, company hierarchy or allies companies. Some of those are: Hoovers, Directory of Coporate Affiliations, and the Hoppenstedt Konzernstrukturen. There are even sources that offer links to extensive financial information or even annual reports in PDF format. A couple of sources specifically concern  executive compensation information: U.S. Executive Compensation Database - Boards & Committees, and Dutch Company Information, Managers and Directors.

An overview of some of the sources available in LexisNexis can be downloaded here. I have tried to list individual information available in the reports for a source as well:

                                           LexisNexis-Company-overview1.xls

Depending on the interface the module is available as the "Company" part. Once you have selected this section you can search through the module. Most sources in the module are grouped according to nation or region. It is not possible to search through a specific source using most groups. You will have to combine a company search in a selected group with (part of) the name of a source.
There is a separate tool to look up company names which even sometimes offers the option to use company hierachy information to combine/include subsidiaries or parent company names. The tool is available under first search box as "Company name look-up".



Once the search is processed the result will be presented and usually grouped by source. You may also use the options below this to group the result according to: Subject, Industry, Company, Geography, Language or People. Above the options to group the search result there is also the option to combine more than one group.



Once you have selected a report there are several options to save a report. If the report contains financial information there usually is an Excel option to export the data from this part to Excel: "Download Table".

Author information: LinkedIn

10:35 PM - 28 July 2008


Description
This weblog will deal with all kinds of tips and tricks on the use of several financial databases.
Home
User Profile
Sections
--- Amadeus
--- Datastream
--- Factiva.com
--- GMID
--- General
--- International Statistics
--- LexisNexis
--- SDC Platinum
--- S&P Indexes
--- Wharton
Recent Entries
- Doing searches in LexisNexis source Edgar online
- Compustat North America & S&P Indexes
- Simple functions & Datastream - Addendum
- Datastream and SDC Platinum (M&A)
- The new OECD iLibrary



External Links:
--- NYSE Euronext
--- Finabase Blog
--- VU Law Blogspot