Видео

How to make it?

Very helpful formula

Abe daadi to sahi se bana ke aa.. poora mula lag raha hai

Thank you for an awesome solution. Can you suggest what needs to be done to view the output for specific financial years? Thank you. @Querinfer

While connecting sharepoint excel to power bi getting error as the data in the preview has been truncated due to size limits. Pls assist i need to link to bi

Thank you very much sir!, I hope you always healty and success

A small caveat though: If the tabular range of cells of data is defined as an EXCEL TABLE with CTRL+T, then this trick doesn't work. In other words, Excel does not let you swap the position of columns in your EXCEL TABLE with the drag-and-SHIFT-drop move using the mouse. Just validated this caveat now! 🙂

Thumbs up and subbed! Thank you for showing this simple, yet profoundly time-saving trick.

Hey it's really helpful. I need an addition to it. Can you help me with it?

Cripto currency decimal qty. Not showing, kindly work this.

Thank you my friend, it's a very challenging excercise but it works. Regards from Bogotá, Colombia.

Thanks, this is very helpful, appreciate the effort put in. The Pivot tables give the cumulative gain to date, is there a way to split this by each financial year basis the date of sale?

Instead of excel please share same for Google sheet

I would like to track what buying lot is the selling transaction associated with. The problem I see is the selling transactions would need to be split up in some cases. Your first fifo example showed allocations to different lots but the actuall selling transactions in your data doesn't split the sells like that. How would you ensure the sells are split correctly in your transaction data?

السلام علیکم Can you calculate Outstanding Balance of a customer on fifo method for a given period in brackets i.e., 0-30, 31-60, 61-90, 91-120, 121-180 and above 180.

SHORT SELL ,intraday ,AND FUTURE SHORT NOT WORKING , KINDLY WORK FOR THIS MATTER

how to find aversge price of remaining shares for each date and security?

Am I right, I think the PrevIndex column can be calculated this way: Index - 1 ?

Can you please do a Phase in Phase out study?

I will write Turkish. Please translate brother. Çok teşekkür ederim bu çalışma için. Şuan kullanıyorum. Yatırım fonları ile ilgili bir sayfam var. Oradaki kullanıcılar için portföylerini takip edebilecekleri bir excel oluşturdum ve senin yöntemini kullandım. Allah senden razı olur inşallah. Türkiye'ye gelirsen beni bul 😊

Good video... Wondering though on how to apply the FIFO on just one item. Like let's say salt having item code 001. Purchased 10 bags November 1st and 7 bags November 10th. Sold 13 bags and the cost of 1st 10 bags is 50 each while the later 7 bags costs Rs 45 each... Thanks

A great solution!

I was crying to find the asnwer online and i camr across yoy. Thank you alot and keep posting new things

Thanks Saleem.

Hardly I know, some thing important but...

Absolutely lived it. Thanks for putting in the effort. Regards.

Thank you

Can you please help me with the recent data? It’s showing so rough

Data is different now,

Best excel video ever, showing so many complex and easy concepts. Thank you very much for the time it took to explain THIS PERFECTLY how to implement in such an easy manner one quite complex problem. One more subscriber to you :)

To get the cost basis for each sales transaction, would there need to be another index for sales transactions? Also, If I want to add the date of sale, would I create a separate column in the original table? Thank you

Very nice and informative video, can you make further to calculate short term capital gain and long term capital gain share which we sold. Egarly waiting your response. Thank you very much 🙏

you are from other world, great job👏

Could you make a fifo basis on the order create date, and available stock. Also at last show closing inventory after allocation

THANK YOU! Probably the only video explaining how to do this properly. A bit complex but does solve the problem.

😑 "PromoSM"

Suppose there’s an opening stock then how should the index be calculated

Abandoned learning sumx filter function not working😢

can we do this in google sheets

Can you upload these lectures in urdu

Kindly make more short videos on Excel tips and tricks 🖤

Yes please 😍

Great Sir! Very well designed and explained. I really appreciate but want to ask wherefrom you have learnt these techniques??? 👏

Wow! Fantastic, Very easy and interactive

Please make the video that would be helpful and learn new things.👍

thanks man

That beard needs some attention

Thank you so much for such an informative video

Will it work on Excel Web/online?