CS2 Skin Inventory & Trading Journal

Here’s your upgraded feature list in a clean, copy-paste-ready format:

---

## Upgraded Feature List – CS2 Skin Inventory & Trading Journal

### 1. Core Inventory Table (Main Sheet)

| Column | Name | Description | Formula (Sample) |
| ------ | -------------------- | ------------------------ | --------------------------------------------- |
| A | **Date** | Auto-filled on new entry | `=IF(B2<>"", IF(A2="", TODAY(), A2), "")` |
| B | **Product Name** | Full name of skin | Manual entry |
| C | **Buy Price (\$)** | Price paid | Manual |
| D | **Sell Price (\$)** | Final sell value | Manual |
| E | **% Gain** | ROI % | `=IF(C2="", "", IF(C2=0, "N/A", (D2-C2)/C2))` |
| F | **Week Start (Mon)** | Groups into trading week | `=A2 - WEEKDAY(A2, 2) + 1` |
| G | **Week Label** | Formatted label | `="Week of " & TEXT(F2, "dd-MM-yy")` |
| H | **Sell Date** | Date you sold the item | Manual |
| I | **Holding Days** | How long you held | `=IF(AND(A2<>"", H2<>""), H2 - A2, "")` |
| J | **Notes** | Reasoning or context | Manual |

---

### 2. Dashboard Metrics (4–8 Cell Tracker)

| Metric | Formula |
| ------------------ | ---------------------------------------- |
| Total Buy | `=SUM(C2:C)` |
| Total Sell | `=SUM(D2:D)` |
| Total Profit | `=SUM(D2:D) - SUM(C2:C)` |
| Avg ROI % | `=AVERAGE(FILTER(E2:E, ISNUMBER(E2:E)))` |
| Best Trade % | `=MAX(FILTER(E2:E, ISNUMBER(E2:E)))` |
| Worst Trade % | `=MIN(FILTER(E2:E, ISNUMBER(E2:E)))` |
| Total Holding Days | `=SUM(I2:I)` |
| Avg Holding Days | `=AVERAGE(I2:I)` |

---

### 3. Capital Efficiency & Turnover Metrics

| Metric | Formula |
| ---------------------- | ------------------------------- |
| Capital Turnover | `=Total Sell / Total Buy` |
| Inventory Velocity | `=COUNT(D2:D) / COUNT(C2:C)` |
| Active Inventory Value | `=SUM(FILTER(C2:C, D2:D = ""))` |
| Inventory Sold % | `=COUNT(D2:D) / COUNTA(C2:C)` |

---

### 4. Monthly Performance Summary

Use `QUERY()` or Pivot Tables to display:

| Column | Metric |
| ----------------- | ---------------------------------------- |
| Month | Auto-grouped via `=TEXT(A2, "MMM-YYYY")` |
| Monthly Trades | `=COUNTIFS()` |
| Monthly Profit | `=SUMIFS()` |
| Avg ROI per Month | `=AVERAGEIFS()` |

---

### 5. Weekly Profit Visuals

Two visuals here:

* **Standard Weekly Profit Chart** – using column G for "Week of"
* **Profit Every 8 Days (Rolling)**:

**Formula:**

```excel
=QUERY(A2:J, "SELECT A, SUM(D)-SUM(C) WHERE A IS NOT NULL GROUP BY INT((A - DATE(2024,1,1))/8) LABEL SUM(D)-SUM(C) 'Profit Every 8 Days'", 0)
```

This creates a view of **rolling 8-day periods**, simulating an “operational week.”

---

### 6. Net Worth Growth Tracker

Use a separate chart to show:

* **Cumulative Net Profit**: `=RunningTotal(Sell - Buy)`
* **Total Capital in Circulation**: `=Total Buy + Value of Unsold Skins`
* \*\*Net Worth = Profit + Inventory Value\`

This helps treat it like a true portfolio.

---

### 7. Notes & Strategy Review Column

Use Column J for:

* Your thought process behind each trade
* Category like: “Quick Flip,” “Major Anticipation,” “Undervalued Buy”
* Review monthly to improve strategy

---

### 8. Visual Charts to Add

* **Line Chart:** Profit by Week
* **Bar Chart:** Monthly Volume vs Profit
* **Pie Chart:** Trade Outcomes (% Win/Loss)
* **8-Day Cycle Bar Chart**: Profit Every 8 Days (custom weekly)

---