Forum Discussion

rudoji's avatar
rudoji
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's avatar
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's avatar
    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

Resources