Calculating FIFO in Excel

thanks yaar i need for this

Thanks, it will help those who are not expert in excel

The attached file computes profit for a single scriptt as per FIFO method. You are just required to punc in your trasactions and file will compute your profits

https://tech.dir.groups.yahoo.com/group/FMwithExcel/message/20

Hi everybody,

No XLS need! Try https://stockfo.com and calculating as FIFO, LIFO and HIFO methods online.

Ok ok you need xls for upload transactions :)

Originally posted by : Saurabh Gupta
	The attached file computes profit for a single scripttt as per FIFO method. You are just required to punc in your trasactions and file will compute your profits https://tech.dir.groups.yahoo.com/group/FMwithExcel/message/20

There is a problem with this file Sir, if i may

According to the data given i believe it is calculating profit as per LIFO method......am i right???

I WANT TO CALCULATE PROFITS WITH STT  AND ALSO PUT IT IN FIFO MENTHOD TO GET THE PROFITS AND LOSSES

HOW TO CALCULATE STT IF THERE ARE 2TO 3 BUYING AND SELLING TRASACTION IN ONE CONTRACT NOTE 

Where is attached sheet can share me link or sheets 

Pl share link to updated file as old links for working of LTCG and STCG through a formula, as links given above are not working