Тёмный

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

Max on Tech
Подписаться 13 тыс.
Просмотров 18 тыс.
50% 1

Download the Watchlist: docs.google.com/spreadsheets/...
◾◾◾◾◾ 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! ◾◾◾◾◾
📢 Discord Chat: / discord
◾◾◾◾◾ Hashtags ◾◾◾◾◾
#Stocks #Watchlist #GoogleSheets

Опубликовано:

 

2 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 35   
@VR4Poker
@VR4Poker Месяц назад
TY so much... really to the point and quick for me...
@ivantonev4561
@ivantonev4561 5 месяцев назад
This was immensely helpful!
@wengwong7198
@wengwong7198 8 месяцев назад
Thanks Max! Appreciate this quick tutorial. Very helpful.
@MaxOnTech
@MaxOnTech 7 месяцев назад
My pleasure! Awesome to see it helps!
@rosalycruzc
@rosalycruzc 2 дня назад
Amazing work, simple and wonderful explanation, God bless, thank you
@MaxOnTech
@MaxOnTech 2 дня назад
glad it helped:) all the best.
@Claudiu-Steflea
@Claudiu-Steflea 2 месяца назад
Great job. Thank you. Very helpfull
@BalazsBedo
@BalazsBedo 6 месяцев назад
Great, thanks!
@brianp461
@brianp461 2 месяца назад
Need to add a column for the percentage change today.
@peterbiskup1122
@peterbiskup1122 6 месяцев назад
how to I get the chart for 1 week and for the day?
@OpBetal
@OpBetal 3 месяца назад
Nice,works for me
@MaxOnTech
@MaxOnTech 3 месяца назад
Good to hear !
@ansarmy
@ansarmy 10 месяцев назад
Thanks Never knew we had this facility of google Finance
@MaxOnTech
@MaxOnTech 10 месяцев назад
hey, glad it helped!
@ryansteinhardt6845
@ryansteinhardt6845 7 месяцев назад
And how can we do day chart?
@lonnykid2997
@lonnykid2997 2 месяца назад
How do I make this work for international stocks? Thanks.
@user-yc2ji7ci8e
@user-yc2ji7ci8e Месяц назад
ITS AMAZING THANKS SIR
@MaxOnTech
@MaxOnTech Месяц назад
Most welcome!
@sunild7050
@sunild7050 3 месяца назад
THANKS ................
@chrisvictorymountain9058
@chrisvictorymountain9058 25 дней назад
Is it possible to add buy and sell signals? For example, if the stock is above the SMA25 it is a buy signal.
@saddamwarsi786
@saddamwarsi786 4 месяца назад
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?
@oneordinarycitizen
@oneordinarycitizen 8 месяцев назад
Great video. Thank you. Does the price function give you the price during the day while the market is open?
@MaxOnTech
@MaxOnTech 8 месяцев назад
Hi, glad it helped! I think it updates the price every time you refresh the sheet :)
@ryansteinhardt6845
@ryansteinhardt6845 7 месяцев назад
how can i get crypto in it? thanks
@armyjoe_9842
@armyjoe_9842 18 дней назад
Is there a formula for dividend?
@user-cu5io2in7y
@user-cu5io2in7y 7 месяцев назад
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.
@MaxOnTech
@MaxOnTech 7 месяцев назад
Thanks for the info!
@datiphoto
@datiphoto 3 месяца назад
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 😁
@biggerlonely7242
@biggerlonely7242 4 месяца назад
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!
@MaxOnTech
@MaxOnTech 4 месяца назад
hey, I think google sheets would have trouble computing that large number of stocks. 😂 But you can download and edit the sheet no problem!
@datiphoto
@datiphoto 3 месяца назад
Do you have a way to track the Max DrawDown in certain amount of time. MDD for 10 years for exemple ?!
@MaxOnTech
@MaxOnTech 3 месяца назад
hmm not quite sure how to implement that tbh
@datiphoto
@datiphoto 3 месяца назад
@@MaxOnTech thanks anyway for the reply. 👍🏾
Далее
Build a Stock Portfolio with LIVE Stock Data on Excel
10:15
UNO!
00:18
Просмотров 1,1 млн
Build an Automated Stock Watchlist in Google Sheets!
14:26
How to Create a Gantt Chart in Google Sheets
10:41
Просмотров 904 тыс.
I saw my boss do these 10 things in Excel!
7:36
Просмотров 2,6 млн
✨ Google Sheets Introduces Tables
7:27
Просмотров 25 тыс.
Excel Stock Portfolio Dashboard - FREE File Download
27:06
10 Google Sheets Tips You DON'T Want to Miss
13:51
Просмотров 561 тыс.