Build a Stock Watchlist w/ Live Data | Google Sheets | 15 min.

◾◾◾◾◾ Timestamps ◾◾◾◾◾
00:00 | Intro
00:31 | Ticker and Company Name
01:32 | Fetch Market Capitalization from Google Finance
02:46 | Price Chart for 10 years and 1 year w/ Sparkline
07:45 | Price, Currency, PE Ratio, EPS from Google Finance
09:12 | Percentage Change of Price for 1, 6, and 12 Months
13:55 | 52 Week High and Low Price
14:42 | Formatting

◾◾◾◾◾ Let's Connect! ◾◾◾◾◾

◾◾◾◾◾ Hashtags ◾◾◾◾◾
#Stocks #Watchlist #GoogleSheets

[GlassMachine-ydvi]

This is amazing. Better than any website's watchlist. Thank You!

[wengwong]

Thanks Max! Appreciate this quick tutorial. Very helpful.

[VRPoker]

TY so much... really to the point and quick for me...

[ansarmy]

Thanks
Never knew we had this facility of google Finance

[RevathiKuppusamy-ci]

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.

[brianp]

Need to add a column for the percentage change today.

[fezbuzzvideos]

This is an amazing tutorial, Thank you @Max

One question. Is there a formula or a way to pull in the Stock Split history?

[lonnykid]

How do I make this work for international stocks? Thanks.

[padyalamadhava]

% formula is wrong, we should divide by old price

[saddamwarsi]

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?

[chrisvictorymountain]

Is it possible to add buy and sell signals? For example, if the stock is above the SMA25 it is a buy signal.

[peterbiskup]

how to I get the chart for 1 week and for the day?

[oneordinarycitizen]

Great video. Thank you. Does the price function give you the price during the day while the market is open?

[biggerlonely]

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!

[datiphoto]

Do you have a way to track the Max DrawDown in certain amount of time. MDD for 10 years for exemple ?!