Your Best Financial Guide Our mission is to help our clients succeed in making timely decisions by setting up the efficient financial infrastructure and providing the reliable financial information 서울시영등포구여의도동 45-2 증권센터빌딩 4 층 Tel: 02-769-7700 Fax: 02-769-7788 Email: fnguide@fnguide.com 0
Index What s DataGuidePro? How to Use DataGuidePro? DataGuidePro Overview 1. FnGuide Reports Market Reports Company One 2. Set-Form Data 3. Cross Sectional 4. Time Series 5. Analytic Tools FnValuation Index Generator Screener 1
What s DataGuidePro? User 와에프앤가이드의방대한 DB 를직접연결해주는엑셀기반의계량분석 Tool 주식, 재무, 채권, 경제, Consensus, 해외 DB, Templates, Valuation Model User FnGuide DB 메뉴선택 / 조건지정후엑셀로다운로드 DataGuide Pro 의특징 원하는데이터를쉽고빠르게찾아주는최강의금융정보제공 Tool 시간과비용이많이드는데이터수집및리서치비용을극적으로절감 DataGuide 하나로주식, 재무, 채권, 경제, 컨센서스, 해외데이터등모든금융데이터를추출 Excel 인터페이스를채택하여데이터수집및투자분석업무효율을극대화 트리구조방식의메뉴채택으로쉽고편리하게데이터검색가능 출력된데이터를항상최신데이터로업데이트할수있는 Refresh 기능제공 시장및개별종목에대해 One-stop으로분석할수있는템플릿제공 사용자정의모델포트폴리오구성및성과분석기능지원 국내외금융기관에서모두사용할수있도록영문출력기능지원 2
How to Use DataGuide Pro? 엑셀상에 DataGuide 메뉴가추가되어원하는데이터를쉽고빠르게출력 1 데이터가이드설치후생성되는아이콘을클릭하여프로그램을실행하면 2 엑셀창이오픈되면서메뉴에 DataGuide Pro 메뉴가추가됨. 3 원하는메뉴를선택한후조회항목, 검색하고싶은데이터등조건을다 양하게선택한후 Submit 클릭하면 4 엑셀창에지정한데이터가출력. 다운로드후데이터를다시얻고싶을경우, 조건추가 / 수정후상단의 Refresh 버튼을누르면업데이트된데이터가출력. 3
DataGuidePro Overview DataGuide 의데이터구조 Data Pool 에프앤가이드의방대한데이터를그대로확인할수있는데이터다운로드센터 FnGuide Reports (Template) 유저가자주사용하는데이터를보기편한리포트형태로가공하여제공 Market Report 다양한마켓레벨의데이터를리포트형식으로보여주는메뉴 Company One 차트와그래프를이용하여개별기업의모든정보를보여주는기업리포트 Raw Data Set Form Data FnGuide 의데이터베이스를카테고리별로재구축 Cross Sectional Time Series 카테고리에상관없이사용자가원하는형태로다양한데이터를출력 원하는데이터를시계열로볼수있는메뉴 Calendar Basis 및 Fiscal Basis 로구분하여데이터출력 Analytic Tool 전문가들을위한데이터분석도구 FnValuation 전문가들이편리하게기업을분석할수있는기업가치평가 Tool Index Generator 사용자가생성하는지수의구성, 관리및결과를조회 Screener 사용자가지정한조건에부합하는종목만을추출 4
DataGuidePro Overview DataGuide 의상세메뉴구조 FnGuide Reports Market Report Company One Indicators Key Indicators Macro Indicators Derivatives Indicators Forecast Aggregates-MF500 Index Comparison Sector Comparison Analysis by Sector Earnings Surprise Reported Aggregates At a Glance Financials Consensus Snapshot Band Chart Analysis Comparison with Sector Peer Analysis Ratio Analysis Summarized Reports 5Yr Summarized Reports 5Qtr All Industries Aggregated Charts Constituent Performance Industry Band Chart Composition History Reports and Disclosure Financial Activities Consensus Overview Research Reports IR Reports Disclosure Cross Sectional Time Series Calendar Basis Fiscal Basis Ownership Capital Changes 4Yr,4Qtr Dividends 4Yr Treasury Stock 4yr,4Qtr Outline and History Corp. History Investment Securities Issued Bonds Credit & Bond Trade Analytic Tools FnValuation Index Generator Screener 5
DataGuidePro Overview DataGuide 의상세메뉴구조 Set-Form Data Company Financials Derivatives Financial Reports Futures/Options Combined Reports Swap Data Stocks Price Trend No. of Shares Index Trend Bonds ELW Cross Sectional ELW Time Series ELW Issue Amount by Underlying Relative Performance Company Bond Issue Beta History Company Credit Ratings Beta Calculation Company Bond Trading Consensus Issued Bonds List Company Consensus Trend Company 12M FWD EPS Trend Daily Consensus Consensus Synthesis Consensus Comparison Consensus Top 30 FWD EPS Aggregates Company Forecast House Forecasts Analysis Forecast Issue by Purpose Issue by Embedded Option Credit Ratings Market Trading Trend Closing Quotes Base Yield Trend Daily Base Yields Retail Bond Index Daily Bond Index Daily Index Trend Events Market Capital Change History Overall Money Flow Capital Change Summary Securities Market Money Flow Treasury Stock Change Investors Activity Dividends Investors Activity by Company Company Name Change Program Trading No. of Shares Locked Up Stock Lending Economy Stock Lending by Sector Overseas GDR/ADR Trend Overseas Company Overseas Index 6
1. FnGuide Reports Market Reports / Company One Market Report 매일변화하는금융시장에대한국내외주요지표들을원클릭으로조회가능 거래소 / 코스닥분류및국제표준체계를따른 FICS 업종분류별합산데이터에따른각종분석용차트를제공 각종보고서작성시사용자가신속하고편리하게참조및인용가능 Company One 개별종목에대한기업개요, 재무정보, 컨센서스, 지분율등에대한데이터를원스탑으로조회 탐방리포트로쓰이는스냅샷과자주사용하는밴드차트를보기편한형태로제공 기업분석리포트, IR 리포트, 공정공시자료를동일한인터페이스에서조회 7
2. Set-Form Data Set-form Data Set-form Data 는에프앤가이드의방대한데이터베이스를그대로옮겨놓 은메뉴로카테고리별로정리된재무, 주식, 컨센서스, 이벤트, 파생상품, 채권, 경제및해외데이터를일괄적으로쉽게출력할수있음 Company Financial - 개별기업의재무제표와복수기업의합산재무제표를다양한형태로조회 Stock - 주가추이, 주식수와시가총액정보, 업종지수, BM대비상대수익률, 역사적베타 Consensus - 증권사애널리스트들의추정실적을다양한방법으로보여주므로향후주식시장에서의개별및복수기업들에대한흐름예측가능 Derivatives - 주가지수및개별종목의선물 / 옵션가격동향. 종가, 이론가, 기준지수, 거래량, 미결제약정등의정보를제공 Bonds - 채권의발행및유통정보등기본적인채권시장의정보 Market - 시장전반의데이터 Economy - 국내및해외데이터까지약 5만여항목 Overseas - GDR/ADR의가격동향및해외지수추이 매일변화하는금융시장에대한국내외주요지표들을원클릭으로모니터링할수있음 거래소 / 코스닥분류및국제표준체계를따른 FICS 분류에따른업종별합산데이터에따른각종분석용차트를제공함 각종보고서작성시사용자가신속하고편리하게참조하고인용할수있음 8
3. Cross Sectional Cross Sectional Cross Sectional 은사용자정의의포트폴리오를구성하여카테고리에상관없이사용자가원하는특정시점의데이터를다운로드받을수있는메뉴. Code Lookup 을통해종목을선택하고, Item 주식, 재무, 컨센서스데이터등을한번에다운로드할수있도록구성하여 User 중심의데이터편집및관리가능 9
4. Time Series Time Series Time Series 는사용자정의의포트폴리오를구성하여카테고리에상관없이사용자가원하는시계열데이터를다운로드받을수있는메뉴 Code Lookup 을통해종목을선택하고, Item 주식, 재무, 컨센서스데이터등을한번에다운로드할수있도록구성하여 User 중심의데이터편집및관리가가능 10
5. Analytic Tools - FnValuation FnValuation FnValuation은기업분석애널리스트, 운용사의펀드매니저, 기업가치평가를연구하는학교및연구소등전문가를위해엑셀기반으로개발된기업가치평가모델 인터넷, 엑셀기반의편리한 Interface 연간 / 분기모델의자유로운선택가능 다양한재무제표추정로직의선택적적용 국내최고의재무 DB 및주식 DB 를이용한완벽한자본금, 주식수변동로직반영 국내전증권사 Consensus 의 Multiple 포함및추정기간최장 5 년가능 RIM, DCF, EVA 등다양한할인평가방법지원 금액, 주식수단위선택가능및한글 / 영문지원 11
5. Analytic Tools Index Generator / Screener Index Generator Index Generator 는지수생성을위한메뉴로사용자가 정의한종목대로지수를구성하고 EWI 방식및 MCI 방식 으로 Weighting 을하여관리할수있음 사용자가만든지수의수익률및베타를 구할수있고, 시장지수를벤치마크로 한상대수익률을확인할수있음 12
5. Analytic Tools Index Generator / Screener Screener Screener는포트폴리오구성을위한종목추출메뉴로, 사용자가지정하는변수에맞는종목들을추출 추출된종목들은리스트를저장하여다른메뉴에서도손쉽게저장된리스트를불러내어사용가능 13