# Two stock Portfolio | Creating a two-stock portfolio in Excel involves setting up a spreadsheet to track the performance of two different stocks over time. Here are the basic steps to create a simple stock portfolio in Excel: in urdu

• 9 months ago
Creating a two-stock portfolio in Excel involves setting up a spreadsheet to track the performance of two different stocks over time. Here are the basic steps to create a simple stock portfolio in Excel:

Open Microsoft Excel and create a new workbook.
Label your columns for tracking the stocks. For a basic portfolio, you can have columns like:
A: Date
B: Stock 1 Name
C: Stock 1 Ticker
D: Stock 1 Price
E: Stock 1 Quantity
F: Stock 1 Total Value
G: Stock 2 Name
H: Stock 2 Ticker
I: Stock 2 Price
J: Stock 2 Quantity
K: Stock 2 Total Value
L: Total Portfolio Value

In the "Date" column (Column A), enter the date for each data point.
In the "Stock 1 Name" column (Column B), enter the name of the first stock.
In the "Stock 1 Ticker" column (Column C), enter the stock's ticker symbol.
In the "Stock 1 Price" column (Column D), enter the stock's price on that date.
In the "Stock 1 Quantity" column (Column E), enter the quantity of stock 1 you own on that date.
In the "Stock 2 Name" (Column G) and subsequent columns, repeat the same process for the second stock.
Calculate the total value for each stock:

In the "Stock 1 Total Value" column (Column F), enter a formula that multiplies the stock price by the quantity you own. For example, in cell F2, you can enter the formula =D2*E2.
In the "Stock 2 Total Value" column (Column K), repeat the same process for the second stock.
Calculate the total portfolio value:

In the "Total Portfolio Value" column (Column L), enter a formula that adds up the total values of both stocks. In cell L2, you can enter the formula =F2+K2. This will give you the total value of your portfolio on that date.
Track portfolio performance:

Continue entering data for each date as the stock prices and quantities change. The formulas will automatically calculate the total values for each stock and the total portfolio value.
Create charts (optional):

To visualize your portfolio performance, you can create line charts or other types of charts in Excel. Select the data you want to chart and go to the "Insert" tab to create a chart.