Thomson One and Workarounds with the New Chromium-based Microsoft Edge Update

Thomson ONE‘s full features are available only with the outdated Internet Explorer (IE) browser. This makes staying up-to-date on the latest browser workarounds critical to accessing this collection of company information, SEC filings, and analyst reports. Continue reading for details regarding this year’s Chromium-based update to Microsoft Edge.

Logo for Chromium-based Microsoft Edge
Continue reading

Reading is fun with Business Trends!

When you’ve got serious work to do, like writing a research paper or preparing for a job interview, Lippincott Library has resources to help. But did you know the library also has a selection of popular books to read for fun? If you’re interested in keeping up with general business topics, or looking for a way to pass the time on your commute, come check out the Business Trends section at Lippincott Library. Business Trends is a rotating collection of popular business books and bestsellers in marketing, management, and leadership.  

Business Trends display area and bookshelves filled with books in the Lippincott Library

You’ll find the Business Trends section as you’re walking into the library – across from the Information Desk and next to the periodicals. Business Trends has everything from biographies of business titans to management advice, and covers a wide variety of hot-button issues. Whether you want to know about AI technology or fast fashion, the gig economy or organic farming, Business Trends has got you covered.  

Here’s a few examples of popular titles you can find in the Business Trends collection: 

The Infinite Game, Simon Sinek 

Finite games have rules, scoreboards, and boundaries; when the whistle blows and the game is over, there are winners and losers. An infinite game, however, has no such clarity.  There are no rules, no endpoints, and no one goes home with a trophy – but using finite strategies is a sure way to lose. Simon Sinek offers advice on adapting to the infinite game of the business world by developing a resilient and forward-thinking mindset. Good leaders understand how to inspire others and build trusting environments, but Sinek argues that inspiration and cooperation are not enough: truly great leaders must be able to play the infinite game.  

The Age of Surveillance Capitalism, Shoshana Zuboff 

We live in a data-driven world, and many of us have accepted targeted ads and digital footprint tracking as part of the invisible, inevitable cost of using otherwise free services like Facebook and Google. Shoshana Zuboff delivers a blow to that complacency in her widely-discussed examination of surveillance capitalism, her term for the ominous new marketplace of human behavior prediction – and modification. Gone are the days of totalitarian states and Big Brother; Zuboff argues we now live in the shadow of “Big Other,” as unregulated and opaque private companies are given free rein to collect our data and influence our behavior.  

Work Wife: The Power of Female Friendship to Drive Successful Businesses, Erica Cerulo and Claire Mazur 

Erica Cerulo and Claire Mazur, friends and business partners, examine the unique benefits of female friendship in the business world. Sharing lessons from their own personal experience, as well as interviews with other women who have successfully navigated business partnerships, Cerulo and Mazur offer insight into what makes friendship among women in the workplace so special. Highlighting the importance of oft-ignored values like compassion and vulnerability, Cerulo and Mazur present a feminist vision of entrepreneurial cooperation.  

To check out these books (and many more!), stop by the Business Trends section the next time you visit Lippincott Library. With nearly one hundred titles covering a wide array of business topics, there’s sure to be something you’ll want to read. 

At last, Pitchbook has come along…

Lippincott Library is proud to announce the addition of Pitchbook to our list of business resources. Covering a vast array of data related to private capital markets, Pitchbook can provide the Wharton community with research information on private equity and venture capital. You will need to create an account, based on your Penn email address. There are download limitations:  Each individual has 25 downloads per month and can use up to 10 in a day.  Unlimited access using the API function in excel is available for public companies.

Continue reading

CEIC: Download Data for International Research

Need macroeconomic data for more than 128 countries? CEIC offers metrics including GDP, CPI, Forex rates, imports, exports, retail sales, and investment as well as premium data for Brazil, Russia, India, and China, letting you match up and download data from multiple sources for further research.

The CEIC logo

Let’s say you need to compare India’s and Russia’s gross domestic product (GDP) and quarterly imports from China from 1990 through 2015.

Continue reading

Thomson One Work-Around for Microsoft Edge

Thomson ONE only works with full functionality in Internet Explorer (IE), and within that, it only works properly in versions IE8 and below. For those of you familiar with this resource, this isn’t anything you haven’t heard before. Compatibility issues continue with Thomson ONE in the latest iteration of the Windows browser, Microsoft Edge. As has been the case before, there is a work around which you can find detailed below.

