WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Investment Banking Tutorials » Financial Statement Analysis » Bid Ask Spread Formula

Bid Ask Spread Formula

Bid-Ask Spread Formula

The ask price is lowest price of the stock at which the prospective seller of the stock is willing for selling the security he is holding whereas the bid price is the highest price at which the prospective buyer is willing to pay for purchasing the security and the differences between the ask price and the bid prices is known as the bid-ask spread. And its formula you can use to calculate the spread –

BID ASK SPREAD FORMULA

Example

Let’s take a practical example of spread to see how it works.

Tim decides to buy a few stocks with the excess savings he has. His friend Brown is a long-time investor. Brown asks Tim to find out the spread of the company M before he invests in it. Brown says that understanding the bid-ask spread will help Tim in future investments. Brown has provided the following details –

  • The bid price (an assumed one) of a stock of Company M – $100;
  • The asking price (also an assumed one) of a stock of Company M – $102;

Since Tim is a new investor, he doesn’t understand what the spread is. So he finds out the formula and applies it. And in one go, he is able to find out the spread of the stock of Company M. Here’s his calculation –

  • Spread = Ask price of a stock – Bid price of the same stock
  • = $102 – $100 = $2.
  • As per Tim, the spread of a stock of Company M is $2.

Explanation

If you want to make your mark as an investor, you need to know the basics of stock trading. Spread is a concept that every investor needs to understand.

When a stock is sold, it has two parties – buyers and sellers. The buyers tell the sellers that they are ready to pay the price for the stock. We call it a ‘bid price.’ The sellers also tell the buyers that they can sell the stock at a price. The price sellers ask is always a little higher than the price buyers are ready to pay. The price sellers ask for a stock is called an ‘ask price.’

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

In the bid-ask formula, we find out the difference between the price the sellers ask and the price the buyer’s bid.

reliance

source: NSE India

We can see from the bid-ask example of Reliance Industries. For a buy quantity of 47, the bid price is 925.25, whereas the asking price is 925.30. Bid-Ask = 925.30 – 925.25 = 0.05.

As an investor, you may ask – why the sellers always ask for the higher price of a stock. It is because they keep a little profit for themselves. But that’s not the only thing that’s included in the ‘ask price.’

Along with the commission of the broker, the spread also includes a number of fees.

Bid-Ask Spread Calculator

You can use the following Bid-Ask Spread Calculator

Ask price of a stock
Bid price of the same stock
Bid Ask Spread Formula
 

Bid Ask Spread Formula = Ask price of a stock – Bid price of the same stock
0 – 0 = 0

Bid-Ask Spread in Excel (with excel template)

Let us now do the same example above in Excel.

It is very simple. You need to provide the two inputs of the Ask price of a stock and Bid price of the same stock.

You can easily find out the spread of the stock of Company M in the template provided.

Bid Ask Spread in Excel

You can download this Bid-Ask Spread template here – Bid-Ask Spread Excel Template.

Bid-Ask Spread Video

Recommended Articles

This article has been a guide to the bid-ask spread formula. Here we discuss the Bid-Ask Spread calculator along with examples and excel templates. You may also look at the following articles to enhance your investing skills.

  • Inventory Turnover
  • Crack Spread Definition
  • What is Ask Price?
  • Compare – Bid vs. Ask
  • Types of Stock Options
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Ratio Analysis Course

Step by Step Guide to Calculating Financial Ratios in excel

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More