How to Check BSE IPO Allotment Status by PAN Card in Excel?
Investing in Initial Public Offerings (IPOs) can be an exciting opportunity to become a part of a company’s growth story right from the beginning. Once you’ve applied for an IPO, one of the crucial moments is checking whether you’ve been allotted shares. In this guide, we’ll walk you through the process of using your PAN card and Excel to check the BSE IPO allotment status.
Understanding IPO Allotment Status
Before we dive into the steps, let’s understand what IPO allotment status means:
Allotment Status:
After the IPO subscription period ends, the company and the stock exchanges finalize the allotment of shares to investors who applied for the IPO.
PAN Card:
The Permanent Account Number (PAN) card, issued by the Income Tax Department, is a unique 10-character code that serves as a crucial identification for financial transactions, including IPO applications.
Steps to Check BSE IPO Allotment Status in Excel
You can use Excel to check your BSE IPO allotment status using these steps:
Step 1: Download the Excel File
Visit the BSE website or the registrar’s website for the IPO in question. Download the Excel file containing the allotment details.
Step 2: Open Excel and Import Data
Open Excel and navigate to the “Data” tab. Choose “Get Data” and select “From Text/CSV.” Locate and open the downloaded Excel file.
Step 3: Review Allotment Status
Once the data is imported, you’ll see a table with allotment details. Review the table to find your PAN card number and corresponding allotment status.
Benefits of Using Excel for Allotment Status
Checking BSE IPO allotment status in Excel offers several advantages:
Efficiency:
Excel allows you to quickly search and find your PAN card among a list of allotments.
Customization:
You can sort and filter the data as needed, making it easier to locate your allotment status.
Reference:
You can save the Excel file for future reference or to track multiple IPO allotments.
Important Considerations
Keep these points in mind when using Excel to check IPO allotment status:
Data Accuracy:
Ensure the PAN card number is entered correctly to accurately check your allotment status.
Registrar’s Website:
The Excel file is usually available on the registrar’s website. Make sure you’re downloading it from an official source.
Conclusion
Checking BSE IPO allotment status by PAN card in Excel is a convenient and efficient way to track your allotment status. By following the steps mentioned in this guide, you can stay informed about your investment journey and take necessary actions based on the allotment status.
By Astrobulls Research Pvt Ltd.