NSE and MCX Symbol and Datestamp Correction

Quick Start

When correcting symbols and datestamps:

1. Convert expiry dates to OpenAlgo format: DD-MMM-YY (e.g., 28-MAR-24)
2. Construct symbols using correct format based on exchange and instrument type
3. Validate symbol structure matches OpenAlgo standards
4. Format strike prices (remove .0, keep decimals like 292.5)

Date Format Standards

Database Expiry Format

• Format: DD-MMM-YY (with hyphens)
• Example: 28-MAR-24, 15-APR-25
• Use: Stored in database expiry column