GoogleSheets - Calculate XIRR from different sheet

Question

I have two sheets: Portfolio and Transactions.

My transaction sheet looks like this :

My portfolio sheet looks like :

Here total Market rate refers the current market price of total X stocks.Say, I have a total of 44 HDFCBK stocks, so 44 * current market price (Rs.1659.9) is 73,035.6.

I would need to display the XIRR of each stock in my portfolio sheet from transactions sheet.

Any help how this can be done?

Thanks.