Build a Stock Portfolio with LIVE Stock Data on Excel

Подписаться 555 тыс.

Просмотров 49 тыс.

50% 1

See NordPass Business in action now with a 3-month free trial here nordpass.com/kenjiexplains with code KENJIEXPLAINS
Get live stock data from the internet with Excel and build a stock portfolio.
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/635a9a...
LEARN:
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
📊 Get 25% OFF Financial Edge Using Code KENJI25: bit.ly/3Ds47vS
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Get LIVE stock data from the internet
3:16 - Build a Stock Portfolio
6:17 - Analyse your Investments with STOCKHISTORY
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

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

2 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 63

@KenjiExplains Год назад

See NordPass Business in action now with a 3-month free trial here nordpass.com/kenjiexplains with code KENJIEXPLAINS

@Joeyleander27 Год назад

One of my favorite things in excel, thanks for showing me some tips on how I can improve mine!

@paulskelton8799 Год назад

Many thanks. Very clear and informative introduction

@mikheilitchulukhadze8554 Год назад

Thank you Kenji for you videos, still waiting for Power BI playlists ))

@yogeshsali Год назад

There is always something new to learn from your videos. Can you suggest any formula for unrealised profit loss calculation of partial sell in stock trading excel sheet?

@nikhilshetty5944 Год назад

Thank you so much 💓

@sodakk17 Год назад

Subscribed because this is a very useful content.

@coriefowler6437 Год назад

Hey Kenji. would it be possible to do a video explaining and demonstrating how to do formulas for the EPS, expected dividend income, annual dividend etc please using excels stock data features? would be much apprciated.

@pierrelequeux1785 Год назад

Very neat portfolio!!

@camlex6310 Год назад

Really cool functions!!

@lucashalef8635 Год назад

Great video bro! Can you make a video of portfolio optimization on stocks?

@Marek_Ondrej Год назад

Hi, thanks for the video. Please is it possible for the table to only contain the ticker? The ticker would be enough for recognizing the stock.

@d.stanley447 Год назад

is it possible to pull the ex dividend date and dividend amount using the live stock data function. Your video's are very helpful, thank you for sharing.

@solomonbhandari-young4154 Год назад

Amazing video

@AnalyticsAtlas Год назад

Very good video. Remind me something

@willzinner8813 Год назад

good to have you back! keep making more please

@DanteCry23 Год назад

Kenji thanks for the video. I was wondering, I see in your gear list that you use a MacBook Pro. How do you use Excel in it? Parallels? How is the performance? Or do you use a secondary computer for these videos as you are using Excel Windows version.

@sfredheim Год назад

Great video! Could you (or someone else) explain how I can add purchase price per share, based on the transactions? I find it hard to find the avarage purchase price, when there's different purchase prices. I found one way, but the complication is in a scenario where I have bought, sold and then bought again. Then the first purchase is included in the calculation, which messes up the avarage purchase price inmy current holding. Thanks :)

@andymarci6766 Год назад

Clear information! My portfolio definetely will improve. Thanks professor Kenji

@utubewatching Год назад

Great tutorial, but I have stocks in the USA market and UK market can this system be used for multi market holdings? Thanks in advance

@mackea4651 Год назад

thank you for breaking it down!!With everything going on right now, the best decision to be on any creative man's heart is having a profitable investment strategy.

@marshallbsanz2068 Год назад

I agree with you and I believe that the secret to financial stability is having the right investment ideas to enable you earn more money, I don't know who agrees with me but either way, I recommend either real estate or crypto and stocks

@martinmomu9141 Год назад

@@marshallbsanz2068 Regardless of all, investing in crypto markets trading still remains one of the best ways of getting out of poverty and obtaining financial freedom in this global economy pandemic

@Richardson238 Год назад

The fluctuations of the market only affect those that hodl coins, but traders makes money on both sides, when it's bearish they go short when it's bullish they go long... The best strategy to use in trading crypto is to trade with a professional, like Arjun B Jagat he understand the market quite well, that way maximum profits are guaranteed.

