Get Latest Stock Data in Excel & Create Your Own Stock Portfolio

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/stock-data-file Update March 2022: Stock data types now refresh automatically! Check out this announcement from Microsoft: insider.office.com/en-us/blog/refresh-stock-quotes-automatically-in-excel

[@Nagaraju-il9ed]

Lella..could you please share vedios on software Testing tools...

[@epauloconnor]

Did Excel remove this feature? Because I do not see this feature in either version of Excel that I have. Can you do an updated video now to show how to do it now?

[@andrewsema359]

could you do a video like this for google sheets. Much appreciated for all the videos you do.

[@deepashankar08]

This should be part of a series called 'Excel : Hidden gems in plain sight' . Thanks , as always brilliant!

[@safensecure67]

I keep getting smarter, every time I watch your videos. I was talking to a customer about computers at work. I mentioned I follow your channel. He replied, "So do I".

[@jackfrost1031]

I just figured this out on my own. I wish I had watched your video first! I love the way you present how-to videos.

[@thedavidseatonshow]

This is absolutely fantastic. I've been teaching my wife Excel and this is the perfect tutorial for managing our stock portfolio and teaching Excel simultaneously. Looking forward to continuing my Excel journey with you in 2021. Happy new year.

[@darkshinigami9438]

Amazing video to finish the year. More videos on Excel finance please

[@LeilaGharani]

Glad you like it. More to come :)

[@tt1t88]

Bravo! Thank you for sharing this video. It’s so helpful!

[@g.robredo6387]

Leila, I am subscribed to everything you do, and I can't be happier to have paid for your courses. So much value!!! Thanks

[@TylerStanczak]

This is such a helpful tutorial. Especially being an investor myself. Really great vid Leila! :)

[@mithunmahato309]

Investor or trader 🙄

[@TylerStanczak]

@@mithunmahato309 just casual investor in the stock market. Not making quick trades :)

[@ablyndon]

Leila, you had me at Electronic Signatures, but this has rocked my world! It’s awesome, thank you! You should seriously consider doing this kind of thing for a living.....

[@LeilaGharani]

That's great! I'm glad the content is useful.

[@randm108]

Really good job n thumb up dear

[@rajsahu1029]

Realy its a very good work. I have take a complete day to understand this. Its solve alot of problems in data base for correction. very very thanks.

[@diegocastanedafiestas1574]

Been watching you since 2018 and you always got me learning something new, thank you so much!! Cheers from Perú.

[@gurmeetsingh-cq6br]

criteria for using this facility is ,we have to upgrade to office 365. no other method. Thanks for teaching us marvelously.

[@leksdic]

Can't wait for the rich data types to hit casual users. They seem super useful. Hopefully in 2021!

[@chrism9037]

This is great, thank you Leila. Have a Happy New Year!

[@LeilaGharani]

Thank you! Happy New Year to you too, Chris!

[@samuelchettiar1968]

Thank you - your videos are very helpful. This is such a helpful tutorial.

[@tslegers]

Excellent video. This will be great for consolidating accounts.

[@kmshlongwane4263]

Lady from now you going to be my lecture. They never taught me this in school.

[@dreddnaught1968]

Was trying to build something like this with API's and Power Query. This is so much simpler. Thank you for all the great tutorials.

[@terrydouglasjayasuriya5162]

Thank you Leila, great and clear video.

[@frannyl8865]

wow you are amazing. I've been struggling with Office 365 for several days now trying to figure this out. Your explanations are very clear and easy to follow.

[@cliftonsett5214]

Yet another reason why I love Excel. Great content as usual, always a pleasure to watch and learn from you.

[@dhananjaykansal8097]

Out of this world

[@suchioswal15]

This is real good tool in excel Makes it easy to maintain the stock portfolio as per our liking.... After this video i even tried the geography data type....and that's fun too

[@LeilaGharani]

Great 👍

[@markie1957]

Superlative video with excellent clarity 👍

[@jeevakumarmasilamani6539]

Thank you Excel GOD.!!!

[@rcurielh]

Thank you again, very helpful !

[@duncancarr7822]

I had no idea about this & it works a treat! Thank you very much Leila.

[@LeilaGharani]

You're so welcome!

[@pedrocotta8320]

Excellent video, as usual. Congratulations.

[@276sachin]

Super Helpful! Thank you for the learning

[@HowToAnalyst]

Learned a lot, thank you!

