Can we get this data with other excel tools. My version is older and I din't have the stocks in "Data types" tab. Can we maybe get this data from web or other sources? Please make a video tutorial on them. Maybe with real estate prices? Would be very greatful 👌😇
This only works in Office 365. If you have a stand alone Office (2013, 2016, 2019, 2021) this feature is not available. Microsoft only offers it in 365. There is a stock connector add-in for stand alone Office. It only gives you the price and a percentage up or down. The 365 stock version is 1000% better. It supplies more information. But if you don't have 365, you're done. Also, using the ticker doesn't always work. Some companies have the same ticker on a different exchange. Some stocks have to be put in by company name.
Stock price and LTP change should be automatically change every day and according to that profit and loss and investment amount and current value should be automatically change every day.if you are capable to do this in Excel worksheet than only create video on this subject as my above ASAP
![BAK Jay - Find Out (For Your Love) [Official Music Video]](http://i.ytimg.com/vi/10FJO_XBCvY/mqdefault.jpg)
Can we get this data with other excel tools. My version is older and I din't have the stocks in "Data types" tab. Can we maybe get this data from web or other sources? Please make a video tutorial on them. Maybe with real estate prices? Would be very greatful 👌😇
It's not exactly 'free' when you have to pay a monthly fee for the feature that allows you to achieve this. Just sayin'.
This only works in Office 365. If you have a stand alone Office (2013, 2016, 2019, 2021) this feature is not available. Microsoft only offers it in 365. There is a stock connector add-in for stand alone Office. It only gives you the price and a percentage up or down. The 365 stock version is 1000% better. It supplies more information. But if you don't have 365, you're done. Also, using the ticker doesn't always work. Some companies have the same ticker on a different exchange. Some stocks have to be put in by company name.
Awesome Work Sir - you are amazing - So Well Explained - Suddenly My Excel is So Cool
First Comment.
Thanks you teacher.
Good and great tutorials.
Glad it was helpful! :)
Worked for me. Awesome share! Thanks a lot. :)
Perfect info thanks
Thank you for putting this video together!
Only works on the desktop pay version...
is there a way to get the dividend yield?
Good voice Changer video acamedi good vid
Whether older version of Excel can support similar functions?
Is there a way to put automated refresh with a set duration?
Hello i love you your from is Slovakia ?
It means we can't use this data in any technical analysis since there is delay
witch excel format we use for this formula sheet
Hi I am able to add the 1st column, but the 2nd column display as =A2.[Market cap], all others are the same as this, why?
dont works live Quotes. its not real time...
Stock price and LTP change should be automatically change every day and according to that profit and loss and investment amount and current value should be automatically change every day.if you are capable to do this in Excel worksheet than only create video on this subject as my above ASAP
Investing in crypto is the best lucrative way of making money now
Crypto is the new gold
I wanted to trade Crypto but got confused by the fluctuations in price