S p s execucomp training
This presentation is the property of its rightful owner.
Sponsored Links
1 / 12

S&P’s ExecuComp Training 國立政治大學商學圖書館 PowerPoint PPT Presentation


  • 73 Views
  • Uploaded on
  • Presentation posted in: General

S&P’s ExecuComp Training 國立政治大學商學圖書館. 李霜林 漢珍數位圖書公司 April, 2004. Today’s Agenda. Brief Intro to Market Insight What within the ExecuComp Download the ExecuComp Database Build a Query in MS Access Data Item Definition. Brief Intro to Market Insight.

Download Presentation

S&P’s ExecuComp Training 國立政治大學商學圖書館

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


S p s execucomp training

S&P’s ExecuComp Training國立政治大學商學圖書館

李霜林

漢珍數位圖書公司

April, 2004


Today s agenda

Today’s Agenda

  • Brief Intro to Market Insight

  • What within the ExecuComp

  • Download the ExecuComp Database

  • Build a Query in MS Access

  • Data Item Definition


Brief intro to market insight

Brief Intro to Market Insight

  • Company and fundamental data on approximately 10,000 active U.S. companies and 14,000 inactive companies

  • Authoritative Company Info

  • Intelligent Industry Info

  • Objective Country Info

  • Valuable Commentary

    http://mi.compustat.com/


What within execucomp

What Within ExecuComp

  • Executive Compensation Data on the Top Officers of over 2,500 Companies Since 1992

    • Directors Compensation

    • Executive Current

    • Executive History (Last 3 years)

    • Executive Options

    • Executive Peers

    • Executive Total


Download the execucomp database

Download the ExecuComp Database

  • Once logged in, select company tab, and enter the ticker for any company, then click Go

  • Click Executive Compensation folder

  • Select “Exec. Access Db”

  • Save it either in .mdb or .zip file to the proper position


Build a query in ms access

Build a Query in MS Access

  • Open the saved Executive Compensation db in MS Access

  • Once the file is open, 8 different tables displayed in a similar dialog box


Build a query in ms access cont

Build a Query in MS Access Cont.

  • 各資料表簡要內容:

    COLEV, COMPTABL, COPEROL, PERSON

    -- These tables include the majority of the executive compensation info

    -- The other four tables: CODIRFIN, COPERFTB, LTAWDTAB and STGRTTAB include Director info, company financial info and Stock Option Grant Info


Build a query in ms access cont1

Build a Query in MS Access Cont.

  • 點選「查詢」鍵

  • 點選「使用設計檢視建立新查詢」,將出現如下視窗


Build a query in ms access cont2

Build a Query in MS Access Cont.

  • 選取適當的資料表後,請關閉「顯示資料表」對話方塊

  • 在每個選取的資料表中,按兩下點選需要的欄位

  • 按需要定義篩選標準


Build a query in ms access cont3

22 records in total

Build a Query in MS Access Cont.

  • 欄位及篩選標準設定完成後,請按下“ ! ”,執行查詢。


Data item definition

Data Item Definition

  • Definitions Tab in Help Page


Questions

Questions?

請洽漢珍數位圖書公司市場部 李霜林Tel: 02 2736 1058 Ext. 263Email: [email protected]


  • Login