Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Fundamental analysis

Fundamental Analysis Of Stocks With Marketxls

Written by admin
Thu Oct 24 2019
Fundamental Analysis Of Stocks With Marketxls - MarketXLS
See how MarketXLS helps you take advantage in the markets.
Download Option Template →
Fundamental Analysis Of Stocks With Marketxls - MarketXLS

Fundamental analysis of stocks is the key method of determining a stock’s real or “fair market” value. Fundamental analysts search for stocks that are currently trading at prices that are higher or lower than their real value.

With the MarketXLS add-in, you will be able to create highly flexible templates for the analysis of companies and stocks. Simply by changing the ticker in focus, you will be able to call vast amounts of data about a company into your spreadsheet. Alternatively, you can create spreadsheets in which you will compare several companies you select, by the metrics you specify.

The list of MarketXLS functions that you can use inside our add-in for Microsoft Excel is continuously expanding. This page is your go-to resource for the general overview of fundamental historical functions at your disposal. As new capabilities are added, they will be listed here.

The historical fundamentals category of functions can be accessed through Excel’s inbuilt function menu as shown below and can be used for in-depth fundamental analysis of stocks.

Fundamental Analysis of Stocks with MarketXLS functions

All functions in this category start from a prefix “hf_” hf stands for “Historical Fundamentals“. This is the category of functions that you would use to carry out the fundamental analysis of stocks. These functions can be used to get historical values (quarterly, yearly, trailing 12 months) of fundamentals from a company’s financial statements. The values returned from these functions will exactly match the values that you would get from SEC filings

You can just start typing =hf_ and Excel will also give a list of all functions available like shown below:

Fundamental Analysis of Stocks

All these functions have a consistent format of usage which is explained with examples below:

Revenue of MSFT Q3 2013: =hf_revenue("MSFT","2013","3")

Revenue of MSFT Year 2015: =hf_revenue("MSFT","2015")

Trailing 12 months Revenue of MSFT Year 2015 Q3: =hf_revenue("MSFT","2015","3","TTM")

The following are the arguments for these functions…

  1. Symbol – Any US stock symbol
  2. Year – Year as a string. Enclose the year number in Double quotes if entering in the formula itself. You can also refer to a cell that carries the year numeric value.
  3. Optional – Quarter Number – Enclose the Quarter number in Double quotes if entering in the formula itself. You can also refer to a cell that carries the year numeric value.
  4. Optional TTM – Type “TTM” within double quotes

 Important Note: All Quarterly values refer to Calendar Quarters and not the fiscal quarters. So, when you ask to get data for Q1 it means data for January to March End. Now this period could be Quarter 3 in some companies whose Fiscal year is from April to March.

We are especially happy to present to you a new way to define periods, which is a feature that our long-time users will especially appreciate. If using the classical way of defining periods (as explained above), when you wanted to get values from a company’s latest financial statements, you first had to find out which fiscal year (or quarter) is the latest for which a company issued an SEC filing. After that, you often had to find out a company’s terminology in naming fiscal years, which do not end on December 31st. For example, if a company’s fiscal year ends on January 31st, the year which ended on January 31st, 2019, might be considered financial year 2018 or 2019, depending on the company.

To solve this problem, we have introduced the option to define periods with relative references. If you are interested in the last reported year, you will define the period as “ly.” For example:

=hf_revenue("MSFT","ly")

You can do the same for the last reported quarter by using “lq”, or for the last 12 months (last four reported quarters) with period defined as “lt”.

Additionally, you may want to specify cells in which the last date of the specified period will be displayed.

Fundamental Analysis of Stocks

The table above shows a very simple overview of how it works. A spreadsheet set up with relative time references will automatically update with new values when the analyzed company publishes new financial reports. The last 12 months periods (“lt”) are especially useful, as they enable you to track trends in the company’s performance on an annual basis, without waiting for the fiscal year to end.

Take your investments research to next level and power your fundamental analysis of stocks with easy to use MarketXLS functions today.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

Rush Enterprises Inc. Class A Common Stock logo

Rush Enterprises Inc. Class A Common Stock

52.20
 
USD
 
-0.35
 
(-0.67%)
85
Rank
Optionable: Yes
Market Cap: 2,812 M
Industry: Auto & Truck Dealerships
52 week range    
42.72   
   55.06
PulteGroup Inc. logo

PulteGroup Inc.

51.99
 
USD
 
-0.63
 
(-1.20%)
85
Rank
Optionable: Yes
Market Cap: 11,760 M
Industry: Residential Construction
52 week range    
35.03   
   54.71
Williams-Sonoma Inc. (DE) logo

Williams-Sonoma Inc. (DE)

129.62
 
USD
 
2.95
 
(2.33%)
84
Rank
Optionable: Yes
Market Cap: 8,021 M
Industry: Specialty Retail
52 week range    
101.58   
   176.89
Moelis & Company Class A logo

Moelis & Company Class A

45.84
 
USD
 
-0.33
 
(-0.71%)
82
Rank
Optionable: Yes
Market Cap: 2,906 M
Industry: Asset Management
52 week range    
33.12   
   58.59
Houlihan Lokey Inc. Class A logo

Houlihan Lokey Inc. Class A

97.65
 
USD
 
0.49
 
(0.50%)
82
Rank
Optionable: Yes
Market Cap: 6,656 M
Industry: Capital Markets
52 week range    
74.18   
   115.21
Coca-Cola European Partners plc logo

Coca-Cola European Partners plc

55.32
 
USD
 
0.23
 
(0.42%)
82
Rank
Optionable: Yes
Market Cap: 25,255 M
Industry: Beverages - Soft Drinks
52 week range    
41.80   
   59.72
Dun & Bradstreet Corporation (The) logo

Dun & Bradstreet Corporation (The)

14.46
 
USD
 
0.15
 
(1.05%)
81
Rank
Optionable: Yes
Market Cap: 6,031 M
Industry: Business Services
52 week range    
11.23   
   20.86
Dick's Sporting Goods Inc logo

Dick's Sporting Goods Inc

126.93
 
USD
 
0.70
 
(0.55%)
81
Rank
Optionable: Yes
Market Cap: 10,470 M
Industry: Specialty Retail
52 week range    
63.45   
   131.12
Columbia Sportswear Company logo

Columbia Sportswear Company

92.83
 
USD
 
1.23
 
(1.34%)
81
Rank
Optionable: Yes
Market Cap: 5,627 M
Industry: Apparel Manufacturing
52 week range    
65.02   
   101.64
CNX Coal Resources LP logo

CNX Coal Resources LP

140.25
 
USD
 
1.28
 
(0.92%)
81
Rank
Optionable: Yes
Market Cap: 7,105 M
Industry: All Other Business Support Services
52 week range    
108.57   
   208.48

More Features