Build a Stock Portfolio with LIVE Stock Data on Excel
HTML-код
- Опубликовано: 30 июл 2024
- 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.
See NordPass Business in action now with a 3-month free trial here nordpass.com/kenjiexplains with code KENJIEXPLAINS
One of my favorite things in excel, thanks for showing me some tips on how I can improve mine!
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.
Many thanks. Very clear and informative introduction
Thank you Kenji for you videos, still waiting for Power BI playlists ))
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?
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.
Thank you so much 💓
Very neat portfolio!!
Really cool functions!!
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.
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 :)
Subscribed because this is a very useful content.
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.
Great video bro! Can you make a video of portfolio optimization on stocks?
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
Amazing video
Very good video. Remind me something
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.
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
@@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
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.
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
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?
Hi, could you make a video for mutual fund portfolio tracker as well? please..
Clear information! My portfolio definetely will improve. Thanks professor Kenji
Please where did you get the stock data from? Did you just type in the companies or you downloaded them?
hi this stock portfolio will work for Australia stocks (asx) Australia Stock exchange? thank you
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 :)
Hi Kenji, kindly lets have how to pull data for NGX from yahoo finance or any other reliable sources
good to have you back! keep making more please
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.
i could see the stocks and geography in my excel tab... even tried in options... please help
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.
How can you add the cost of the transactions (fees) to your portfolio? Thank you for the video!
What tools does Excel have to simplify monitoring dividend earnings?
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!
Can you select more than one stock in stock history?
Is it possible for the crypto?
SIR, DATA TYPES ARE NOT MENTIONED IN MY EXCEL PLEASE REPLY, WHAT TO DO ... THANKS FOR THE INFORMATION
why I can't download the template? is it under maintainance or something or get removed? 😅
What if the stock button on excel is not working when you press it.
Excel Stock Data!!
very helpfull but i feel so uselles my god.. .
sir how to add stock or geography tool
@hatsapp4882 which number
Is 27 too late to start in investment banking as an analyst?
There may be exceptions but usually it's more common to start as an associate at that age after your MBA
@@KenjiExplains Thanks a lot for your response!
I see no 'Data Type' in my Excel.
< *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?*
When you invest you're buying a day you don't have to work because investing with Mrs Lelia Nicole is the greatest thing in life.
Bro, college didn't teach me this
You have a satanic pose for almost all your thumbnails.