Hello.
I am attempting to FIFO a series of buy and sell transactions into a semi-formatted output given there is other data I need to calculate for this. However, FIFO'ing the transactions is what I am after largely.
I've effectively given up on this being possible without the use of VBA.
I need transactions that I have laid out like this (these are all from the same security, I just randomized the data for example's sake so if the values don't seem right, no worries).:
To Become something like this:
As you can see, thus far I have created a semi-calculator-esque idea that will allow me to manually FIFO quite easy (IE it allows me to put the buy/sell in, and then tells me how much of each was used and displays the remainder such that I can carry it over myself and delete the order myself when it is complete) but, these lists often have hundreds of transactions. Any form of advice or help would be greatly appreciated.
Thanks!
I am attempting to FIFO a series of buy and sell transactions into a semi-formatted output given there is other data I need to calculate for this. However, FIFO'ing the transactions is what I am after largely.
I've effectively given up on this being possible without the use of VBA.
I need transactions that I have laid out like this (these are all from the same security, I just randomized the data for example's sake so if the values don't seem right, no worries).:
To Become something like this:
As you can see, thus far I have created a semi-calculator-esque idea that will allow me to manually FIFO quite easy (IE it allows me to put the buy/sell in, and then tells me how much of each was used and displays the remainder such that I can carry it over myself and delete the order myself when it is complete) but, these lists often have hundreds of transactions. Any form of advice or help would be greatly appreciated.
Thanks!