@Saransh_Khemka Please find attached link to the sheet I use for calculation of XIRR. As you are aware all investments are shown in -ve and withdrawals in +ve.

I have populated the sheet with dummy numbers. You can insert lines as you need.

Could you please explain?

Some change in tactics:
Because the markets are in somewhat uncertain phase and there are macro events and economic facts that are likely to keep thing uncertain for next. 2- 3 months , I have decided to …

1. Get out of financials like Bajaj finserv and large caps like Tata motors where things are not likely to turn soon for better .In general ,large caps are more prone to manipulation by FIIs and rewards are not very high . It’s better to hold cash and take calculated risks rather than adding ballasts that help in sinking the ship.

2.Book some profits …sold PGEL, Shilchar , REDTAPE ,Nuvama etc for different reasons. Shilchar is still in radar and will pick up near or below 6k only after the results .Sold at 7500 since the run up was very steep in last 2 weeks and the results are likely to be near flat as the new capacity was in picture for only 15 days.

3. Buy good small and mid caps at per determined price via GTT . Two types …
   a. Good companies with high growth visibility and good momentum .(Technoelectric ,Gravita ,Strides ,BLS etc.).
   b. Good enough companies at their worst business position and/or at strong support or stocks under pressure due to some temporary reasons . They are likely to fall less but has much better upside (excepting big market crash ).(Inox India,Polyplex, RaymondLSL , Indigopaints etc.)

So in general , reducing random throws of dice and keeping some cash( 10% ) to pick at dips. Not selling out high conviction bets because mostly it’s too soon to judge .Need at least another quarter to judge most of the companies since more than 60% stocks has been only a few months in keeping .

I do not believe we are heading for a crash just because too many people are shouting from rooftops that there is going to be a crash . Random asinine comparisons with historical crashes are being made using the telescopic effect of time to link unrelated events at will. Markets may crash when it wants anytime but howling of scavengers is not going to bring it down .

hey can you please share xirr excel

can someone explain how the earnings are going to look like going forward? And whether or not this is a reputable company within the elevator space