[@rajanghadi2337]

This utility along with Stockhistory function helps analysis much

[@monishtabla]

Great tutorial, very helpful, thanks

[@Dennis-kt6ey]

Amazing. Absolutely amazing. Thank you.

[@LeilaGharani]

Our pleasure!

[@gurmeetsingh-cq6br]

thanks madam. great learning.

[@andrewmoss6449]

It’s great how Microsoft is adding all these new data types to Excel. Certainly saves some leg work. Happy New Year, Leila, and keep up the great work in 2021 - as you push closer and closer to one million subscribers.

[@patrickwilliams6009]

You are fantastic. Exactly what i need. Also watched your income, cashflow and balance sheet financial videos.

[@mikeg1226]

Leila. I put a macro together in google sheets that pulls stock data real time. I can hit refresh and it gets latest. This video is soooo amazing! I also must be upfront. I had a very hard time lately bc my mom passed from this covid last month. It snuck up silently and fast while she was dealing with another issue. At 86 years old her mind was 100% and full of energy so seeing this happen fast put me in shock non stop. I am going back to coding Monday and good to have a coding distraction now. Take care.

[@LeilaGharani]

I'm so sorry for your loss, Mike.

[@mikeg1226]

@@LeilaGharani thanks

[@zavoshmostoufi991]

Thank you. Excellent

[@Alex-tg5lg]

Thanks Leila, Im studying since early morning on January 1, 2021. Great videos

[@petesmit33]

Excellent thank you very much for this

[@Dmitriy60]

Thank you very much Leila !

[@LeilaGharani]

You're welcome 😊

[@johnto269]

Wonderful course! Thank you very much!

[@awaiskhan9296]

Another excellent video, God bless you. You are brilliant

[@LeilaGharani]

Thank you! Cheers!

[@faisalym]

Just the video I needed to create my own portfolio. Thank you Leila!

[@LeilaGharani]

You're so welcome!

[@naibahmadzada2041]

This is great "gift" for a new year.Thank you Leyla. Happy new year 🌺

[@MrAtlantis95]

Thanks! This is mind blowing!

[@rustey222]

Thanks so much

[@ganesh199208]

This is very helpful.

[@venkatiyer7459]

Thanks again .... I am using google sheets for Stocks/Portfolio ..

[@bt-os5oq]

She is brilliant

[@temyraverdana6421]

Amazing tutorial, Thanks and see you next year

[@leonardo8883]

this is a super tutorial..but what if I need to import commodities data or forex..? How can I import this type of data?

[@bobargenis]

The Best; outstanding...

[@mjay2526]

Thank you. This will greatly help me learning on investing in stock.

[@LeilaGharani]

Very welcome!

[@0815lloyd]

Sehr gutes Video, vielen Dank dafür!

[@LeilaGharani]

👍

[@NaftuliSinger]

Thank you. As always, learnt something new!

[@Whiteruud]

Excellent tutorial - one formula column I would like insert is the how much the present price of a stock is from its 52 week high - can do a video to demonstrate how to do this, Leila - thank you David

[@ΧρήστοςΓρ-δ5ζ]

thank you very much!!!You are awsome

[@rishabhkesharwani7761]

Happy new year Ma'am Thanks for new year 1st day knowledgeable video👍

[@LeilaGharani]

Happy new year to you too!

[@shyamn7998]

Good information shared

[@sandipansarkar9211]

finished watching

[@raj21at]

Thanks for fulfilling my pro longed request

[@Galileo2pi]

Awesome; When I grow up, I want to be like you, lol. Pretty useful. Thanks so much

[@LeilaGharani]

Glad you like it!

[@denconstutube]

Another great video. I have been learning so much from your videos and this video continues the trend. Thank you so much for all you do.

[@LeilaGharani]

Great to hear!

[@dimplepatel8714]

Hey Leila...u have explained very nice...but it's a request from me...that when u speak... please speak slowly...I m from India ....thankuu.....with lots of love😊

[@carlglyde5764]

Hi Leila, this is awesome thank you. Would you be able to advise on how to add information about new shares of a type I already have? For instance, if I bought apple last week at $200 and then again today at $150, how would I add that elegantly without multiple rows for one stock? I dollar cost average so its not very straightforward. I'm also new to excel. Thank you in advance!

[@sachinrv1]

