370 likes | 584 Views
Bloomberg @ SFU. Mark Bodnar Business Librarian mbodnar@sfu.ca. Housekeeping & Agenda. Goals Handouts Beyond Bloomberg. Logging in Training Equity tour News Starting points Excel API Help. Bloomberg @ SFU. Logging in. Logging in. Training.
E N D
Bloomberg @ SFU Mark Bodnar Business Librarian mbodnar@sfu.ca
Housekeeping & Agenda • Goals • Handouts • Beyond Bloomberg • Logging in • Training • Equity tour • News • Starting points • Excel API • Help
Training Enter BU (Bloomberg University) to get to this page
Equity tour Microsoft’s Description page: DES MSFT US EQUITY DES or Microsoft <HELP> -- then pick DESDescription from the list
Equity tour Price chart for MSFT: GPO
Equity tour Financial Analysis choices for MSFT: FA
Equity tour Earnings Estimates choices for MSFT: EE
Equity tour Peer valuation for MSFT: PV
Equity tour Analyst Recommendations for Ballard Power: ANR
News Top News with the default category of Worldwide:TOP
News Other possible News categories
News Top News with the category changed to Bonds
Starting points Industry Overviews: IBQ – then choose from among 68 industries
Starting points World Bond Markets Monitor: WB
Starting points World Equity Indices Monitor: WEI
Starting points World Economic Calendar: WECO
Starting points Market Monitor: NW (Help pages shown here)
Excel API Building a sheet Bloomberg @ SFU
Excel API Dynamic updating
Excel API Populated sheet (1)
Excel API Populated sheet (2)
Excel API Enter BBXL for sample spreadsheets (and more)
Excel API Enter BBXL for sample spreadsheets (and more)
Help Either: Oil <HELP> or <HELP> + search for Oil
Help Either: Pharmaceuticals <HELP> or <HELP> + search for Pharmaceuticals
Final Notes • Bloomberg: Practice • Beyond Bloomberg: Other financial databases at SFU… • Datastream • WRDS: Compustat/CRSP/BvD + ?