Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Earnings per Basic Share

Live
Returns the basic EPS for the firm. Basic EPS does not factor any dilutable securities into consideration.

How calculated

No Calculations

Example usage

=hf_Earnings_per_Basic_Share("MSFT",2019)- Returns the value for the year 2019.
=hf_Earnings_per_Basic_Share("MSFT",2019,2)- Returns the value for the year 2019 and the calendar quarter 2
=hf_Earnings_per_Basic_Share("MSFT",2019,3,"TTM")- Returns the value for the year 2019 and trailing twelve months from the calendar quarter
=hf_Earnings_per_Basic_Share("MSFT","lq") - Returns the value for the last quarter
=hf_Earnings_per_Basic_Share("MSFT","lq-1")-Returns the value for the last quarter-1
=hf_Earnings_per_Basic_Share("MSFT","ly") - Returns the value for the last year
=hf_Earnings_per_Basic_Share("MSFT","ly-1") - Returns the value for the last year - 1
=hf_Earnings_per_Basic_Share("MSFT","lt") - Returns the value for the last 12 months.
=hf_Earnings_per_Basic_Share("MSFT","lt-1") - Returns the value for the previous last 12 months.

Assets

Stocks
Legal
DisclaimerPrivacy PolicyLicense AgreementTerms of UseRefund PolicyDMCA Policy
Company
Contact UsTeamAffiliates
Resources
MarketXLS statusStatus
Knowledge BaseServicesMarketXLS ReviewOptions Trading Plugin
Demos
Book your personal DemoVideo TutorialsVersion 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.

© 2021 MarketXLS Limited