Continue reading

The Library is Open!

Hello, Wharton students! Welcome to Lippincott Library and a new academic year. Find us online, chat with us during the day, email us after hours, call us at 215-898-5924 or head up to the second floor of Van Pelt-Dietrich Library and say hello! We’re here to support your research and academic needs. We offer a number of library services to do that.

 

RESEARCH TO GO. Have a question between classes? Visit us in Huntsman Hall! We hold office hours every Monday through Thursday 12:30 – 1:30 in JMHH 251.  Drop in and get quick answers for your job search or research questions.

 

business FAQ

Our Business FAQ is your 24/7 librarian. Search by keyword or concept to find resources on topics such as market research, company financials, analyst reports and more.

DOCUMENT DELIVERY. Available to undergraduate students, MBAs,  PhD candidates and Wharton faculty. Email docdel@wharton.upenn.edu to request articles and book chapters. Include the full citation for the fastest reply.

BUSINESS NEWS. Put away your wallet! Lippincott Library subscribes to major newspapers like the Wall Street Journal, the Financial Times, the New York Times, and many other business periodicals such as the Harvard Business Review and The Economist. You can read them in print in the library or online through several of our databases. You also now have access to WSJ Pro through Factiva. To limit your results to articles from WSJ Pro, click “Search” and then click “Source” below the “Free Text Search” box. Type WSJ Pro in the “Source” search bar and select any WSJ Pro sections of interest.

GROUP STUDY ROOMS.  Have a team project or group presentation?  Reserve a room  for your meeting. We have smaller study rooms for 4-5 people and two larger rooms that accommodate 10-12 people.

YABLON FINANCIAL RESOURCES LAB. Your one-stop-shop for access to Bloomberg and Capital IQ. Yablon is open to Wharton students only whenever Lippincott Library is open, and our librarians are happy to help you with these resources.

WORKSbloomberg120611_2_560HOPS.  On Wednesdays we talk about Bloomberg. Each week we offer Bloomberg training from 3:30 – 4:30 in Yablon Financial Resources Lab. It’s hands-on so be sure to come a few minutes early to create your own Bloomberg account. Register for this and other business workshops here.

 

TEXT BOOKS. We have library copies of textbooks for many Wharton courses on reserve at the Lippincott Services Desk.  Most textbooks can be checked out for three hours and used in the library. Check if we have your textbook in Franklin’s Course Reserves catalog.

cropped-datapointsheader.jpg

DATAPOINTS is Lippincott Library’s blog. Follow us for tips and tricks about library databases, new resources we’ve added to our collection, and more. And follow us on Twitter @LippincottLib for business news, library workshops, and more.

We hope to see you in Lippincott Library soon!

Passport GMID for Market Entry Strategies

Passport GMID is one of our premier market research databases. Learn how to utilize this tool to its fullest when working to craft a market entry strategy for consumer products. This video will illustrate some of the many ways you can use Passport GMID to inform your decisions. And, feel free to contact the Lippincott librarians for additional assistance with using this great resource.

Ins and Outs of EINs

There is no shortage of symbols or numbers that can be used to identify companies, which makes trying to match company lists from different sources challenging. The more commonly used company identifiers include ticker symbols, CUSIPs, CIKs and ISINs, as well as proprietary numbers like D-U-N-S Numbers or BvD identification numbers. One of the less commonly used company identifiers is the Employer Identification Number (EIN), also known as the Federal Tax Identification Number. It is used by the Internal Revenue Service (IRS) to identify entities that need to file business tax returns. It is a nine digit number, either expressed as a single string (050155090) or with the first two digits, a dash/hyphen and the final seven digits (e.g. 05-0155090). EINs are not as readily available in directory and company databases as other identifiers. Where can you find EINs for company matching when you need them?

Individual EINs for a specific company are available from a company’s SEC filings; see Lippincott’s Business FAQ Where do I find SEC (Securities & Exchange Commission) filings? for details about locating these filings. On the front page of a filing, the EIN is listed as the IRS Employer Identification No.

aapl8-kb

It is also listed in the filing submission text files with the label IRS Number. You can find EINs for private companies if they have filed with the SEC. See for example the IRS Number from the complete submission text file from a Form D filed by Uber in 2015.

uberformdb

