Grab the file I used in the video from here 👉 pages.xelplus.com/stockhistory-file Stockhistory is now available to all Office 365 subscribers!
@6toolbaseball
3 жыл бұрын
Maybe we’ll get this in other versions in 2030 😂
@davidjames3494
3 жыл бұрын
But choosing a different ENDDATE instead of TODAY does not work, why? Also I think the common date periods should be solved by XL. It is a bug.
@desdelafabrica
3 жыл бұрын
Good Morning! I am a 365 office subscriber and this formula is not available. As i have my office in Spanish, i tried the "Spanish formula HISTORIALCOTIZACIONES" i did not work either I wanted to practice this amazing video that you published. If you can help me, i would appreciate. Thank you..
@evanscott1204
2 жыл бұрын
i prefer using the stock icon in microsoft excel in the ribbon its easier for me the other way is more complicated which would you prefer using long way or the easiest way
@evanscott1204
2 жыл бұрын
I wanted to know for a job
@OldDogNewTrick2 жыл бұрын
Just found this recently, and I am excited about trying out some of these features myself. Never too old (81 years old now) to learn another new trick. Thank you so much.
Leila is always adding to our knowledge "STOCK" and creating "HISTORY" with her unique teaching style and long list of videos on practically everything needed in office work! Glad to watch this neat video, thank you! 😊👍👏
Excellent! I have been using the Stock function from the time you posted your video on the function, and it has been perfect. Obviously, this function is so much better. I will start it today. Thank you again for all of your great videos.
I was desperately looking for this function in excel. Thank you very much. Very informative
@LeilaGharani
3 жыл бұрын
Glad it was helpful!
@antoniosalazar8222
3 жыл бұрын
kzread.info/dash/bejne/kXxhk4-Gosy_dJs.html
@RichErmlick3 жыл бұрын
Leila, you are an amazing teacher with deep knowledge, awesome content, and a wonderful style of presenting things quickly and cleanly. Well done and Big Kudos on the success of your brand!
Excellent, Leila! As always, you’re a big help for me. Thanks a lot and more power to you. Stay safe, God bless you! I did not skip the ads, grateful meh here! 🤗
@LeilaGharani
3 жыл бұрын
Thank you 😊
@captvo3 жыл бұрын
Excellent video! Clear and crisp tutorials as always!
I love this function! Great video, thanks for sharing.
@robertbyers3 жыл бұрын
Fabulous, I'm looking forward to STOCKHISTORY appearing in the main Excel release channel. Thank you for the walkthrough!
@LeilaGharani
3 жыл бұрын
You're very welcome, Robert!
@genechicago48063 жыл бұрын
Neat! I like how you made the formula more dynamic. Your mastery of Excel is impressive and does qualify you as a geek---just like it shows on the cup. :) Thank you for sharing your knowledge!
@LeilaGharani
3 жыл бұрын
Wow, thanks!
@mehranhourmozdi42332 жыл бұрын
Found this and am excited to use the features. Thank you for your education.
@majeedpanahi57833 жыл бұрын
Excellent function and a very good explanation as always by Leila. Well done and keep it up.
Excellent video tutorial, Leila! Keep it up! Thanks!
@LeilaGharani
3 жыл бұрын
Thank you! Will do!
@dl80983 жыл бұрын
Leila is the crush of all Geeks! Love you and your work! 😍
@jakovvodanovic91652 жыл бұрын
Just what I was looking for, thanks a lot.👌
@ShubhamMathur143 жыл бұрын
Thank you this video. Would love to see more videos on stocks functions....
@ShubhamMathur14
3 жыл бұрын
@Leila Gharani, Ma'am - Please make a series on Stock Market.. Your way of teaching (Specially Excel) is excellent and lots and lots of people has learned lot from your courses /KZread videos. Kindly give a thought on this. Best Regards Shubham
@alhassanmusah72423 жыл бұрын
Extremely Marvelous Tutorial.. I have been following up every time.. You are Magnificent Leila
@LeilaGharani
3 жыл бұрын
Happy to hear that!
@williama.rivera94142 жыл бұрын
Very instructive and informative video. Thank you so much for share it.
@sepandjazzi4 ай бұрын
Thank you so much - great video as are the others!
@ManojKumar-sk3fw3 жыл бұрын
Thank you for mentioning INDIA is included in the covered exchanges
@LeilaGharani
3 жыл бұрын
😀 It was a question in the comments of the previous stock data type video so I thought I address it here. Thank you for the first like and comment 🙏
@ManojKumar-sk3fw
3 жыл бұрын
@@LeilaGharani I raised that question on instagram and Your KZread channel..
@mariamnassar2402 Жыл бұрын
You are amazing teacher with mastery very impressive!
thank you for such wonderful trainings!! very clear and easy to follow. I'm able to replicate effectively.
@LeilaGharani
3 жыл бұрын
Wonderful!
@BIMoji14 ай бұрын
Amazing work. Thank you
@IbadassI Жыл бұрын
Awesome, thanks for this!
@OfficeFreak3 жыл бұрын
Loved your new setup 🤘
@karl20163 жыл бұрын
Great video...always learning from your work.
@LeilaGharani
3 жыл бұрын
I appreciate that!
@savageplanets Жыл бұрын
Thank you so much for this… it was extremely helpful. Good job!
@LeilaGharani
Жыл бұрын
You're very welcome, Steve!
@jonwg59942 жыл бұрын
Awesome video, thanks
@keerthanavk81003 жыл бұрын
Ma'am can u make more videos on accounts? Your previous accounts videos were very clear and much easier to understand. Thank u for making such a great videos❤😊✨
@alhassanmusah72423 жыл бұрын
Looking forward to see more Formative stock functions which can generate reports
@CaribouDataScience2 жыл бұрын
Thanks, You made that look easy.
@franciscojrlarita4412 жыл бұрын
Thank you, I like it.
@shakthiatukorala5953 жыл бұрын
Nice tutorial, nicely explained.
@LeilaGharani
3 жыл бұрын
Thank you!
@waleedfaris3 жыл бұрын
thank you very much for all these wonderful and valuable information you are providing And just now I was telling my mom I wanna learn and know whatever she knows from the excel sheet 😓 Because I'm an accountant.
@TheAdidaskicks233 жыл бұрын
timely video! 🚀🚀🚀
@TheWinningSperm8883 жыл бұрын
This will change my life! Thankyou 🙏
@LeilaGharani
3 жыл бұрын
Our pleasure :)
@antoniosalazar8222
3 жыл бұрын
kzread.info/dash/bejne/kXxhk4-Gosy_dJs.html
@umeshchandgond6985 Жыл бұрын
Thanks This video helped me a lot
@pedrocotta83202 жыл бұрын
Excelent lesson.
@MadVillain05243 жыл бұрын
really beautiful video. Amazing
@LeilaGharani
3 жыл бұрын
Thank you!
@tumpalmanurungtmchannel67642 жыл бұрын
Great video...thanks for sharing...Leila...👍
@LeilaGharani
2 жыл бұрын
You are so welcome!
@stephenfarrell67944 ай бұрын
Finally got around to setting this up, thank you. Is there a way to reverse the date sequence from newest to oldest?
@mdexcelpro84953 жыл бұрын
Really really very very amazing function great 👍👍
@LeilaGharani
3 жыл бұрын
It really is!
@sahrasassy5982 Жыл бұрын
I need this to be this way for my double bottom strategy code.
@TheUnofficialMaker2 жыл бұрын
You Rock Girl!
@ageloskolaitis78213 жыл бұрын
Excellent video & excellent formula! It would be nicer for the formula to show also the number of outstanding shares though.
@drsteele47493 жыл бұрын
Super video, Leila. You've got to be careful with applying that technique to a portfolio of stocks. Sometimes there are missing dates from trading halt orders or you've got stocks across different exchanges with different days off, especially for holidays between countries.
@LeilaGharani
3 жыл бұрын
Fully agree - that's why we need to do the check first to make sure they all have the same dates otherwise we might be showing the wrong value for the date.
@digigoliath3 жыл бұрын
Nice. TQVM.
@avijeetmohanty3 жыл бұрын
Thanks for this informative video. Sadly not in Excel 2016
@hugomeza29103 жыл бұрын
I been watching your videos lately. Thanks for all the information. It’s really helpful. I want to create an interactive dashboard for my stock portfolio. Do you have a video on that?
@chrism90373 жыл бұрын
Very cool Leila!!
@LeilaGharani
3 жыл бұрын
😊
@rohitbhansali41883 жыл бұрын
Looking Forward for more Excel Hacks
@oryanol3 жыл бұрын
Right on time. Thanks
@LeilaGharani
3 жыл бұрын
Perfect!
@adriansagala8753 жыл бұрын
Woow thank you for sharing.
@LeilaGharani
3 жыл бұрын
My pleasure
@mtranjan013 жыл бұрын
Loved it❤❤❤
@LeilaGharani
3 жыл бұрын
👍
@pawanchoubay85784 ай бұрын
thx a lot
@mariostudio73 жыл бұрын
Excel is getting more and more stocks friendly
@MohamedIbrahim-sv9mk3 жыл бұрын
You look good in this new look ❤️
@LeilaGharani
3 жыл бұрын
Thanks 😅
@wayneedmondson10653 жыл бұрын
Thanks Leila. Great intro to get started with the new STOCKHISTORY function! Too bad Sparklines Data Range will not accept #SPILLED range as input. Maybe some day. Thanks for sharing :)) Thumbs up!!
@The_1two34 ай бұрын
Thanks Leila, indeed a useful video. Can you please help to derive the daily moving average in one cell of the last 30 days closing as that will help to compare with the current price. this function is there in Google Sheet but unable to found in MS Excel.
@dirkdevis62162 жыл бұрын
Great tutorial. Thanks a lot. A question though. If you have stocks from different exchanges (for example XNYS and XBRU), the exchange have different days that the stock markets are closed/open and the timeline is not the same. Would there be a way to force the values to use a unique timeline ?
@upendrasharma42573 жыл бұрын
Not sure how do you know most Indians are appreciating your work. Just noticed you highlighted India is covered like emerging market, emerging investors in India. :)
@osamasaid84763 жыл бұрын
Excellent
@atlrecon95713 жыл бұрын
Great presentations. I stuck need help with finding dollar value
@awaiskhokhar4883 жыл бұрын
Mam you are looking gorgeous in your office. Stay blessed.
@godfreykiggundu77874 ай бұрын
Thanks a lot Leila for this video. It has really helped me in my trading plan/strategy. But another challenge that I have faced is when it comes to fetching data based on the one-hour time frame. The Stockhistory function gives data only on the daily, Weekly and Monthly. But I need data for hourly time frame. How can I go about that?
@user-cw2iy2tl2j5 ай бұрын
Can you please explain how we can get the closing price o stocks for consecutive days (say 10 days) instead of months? Thank you!
@roallanwood11375 ай бұрын
Love your videos. Q.why are some stock prices not shown, e.g.Lloyds Bank, BT etc on the London stock exchange.?
@Corey_Bee2 жыл бұрын
For daily info, I just passed the array of dates outputted in the date row as the "start date" for all the other rows (it handles dynamic array). Performance might not be as good but it worked just fine for ~10 companies with 5 years of data. Also, you want to pick a ticker for the date row that has been traded consistently for your time period.
@LeilaGharani
2 жыл бұрын
Thanks for sharing your tips!
@StockBuzz20212 жыл бұрын
Leila ,Do u know U r so amzaing ... and keep rocking..enjoy !
@hazemgheith9991 Жыл бұрын
Thank You! Is there similar approach to download daily stock options prices?
@indiabharat56813 жыл бұрын
Good Idea
@TheyForcedMyHandLE Жыл бұрын
Works, when not #BUSY!, which is always...
@jorgegonzalez52522 жыл бұрын
Hi Leila, thanks for all the videos that you post. very clear and helpful. I have a problem I am trying to create a table with only the daily %change. and i cannot figure it out. could you help me please
@elnabz47313 жыл бұрын
Please can you make a video on how to to draw AOA and AON diagrams for CPM calculation?
@robh.12123 ай бұрын
I would like to show the year to date performance of spy as a percentage. Is there a way to use stockhistory to do that? Do you know of some other way to get excel to show me the year to date performance of spy as a percentage? Thanks so much in advance. We really love your videos. They are so helpful and they age well.
@Fushshwwixhxushs3 жыл бұрын
Great to see this data available with an Office license. Is there anything like that provided by Microsoft for PowerBI?
@darcyg8523 жыл бұрын
This is awesome - can it be used for commodity stock pricing?
@michaelren1043 жыл бұрын
Thank you so much for explaining it really well. I had looked up other tutorials for this function, but failed to fully understand it. Two questions if you haven't answered them already: 1) How to align daily data for several stocks (eg I have some stocks that don't go back a year and their results are misaligned to the others). 2) the present setup shows the oldest data first, how can we set it to show today's price in the leftmost cell and then go backwards? Thanks much
@jamesroberts5645
2 жыл бұрын
I second this question? Would save a lot of time adjusting ranges etc. Thanks for the great video, very informative! :)
@michaelren104
2 жыл бұрын
@@jamesroberts5645 I now use the following to calculate stockhistory: Fill up the top cell with date and use this for returning stockvalue at only that date: =STOCKHISTORY($A$5,E1,E1,0,0,1) Where E1 is the date for which I want the stock value. Hope that helps
@jamesroberts5645
2 жыл бұрын
@@michaelren104 Thanks Michael, that worked a treat. In case you're still after an easy way to have historical data in descending order, after hitting my head against numerous walls and necking a few large bottles of fine scotch whiskey i finally found the solution. This is the formula: =TRANSPOSE(SORT(STOCKHISTORY(A5,C2,TODAY(),0,B42,B43,B44),1,-1)) Its the 'SORT' and 1,-1 at the end that does the magic. You may already have discovered this but i only just have. Lol!
@rayschrijvers9249 Жыл бұрын
Nice video... thank you. Is there a function to reverse the order of the date from the newest to the oldest? Thx
@muntean90103 жыл бұрын
this is like the reviews for the latest GPUs/CPUs, most of the people don't have access to these nice features of the coming months...
@LeilaGharani
3 жыл бұрын
Always good to know what's coming though 😊
@dhruvinmangukia89173 жыл бұрын
this function is amazing and you explained it very well. can we get adjusted close price of stocks as there is no option for that to select. Mostly calculation on stocks are done on adjusted close price basis which is downloadable from yahoo finance website. But If I am working on any research of around 50-100 companies . Can we get adjusted close price in excel with this formula?
Пікірлер: 301
Grab the file I used in the video from here 👉 pages.xelplus.com/stockhistory-file Stockhistory is now available to all Office 365 subscribers!
@6toolbaseball
3 жыл бұрын
Maybe we’ll get this in other versions in 2030 😂
@davidjames3494
3 жыл бұрын
But choosing a different ENDDATE instead of TODAY does not work, why? Also I think the common date periods should be solved by XL. It is a bug.
@desdelafabrica
3 жыл бұрын
Good Morning! I am a 365 office subscriber and this formula is not available. As i have my office in Spanish, i tried the "Spanish formula HISTORIALCOTIZACIONES" i did not work either I wanted to practice this amazing video that you published. If you can help me, i would appreciate. Thank you..
@evanscott1204
2 жыл бұрын
i prefer using the stock icon in microsoft excel in the ribbon its easier for me the other way is more complicated which would you prefer using long way or the easiest way
@evanscott1204
2 жыл бұрын
I wanted to know for a job
Just found this recently, and I am excited about trying out some of these features myself. Never too old (81 years old now) to learn another new trick. Thank you so much.
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
Leila is always adding to our knowledge "STOCK" and creating "HISTORY" with her unique teaching style and long list of videos on practically everything needed in office work! Glad to watch this neat video, thank you! 😊👍👏
@LeilaGharani
3 жыл бұрын
Thank you, Vijay 😊
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
as a 30+ year excel user, I am humbled with your knowledge and new ideas. Thank you very much!
@LeilaGharani
3 жыл бұрын
Thanks for watching, Don!
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
Excellent! I have been using the Stock function from the time you posted your video on the function, and it has been perfect. Obviously, this function is so much better. I will start it today. Thank you again for all of your great videos.
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
Hi Leila, Thank you for sharing your knowledge! You do an excellent job at explaining Excel and make it easy.
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
I was desperately looking for this function in excel. Thank you very much. Very informative
@LeilaGharani
3 жыл бұрын
Glad it was helpful!
@antoniosalazar8222
3 жыл бұрын
kzread.info/dash/bejne/kXxhk4-Gosy_dJs.html
Leila, you are an amazing teacher with deep knowledge, awesome content, and a wonderful style of presenting things quickly and cleanly. Well done and Big Kudos on the success of your brand!
@LeilaGharani
3 жыл бұрын
Thank you!
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
Excellent, Leila! As always, you’re a big help for me. Thanks a lot and more power to you. Stay safe, God bless you! I did not skip the ads, grateful meh here! 🤗
@LeilaGharani
3 жыл бұрын
Thank you 😊
Excellent video! Clear and crisp tutorials as always!
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
I love this function! Great video, thanks for sharing.
Fabulous, I'm looking forward to STOCKHISTORY appearing in the main Excel release channel. Thank you for the walkthrough!
@LeilaGharani
3 жыл бұрын
You're very welcome, Robert!
Neat! I like how you made the formula more dynamic. Your mastery of Excel is impressive and does qualify you as a geek---just like it shows on the cup. :) Thank you for sharing your knowledge!
@LeilaGharani
3 жыл бұрын
Wow, thanks!
Found this and am excited to use the features. Thank you for your education.
Excellent function and a very good explanation as always by Leila. Well done and keep it up.
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
Fantastic! Never in a million years could I have figured this out without your video
@LeilaGharani
Жыл бұрын
Glad I could help!
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
I learn a lot of excel with you and also an excellent English pronunciation, 2x1. Muchas Gracias
This video is super useful. I think you will have to put up a question and answer session for your viewers.
This is a brilliant add-on to Excel! Thanks!
Leila, as always, brilliant. I knew this function, but I don't remember whether I saw it in your previous videos or in your courses. Thank you.
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
Thank you Leila, this was VERY helpful.
This has made me grown one more bit today, many thanks Leila
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
I've followed your channel for about a year now. I've learned so much. Thanks.
@LeilaGharani
3 жыл бұрын
Great to hear, Pierre!
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
Excellent video tutorial, Leila! Keep it up! Thanks!
@LeilaGharani
3 жыл бұрын
Thank you! Will do!
Leila is the crush of all Geeks! Love you and your work! 😍
Just what I was looking for, thanks a lot.👌
Thank you this video. Would love to see more videos on stocks functions....
@ShubhamMathur14
3 жыл бұрын
@Leila Gharani, Ma'am - Please make a series on Stock Market.. Your way of teaching (Specially Excel) is excellent and lots and lots of people has learned lot from your courses /KZread videos. Kindly give a thought on this. Best Regards Shubham
Extremely Marvelous Tutorial.. I have been following up every time.. You are Magnificent Leila
@LeilaGharani
3 жыл бұрын
Happy to hear that!
Very instructive and informative video. Thank you so much for share it.
Thank you so much - great video as are the others!
Thank you for mentioning INDIA is included in the covered exchanges
@LeilaGharani
3 жыл бұрын
😀 It was a question in the comments of the previous stock data type video so I thought I address it here. Thank you for the first like and comment 🙏
@ManojKumar-sk3fw
3 жыл бұрын
@@LeilaGharani I raised that question on instagram and Your KZread channel..
You are amazing teacher with mastery very impressive!
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
Awesome content..explained in most easiest way..Thankyou..
Very Great introduction. Will get it and try soonest. Amazing
This is a great Video Presentation. Very useful tips and tricks.Thank you Leila.
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
Thank you for this video, keep growing.
Terrific explanation. thank you
Tank you Leila for your help and may God bless you
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
Very interesting and useful information. Thanks a lot
Thank you, Leila. You are awesome!
@ramkishoryadav9087
2 ай бұрын
kzread.info/dash/bejne/ZGSf08-tqtLRaKw.htmlsi=nnOpAEpBY8gqJl-d
thank you for such wonderful trainings!! very clear and easy to follow. I'm able to replicate effectively.
@LeilaGharani
3 жыл бұрын
Wonderful!
Amazing work. Thank you
Awesome, thanks for this!
Loved your new setup 🤘
Great video...always learning from your work.
@LeilaGharani
3 жыл бұрын
I appreciate that!
Thank you so much for this… it was extremely helpful. Good job!
@LeilaGharani
Жыл бұрын
You're very welcome, Steve!
Awesome video, thanks
Ma'am can u make more videos on accounts? Your previous accounts videos were very clear and much easier to understand. Thank u for making such a great videos❤😊✨
Looking forward to see more Formative stock functions which can generate reports
Thanks, You made that look easy.
Thank you, I like it.
Nice tutorial, nicely explained.
@LeilaGharani
3 жыл бұрын
Thank you!
thank you very much for all these wonderful and valuable information you are providing And just now I was telling my mom I wanna learn and know whatever she knows from the excel sheet 😓 Because I'm an accountant.
timely video! 🚀🚀🚀
This will change my life! Thankyou 🙏
@LeilaGharani
3 жыл бұрын
Our pleasure :)
@antoniosalazar8222
3 жыл бұрын
kzread.info/dash/bejne/kXxhk4-Gosy_dJs.html
Thanks This video helped me a lot
Excelent lesson.
really beautiful video. Amazing
@LeilaGharani
3 жыл бұрын
Thank you!
Great video...thanks for sharing...Leila...👍
@LeilaGharani
2 жыл бұрын
You are so welcome!
Finally got around to setting this up, thank you. Is there a way to reverse the date sequence from newest to oldest?
Really really very very amazing function great 👍👍
@LeilaGharani
3 жыл бұрын
It really is!
I need this to be this way for my double bottom strategy code.
You Rock Girl!
Excellent video & excellent formula! It would be nicer for the formula to show also the number of outstanding shares though.
Super video, Leila. You've got to be careful with applying that technique to a portfolio of stocks. Sometimes there are missing dates from trading halt orders or you've got stocks across different exchanges with different days off, especially for holidays between countries.
@LeilaGharani
3 жыл бұрын
Fully agree - that's why we need to do the check first to make sure they all have the same dates otherwise we might be showing the wrong value for the date.
Nice. TQVM.
Thanks for this informative video. Sadly not in Excel 2016
I been watching your videos lately. Thanks for all the information. It’s really helpful. I want to create an interactive dashboard for my stock portfolio. Do you have a video on that?
Very cool Leila!!
@LeilaGharani
3 жыл бұрын
😊
Looking Forward for more Excel Hacks
Right on time. Thanks
@LeilaGharani
3 жыл бұрын
Perfect!
Woow thank you for sharing.
@LeilaGharani
3 жыл бұрын
My pleasure
Loved it❤❤❤
@LeilaGharani
3 жыл бұрын
👍
thx a lot
Excel is getting more and more stocks friendly
You look good in this new look ❤️
@LeilaGharani
3 жыл бұрын
Thanks 😅
Thanks Leila. Great intro to get started with the new STOCKHISTORY function! Too bad Sparklines Data Range will not accept #SPILLED range as input. Maybe some day. Thanks for sharing :)) Thumbs up!!
Thanks Leila, indeed a useful video. Can you please help to derive the daily moving average in one cell of the last 30 days closing as that will help to compare with the current price. this function is there in Google Sheet but unable to found in MS Excel.
Great tutorial. Thanks a lot. A question though. If you have stocks from different exchanges (for example XNYS and XBRU), the exchange have different days that the stock markets are closed/open and the timeline is not the same. Would there be a way to force the values to use a unique timeline ?
Not sure how do you know most Indians are appreciating your work. Just noticed you highlighted India is covered like emerging market, emerging investors in India. :)
Excellent
Great presentations. I stuck need help with finding dollar value
Mam you are looking gorgeous in your office. Stay blessed.
Thanks a lot Leila for this video. It has really helped me in my trading plan/strategy. But another challenge that I have faced is when it comes to fetching data based on the one-hour time frame. The Stockhistory function gives data only on the daily, Weekly and Monthly. But I need data for hourly time frame. How can I go about that?
Can you please explain how we can get the closing price o stocks for consecutive days (say 10 days) instead of months? Thank you!
Love your videos. Q.why are some stock prices not shown, e.g.Lloyds Bank, BT etc on the London stock exchange.?
For daily info, I just passed the array of dates outputted in the date row as the "start date" for all the other rows (it handles dynamic array). Performance might not be as good but it worked just fine for ~10 companies with 5 years of data. Also, you want to pick a ticker for the date row that has been traded consistently for your time period.
@LeilaGharani
2 жыл бұрын
Thanks for sharing your tips!
Leila ,Do u know U r so amzaing ... and keep rocking..enjoy !
Thank You! Is there similar approach to download daily stock options prices?
Good Idea
Works, when not #BUSY!, which is always...
Hi Leila, thanks for all the videos that you post. very clear and helpful. I have a problem I am trying to create a table with only the daily %change. and i cannot figure it out. could you help me please
Please can you make a video on how to to draw AOA and AON diagrams for CPM calculation?
I would like to show the year to date performance of spy as a percentage. Is there a way to use stockhistory to do that? Do you know of some other way to get excel to show me the year to date performance of spy as a percentage? Thanks so much in advance. We really love your videos. They are so helpful and they age well.
Great to see this data available with an Office license. Is there anything like that provided by Microsoft for PowerBI?
This is awesome - can it be used for commodity stock pricing?
Thank you so much for explaining it really well. I had looked up other tutorials for this function, but failed to fully understand it. Two questions if you haven't answered them already: 1) How to align daily data for several stocks (eg I have some stocks that don't go back a year and their results are misaligned to the others). 2) the present setup shows the oldest data first, how can we set it to show today's price in the leftmost cell and then go backwards? Thanks much
@jamesroberts5645
2 жыл бұрын
I second this question? Would save a lot of time adjusting ranges etc. Thanks for the great video, very informative! :)
@michaelren104
2 жыл бұрын
@@jamesroberts5645 I now use the following to calculate stockhistory: Fill up the top cell with date and use this for returning stockvalue at only that date: =STOCKHISTORY($A$5,E1,E1,0,0,1) Where E1 is the date for which I want the stock value. Hope that helps
@jamesroberts5645
2 жыл бұрын
@@michaelren104 Thanks Michael, that worked a treat. In case you're still after an easy way to have historical data in descending order, after hitting my head against numerous walls and necking a few large bottles of fine scotch whiskey i finally found the solution. This is the formula: =TRANSPOSE(SORT(STOCKHISTORY(A5,C2,TODAY(),0,B42,B43,B44),1,-1)) Its the 'SORT' and 1,-1 at the end that does the magic. You may already have discovered this but i only just have. Lol!
Nice video... thank you. Is there a function to reverse the order of the date from the newest to the oldest? Thx
this is like the reviews for the latest GPUs/CPUs, most of the people don't have access to these nice features of the coming months...
@LeilaGharani
3 жыл бұрын
Always good to know what's coming though 😊
this function is amazing and you explained it very well. can we get adjusted close price of stocks as there is no option for that to select. Mostly calculation on stocks are done on adjusted close price basis which is downloadable from yahoo finance website. But If I am working on any research of around 50-100 companies . Can we get adjusted close price in excel with this formula?