Excel Macro or alternate solution for share capital gains

I need some excel macro to calculate capital gains (long-term/short-term/Intraday) on share transactions? I can buy this as it is if someone has already built. My requirement is one time for a set of 200 transactions on one Indian shares. Key out put would be to do FIFO matching and separation of long-term, short-term and Intraday. If someone is willing to do it one time manually also they can also bid for it. File for the project is attached.