Bloomberg terminals and data limits at Sauder

David Lam Library at UBC Sauder provides access to Bloomberg terminals in Wayne Deans Investment Analysis Centre (WDIAC) and Leith Wheeler lab (Room 222 in the Canaccord Learning Commons). The terminals in WDIAC are for Sauder student use only. The terminals can be booked online (select Book Lab Terminals under Canaccord Learning Commons). Please note that terminal 6 in Leith Wheeler lab is no longer bookable. It is available on a strictly drop-in basis.

Bloomberg data limits
Bloomberg has 3 kinds of data limits:

  1. All of our Bloomberg terminals have a monthly downloading limit. This is strictly enforced by Bloomberg.  If we have reached our monthly downloading limit, users will see the following error message when they try to download: #N/A Limit. This limit is based on unique securities and depends on the type of data being downloaded. For example some data, such as intra-day, is valued a little bit higher than historical end-of-day for any given list of securities. Bloomberg does not recommend more than 5000 to 7000 unique identifiers per month. Once a security is used once in a month, then if you use it again it will not count again towards the monthly limit.
    Bloomberg recently changed its policy and no longer extends data limits for educational subscriptions. Once a monthly downloading limit is reached, we have to wait until the beginning of the next month before it resets. There is no way of knowing whether the monthly data limit has been reached, until it has been exceeded.
    Bloomberg associates its data limits with paid licenses.  That means one Bloomberg license may have reached its monthly limit, but the other licenses may not have reached their limits. If a monthly downloading limit is reached, a student may switch to another Bloomberg  machine which has not reached its monthly limit. Sauder students can switch to machines in both Leith Wheeler and WDIAC.  Non-Sauder students can only switch to a machine in Leith Wheeler.  Unfortunately, 4 of the 5 Bloomberg machines in Leith Wheeler share the same license meaning that if one of those terminals has reached its monthly data limit, then all those associated machines will also have reached that data limit. Please be judicious in downloading data to avoid hitting the limits for yourself and all other users.
  2. Bloomberg terminals also have a daily downloading limit. The Daily API limit is 500,000 hits/per day. A “hit” is defined as one request for a single security/field pairing. Therefore, if you request static data for 5 fields and 10 securities, that will translate into a total of 50 hits. The best thing to do is to try to refresh just the portion of the spreadsheet that really needs to be refreshed and avoid refreshing it all or reopen it many times a day.
    If you are running into daily limit problems, it is best to contact the Bloomberg Help Desk, while on Bloomberg.  Bloomberg will get back to you within 24 hours/1 business day via your Bloomberg mail. The Help Desk may advise you on how to create more efficient data queries, which will minimize the number of hits.
  3. The third limit consists of open fields. You can have no more than 3500 real time fields open at the same time. If you exceed this limit you will see “NA Limit” as an error message and you just need to delete some securities/ fields in order for the error message to disappear and to see the values.

Please keep in mind that more than 3 unsuccessful login attempts on Bloomberg will lock the station. If this happens, please use the “forgot your password” function within Bloomberg.

For more information about Bloomberg, check out our research guide which provides tips on getting started with Bloomberg, obtaining help, and some fantastic Bloomberg keyboard shortcuts.

UBC’s Community Leadership Program

On March 28th, Irena Trebic completed the UBC Community Leadership Program (CLP). CLP is a UBC leadership development opportunity which allows UBC staff and faculty to explore and develop their leadership skills through interactive learning opportunities and workshops. These skills are put into practice when program participants lead groups of UBC undergraduate students through a three-day community-service learning project in a school or non-profit organization.

As part of the program, there is an initial four-day training workshop where project leaders have the opportunity to realize their leadership style and explore leadership improvement capacities. Then, they select the project they would like to work on. The project takes place during Reading Week in February and is followed by Wrap-Up Activities.

Irena was a project leader for the program delivered at the Simon Fraser Elementary School. She was in charge of supervising 3 UBC student leaders and 20 UBC student volunteers who worked with elementary school students during Reading Week to create complex machines for their Science Fair projects.

In addition to being an excellent professional development opportunity for Irena, this project also contributed to David Lam Library’s strategic goal of engaging with communities. In addition to developing their own leadership skills, project leaders also help UBC students cultivate their own leadership potential.

As a token of appreciation for having participated in the program, Irena received a copy of the book How to Be a Positive Leader: Small Actions, Big Impact, signed by Santa Ono himself! UBC students, faculty and staff can access this ebook online.

If you are interested in learning more about CLP please see the program outline.

“Harry Potter and the academic business library”: A research poster by Irena Trebic

Congratulations to Irena Trebic, Reference Librarian, who presented her research poster “Harry Potter and the academic business library” at the Association of College & Research Libraries (ACRL) conference in Baltimore, MD on March 23, 2017. This research poster provides a summary of a partnership between David Lam Library, Chapman Learning Commons and Rare Books and Special Collections that produced a multi-branch exhibit illustrating connections between the Harry Potter series and Vancouver’s local business community. The poster outlines David Lam Library’s/CLC’s strategies of engaging users, illustrating thematic connections and soliciting feedback from students via a survey about changes in user perceptions.  In addition to the exhibitions,  UBC Library also hosted a Colloquium and two Halloween parties.  Irena received noted positive feedback and votes for the quality of the poster. A thank you to Chelsea Shriver for her support with this project. The poster is available in cIRcle, UBC’s digital repository.

