Forum Discussion
Twifoo
Feb 08, 2021Silver Contributor
FIFO Inventory Formula Challenge
To revel my second anniversary as a member of this EXCELlent Community, I hereby proffer this challenge to season your array manipulation skills. Perhaps, keenadvice mathetes Riny_van_Eekelen PeterBa...
Riny_van_Eekelen
Feb 09, 2021Platinum Contributor
Twifoo Don't really now what "Array manipulation" is and I'm probably violating all the rules of the challenge. Sorry about that. I used your challenge to play around with LET, in stead.
Traderbear
Sep 12, 2023Copper Contributor
I have applied your Let algorithm to a FIFO calculation for option trading. I have been able to get it to work--partially. To use it this way, I had to allow for negative inventory (equity) values. There are cases where it gives the wrong answer. If you are interested in helping me find the problem, I can send you a spreadsheet that shows the problem.
Thanks,
Paul Accampo