Great video! It is very helpful. It appears that the %-change calculation is incorrect. The difference must be divided by the earlier price, not the current price.
Exact, The % is not correct. I've tried to change even months and checking back on google finance it's not at all the same % than u. Video to fix that would be welcome 😁
Great video man However to calculate the percentage change, we often need to use the price data from the last Friday of the given time. This means that one month back from today is the 26th of February, we would use the price data from the last Friday, which might be on the 22nd of February. Can you help me to achieve that login in excel?
hi how do you get the chart for say 2 years for SBUX from Sept 1, 2006 to 2008 please? What is the formula for getting the 2 year charts from a specific date in the PAST?
Is there a way to get a Google Sheet of ALL stock ticker symbols so I can track all of the stocks, if I wanted to? Of course, I would edit it down. Thanks! Amazing job by the way!
This is amazing. Better than any website's watchlist. Thank You!
Absolutely the best spreadsheet i seen in 15 years on youtube. Thanks so much
Thanks Max! Appreciate this quick tutorial. Very helpful.
My pleasure! Awesome to see it helps!
This was immensely helpful!
Nice, do you have a workaround for foreign stocks which are not supported by GOOGLEFINANCE function? For instance, Japanese stocks?
TY so much... really to the point and quick for me...
Great video! It is very helpful. It appears that the %-change calculation is incorrect. The difference must be divided by the earlier price, not the current price.
Thanks for the info!
Exact, The % is not correct. I've tried to change even months and checking back on google finance it's not at all the same % than u. Video to fix that would be welcome 😁
Great job. Thank you. Very helpfull
Thanks
Never knew we had this facility of google Finance
hey, glad it helped!
ITS AMAZING THANKS SIR
Most welcome!
How do I make this work for international stocks? Thanks.
Need to add a column for the percentage change today.
Is there a way to make the chart's red if the price is down compared to a year ago?
% formula is wrong , we should divide by old price
yikes, thanks for pointing it out :D
Nice,works for me
Good to hear !
how to I get the chart for 1 week and for the day?
thank you so much great vdo
Great, thanks!
THANKS ................
how do you account for dividends and splits? Seems like over the long term this would be inaccurate without.
This is an amazing tutorial, Thank you @Max
One question. Is there a formula or a way to pull in the Stock Split history?
Great video man
However to calculate the percentage change, we often need to use the price data from the last Friday of the given time. This means that one month back from today is the 26th of February, we would use the price data from the last Friday, which might be on the 22nd of February. Can you help me to achieve that login in excel?
Great video. Thank you. Does the price function give you the price during the day while the market is open?
Hi, glad it helped! I think it updates the price every time you refresh the sheet :)
What about ETFs and Mutual Funds?
Is it possible to add buy and sell signals? For example, if the stock is above the SMA25 it is a buy signal.
hi how do you get the chart for say 2 years for SBUX from Sept 1, 2006 to 2008 please? What is the formula for getting the 2 year charts from a specific date in the PAST?
how to calculate the % change of the price in the past one week
Is there a formula for dividend?
GOOD INFORMATION
And how can we do day chart?
Is there a way to get a Google Sheet of ALL stock ticker symbols so I can track all of the stocks, if I wanted to? Of course, I would edit it down. Thanks! Amazing job by the way!
hey, I think google sheets would have trouble computing that large number of stocks. 😂 But you can download and edit the sheet no problem!
Do you have a way to track the Max DrawDown in certain amount of time. MDD for 10 years for exemple ?!
hmm not quite sure how to implement that tbh
@@MaxRohowsky thanks anyway for the reply. 👍🏾
how can i get crypto in it? thanks
Awesome thanks!