דוח כזה נחוץ כדי לחשב את המס הישראלי (הלכת מוזס וכו.). את הפרומפט כתב ChatGPT בעצמו . כל הקניות הרלוונטיות צריכות להופיע בדוח.
Reusable Prompt: FIFO Tax Lot Matching from Excel
I will upload an Excel file containing all buy and sell transactions for a single security.
Please do the following:
1. Filter the data to only this ticker (ignore all others).
2. Assume FIFO accounting and that all buys needed to cover sells are contained in the file (no short sales, no missing history).
3. Match all sells to buys on a FIFO basis, fully allocating every sell.
4. Produce an Excel file where each row is a FIFO tax lot, including:
- Buy Date
- Sell Date
- Quantity
- Buy Price
- Sell Price
- Cost Basis
- Proceeds
- Realized Gain/Loss
5. Ensure:
- Total FIFO-matched shares equal total shares sold
- Any remaining unmatched buys are treated as unsold shares only
- No sell is left unmatched
6. Report:
- Total shares sold
- Total remaining shares
Output the final FIFO result as a downloadable Excel file and confirm totals for reconciliation.
Please do the following:
1. Filter the data to only this ticker (ignore all others).
2. Assume FIFO accounting and that all buys needed to cover sells are contained in the file (no short sales, no missing history).
3. Match all sells to buys on a FIFO basis, fully allocating every sell.
4. Produce an Excel file where each row is a FIFO tax lot, including:
- Buy Date
- Sell Date
- Quantity
- Buy Price
- Sell Price
- Cost Basis
- Proceeds
- Realized Gain/Loss
5. Ensure:
- Total FIFO-matched shares equal total shares sold
- Any remaining unmatched buys are treated as unsold shares only
- No sell is left unmatched
6. Report:
- Total shares sold
- Total remaining shares
Output the final FIFO result as a downloadable Excel file and confirm totals for reconciliation.
