How can I check BSE IPO allotment status by PAN card by SMS online in Excel? 

Demystifying BSE IPO Allotment Status Check by PAN Card through SMS and Online Excel

Initial Public Offerings (IPOs) offer investors a chance to own a piece of a company’s shares before they are listed on the stock exchange. Being part of an IPO can be exciting, but once you’ve applied for shares, the next question is often about allotment. In this comprehensive guide, we’ll walk you through the process of checking BSE IPO allotment status using your PAN card through SMS and even using Excel online. Let’s dive in and unravel the steps.

Understanding IPO Allotment

Before delving into the allotment status, it’s important to grasp the concept of IPO allotment. When you apply for shares in an IPO, the issuing company and the stock exchange allocate a certain number of shares to successful applicants. The allotment process is based on various factors, including the number of shares available and the demand from investors.

Checking BSE IPO Allotment Status via SMS

Checking IPO allotment status through SMS is a convenient way to get real-time updates on the status of your application. Follow these steps:

Step 1: Keep Your PAN Card Handy

You’ll need the PAN card details used for the IPO application.

Step 2: Send an SMS

Open the messaging app on your phone and send an SMS in the format provided by the registrar or the stock exchange. Typically, the format is:

IPO

Replace with the application number you received after applying for the IPO, and with your PAN card number. Send this SMS to the designated number provided by the registrar.

Step 3: Receive Allotment Status

After sending the SMS, you’ll receive a reply indicating your IPO allotment status. The message will contain information about the number of shares allotted to you, as well as any instructions for further action.

Checking BSE IPO Allotment Status Online Using Excel

If you prefer a more organized way to track your IPO allotment status, you can use Microsoft Excel online. Here’s how:

Step 1: Create an Excel Sheet

Open Microsoft Excel online or through the desktop application. Create a new sheet and label columns for Application Number and PAN.

Step 2: Enter Data

In the respective columns, enter your application numbers and corresponding PAN card numbers that you used for the IPO applications.

Step 3: Utilize Excel Functions

Use Excel functions to fetch the allotment status. You can use the HYPERLINK function to generate a link to the registrar’s website where you can check the allotment status. This provides a quick way to access the status directly from your Excel sheet.

Benefits of Checking Allotment Status

Checking your IPO allotment status offers several advantages:

Timely Action: Knowing your allotment status helps you take prompt action, whether it’s making payment for the allotted shares or adjusting your investment strategy.

Clarity: Allotment status provides clarity on the outcome of your application, reducing uncertainty.

Planning: With allotment information, you can plan your financial moves accordingly, based on the number of shares allotted to you.

Stay Informed with Astrobulls Research Pvt Ltd.

At Astrobulls Research Pvt Ltd., we believe in empowering investors with knowledge and insights to make informed decisions. Whether you’re a seasoned investor or new to the IPO landscape, our team is dedicated to providing valuable guidance and assistance in your investment journey.

For further assistance, information about stock market courses, or any other inquiries, feel free to reach out to us on WhatsApp at +91 9685990797. Our experts are here to support you and help you excel in your stock market endeavors.


Send Inquiry on WhatsApp

By Astrobulls Research Pvt Ltd.

Leave a Comment

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