Forum Discussion

Sam_S007's avatar
Sam_S007
Copper Contributor
Jun 12, 2020
Solved

Historical Stock Prices into Excel from Yahoo! Finance

I am using Power Query to automatically download historical stock price data from Yahoo! Finance into Excel.  The URL is https://finance.yahoo.com/quote/QQQ/history/   It populates a worksheet with...
Charting
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 12, 2020

    Sam_S007 

    Sure, just open the query on editing, find Change Type step, stay on it, select proper column and apply Decimal Number format, close the query.

     

    I did that in attached file.

Sam_S007's avatar
Sam_S007
Copper Contributor
Jun 12, 2020

SergeiBaklan 

 

Hi Sergei,

 

Thanks! That works perfectly. 

 

Sam

 

Resources