Data
Stock Return Thirty Days
Live1.40%
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 | =StockReturnThirtyDays("MSFT") - Returns the total stock return for MSFT for the given period =StockReturnThirtyDays("MSFT","total") - Returns the total stock return for MSFT for the given period =StockReturnThirtyDays("MSFT","price) - Returns the price return for MSFT for the given period |
Assets | Stocks ETFs Mutual Funds Cryptocurrencies |
| Stock | Stock Return Thirty Days |
|---|---|
CAT | 1.40% |
DE | -1.49% |
CMI | 0.01% |
CNHI | -4.43% |
ASTE | -9.17% |
GE | 0.19% |
Caterpillar Inc.
CAT
NYE
Sector: Industrials
Industry: Farm & Construction Equipment
273.06
USD
1.03
(0.38%)
Optionable: Yes Market Cap: 142,672 M 90-day average vol: 2,546,440
Previous close: 272.03 Open: 272.01 Bid: 270.63 Ask: 274.0
52 week range
160.60 293.88
Last updated: Sunday 24th September 2023
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started todaySearch for a stock
🎉 Exciting news! 🎉
You are invited to join our Discord Channel.
Interact, learn, and grow with experts in the markets!
Join our DiscordCall: 1-877-778-8358
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
Get started today