November 30, 2021


The travel folks

Video: Tracking Warren Buffett’s Trades Using GURUG

3 min read

GuruFocus Editorial and Help Assistant James Li mentioned in a prior video clip how to use two main functions of our Excel Add-In, a popular GuruFocus Quality and Quality Moreover aspect: Fairness Screen and GURUF. In today’s video clip, as a nod to “Warren Buffett (Trades, Portfolio) Wednesday,” we will examine how to retrieve the hottest trades from Warren Buffett (Trades, Portfolio)’s Berkshire Hathaway Inc. (NYSE:BRK.A)(NYSE:BRK.B) working with GURUG, a sister functionality of GURUF.


Determine 1 illustrates a snapshot of Buffett’s hottest trades.

Determine 1

A single could see clock symbols up coming to some of the inventory tickers, as highlighted in Determine 1. The clock image indicates that the claimed trade is a Genuine-Time Choose: Quality members have entry to info on these kinds of trades, in which the expert helps make a trade in a corporation where by he or she owns at the very least five% of a company’s overall shares remarkable. Per Securities and Trade Fee polices, gurus will have to file these trades within just two months.

As Determine 1 illustrates, Buffett’s conglomerate created two actual-time trades in the airline industry in early April: Delta Air Traces Inc. (NYSE:DAL) and Southwest Airlines Co. (NYSE:LUV).

GURUG functionality walkthrough

The Expert UDF Library incorporate-in is made up of 3 user-described functions: GURUF, GURUG and GURUE. We mentioned GURUF, the functionality for retrieving inventory financial info, in the prior video clip. The F in “GURUF” stands for financial.

Similarly, the 2nd G in “GURUG” stands for expert, i.e., the functionality makes it possible for end users to retrieve expert trade info. Determine 2 illustrates a display screen shot listing the parameters for GURUG.

Determine 2

To retrieve the stocks Buffett’s conglomerate trimmed its keeping in given that fourth-quarter 2019, enter a GURUG functionality like the following:

=GURUG(“Warren Buffett (Trades, Portfolio)”,”Reduce”,”2019-10-01”,””,”Y”)

Notice that the commence date higher than (2019-10-01) signifies the very first working day of the 3 months ending December 2019, the most-modern quarterly portfolio out there for Berkshire as of this crafting. The conglomerate has not launched its March 2020 quarter portfolio as the deadline is forty five days immediately after the quarter ends per SEC polices.

The following video clip illustrates the system to retrieve the output revealed in Determine 3.

Determine 3

If you established the “show caption” parameter to indeed, GURUG will display screen the header row, which by default is made up of the following columns:

  • Image
  • Business
  • Current Value
  • RecmDate: the date of transaction
  • Trans_share: the transaction’s effects to portfolio
  • RecmPrice: the ordinary inventory price tag of the quarter
  • Value (3-month Low)
  • Value (3-month Substantial)
  • Value Transform from Ordinary
  • Current Shares

For illustration, the output illustrates that Berkshire trimmed his Delta posture on April 2, impacting the fairness portfolio by .thirteen%. Shares traded around $24.19 that working day the inventory is now buying and selling close to 2.eighty five% bigger. As of April 2, Buffett’s conglomerate owns 58,900,759 shares.

See also

Determine 3 illustrates some of Berkshire’s other trades created given that fourth-quarter 2019, together with some reductions in his top rated 5 holdings: Apple Inc. (NASDAQ:AAPL), Lender of The us Corp. (NYSE:BAC), Coca-Cola Co. (NYSE:KO), American Express Co. (NYSE:AXP) and Wells Fargo & Co. (NYSE:WFC). For illustration, Berkshire trimmed its Wells Fargo keeping to just 323,212,918 shares, lowering the portfolio 1.thirty%. The shares averaged $52.forty eight in the course of the quarter.


Disclosure: As of crafting, the writer is prolonged Apple and Southwest.

Go through much more below:

Not a Quality Member of GuruFocus? Indication up for a cost-free 7-working day trial below.

About the writer:

James Li

I am an editorial researcher at GuruFocus. I have a Master’s in Finance from SMU, and I enjoy crafting stories on financial developments and investor portfolios. Follow me on Twitter at @JamesLiGuru!

Check out James Li’s Web-site All rights reserved. | Newsphere by AF themes.