MS Excel Pull Stock Prices automatically into Excel

This is a cool feature in MS Excel which allows you to pull stock prices and stock analysis in Excel directly. It allows you to keep your portfolio updated, help you in Valuation and much more.
#MSExcel #Excel #Valuation #Stocks #ShareValuation #StockValuation #EquityResearch

[nerdalert]

I don't have a stock option in inside the data tab? What magical excel version are you using?? :(

[madhavshrivastav]

i cant see the stocks options in my data tab

[sharvishah]

Thank you. How do you add commodities?

[ajazshake]

Should have mentioned works only for 365.

[SeedGH]

When the price changes should I close the sheet and open it again? Or it changes directly without needing of close and open ?

[nabankurdas]

Hi, How I can include the type of Stock (Large / Mid / Small) . Is there any option here?

[Devender_Singh_Chaudhary]

Great feature for managing portfolio, not sure if we have it in excel 2013 version ? Let me know if it is available.

[prakasharc]

no stock option under data tab. are you using add-ins?

[seshadrisrinivasan]

Sir, I followed your video and working fine. But when I save exit xl file and reopen it after some time the all the stock names are deleted and other fields are not deleted. How to save and use the same form

[lingaduraialagiah]

Please give us the procedures for pull live option chain to excel

[ayusharchives]

Sir data types option tab is not available in my version of Excel. Kindly assist sir

[AjayShukla-ol]

Can we check price of Mutual fund schemes, regular and Direct

[kanakjadav]

Very good effective and simple explanation

[iZacq]

I just want Excel to work on, how much is it per year ?

[vimalnathwani]

Hi. I am using the feature but it doesn't refresh the prices during the day. Only end of day. So 4pm NY time or when market prices settle. Is there any way to pull open, high, low, close intraday? So for today. 2nd Sept, i will only see prices in the automatic retrieval around 6pm NY time and not intra day

[saif]

This is very useful tip for updating stock data into excel, Thanks for sharing this.
I just have 1 question that does this data gets updated in live market sessions ?
If not, then how can we do that ?

[KrazzyForHealth]

Very useful and Informative! Thanks for Sharing

[angad_trading_co]

Thank, that what I looking for, is it update every day

[priyadarshinanda]

What u use ...the paid version of office 365 or free version of office

[aakashsharma]

How to refresh this data Will it be automatically updated ?