How it works
For each lot, units bought = invested amount / unit price. Weighted average cost = total invested / total units; export each lot.
Input definitions
- CSV: amount invested,price per unit
- Plain text; maximum 200,000 characters.
A worked example
- CSV: amount invested,price per unit
- amount,price 100,10 100,20
Assumptions & limits
Entered single-currency amounts and fixed rates; monthly interest and two-decimal half-up rounding. No tax, lending approval, changing rates or live market data.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Why is average purchase price not the simple average of unit prices?
Different prices buy different quantities for the same investment. Average cost divides total invested by total units, rather than averaging quoted prices.
How does Average purchase price from investment lots work?
For each lot, units bought = invested amount / unit price. Weighted average cost = total invested / total units; export each lot.
What are the limits of Average purchase price from investment lots?
Entered single-currency amounts and fixed rates; monthly interest and two-decimal half-up rounding. No tax, lending approval, changing rates or live market data.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.