Finance in Excel 2 - Import and Chart Historical Stock Prices in Excel

Video quality	The size	Download

Information Finance in Excel 2 - Import and Chart Historical Stock Prices in Excel

Title	:	Finance in Excel 2 - Import and Chart Historical Stock Prices in Excel
Lasting	:	7.44
Date of publication	:
Views	:	180 rb

Is this specifically for older versions of excel? Im using the most recent version (as of 2021) and I don't seem to be able to open a page like that from the external data tab
Comment from : Quinn Pisani

can you show us the newest way? cuz the option given in the new excel is different compared to this one thank you
Comment from : Patrick Queen

Love you bro You made my day
Comment from : Shokhruz Abdukhamitov

still usefull af in 2020 ty man
Comment from : Lenny B

Thank you sir 👍👍👍👍👍br🕉️🙏👍
Comment from : paresh prajapati

doesn't work anymore
Comment from : kevin farley

Just wonderful, I been tryin to find out about "end of day stock quotes" for a while now, and I think this has helped You ever tried - Fenason Zeyames Idea - (Have a quick look on google cant remember the place now ) ? Ive heard some amazing things about it and my m8 got excellent results with it
Comment from : Steward Nyanchoka

This was great, I been tryin to find out about "historical daily stock quotes" for a while now, and I think this has helped Ever heard of - Fenason Zeyames Idea - (just google it ) ? Ive heard some interesting things about it and my friend got excellent success with it
Comment from : Hunter Hunter

Cheers for this, been searching for "historic stock data" for a while now, and I think this has helped Have you heard people talk about - Fenason Zeyames Idea - (just google it ) ? Ive heard some unbelievable things about it and my co-worker got great results with it
Comment from : Jomana

This was great, thanks, I have been researching "historical quarterly stock prices" for a while now, and I think this has helped Ever heard of - Fenason Zeyames Idea - (Have a quick look on google cant remember the place now ) ? Ive heard some pretty good things about it and my buddy got amazing results with it
Comment from : Hm Comps

Many thanks, I have been researching "free historical stock quote" for a while now, and I think this has helped You ever tried - Fenason Zeyames Idea - (should be on google have a look ) ? Ive heard some incredible things about it and my buddy got amazing results with it
Comment from : Igor Sidelkovsky

I need to get data of last 5 years stocks as on 31st March can anybody help me out as how to go about it
Comment from : Anusha karol

Thank u sir it has help me making black book
Comment from : aditya thakkar

But how to do all stocks at once? Can anyone please reply to this message?
Comment from : MathEnglish

how can i get closing stock prices with symbols for microsoft online version ?]
Comment from : Expert Programmer

Can we get it for the Indian market, if yes pl guide
Comment from : GANESH PATHAK

Can you do this with smaller time frames?
Comment from : Comparethebot

Thanks
Comment from : Your Walk Guide

I'm having problems with my formulas because Yahoo Finance post the dividends in the historical chart and it imports them I'm actually using the querry so everytime I update the data it comes back and messes up my formulas Whats another good source for historical data that is updated without this problem? thanx
Comment from : TheZeus017

Is there an easy way to get the data to go much further back (eg 1 year) without having to get the data from many different pages? Thanks
Comment from : Sam Perry

Hello! Have you heard about - TK Explosion Easy Website Builder (do a google search)? Ive heard some decent things about it and my cousin got amazing money with it
Comment from : Shahid Hussain

This was so helpful! You just saved me and my finance project!
Comment from : Yessy Zamora

Shit I've just grown to be amazingly jealous of my brother's best friend He's actually been single for a long time Yet he's mind-fucked a swimwear model to inform him she has fallen in love with him in under a month How is that actually manageable? He laughed and said he tried the Cupid Love System (Google it!) I wish someone beautiful fell for me I cannot recall at any time seeing him so happy Sort of makes me frustrated
Comment from : Rajib Kar

there has to be an easier method to import all historical data
Comment from : Connor Godfrey

thank you for this
Comment from : MP112791

Great VideoYou have done a very good job
Comment from : Manob Patra

thanks
Comment from : Manuel Castillo

Would it automatically update the new stock price for the next day if I choose not to un-check "save query definition"? What can I do to make the chart display every single date? in my opinion charting in excel still sucks Thanks for making this great tutorial!!! it's exactly what I need
Comment from : Kevin V

Really nice video no waste of time at all thanks for ur effort
Comment from : Jasbeer Singh

great help
Comment from : Zachary Wenner

in excel 2003, the data is charted from most recent to earliest, the opposite of how it should be 2007/2011 seems to recognize how time passes and adjust accordingly, regardless of how the data is arranged in the spreadsheet Because of this, I have to flip the data in Excel 2003 Do you know of a way to avoid this?
Comment from : Lazaristas

Should this work in Excel 2011 for Mac? There does not seem to be get data 'From Web' option on the Data ribbon - only 'HTML'
Comment from : John Henry

How can you import multiple year of data into excel using this method? Since the data is too long, you have to click on next page to see historical data from a different period But once you go to the next page, the previously checked green arrow is no longer recognized
Comment from : Yellowknight888