Oneyearclose

Returns one year of daily closing prices for the symbol.

Syntax

=mxls.oneyearclose(stock)

Excel Online (Mac & Windows)

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

Get started today

MarketXLS Excel Add-in Tutorial - How to Use Oneyearclose and Other Financial Formulas

▶

How does MarketXLS work?