Get History
Gets the list by metric and symbol
Syntax
=mxls.getHistory(stock, startDate, endDate, [periodicity])Parameters
stockstringRequired
startDatestringRequired
endDatestringRequired
periodicitystring
Related Formulas
More MarketXLS Price History formulas you can use in the same worksheet:
- Get Tabular Data from QuoteMedia
- Get Tabular Data from QuoteMedia (Dynamic)
- Get Useful Lists
- High Price (Month End)
- High Price (Quarter End)
- High Price (Year End)
- High Price In X Number Of Days
- High Price In X Number Of Weeks
See getHistory used in a complete workbook: Efficient Frontier: Complete Guide to Portfolio Optimization and Modern Portfolio Theory
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?