I am using the method shown by sahil sharma, where you have to download the trade book and insert 1st row as starting date account value and last row as final date account value. And insert two columns. One is binary , where sell is +1 and buy is -1 and last column value. And then apply xirr function to value column. Its easy
Subscribe To Our Free Newsletter |