Hello everyone, I have tried to create excel for calculating Actual Investment fifo method. But the results are not coming as expected. Need your help to suggest excel formula.

I tried so many formulaes, nothing provided me the correct result. So i removed everything what i have done.

In the attached file I added the Values as below

On row 25 I just kept the 10th Transaction for using when ever it is required to copy after deleting the 10th transaction on row 18.

Can anyone help me with the forumula to get the actual investment amount even i have done mulitple buy and sell transactions in between. so i can get the exact numbers for other calculations.

I tried so many formulaes, nothing provided me the correct result. So i removed everything what i have done.

In the attached file I added the Values as below

Cell Reference | Cell Value |
---|---|

N9 | Amount Invested Value caluclated by totalling the values of buy and sell value, which is not showing correct value of the Amount Invested due to getting Profit or Loss in Sell value |

O9 | Units Present after 10 Transactions |

N11 | Actual Amount invested which is calculated below from H13 to M15 Cells for 10 Transactions |

O11 | Units Present after 10 Transactions |

N17 | Actual Amount invested which is calculated below from H19 to M22 Cells for 9 Transactions |

O17 | Units Present after 9 Transactions |

On row 25 I just kept the 10th Transaction for using when ever it is required to copy after deleting the 10th transaction on row 18.

Can anyone help me with the forumula to get the actual investment amount even i have done mulitple buy and sell transactions in between. so i can get the exact numbers for other calculations.