沃顿商学院金融数据库产品介绍(WRDSLibrarianColloqu

NavigatingWRDS:OverviewofFinancialDataonWRDSCRSP,Compustat,andIBESDenysGlushkovRabihMoussawiWRDSLibrarianColloquiumWashington,D.C.,June15,2009Agenda•WhatisWRDS?•SourcesofFinancialData•OverviewofCompustat,CRSP,andIBESData•WRDSToolsandSupport:HowtoGettheHelpYouNeed?•HowCanResearchersUseWRDSMoreEfficiently?WRDSOverview•Singleandflexiblesourcetoextractdatafromleadingresearchdatabases–Varietyofdisciplines:Accounting,Finance,Economics,Banking,Insurance,Marketing,Statistics,+–Standardizedqueries:Everydatabasewebpagehasthesameformat:query+variabledocumentation+listofmanuals,overviews,&researchapplications–IdealforDatalinking:e.g.CRSP(stockprices,dividends,splits),LinkingCRSPandCOMPUSTAT,MatchingIBESandCRSPData,+linkingsampleprograms•Internet-basedplatformwithmultipleaccessoptions–Webqueries:compatiblewithvariousbrowsersandoperatingsystems(nothingtoinstall)•Standardized,easy-to-use,point-and-clickinterface,unlimiteddownloads(~2GBsizelimitperquery)•Easyvariableandcompanynamesearches,andothertools•FastextractsandrecordretrievalsthroughTerraBytesofdata–PCSASCONNECTremotelibraries–UNIXX-Windowsandbatchjobcapabilities•Full-timeresearchandtechnicalsupport–Onlinehelp(variabledefinitions,datasources,equations,manuals,tutorials,sampleprograms,FAQs),emailsupport,and24/7networkmonitoring–DataOverviews,ResearchApplications,KnowledgeBaseandForums@WRDS–WeareWRDSuserstooWRDSHistory•OriginallydevelopedforWhartonneeds:–Centralizedatamanagementandresearchsupport–ProvidefacultyandPhDcandidateswithweb-based,andinteractiveresearchtools•Grownfrom2subscribersin1997to250+subscribersin2009:–Alltopacademicandnon-profitresearchinstitutions–Wesupportover18,000facultyandotherresearchers’accounts•Dataincreasedfrom60GBto30+TB–Originallyaccountingandfinancialdata;nowincludeseconomic,banking,insuranceandmarketingdata–SeveralFreeDataSources•Partnershipswithleadingdatavendors:Grownfrom2to40+dataprovidersDataLicensingandAccesswithWRDSDatabasesàlacarteDataWRDSLicensingSubscriptionAgreementAgreementRe-distributionagreementWRDSDataVendorWRDSSubscriberWRDSTechnologyFlexibilitytoConnectandGetDataLibraries/LabsOntheroadUserPCWRDSserverWRDSAccountTypesWebUNIXExpirationquerieslogin**datesFacultyxxFulltimeStaffxxPhDCandidatesxxxMasterStudentsxxResearchAssistantsxxxVisitors*xxxSharedClassAccountsxxLibrary&IP-basedx*‘Visitors’musthaveformal,temporaryappointment**AlsoallowsforPCSASCONNECTsessionsMarketDataCRSP,OptionMetrics,&others-PricesandReturnsofequitiesandbonds-SharesOutstanding,Volume,andMarketCapitalization-HistoricalData,noselectionorsurvivalbiases-Prices(NAVs)andReturnsofREITSandClosedendfunds-Prices,Volumes,andImpliedVolatilitiesoftradedOptions-BondPrices,Returns,andRatings(S&PRatings,FISD,Trace)AccountingDataCompustat&others-BS,IS,andCFnumbersfrom10-K,10-Qfilings-QuarterlyandAnnualFreqs(observedwithlags)-Financial,Accounting,andIndustrySpecificData(e.g.SSS,VerifiedOilReserves)-ExecutiveCompensationData(Analyst)ForecastsDataIBES,FirstCall,&others-AnalystexpectationsaboutcompaniesfutureEarnings(futureEPS,g(sales),orSSS)-Valuationassessments:Recommendations,PriceTarget-RevisionsandnewestimatesondailyfrequencyOwnershipDataThomsonReuters’OwnershipData-Ownershipbycompanies’insidersandlargeblockholders-AggregateOwnershipbyinstitutionswith$100millionindiscretionaryassets,atthesecuritylevel(e.g.hedgefunds,mutualfunds–VanguardGroup)-Ownershipbymutualfundmanagementcompanies,atthefundlevel(e.g.VanguardS&P500IndexFund,etc…)SECEDGAR,IAPD,…Sell-SideAnalysts(brokers)Exchanges,&…DataonWRDS–EasyandFlexibleExtractsS&P’sCompustatAccountingandFinancialData•CompustatNorth-America:U.S.andCanadianfundamentalandmarketinformationonaround31,000activeandinactivepubliclyheldcompanies,from1950-present•CompustatGlobal:fundamental,market,andcurrencydataformorethan30,000publiclytradedcompaniesinglobalmarkets(80countries),from1988-present•FundamentaldataavailableonanannualandquarterlyfrequencieswiththousandsofIncomeStatement,BalanceSheet,StatementofCashFlows,andsupplemental&industry-specificdataitems•MarketdataavailableonamonthlyanddailyfrequencieswithPrices,Dividends,Returns,TradingVolume,SharesOutstandingandShort-InterestInformation•InformationonIndices,Segments,Banks,Incentiveplans,PensionDataItems,aswellas:ExecutiveCompensationandS&PCreditRatingsXpress•Inthesummerof2007,WRDSadoptedtheXpressfeedformatofCompustatNorthAmerica,containingmoredetailsonawiderarrayofcompaniesCompustatExample–LiveDemo•GetCurrentAssets,Inventories,andLong-TermDebtforMicrosoft,Dell,andIBMbetweenJan2000andApril2009:NorthAmerica&GlobalOtherDataSecurityDataNorthAmerica&GlobalCompanyFinancialandAccountingDataS&PCreditRatingsXpressPoint-In-TimeIndustrySpecificSegmentExecutiveCompensationWRDSSupport:Compustat•OverviewtoCompustatXPressfeedDatabase,FAQs,andWRDSReferenceMaterials