Restricted Access Period for Mid-term Exams

From 8am to 7pm, Monday to Friday, February 20th through March 9th, Watson Library is open to all current graduate students, undergraduates in economics, faculty, and staff.

At all other times during these two weeks, i.e. after 7pm until close and all open hours on Saturday and Sunday, Watson Library is available to all University affiliates.

If you need materials or services during the 8am to 7pm period designated above and you are not in one of the groups listed please ask a library staff member for help.

Study space is available in Butler Library, Lehman Library (3rd floor of International Affairs Building), and the Science and Engineering Library (campus level of the NorthWest Corner Building).  http://library.columbia.edu/services/study-spaces.html

And check out the designated talk zones now available across the across the Columbia Libraries!  https://blogs.cul.columbia.edu/business/2015/09/01/talk-zones-come-to-columbia-libraries/

If you have any questions, please contact our staff at 212-854-7804 or business_circulation@library.columbia.edu.  Thanks.

ADI Hackathon – February 3rd-4th

The Application Development Initiative Group (ADI) will be hosting a Hackathon in the Watson Library of Business & Economics starting at 4pm this Friday, February 3rd, and ending at Noon on Saturday, February 4th.  During this time, use of the main ground floor reading room and study rooms (G01-G17) will be restricted to use by Hackathon participants.  The rest of the Library (including the computer workstations, 1M & 2M study spaces, and mezzanine study rooms) will remain accessible to all eligible patrons as usual.

To view the hours of operation for Watson Library, please visit this page… https://hours.library.columbia.edu/?library=business

To contact the Watson Library staff, please call 212-854-7804 during our open hours or send an  email to business_circulation@library.columbia.edu.  Thanks.

New Dataset: Infogroup’s Historical Business File

Columbia University has access to the Infogroup’s Historical Business File via WRDS.

Infogroup gathers geographic location-related business and residential data from various public data sources, such as local yellow pages, credit card billing data, etc. The Infogroup database at WRDS contains two packages: Historical Business and Historical Residential, both of which largely focus on US sectors.

The Historical Business data starts in 1997, while Historical Residential dates back to 2006. The Historical Business data is a calendar year-end snapshot of local business data. It contains business identification, location, industry, corporation hierarchy, employment, sales, and other fields.

For more information about this dataset, please visit this page

Figure 1

Table1

Table2

Using Python, R, MATLAB APIs for Datastream!

Do you know that in addition to Excel API, now you can also extract data easily from Datastream by using Python, R, or MATLAB?

For Python:

PyDatastream is a Python interface to the Thomson Dataworks Enterprise (DWE) SOAP API (non free), with some convenience functions for retrieving Datastream data specifically. This package requires valid credentials for this API.

It is a Python API for time-series data which abstracts the database which is used to store the data, providing a powerful and unified API. It provides an easy way to insert time-series datapoints and automatically downsample them into multiple levels of granularity for efficient querying time-series data at various time scales.

 

 

Alternatives for other scientific computing languages:

Please note that only PhD students and faculty can request credentials. Please email business@library.columbia.edu if you had any questions.

New CBS Students Raffle Results!

Welcome to Columbia! Thank you all for attending the raffle hosted at the resource fair in Watson Library. We have our three winners here:

  • Amerder Chawlar – Winner of $10 Starbucks GC

raffle-winner-aug-2016-ameider-chawla-10-starbucks-gift-card1

  • Ruoyun Luo – Winner of $10 Starbucks GC

raffle-winner-aug-2016-ruoyun-luo-10-starbucks-gift-card

  • Pedro Barbara – Winner of $25 Starbucks GC

raffle-winner-aug-2016-pedro-barbara-25-starbucks-gift-card-1_2

Congratulations again! Hope y’all have a wonderful semester!

Reduced & Labor Day hours

The Watson Library of Business & Economics will be open for reduced hours from 1pm-9pm on Friday, September 2nd to allow for the LEED Exam to take place in the morning.

Our Research Librarians will still be available for office hours on Friday between 1pm – 5pm.

Watson Library will be closed from Saturday 9/03 through Monday 9/05 in observance of the Labor Day Holiday weekend.  Regular Fall hours begin on Tuesday 9/06.

The Library’s full schedule can be viewed at… http://hours.library.columbia.ed/?library=business

Please contact us at 212-854-7804 or business_circulation@library.columbia.edu if you have any questions.

Business School Resource Fair

As part of new student orientation, the Business School will be holding a Resource Fair in the Watson Library of Business & Economics on Monday, August 22nd.

This event is open to incoming MBA students only, so the ground floor reading room and study rooms will be unavailable to library patrons between Noon – 5:30pm.

The 1M & 2M study spaces and mezzanine study rooms will remain open for library patrons between 8am – 7pm.

To view Watson Library’s hours of operations, please visit… http://hours.library.columbia.edu/?library=business.

For questions regarding access to Watson Library, please call 212-854-7804 during our open hours.  Thanks.

[Metro SIG Meeting] Historical Corporate Annual Reports Digitization Project

cover

This Wednesday, June 8 2016, Watson Library’s Interim Head Jeremiah Trinidad-Christensen was invited to make a presentation at the Metro’s Economics and Business Librarians SIG meeting about the Historical Corporate Annual Reports Digitization Project in Watson Library.

Jeremiah provided an excellent summary of this widely-used digitization project, which was conducted by a group of Watson Library staff, led by our Collection Development Librarian Yasmin Saira from 2007 to 2009. The audiences were hugely intrigued by the fascinating stories Jeremiah extracted from these reports; everyone was also amazed at the visualization he created in the end, using one of the historical NYC maps:

map

If you want to learn more about this historical corporate report collection, here are some relevant links:

If you would like to request a full copy of this presentation, or had questions regarding our collections, please reach out to us at business@library.columbia.edu

Thomson One: Workaround for using Chrome and Firefox

Thomson One is a useful database for financial data on public companies, as well as merger and acquisition information and market data. Users can search and screen across databases to identify companies that meet your specific investment criteria as well as conduct peer analysis.  Includes Investext, Private Equity database (Venturexpert) and Thomson Deals (SDC Platinum).

However it proves to be difficult because of its compatibility with only Internet Explorer (IE) pre-version 10.  However this is a workaround with an extension/Addins for Chrome/Firefox.

Please note that not all functions are supported with this solution (i.e. downloading analyst reports).

Please note, this information was gathered from a various business libraries. 

 

Welcome new and returning students!

DSC_1167

Contact a librarian for research help:

  • In person: Monday to Friday, 1pm to 5pm – ask for help at the service desk
  • Phone: Call us at 212-854-7804
  • Email [24 hour response on weekdays]
  • Consultations: email to set up an appointment
  • IM a research librarian for help with your research.

Search library resources:

  • Consult our research guides
  • List of business and economics databases
  • Use CLIO, the Libraries catalog to search for books, journals, ebooks, ejournals, articles and more!  Watch this short video to make the most out of CLIO!

Use the Columbia Libraries:

  • Hours
  • Find a study space
  • Reserve a study room in Watson [Business school students only]
  • Reserve a study room in Butler, Lehman or the Science and Engineering Library
  • Course reserves information
  • Printing in the Watson Library
  • Information about access to the libraries, loan periods, fines, etc.