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

Stock Return One Year

Live
19.82%
The return is calculated on the closing prices for the given calendar days. The value gets updated everyday at around 5PM EST.Can be used to retrieve total return or price return.

How calculated

(Previous Closing Price/Closing price on the given past x day )-1

Example usage

=StockReturnOneYear("MSFT") - Returns the total stock return for MSFT for the given period
=StockReturnOneYear("MSFT","total") - Returns the total stock return for MSFT for the given period
=StockReturnOneYear("MSFT","price) - Returns the price return for MSFT for the given period

Assets

Stocks ETFs Mutual Funds Cryptocurrencies
Stock Return One Year
StockStock Return One Year

MSFT

19.82%

ORCL

47.35%

IBM

-1.05%

GOOGL

4.57%

HPQ

-21.87%

CSCO

12.98%

AAPL

20.29%
Microsoft Corporation logo

Microsoft Corporation

Sector: Technology   

Industry: Software - Infrastructure

323.38
 
USD
  
-10.30
  
(-3.09%)
Optionable: Yes  Market Cap: 2,481,073 M  90-day average vol: 29,965,411

Previous close: 333.68  Open: 331.65  Bid: 322.21  Ask: 322.4
52 week range    
213.43   
   338.56
Peers   
ORCL / 
IBM / 
GOOGL / 
HPQ / 
CSCO / 
AAPL / 
Last updated: Thursday 8th June 2023
75
MarketXLS Rank
50
Value
92
Technical
84
Quality

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

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

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

Join our Discord

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