JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
I have a table in date order (oldest to newest, by day, including duplicate dates) with ledger entries for stock purchases and stock sold.
I will never sell more than what is available to sell
If I need to calculate difference in price for A as £8 (£10 - £2) for date 03/01/2019, what formula would I need, based on first Buy price for Product A vs first Sell price for Product A
Related, if for 03/01/2019 -100 were sold, how would I calculate price difference as: £8.17 for Product A? £10 - (50*£2 + 10*£1)/60
And formula for % difference for same!
TIA,
Jack
I have a table in date order (oldest to newest, by day, including duplicate dates) with ledger entries for stock purchases and stock sold.
I will never sell more than what is available to sell
Date | Order | Product | Quantity | Unit Price | Unit Price Difference (£) | Unit Price Difference (%) |
01/01/2019 | Buy | A | 50 | £2 | ||
02/02/2019 | Buy | A | 100 | £1 | ||
03/03/2019 | Sell | A | -50 | £10 | ? | ? |
If I need to calculate difference in price for A as £8 (£10 - £2) for date 03/01/2019, what formula would I need, based on first Buy price for Product A vs first Sell price for Product A
Related, if for 03/01/2019 -100 were sold, how would I calculate price difference as: £8.17 for Product A? £10 - (50*£2 + 10*£1)/60
And formula for % difference for same!
TIA,
Jack