How to Calculate Daily Log Returns in Excel

Gregory Jul 09, 2026

Calculating daily log returns in Excel is a crucial step in financial analysis, enabling you to understand the growth or decline of an investment on a daily basis. This process involves applying the logarithmic function to find the compounded return over a specific period. Let's dive into the step-by-step process of calculating daily log returns in Excel.

Daily Work Tracker Excel: Essential Functions for Better Planning
Daily Work Tracker Excel: Essential Functions for Better Planning

Before we begin, ensure you have a dataset with daily closing prices of the asset you're analyzing. For this guide, let's assume you have a column (A) with daily closing prices, and you want to calculate the daily log returns in column (B).

Excel Sum Formula Examples, Excel Sum Formula Guide, Excel Spreadsheet Learning, Excel For Business Data Management, Excel Spreadsheet Formulas, Excel For Business Management, How To Assign Serial Numbers In Excel, Excel Spreadsheet Skills, Excel Sumproduct Guide
Excel Sum Formula Examples, Excel Sum Formula Guide, Excel Spreadsheet Learning, Excel For Business Data Management, Excel Spreadsheet Formulas, Excel For Business Management, How To Assign Serial Numbers In Excel, Excel Spreadsheet Skills, Excel Sumproduct Guide

Understanding Logarithmic Returns

The log return is the logarithmic difference between the closing prices of two consecutive days. It represents the compounded return over that period, making it a valuable metric for comparing returns across different investments.

Excel tutoring
Excel tutoring

To calculate the log return, we'll use the formula: log(P_t / P_t-1), where P_t is the closing price on day t, and P_t-1 is the closing price on day t-1.

Preparing Your Data

Calender in Excel ‼️ Amazing Excel trick using data validation and conditional formatting ✅ #Excel
Calender in Excel ‼️ Amazing Excel trick using data validation and conditional formatting ✅ #Excel

Before calculating the log returns, ensure your data is properly formatted. Your dataset should have the closing prices of the asset for each trading day, with no missing values. If there are any gaps, interpolate or extrapolate the missing values based on the available data.

For this example, let's assume your data starts from row 2, with the first cell containing the date (A1) and the closing prices starting from A2.

Calculating Daily Log Returns

Top 101 Excel Templates for Productivity
Top 101 Excel Templates for Productivity

Now that your data is ready, let's calculate the daily log returns. In cell B2, enter the following formula:

=(LN(A2/A1))

This formula calculates the natural logarithm of the ratio of the current day's closing price (A2) to the previous day's closing price (A1). Copy this formula and paste it down to the rest of the cells in column B, applying it to each pair of consecutive days.

📋 Calendar + Task Tracker + Time Log #excel
📋 Calendar + Task Tracker + Time Log #excel

Interpreting Daily Log Returns

Once you've calculated the daily log returns, you can analyze the growth or decline of the asset on a daily basis. A positive log return indicates growth, while a negative log return indicates a decline in the asset's value.

Excel Task Tracker Template: Daily, Weekly, Monthly (digital Download) - Etsy
Excel Task Tracker Template: Daily, Weekly, Monthly (digital Download) - Etsy
the 5 excel shortcuts i use in daily reporting work smarter save time more
the 5 excel shortcuts i use in daily reporting work smarter save time more
Boost Productivity With 141 Free Sheets
Boost Productivity With 141 Free Sheets
Useful Excel tricks
Useful Excel tricks
Automatic Excel Salary Sheet | Late Deduction + Overtime Calculation | Full Formula Tutorial
Automatic Excel Salary Sheet | Late Deduction + Overtime Calculation | Full Formula Tutorial
calculate expiry date in excel | Excel Tutorials | how to calculate expiry date in Excel #Excel2022
calculate expiry date in excel | Excel Tutorials | how to calculate expiry date in Excel #Excel2022
Task List in Excel
Task List in Excel
Elapsed Time Excel
Elapsed Time Excel
a blackboard with the words create a dataform in excel
a blackboard with the words create a dataform in excel
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
the value function for an error in excel and excel - click to see if it is not
the value function for an error in excel and excel - click to see if it is not
the top ten basic ms excel formulas
the top ten basic ms excel formulas
Task Planner & To-Do List | Stay Organized and Boost Productivity
Task Planner & To-Do List | Stay Organized and Boost Productivity
Free Excel Leave Tracker Template (Updated for 2026)
Free Excel Leave Tracker Template (Updated for 2026)
Free Printable Mileage Log Template (Excel, Word)
Free Printable Mileage Log Template (Excel, Word)
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
Excel - how to create timesheets
Excel - how to create timesheets
a poster showing how to use chart in excel
a poster showing how to use chart in excel
Don't save the date 📆
Don't save the date 📆
a poster with the words excel in green and white, on top of each other
a poster with the words excel in green and white, on top of each other

To get the cumulative log return, you can use the SUM function to add up the daily log returns. This will give you the compounded return over the entire period.

Cumulative Log Returns

To calculate the cumulative log return, use the SUM function in a new cell (e.g., C2) and enter the following formula:

=SUM(B2:B100)

This formula sums up the daily log returns from B2 to B100. You can adjust the range as needed to match your dataset.

To convert the cumulative log return to a percentage, use the EXP function in a new cell (e.g., D2) and enter the following formula:

=EXP(C2)

This formula calculates the exponential of the cumulative log return, giving you the compounded return as a percentage.

By following these steps, you can effectively calculate and analyze daily log returns in Excel, providing valuable insights into the performance of an investment over time. This skill is essential for any financial analyst or investor looking to make data-driven decisions.