Checking BSE IPO Allotment Status by SMS in Excel

Initial Public Offerings (IPOs) are an exciting way for investors to participate in a company’s journey by buying its shares during the IPO subscription period. After applying for an IPO, investors eagerly await the allotment status to know if they have been allocated shares. The Bombay Stock Exchange (BSE) offers a convenient way to check IPO allotment status by sending an SMS from your mobile phone. In this article, we will guide you through the process of checking BSE IPO allotment status by application number using an Excel sheet and SMS.

Understanding BSE IPO Allotment Status

IPO allotment status refers to whether an investor’s application for shares in an IPO has been accepted and shares have been allocated. This status is crucial as it determines whether the investor will become a shareholder of the company or receive a refund if the application is not successful. The BSE provides a straightforward method to check IPO allotment status using an SMS service.

Checking BSE IPO Allotment Status by SMS

You can follow these steps to check BSE IPO allotment status using an Excel sheet and SMS:

Step 1: Prepare Excel Sheet

Create an Excel sheet with the following columns: Application Number, PAN Number, and Mobile Number. Fill in the respective details for each IPO application you have made.

Step 2: Get BSE SMS Code

Visit the BSE website or refer to the IPO prospectus to find the SMS code provided for checking allotment status. This code is usually a unique keyword associated with the IPO.

Step 3: Format the SMS

In the Excel sheet, create an SMS message using the SMS code, your application number, PAN number, and mobile number. The format of the SMS should be something like this:
SMS: “SMS Code Application Number PAN Number Mobile Number“

Step 4: Send the SMS

Copy the formatted SMS from the Excel sheet and send it to the designated BSE SMS number using your registered mobile number.

Step 5: Receive Allotment Status

After sending the SMS, you will receive a response indicating your IPO allotment status. The SMS will inform you whether your application has been successfully allotted shares or not.

Benefits of Using Excel and SMS for IPO Allotment Status

Using Excel and SMS to check IPO allotment status offers several advantages:

• Efficiency: Excel helps you organize and manage multiple IPO applications, while SMS provides a quick way to check allotment status.
• Convenience: You can check the status from the comfort of your mobile phone, eliminating the need to visit websites or contact brokers.
• Real-Time Information: The SMS response provides instant information about your allotment status as soon as it’s available.

Conclusion

Checking BSE IPO allotment status by SMS in Excel is a user-friendly and efficient method to stay updated on your IPO application status. By utilizing the power of technology and automation, you can quickly access information about your share allocation without the need for manual tracking. This process streamlines the communication between investors and the stock exchange, enhancing transparency and convenience in the IPO investment journey.

Send Inquiry on WhatsApp