How to write FIFO Function in Excel programming

[C.H.Chng]

Appreciated if someone can help me on the problem on how to create / write VB
code in excel for FIFO function on my stock valuation purpose.
and pls mail to :- (e-mail address removed)

 

[Rob]

Appreciated if someone can help me on the problem on how to create / write VB
code in excel for FIFO function on my stock valuation purpose.
and pls mail to :- (e-mail address removed)

It really depends on the structure of your worksheet. Do you have an
example?

Also are you looking for a holding period return, cost basis, or some
other measure?