Thread
:
How to program FIFO inventory in excel ?
View Single Post
#
3
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 3
How to program FIFO inventory in excel ?
hi, amount is for both...
if the bond is sold, then the number shows amount sold
if the bond is purchased, then the number shows amount bought
tha.
wrote:
"Amount" is the volume purchased or sold?
wrote:
dear all,
I have 1 sheet which contains product name, buy or sell, price, amount,
trade date, counterparty.
for example :
book A - buy - $50 - 10 - 1 jan 06 - G
book B - buy - $100 - 20 - 1 jan 06 - G
book A - buy - $60 - 15 - 2 jan 06 - H
book A - sell - $65 - 15 - 3 jan 06 - I
book B - sell - $110 - 15 - 3 jan 06 - J
I would like to have a new sheet which shows FIFO for those books
so it would shows table with something like
book A - sell - $65 - 15 - 3 jan 06 - I consist of : book A - buy -
$50 - 10 - 1 jan 06 - G
:
book A - buy - $60 - 5 - 2 jan 06 - H
(book A sold at 3 jan 06 to I at price $65 is using 10 books bought at
1 jan 06 at price $50 from G & 5 books bought at 2 jan 06 at price $60
from H (in table form))
how can I do that ?
thanks
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]