@betheluktu7647 Год назад

I'm honestly surprised that this name is being mentioned here, I stumbled upon one of his clients testimony last two months in CNBC world news and decided to try him out...I'm Expecting my third cashout in 2days

@lea5898 Год назад

I have heard a lot about Investments with Arjun B Jagat , how good he is and how he has helped People. Please how safe are the profits?

@reddyreddy1618 Год назад

Hi, could you make a video for mutual fund portfolio tracker as well? please..

@DANNYEL20122 Год назад

Please where did you get the stock data from? Did you just type in the companies or you downloaded them?

@EDDIEGARAGE 3 месяца назад

hi this stock portfolio will work for Australia stocks (asx) Australia Stock exchange? thank you

@user-ie6rm3xh2n 7 месяцев назад

Idea for a next video. I have a RealT portfolio and I'd love to have a similar tracker spreadsheet to followup my properties and rents.

@delorims 9 дней назад

Hi Kenji, kindly lets have how to pull data for NGX from yahoo finance or any other reliable sources

@tidjmoni1547 2 месяца назад

How can you add the cost of the transactions (fees) to your portfolio? Thank you for the video!

@tearolecaill4876 Год назад

Is it possible for the crypto?

@KarenLopez-hd6jx Год назад

Can you select more than one stock in stock history?

@PLBL 9 месяцев назад

Hi Kenji. What about funds? Like S&P 500. How would we add that? Doesn't seem to work with the Stocks plugin in excel. Please help :)

@iskoba68 3 месяца назад

i could see the stocks and geography in my excel tab... even tried in options... please help

@muhammadkamranali3586 4 месяца назад

Hi, you are doing great work. Nice contributions and videos. Can you help me with one thing. I am looking to automate my stock market database and transactions. I get PDF files for each transaction from my broker. I am looking to built a file that can give me number of unsold shares and their cost under FIFO method, realized gains/losses etc. I have seen your video of dashboard but unfortunately that did not serve my purpose. Is it possible you look into my file. Thanks.

@Surfsailwaves 5 месяцев назад

What tools does Excel have to simplify monitoring dividend earnings?

@charl1eFPS Год назад

What's up man! I started learning MS Excel, and mine doesn't allow me to use the Data Type, I have the Microsoft Office Home and Student 2021 version. Is it because of the version or I am missing some settings? It's also not default, so I added it in the Data Ribbon tab, I selected the Data Type and now it's showing but it's greyed out and even tho I put some data like yours Stock, Ticker and made it a table, it still doesn't allow me to use the Data Type. Can you help me with this? Please thanks!

@lifegoeson9562 5 месяцев назад

SIR, DATA TYPES ARE NOT MENTIONED IN MY EXCEL PLEASE REPLY, WHAT TO DO ... THANKS FOR THE INFORMATION

@kanazawasyosuke2262 2 месяца назад

why I can't download the template? is it under maintainance or something or get removed? 😅

@Alex.anogiannakis 3 месяца назад

very helpfull but i feel so uselles my god.. .

@bryanmakesit7732 5 месяцев назад

What if the stock button on excel is not working when you press it.

@michaelquach7046 Год назад

Excel Stock Data!!

@invefin Год назад

sir how to add stock or geography tool

@invefin Год назад

@hatsapp4882 which number

@ajraol9032 Год назад

Is 27 too late to start in investment banking as an analyst?

@KenjiExplains Год назад

There may be exceptions but usually it's more common to start as an associate at that age after your MBA

@ajraol9032 Год назад

@@KenjiExplains Thanks a lot for your response!

@EElia-bj9tp 4 месяца назад

I see no 'Data Type' in my Excel.

@samrick4768 Год назад

< *Great video! I really do have a question. For someone with less than $10,000 to invest, how would you recommend we enter the crypto market? I am looking at studying some traders and copying their strategy rather than investing myself and losing money emotionally. What’s your take on this approach?*