make a table on stock price of past 10 years of dr reddy, lupin.cipla,sun pharma, zydus cadila when they announced the dividend. i need stock price as follows : 10 days before, 5 days before, dividend announcement day, 5 days after, 10 days after
I don't have real-time access to financial data or historical stock prices. However, I can guide you on how to create such a table using publicly available resources.
To analyze the stock prices of Dr. Reddy's Laboratories, Lupin, Cipla, Sun Pharma, and Zydus Cadila around their dividend announcements, you should follow these steps:
1. **Identify the Dividend Announcement Dates**: Look up the dates when each of these companies announced their dividends over the past 10 years. This information is typically found on financial news websites, the companies’ investor relations pages, or financial databases.
2. **Gather Historical Stock Prices**: Use financial data websites such as Yahoo Finance, Google Finance, or Bloomberg to gather historical stock prices. You will want to collect closing prices for:
- 10 days before the dividend announcement
- 5 days before the dividend announcement
- The day of the dividend announcement
- 5 days after the dividend announcement
- 10 days after the dividend announcement
3. **Create a Table**: Once you have collected this data, format it into a table. Here’s a template that you can use:
| Company | Dividend Announcement Date | -10 Days Price | -5 Days Price | Announcement Price | +5 Days Price | +10 Days Price |
|------------------|---------------------------|----------------|---------------|-------------------|----------------|-----------------|
| Dr. Reddy's | [Date] | [Price] | [Price] | [Price] | [Price] | [Price] |
| Lupin | [Date] | [Price] | [Price] | [Price] | [Price] | [Price] |
| Cipla | [Date] | [Price] | [Price] | [Price] | [Price] | [Price] |
| Sun Pharma | [Date] | [Price] | [Price] | [Price] | [Price] | [Price] |
| Zydus Cadila | [Date] | [Price] | [Price] | [Price] | [Price] | [Price] |
4. **Fill in the Table**: After gathering the required stock prices, fill in the table with the observed data.
5. **Analyze the Data**: Depending on your goal, analyze how the stock prices reacted around the times of the dividend announcements. Look for trends or patterns.
### Resources You Can Use
- **Yahoo Finance**: For historical stock prices.
- **Google Finance**: For easy access to stock price data.
- **Company Press Releases**: Usually found in their investor relations sections for announcement dates.
If you need help with anything else, feel free to ask!
Update (2026-01-10):
While I cannot provide real-time or specific historical stock prices, I can describe how you can create a table for the stock prices of Dr. Reddy's Laboratories, Lupin, Cipla, Sun Pharma, and Zydus Cadila around the time of their dividend announcements. Here's a guide on how to structure the table:
### Steps to Create the Table:
1. **Collect Dividend Announcement Dates**: You can find historical dividend announcement dates for each of these companies via their investor relations website or financial news platforms like Yahoo Finance, Google Finance, or Bloomberg.
2. **Extract Historical Stock Prices**: Use stock market data providers (Yahoo Finance, Google Finance, etc.) to get the closing stock prices for the dates you are interested in:
- 10 days before the announcement
- 5 days before the announcement
- Announcement day
- 5 days after the announcement
- 10 days after the announcement
3. **Fill in the Data**: After collecting the data, fill in the table below.
### Example Table Structure
| Company | Dividend Announcement Date | -10 Days | -5 Days | Announcement Day | +5 Days | +10 Days |
|---------------|----------------------------|----------|---------|------------------|---------|----------|
| Dr. Reddy's | YYYY-MM-DD | $XXX | $XXX | $XXX | $XXX | $XXX |
| Lupin | YYYY-MM-DD | $XXX | $XXX | $XXX | $XXX | $XXX |
| Cipla | YYYY-MM-DD | $XXX | $XXX | $XXX | $XXX | $XXX |
| Sun Pharma | YYYY-MM-DD | $XXX | $XXX | $XXX | $XXX | $XXX |
| Zydus Cadila | YYYY-MM-DD | $XXX | $XXX | $XXX | $XXX | $XXX |
### Notes:
- Replace `YYYY-MM-DD` with the actual dates and `$XXX` with actual stock prices.
- You can perform this analysis for one or more years or focus on the most recent decade.
- Using a spreadsheet software like Excel can help you manage and analyze the data more effectively.
### Additional Resources:
- **Yahoo Finance**: Search for each stock and navigate to the "Historical Data" section.
- **Google Finance**: Similar to Yahoo, allows you to look up historical stock prices.
- **Company Websites**: Most companies maintain an investor relations section where they provide details of dividends announced.
If you need further assistance or have specific data points you'd like to analyze, let me know!
Update (2026-01-10):
Creating a detailed stock price table for specific companies and timeframes with exact historical data requires access to financial databases or market platforms, which I cannot access directly. However, I can guide you on how to create this table and where to find the data.
### Steps to Create the Table:
1. **Collect Dividend Announcement Dates**:
- Visit the investor relations pages of the companies (Dr. Reddy's, Lupin, Cipla, Sun Pharma, Zydus Cadila) or financial news websites to find the dates when dividends were announced over the past 10 years.
2. **Gather Stock Price Data**:
- Use a financial data platform such as Yahoo Finance, Google Finance, Bloomberg, or a stock market analysis tool.
- For each dividend announcement date, find the stock prices on:
- 10 days before
- 5 days before
- Dividend announcement day
- 5 days after
- 10 days after
3. **Compile the Data into a Table**:
- After gathering all relevant data, compile it into a structured table. Below is a sample format for the table:
### Sample Table Structure
| **Company** | **Dividend Announcement Date** | **-10 Days** | **-5 Days** | **Announcement Day** | **+5 Days** | **+10 Days** |
|------------------|-------------------------------|--------------|-------------|----------------------|-------------|--------------|
| Dr. Reddy's Labs | YYYY-MM-DD | Price | Price | Price | Price | Price |
| Lupin | YYYY-MM-DD | Price | Price | Price | Price | Price |
| Cipla | YYYY-MM-DD | Price | Price | Price | Price | Price |
| Sun Pharma | YYYY-MM-DD | Price | Price | Price | Price | Price |
| Zydus Cadila | YYYY-MM-DD | Price | Price | Price | Price | Price |
### Example:
Assuming you found that Dr. Reddy's announced dividends on specific dates:
| **Company** | **Dividend Announcement Date** | **-10 Days** | **-5 Days** | **Announcement Day** | **+5 Days** | **+10 Days** |
|------------------|-------------------------------|--------------|-------------|----------------------|-------------|--------------|
| Dr. Reddy's Labs | 2023-05-15 | 5000 | 5100 | 5150 | 5200 | 5220 |
| Lupin | 2023-08-01 | 900 | 910 | 895 | 900 | 895 |
| Cipla | 2023-11-10 | 1000 | 1005 | 1010 | 1020 | 1015 |
| Sun Pharma | 2023-02-20 | 800 | 805 | 810 | 815 | 820 |
| Zydus Cadila | 2023-03-25 | 650 | 652 | 655 | 657 | 650 |
### Notes:
- Ensure to check for any stock splits, mergers, or other corporate actions during the periods that might affect stock prices.
- Record the market closing prices for consistency.
- This process may require some time and effort depending on how many announcement dates and companies you are interested in.
By following these steps, you should be able to create a comprehensive table reflecting stock prices around dividend announcements for each company over the last ten years.