Fantastic tutorial. One thing sure, Office 365 has more to it than meets the eye. The only worry is, if Excel keeps evolving at this rate, jobs of finance person like me will become redundant. LOL :) Thanks Leila :)

[@LeilaGharani]

Haha, it will take a lot more to make us nerds redundant 😊

[@yoliedepaz3340]

Thanks a lot, Leila. Happy holidays!

[@LeilaGharani]

Same to you!

[@yoliedepaz3340]

I hope someday you’ll be able to create stock indicators in excel. That would be a great challenge. Great video, as always. More power, Leila. 👏👏👏💪🏼

[@robertovelicaz7719]

Great video as always! Many thanks for all your postings this past year! Best wishes for 2021 Leila!!!

[@LeilaGharani]

Thank you! You too, Roberto!

[@tedsterrett7204]

Great Video Leila, you just caused my portfolio to go up in value! Happy New Year, Thanks!

[@LeilaGharani]

Happy new year, Ted!

[@ronconnelly]

Fantastic video Leila! Just as all of them are. Thanks so much. Happy New Year!

[@user-rida2002i]

Leila love your tutorial and you😍

[@ShubhamMathur14]

Learned new information.. I would love to see a Playlist on using on stock market.

[@JV_FORCE]

Outstanding 😇

[@shakthiatukorala595]

Nice tutorial again. Really useful feature in Excel. Thanks for explaination. Happy new year.....!

[@LeilaGharani]

Glad you like it. Happy new year!

[@rajendrannamdev3844]

Very useful. Thank you. Can you please make another video - how to auto-refresh this table using VBA.

[@CP-rm7rz]

Love your channel. Timing on this subject/functionality is perfect . Constructive Channel feedback: Excellent teacher and knowledge, smart, Mesmerizing voice & accent , elegant, classy Happy New Year

[@LeilaGharani]

Thank you very much, Chris! Happy New Year!

[@chiwilanjabulosikwila3487]

Great video Leila! Good feature that you can use creatively to do so much more.

[@LeilaGharani]

Absolutely! Glad you like it.

[@islandcactus1508]

Fantastic as always, any way to get futures (pre / post) prices integrated into the price? I only get prices during regular trading hours.

[@aravindgowda9375]

Thank you Madam, wish you happy new calendar year 2021. Let's all learn good things, gain better knowledge & gift this precious earth to future generation in good mode as given to us by our previous generation.....

[@Zues64]

Leila, for those of us who use the home version of Excel without the stock datatype, can you point me to a video on how I can import stock data from a website like Yahoo Finance , Google Finance, etc.. I need to import the stock's Sector and Industry. Thank you!

[@jkederyte]

Amazing! I was doing the same manually in excel, now my life will be so much easier, thank you!

[@marcelleza]

Thank you, Leila! Happy New Year!!!!

[@westernugmedia.1305]

Thanks our dear Leila, we appreciate your work, may God bless🙏 en happy new year #here in Africa

[@LeilaGharani]

Thank you, Bruno! Happy New Year!

[@juanmejia8887]

Really good. Thx

[@dinuachar]

U r great am great follower u

[@mattschoular8844]

Thanks Lelia....Perfect timing with this video. My New Year's resolution is to track my investments more closely. Happy New Year....

[@LeilaGharani]

Happy new year, Matt!! Hope your investments will do well in 2021 😊

[@riupadhyay]

Excellent content Leila. This is super helpful !

[@zenohdcunha2203]

Thank you for a wonderful and practical tutorial Leila!!! Could I request you to make on on how to import stock data on Excel 2010... It would be of great help.... Thanks a ton in advance....

[@udusegbe]

Nice. Good way to end the year 😀

[@LeilaGharani]

Glad you like it 😊

[@aktharhussain946]

Brilliant, thank you!

[@RahulJauhari]

Happy New year to you

[@Ghostalitta]

Great video, can you please show how we can retrieve the historical data? Like the past 1, 3, or 5 years for daily or monthly? As if we need to calculate the return, expected returns, STD, covariance or correlation we need the historical data over a period of time.

[@mmorenob2012]

Woooow, excellent video

[@LeilaGharani]

Thank you!

[@rajsahu1029]

Thanks!

[@rammer7788]

Thank You and Happy 2021! This is so helpful!

[@remars-xcel]

Thank you Queen I need this

[@LeilaGharani]

😊

[@jeevankg]

it is very nice and informative. I would like to add some financial ratio such as earnings of last year and EPS values. How can we automize