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

[manretify]

worst ever. there are free excel macro that pull 16 years worth of SPX data in 10 seconds. You want people to do this by hand? 16 years is at least 8 pages a year, 100 pages total! that will take hours for something that should take seconds!

[Thatmakessense356]

@ExcelisHell Is there a way to get excel to make 1 day, 1 week, etc. charts using current data and then storing that data? Would there be a way to get moving averages, etc. from that?

[zaw92]

great help

[dovic3107]

thanks a lot for this video !! great job !!

[gqiq]

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?

[StockTradingMaster]

Good video

[johnwhenry131]

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'.

[Yellowknight888]

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.

[ExcelisHell]

@Yellowknight888 do it in parts or copy by hand.