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, SMS, and Online in Excel

Initial Public Offerings (IPOs) serve as a gateway for investors to participate in the growth story of emerging companies. As you invest in an IPO, the anticipation of whether you have been allotted shares is palpable. The Bombay Stock Exchange (BSE) facilitates the allotment process, and in this guide, we delve into the various avenues through which you can check your BSE IPO allotment status. From using your PAN card to employing SMS services and leveraging the online platform, we provide a comprehensive roadmap for investors. Let’s navigate this exciting journey together!

Exploring the PAN Card Route

Your Permanent Account Number (PAN) card plays a pivotal role in tracking your BSE IPO allotment status:

  • Registrar and Transfer Agent (RTA): The RTA manages IPO allotment and maintains records. Visit the RTA’s official website and input your PAN and application number to ascertain your allotment status.
  • Depository: If you’ve applied through a Depository Participant (DP), you can access the DP’s portal to check the status using your PAN.

Unlocking the Power of SMS

In an era of swift communication, SMS services offer a convenient method to access your BSE IPO allotment status:

  • Format: Compose an SMS with the Application Number and send it to the designated number provided by the registrar. You’ll receive an SMS disclosing your allotment status.
  • Example: If your Application Number is 1234567890, send an SMS like this: “IPOALLOT 1234567890” to the specified number.

Seamless Online Experience

The digital realm offers a user-friendly avenue to ascertain your BSE IPO allotment status:

  • BSE Website: Navigate to the BSE official website and access the IPO section. Enter your application number and PAN to view your allotment status.
  • Online Portals: Numerous financial news portals offer IPO tracking services. Provide your application number and PAN to retrieve your allotment status.

Convenience in Excel

Harnessing technology for greater convenience, you can even track your BSE IPO allotment status using Excel:

  1. Data Entry: Create a spreadsheet in Excel with columns for Application Number and PAN.
  2. Formula: Employ VLOOKUP or INDEX-MATCH functions to fetch allotment status data from online sources, automating the process.
  3. Refresh: Regularly update the spreadsheet to obtain real-time information about your BSE IPO allotment status.

Empowering Your Investment Journey

Mastering the art of IPO investing demands both strategic insight and swift access to critical information. As you tread this path, enrolling in stock market courses equips you with the tools to make informed investment decisions.

For personalized guidance on IPO investing, understanding the intricacies of BSE IPO allotment status, and embarking on a successful journey in the world of IPOs, connect with Astrobulls Research Pvt Ltd. Our commitment lies in empowering investors with insights and support to navigate the dynamic landscape of IPOs with confidence.


Send Inquiry on WhatsApp

By Astrobulls Research Pvt Ltd.

Leave a Comment

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