Forum Discussion

Copper Contributor

Jul 01, 2021

Power Query returns only 100 rows

Hello, I'm trying to download historical stock price data from Yahoo! Finance using the Power Query tool however, it only ever shows me the first 100 rows. Has anyone else encountered this probl...

excel

Lorenzo

Silver Contributor

Jul 03, 2021

rudoji

Alternatively with Excel 365:

=STOCKHISTORY("CARR",TODAY()-10,TODAY(),0,1,0,1,2,3,4,5)

pdxtony

Copper Contributor

Jan 30, 2022

Lorenzo Unfortunately the excel stock history function returns prices that are not adjusted for dividends/distributions - so you can't use it to calculate historical performance for any instrument that has any kind of distribution