Google Sheets - Average, Weighted Average, Average Ifs & Conditional Weighted Average 

Man I have tried to setup a similar formula for conditional weighted average for days, and you put me on the right track in 10 minutes. Great work, liked and subbed immediately.

Really amazed by the way you are explaining each functions with an example, the least I can do is to give a thumbs up and share this video with my colleagues!

Great content! Really helpful. I've been watching your channel for a while now and love how you're diving into complicated topics like formulas and google apps script. Would love to see more content and your creativity applied to investment and trading strategies. 💙

Each of your tutorials is like a seminar. Thank you very much!

Absolutely fantastic explanation.

Excellent!!

WooW, thank so much. finally found that video.

hey this is awesome! real quick question if you want to add transactions does that mean you need to update the filter ranger every time? does anyone know a way around this?

Wow, that was excellent, my only gripe is that you ignore transaction costs which are important. It would be great to incorporate the costs into the average share price so you know where you need the share price to be to break even.

Hi Sir - thanks for the very informative doc - can you explain why i'm getting the following error when I try to do what you do at the 15:15 mark - "AVERAGE.WEIGHTED has mismatched range sizes. Expected row count: 2. column count: 1. Actual row count: 1, column count: 1." - it seems when I add a -1 to the last statement, the filter spits out only one number

Thanks for the video! Its really helpful, however for the average price, how could I eliminate the realized gain/loss (i.e. only the cost of the current shares holding)?

You are GREAT, i love you videos. However, the average price is still wrong ......that's because you consider only all buy quantity and you don't consider sell quantity. In fact, at the end, the correct average price of google shares is 1717.77. In this example the difference is tiny, but with multiple buy and sell operation or with big quantity of shares, the average buy price is COMPLETELY different..... And you will sell or buy new shares with a wrong idea of profit or loss. Plus, FIFO method is also a good way to consider the average price. It would be awsome if you can make a video considering these two aspects. I tried hard to find out a solution but i am not so smart as you :( PLEASE HELP ME... Thankyou for your great and wonderful work. I really appreciate all your videos. You teached me a lot of things!!!!! Cris

First viewer 🙏 very much helpful bro

Can you make a video for calculating EMAs of different values, RSI, MACd, Bollinger bands for stocks in the portfolio in single sheet?

You're legend!

Hi, You are very good at spreadsheet thanks for awesome... What do you think about seach algorithms. Can you focus on it? I really do want to learn it.

HOW CAN U AUTOFILL THE VALUES INSTEAD OF DRAGGING FORMULA DWN IN COL C PORFOLIO (WITHOUT USING MAP OR LAMBDA), COZ IF U ADD MORE STOCKS U HAVE TO KEEP DRAGGING THE FORMULA DWN

hey you have great videos , but like somone ask here and you didnt respone this is still not caculate good the AVG because this is not considering the shares i sold only the shares i buy so if i sold the stock and than buy again this gives me the AVG of the price i buy not removing the shares i already sold (sry if i have bad english realllyy hope you can respone and help me thank you)

I was trying the query where function, but not giving any result. The colum include some equations. Can u please help

Can u advise how to get shares qty?

Is it also important that you calculate also the costs to buy the stock? This formula does not do this.