Stock Return Forty Five 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..

Syntax

=mxls.StockReturnFortyFiveDays(Symbol, [TypeOfReturn])
Excel Online (Mac & Windows)

Parameters

SymbolstringRequired
TypeOfReturnstring

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
MarketXLS Excel Add-in Tutorial - How to Use Stock Return Forty Five Days and Other Financial Formulas
▶
How does MarketXLS work?