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

[@RyderDK]

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.

[@sathishg1315]

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!

[@ΣυμεώνΠαπαδόπουλος-λ4ο]

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

[@ExcelGoogleSheets]

Thank You!

[@wazizzyk2]

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

[@KyleBruns-d9l]

Absolutely fantastic explanation.

[@ioio7354]

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

[@ioio7354]

Please help me.....i am not able to find a formula to find the real average price of shares i have.... in your video for example, we have 6 google shares at 1.700$, then we sell 2 shares, so we have 4 shares at 1.700$, then we buy 5 shares at 1.732$. So we have 9 shares totally, and the avg price is ((4*1700)+(5*1732))/9 =1717,77. Which formula i can use to automate this process? if i bought and sold 1.000 times google how i could find the average price of google's shares i have. This thing is driving me crazy!!!!! Only you could find a solution!!!

[@jelledebruin5156]

@@ioio7354 Hey lo lo, 1 year later and I have the same issue. How did you solve this issue? I search everywhere but can't find the solution.

[@ioio7354]

@@jelledebruin5156 he didn't answer.... and I gave up.....

[@prateeksharajput8203]

First viewer 🙏 very much helpful bro

[@ExcelGoogleSheets]

Great 👍

[@knottcrypto293]

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?

[@ExpensiveUrine]

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. 💙

[@jessicatsai59]

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)?

[@sharewasi3438]

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

[@singsereybot9585]

WooW, thank so much. finally found that video.

[@AbhishekSharma-gn4iu]

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

[@rogeriotravassos5281]

Excellent!!

[@rzzr896]

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.

[@djidopeled8605]

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)

[@henkjansen5600]

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

[@krishparikh]

Can u advise how to get shares qty?

[@mehmetaliyurtsever]

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.

[@ExcelGoogleSheets]

I'm not sure what you mean by "seach algorithms"

[@LongingPatriot]

You're legend!

[@ExcelGoogleSheets]

👍

[@sudheeshspillai9509]

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