How can I check BSE IPO allotment status by application number by SMS in Excel online? 

How to Check BSE IPO Allotment Status by Application Number by SMS in Excel Online?

Initial Public Offerings (IPOs) present an exciting opportunity for investors to buy shares of a company that is going public for the first time. The IPO process involves various stages, including the submission of applications by investors. Once the IPO subscription period ends, investors eagerly await the allotment of shares. In this article, we will guide you through the process of checking BSE IPO allotment status by application number using SMS and Excel Online.

Understanding IPO Allotment Status

IPO allotment refers to the process of allocating shares to investors who have applied for shares during the IPO subscription period. The allotment process considers various factors, including the number of shares applied for by each investor, the price at which they bid, and the total demand for shares. Once the allotment process is complete, investors can check their allotment status to know how many shares they have been allotted.

Checking BSE IPO Allotment Status by Application Number

You can check your BSE IPO allotment status by following these steps:

  1. Open the messaging app on your mobile phone.
  2. Create a new SMS.
  3. Enter the designated number for IPO allotment status checking (provided by the stock exchange).
  4. In the message body, enter the required details, including your application number.
  5. Send the SMS.

After sending the SMS, you will receive a response containing your IPO allotment status. The response will indicate the number of shares allotted to you, if any, along with other relevant information.

Using Excel Online to Organize Allotment Details

Excel Online is a powerful tool that can help you organize and manage your IPO allotment details efficiently. Here’s how you can use Excel Online:

  1. Open Excel Online and create a new spreadsheet.
  2. Create columns to input information such as application number, allotted shares, and other relevant details.
  3. As you receive allotment information via SMS, enter the details in the corresponding rows and columns.
  4. You can use Excel’s functions and formulas to calculate total allotted shares, average price, and other metrics.
  5. Regularly update the spreadsheet with new allotment information as you receive it.

Using Excel Online allows you to have a consolidated view of your IPO allotment status and helps you make informed decisions about managing your investment portfolio.

Benefits of Checking Allotment Status

Checking your BSE IPO allotment status by application number offers several benefits:

  • Clarity: It provides clarity on the number of shares you have been allotted.
  • Decision-Making: You can make informed decisions about holding, selling, or buying more shares based on your allotment status.
  • Portfolio Management: Tracking your allotment status helps you effectively manage your investment portfolio.
  • Profit Calculation: You can calculate potential profits or losses based on your allotment and the prevailing market price.

Conclusion

Checking BSE IPO allotment status by application number via SMS and organizing the information in Excel Online can enhance your experience as an IPO investor. It provides you with timely updates on your share allotment, enabling you to manage your investments effectively. By staying informed about your allotment status, you can make well-informed decisions that align with your financial goals.

Send Inquiry on WhatsApp

By Astrobulls Research Pvt Ltd.

Leave a Comment

Your email address will not be published. Required fields are marked *