Pricing Book a Demo

Functions Templates Pricing

Functions
Templates
FundXLS
Pricing
Blog

Financial metrics glossary›Earnings and analyst estimates

EPS (Last Year - 1)

Hidden

Returns the Earnings per share 2 years ago

Example usage

=hf_Earnings_per_Basic_Share("MSFT","ly-1")

Select Country:

Legal

Disclaimer Privacy Policy License Agreement Terms of Use Refund Policy DMCA Policy

Company

Contact Us Team

Resources

MarketXLS status

Knowledge Base Economic Indicators Financial Metrics Glossary Stock Data in Excel marketdatamcp FundXLS ETF Overlap Calculator Mutual Fund Overlap Calculator Portfolio X-Ray Options Strategy Library MarketXLS Review Affiliates

Demos

Book your personal Demo Video Tutorials Version History

Data Sources

Toronto Stock Exchange

barchart

quotemedia

FRED data

Nasdaq

iex cloud

Financial Market Data powered by Quotemedia.com. All rights reserved. View the Terms of Use. Data delayed by 15 minutes unless indicated. Real-time data subscriptions available through our data partners and require additional exchange subscription agreements.

MarketXLS does not provide its own datafeed or any API access to users of the software for any commercial purposes of the user. The software is for personal use only as defined in our License Agreement. Users may not use the data provided in violation of the terms of our License Agreement.

Information provided in this solution is obtained from sources believed to be reliable. The publishers are not responsible for any errors or omissions contained herein or delivered through the software. Data and functionality of this software is subject to many factors including but not limited to internet connectivity, data interruptions, server breakdowns, trading halts etc.

Financial Market Data copyright © 2019 QuoteMedia. Data delayed 15 minutes unless otherwise indicated (view delay times for all exchanges). RT=Real-Time, EOD=End of Day, PD=Previous Day. Market Data powered by QuoteMedia. Terms of Use.

All data on this website is Copyright © MarketXLS.

© 2025 MarketXLS Limited