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

Fundamental Analysis Of Stocks With Marketxls

Written by MarketXLS Team on 
Thu Oct 24 2019
 about Fundamental analysis
Fundamental Analysis Of Stocks With Marketxls - MarketXLS
Boost your market advantage with MarketXLS. Real-time, enterprise-grade data. Book a demo or subscribe now!
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
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

We respect your privacy and will never share your email.
MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University

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

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord