YiChung's space

import autogen

config_list=[
    {
        "model": "gpt-4",
        "api_key": "請放入API key",
    }
]

user_proxy (to coder):

Plot a chart of 'TSMC','TSLA' and 'MSFT' stock price current YTD.

--------------------------------------------------------------------------------
coder (to user_proxy):

To plot a chart of the stock prices for 'TSMC', 'TSLA', and 'MSFT' year-to-date (YTD), we can use the `pandas` and `matplotlib` libraries in Python. Here's the code:

```python
# filename: stock_chart.py
import pandas as pd
import matplotlib.pyplot as plt

# Define the stock symbols
symbols = ['TSMC', 'TSLA', 'MSFT']

# Read the stock data from a CSV file (replace 'stock_data.csv' with the actual file name)
df = pd.read_csv('stock_data.csv')

# Filter the data for the specified symbols and YTD dates
df = df[df['Symbol'].isin(symbols)]
df['Date'] = pd.to_datetime(df['Date'])
df = df[df['Date'].dt.year == pd.Timestamp.now().year]

# Pivot the data to have symbols as columns and dates as rows
df_pivot = df.pivot(index='Date', columns='Symbol', values='Close')

# Plot the chart
df_pivot.plot(figsize=(10, 6))
plt.xlabel('Date')
plt.ylabel('Stock Price')
plt.title('Stock Prices YTD')
plt.legend()
plt.show()