Corporate Affiliations, a directory database from LexisNexis providing corporate structure information, includes EINs in its records for public companies and some private companies. One caveat about Corporate Affiliations and the other resources mentioned below is that they often only list EINs for public companies, even though private companies are also required to obtain and use EINs. To find EINs in Corporate Affiliations, search for a company of interest and view its record. The EIN will appear toward the top of the record as FEIN.

hasbrocorpaffiliationsb

Note that Corporate Affiliations is misleading with regard to the exportability of EINs. While FEIN appears to be available as an exportable field, it is not populated in the export results; a FEIN column will display, but it will be blank. Another LexisNexis option is to use the FEIN search in Lexis.com. Lexis.com is available to current Wharton students, faculty and staff at Lippincott; please contact us at lippinco@wharton.upenn.edu to set up an appointment.

Mergent Online includes the EIN in the header information at the top of  the company record, labeled IRS Number.

mergentalleghenytechnologies21b

mergentcompanyanalysislisb

These can be exported for 500 records at a time via the Company Analyst List option that appears on the results page after running a search.

After adding companies to the analysis list, click the My Mergent Tools button and select Company Analysis List. From the My Mergent Tools page, select Company Comparison Report. EIN appears as IRS Number in the Select Data Items area.

mergent-selectdataitems

EINs for nonprofit organizations can be found in their IRS 990 filings, officially titled Return of Organization Exempt from Income Tax.

990filingexampleb

 

 

 

 

 

 

 

See the 990s, Financials & Regulations tab of our Nonprofit Sector research guide for information about tools for locating 990s.  They appear At a Glance section of each foundation record in the Foundation Directory Online.

PewFoundationCenter.jpg

The National Directory of Nonprofit Organizations includes the EIN in organization records, and also provides it as a field in exported lists.

Election 2016: By the Ad$pend

kantar_logoadspender_logo

There are several Lippincott Library resources that contain advertising expenditure data, but only one that tracks it at the advertiser/brand/product level, by media, by market. That is AdSpender, from Kantar Media. AdSpender allows you to find out how much advertising is being done (in dollar amounts, or by units aka number of ads) over time. Our subscription includes a rolling 5-year period. One great way to use this during this election cycle is to track presidential campaign ad spending, down to the city level. This way we can see in which states the candidates’ campaigns feel the race is close and want to spend more, and in which states they feel confident in their winning Electoral College votes – a great indicator of where political advertising dollars will be spent.

createOnce you enter into AdSpender, use the Custom Reports menu on the left to click Create. First, you’ll be able to select from a large menu of Available Media – including Network TV, Cable TV, National Newspapers, Network Radio, Internet Display, and even Outdoor (such as billboards). Select all or as many media formats as you’d like to track and move them to the Selected Media menu. Or, click on the Media tab to select certain Designated Market Areas (DMAs) of interest. Then click the Next link in the top right (how you’ll navigate through all steps of this process).

Now we can choose the time period that we’d like to have measured. To check the date range coverage of the media format that you are interested in, click on Availability in the top right corner. Remember that our coverage is on a rolling 5-year basis. You also havetimeperiods the choice of viewing the data as one large aggregated sum (Time Period-Single) or at a monthly/quarterly level (click on the Select Multiple Time Periods button).

The next step is to choose what AdSpender calls our Product Set. This is the company or advertiser or brand or product that you want to learn more about. We can search Advertiser names like Clinton For President or Trump For President to find their presidential campaign advertising. Double-click the correct result productset– it will
italicize when it
has been properly added to your report.

 

Step 4 is where it gets fun, because we can customize our report format to the detailed level we’d like to see. So, for reportformatexample, I can break out my columns first by Media, then by Product, then by Market, then by Time Period. So I’ll be able to see, for each campaign, the spending on each media format then sorted into the DMAs that saw this coverage, then see the trend over time. Set any addition Report Format (e.g. to show both Dollars and Units) and Report Options you’d like (e.g. font and shading preferences), then set a title and hit Run Report.title

 

 

 

The Report Viewer menu shows you all of the recently created reports within Penn’s subscription. The report will move through stages here – Submitted, Running, Completed. This can sometimes take a few minutes. One refreshtrick if you’ve noticed that your report is taking longer than you’d like is to hit the Refresh Listing link, which will manually refresh the menu rather than waiting for it to auto-refresh. Then you’ll be able to view/download the report, in both PDF and .csv formats.

outputpdfoutputcsv

And for more about political advertising, including how to find an archive of the ads and their creative content, use our Business FAQ: “How can I track political ads and spending?