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

Stock Return Seven Days

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

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


Stocks ETFs Mutual Funds Cryptocurrencies
Stock Return Seven Days
StockStock Return Seven Days




Alliance Data Systems Corporation logo

Alliance Data Systems Corporation

Sector: Financial Services   

Industry: Credit Services

Optionable: Yes  Market Cap: 2,932 M  90-day average vol: 0

Previous close: 56.15  Open: 56.6  Bid:   Ask:
52 week range    
FIS / 
HHS / 
GPN / 
Last updated: Friday 29th September 2023

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
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and Templates.
Get started today