Irena also created a Harry Potter at David Lam Library research guide which summarizes the exhibition and related events in addition to providing links to relevant library books, ebooks, databases, journals, and theses.

International Women’s Day

In honour of International Women’s Day, David Lam library would like to highlight some books from our collection about women and work. Come into the library and check out the books for yourself!

Women in Leadership and Work-family Integration

Margaret Weber 2015
Lean in : women, work, and the will to lead Sheryl Sandberg 2013
Women in business : the changing face of leadership Patricia Werhane et al. 2007
The feminine in management consulting : power, emotion, and values in consulting interactions Sheila Marsh 2009
How Asian women lead : lessons for global corporations Jane Horan 2014
Avon : building the world’s premier company for women Laura Klepacki 2005
The 85% niche : the power of women of all colors–Latina, Black, Asian Miriam Muléy 2009
The voice of success : a woman’s guide to a powerful and persuasive voice Joni Wilson 2009
Global women’s entrepreneurship research : diverse settings, questions, and approaches Karen D. Hughes 2012
Black women in leadership : their historical and contemporary contributions Dannielle Joy Davis 2013

Celebrate Freedom to Read Week

UBC Library is celebrating Freedom to Read Week, February 26 to March 4, 2017. Freedom to read can never be taken for granted. Even in a free country such as Canada, schools and libraries are regularly asked to remove books and magazines from their shelves. Banning books and restricting free expression on the Internet affects the right of Canadians to decide for themselves what they choose to read.

Are you curious about books that have been banned in Canada? Titles such as To Kill A Mockingbird and even the Harry Potter series made it to the list in recent decades! Take a look at the list of 30 challenged publications to find out more.

As part of Freedom to Read Week, UBC Library is hosting a Freedom of Information Request Workshop. Learn about the process of filing Freedom of Information (FOI) or Access to Information (ATIP) requests in BC and Canada. Topics include finding out if the information you need is already publicly available, structuring your request so it can be answered efficiently, and knowing your information rights under FOI laws.

Time & Date: Wednesday, March 1, 2017 at 12:30p.m.–1:30p.m. Location: Woodward Library Computer Lab – Room B25

Click here to register for the workshop.

What are they saying 85

Thanks so much for your quick reply. Really helpful information!”
-UBC Sauder School of Business Phd student in Finance, February 2017

Library resources vs. “fake news”

Given the current trend of “fake news” stories, David Lam Library wanted to shed light on its library resources which offer access to trustworthy sources of information.  The library subscribes to over 50 online business databases which pool quality information from a variety of reputable sources. You can find information ranging from current news (eg. Factiva database), company reports (eg. Mergent database), consumer trends (eg. Passport GMID database), industry reports (eg. IBIS World database), and countless scholarly and peer-reviewed articles (eg. Business Source Complete database), in addition to many other types of business information. Instead of worrying about whether something you find on the Internet comes from a reputable source, why not check out some of the databases listed above? If you are not sure where to start or how to search these databases, be sure to drop by the research help desk, Monday to Friday, 1-4 pm to obtain help from a reference librarian.

If you are not sure whether something you read online falls under the category of “fake news”, here is a possible checklist to follow:

1. Do you know who the source is, or was it created by a common or well-known source? Example National Geographic, Discovery, etc.
2. How does it compare to what you already know?
3. Does the information make sense? Do you understand the information?
4. Can you verify that the information agrees with three or more other sources that are also reliable?
5. Have experts in the field been connected to it or authored the information?
6. How current is the information?
7. Does it have a copyright?

Happy searching!

Opening Reception and Symposium at Belkin Art Gallery

Do you need a bit of a study break? Why not check out the To refuse/To wait/To sleep and M&A Opening Reception and Symposium at Belkin Art Gallery.  This exhibition investigates belief and prediction in economic models, precarious labour and illicit and marginalized markets. Speculative and experimental, this work of various artists tests models, forecasts futures and examines histories of exchange and the limits of productivity. In the context of knowledge-based economies, student debt and the outsourcing of intellectual labour, the exhibition aims to draw forth dialogues about how we imagine individual and collective futures in the “new normal.”

The Opening Reception will take place on Thursday, January 12, 6-9 pm. The Symposium takes place on Friday, January 13 from 3 to 9 pm at the UBC Peter Wall Institute of Advanced Studies and will include artists Melanie Gilligan, Gabrielle Hill, Richard Ibghy & Marilou Lemmens, Marianne Nicolson and international curator and author Maria Lind. The Symposium is free and open to the public, but space is limited and registration is required:

To find out more, take a look at



What are they saying 84

I wanted to send a thank you note to let you know how amazing [the staff member at the front desk] was this morning at the CLC…. I know the staff at the CLC face many students and are asked to help across the board, but I wanted to reach out and let you know just how much I appreciated [her] going above and beyond this morning to help.”
-UBC Sauder School of Business Student, November 29, 2016

What are they saying 83

“Thank you for the informative workshop on Business Resources. I appreciate the opportunity to learn more about and be reminded of these useful tools!”
-Staff member, November 2016

Page 3 of 1912345...10...Last »

a place of mind, The University of British Columbia

UBC Library



Emergency Procedures | Accessibility | Contact UBC  | © Copyright The University of British Columbia